Hello Everyone!

I am in the process of moving a two language Menalto Gallery (English & Japanese) to Piwigo.

I've installed the Menalto2Piwigo plugin but was not sure about the instructions, so this is what happened to me, and my suggestions to improve the plugin...

Firstly, on the "How to use it?" page there are fields to put in database details that already had some of my Piwigo database info. That seemed strange so I put in my Menalto Gallery database info. For such an important task, not having specific instructions as to what database to use was confusing to me.

Next, it took me a while to realize that the word "Synchronise" was a button. (Suggestion: I think it should be highlighted as such.)

There were three Syncronize Errors (wrong filename). I found the filenames in the data file, eliminated the spaces and that fixed it.

In the "Synchronise" window, the fields are reasonably self-explanatory but I was not sure what, "add new photos to basket" means. I've never used Piwigo before.

Further down I see, "reduce to single existing album" with a list of all the albums in my Menalto Gallery. This seemed scary to me. All those albums will be reduced to one? A short explanation would be good here.

Anyway, I clicked the Submit button.

I was taken to a page that had a "Some checksums are missing." button. (Didn't realize it was a button at first!). I clicked on that and somehow muddled my way through it... I'm not a programmer, so what the concept of checksums is unknown to me. Some instructions on what to do on that page would be great for me and for future users who don't know about such things...

Anyway, it seems like all my pictures have been imported and from now I will try to use the Extended Descriptions plugin setup.

Also, on the first page, step 3, Submit the form at the end of this page. Why not change it to: Click on the "Start Import" button at the bottom of this page.

BTW, that "Start Import" button disappears once you click on Step 2, Synchronise, so perhaps there should be instructions to: Return to this plugin page after the synchronise is complete.

Anyway, I hope what I've written here will be useful and improve the process for future users...

pashdown wrote:

In attempting to migrate from Gallery2, I am getting this error on some comments:

  'anonymous_id' doesn't have a default value

I have deleted some comments from my Gallery2 mysql to get past this, but there are some I would like to keep.  Is there a way I can massage my Gallery2 mysql database to give a value to anonymous_id?

This is a thread from a Gallery 3 import, but maybe it will help?

https://piwigo.org/forum/viewtopic.php? … 77#p161677

pashdown wrote:

Unfortunately, Gallery2 doesn't have the "server_remote_host" nor "server_http_host" columns anywhere.  I'm pouring over the code trying to figure out where it does fetch 'anonymous_id' from, but I can't find it in the Gallery2 section.  Maybe that's the problem?  There is a 'g_host' column that I can't see being used anywhere.

I fixed it by inserting anonymous_id into the inserts like this:

          $comment_inserts[] = array(
            'image_id' => $iid[ $row['id'] ],
            'date' => $row['date'],
            'anonymous_id' => '0.0.0.0',
            'author' => pwg_db_real_escape_string($row['author']),
            'content' => pwg_db_real_escape_string($comment),
            'validated' => 'true',
            );

In retrospect, it may be proper to do 'anonymous_id' =>  $row['host'] instead, but right now, I'm really not concerned about the IP address of 20+ year-old comments.  I just needed them imported.