Coppermine Importer - Page 7

Radek Havelka · May 19th, 2009, 10:07 AM

your tables seems to have no encoding set by default - i created a database with encoding "cp1250_czech_cs", launched your installer and all the tables created by this installer have "cp1250_czech_cs" encoding set on them.

I tried to add this codepage setting query to the script, but I wasnt successfull somehow, maybe i give up and drop all old comments, most of the description is done without diacritics, so should be fine

Chuck S · May 19th, 2009, 10:11 AM

Code:

Content visible to verified customers only.

This does not work?

Radek Havelka · May 19th, 2009, 10:13 AM

also, there is one problem i discovered - i have categories and subcategories in my CPG gallery. The structure imports OK to PP, but once albums are transferred, if the album ID matches CATEGORY ID, then all the photos are assigned to CATEGORY instead of newly created album.

Radek Havelka · May 19th, 2009, 10:15 AM

for some reason, it didnt

im now redoing all the thumbs and medium size images, once i finish with that, i will get back to this issue and try to reimport the comments with this settings, and will try to find out the problem. I suggest you put this as one setting to config file, might be usefull to all future users with non-ascii charsets

Chuck S · May 19th, 2009, 11:00 AM

Well we dont claim to natively support all foreign languages so might be an option in the future.

Radek Havelka · May 31st, 2009, 03:42 AM

thank you

I managed to modify the script so it takes all the various diacritics issues into account (not only the database, but also non-ascii characters in filenames made me a lot of troubles, so i had to add a function that checks the filename for A-Z 0-9 characters only and replaces any "invalid" ones). I have my website up and running, with some adjustments to fit our needs.

One thing that is still not clear to me is MEMBER / PERSONAL ALBUM. After i imported all the pictures from our Coppermine, all user albums can be found under PERSONAL ALBUMS list of PHOTOPOST HOMEPAGE. But, I cant browse to that via MEMBER page :

this

Fotogalerie Valka.cz - All albums

shows i have 38 pages of albums

and if I go for example letter D

Fotogalerie Valka.cz - All albums

i see some of them filtered by username starting by D.

BUT

when I go Member galleries, letter D

Fotogalerie Valka.cz - Member Galleries

i dont get anything.

New albums created in PHOTOPOST seems to work as expected and are assigned to Member galleries, but those old albums dont. I dont want to have this duality, which can be confusing to our users, how do I "upgrade" old personal albums from CPG to PHOTOPOST ones ? What DB change needs to be done ? Just hint please, i can update it by myself

, just dont know where to look.

Chuck S · May 31st, 2009, 10:03 AM

You can try going to admin scan database and rebuild the members last photo.

Fotogalerie Valka.cz - Admin Gallery

Fotogalerie Valka.cz - von Fenstein Gallery

Radek Havelka · May 31st, 2009, 11:14 AM

this seems to do the job, but only for some users - for example this one

Fotogalerie Valka.cz - Sutelik Gallery

is not visible under S, but those you've linked are visible now. What can be the problem here ?

Chuck S · May 31st, 2009, 11:30 AM

You can run it again.

Radek Havelka · June 1st, 2009, 04:57 AM

did it, no difference

Radek Havelka · June 1st, 2009, 05:07 AM

I found the problem - the mysql settings of the database is CASE SENSITIVE, so when looking for 's%' it doesnt find Sutelik user ... i will modify this code to work with case sensitive names

Chuck S · June 1st, 2009, 10:09 AM

Okay glad you sorted that

Halfhidden · September 17th, 2009, 10:50 AM

Hi Chuck, just installed coppermine script you created to migrate from Coppermine to Photopost... al went fine but I have this error on the last import... should I just ignore this:

Error

Code:

Content visible to verified customers only.

Thanks Steff

Halfhidden · September 17th, 2009, 10:54 AM

Hi Chuck, just installed coppermine script you created to migrate from Coppermine to Photopost... al went fine but I have this error on the last import... should I just ignore this:

Error

Code:

Content visible to verified customers only.

I don't seem to have any picture imported and the categories aren't working.
Thanks Steff

Chuck S · September 17th, 2009, 02:00 PM

That error tells me you have not inputted the correct config mysql information when asked. You can edit the config file that comes with the script and recheck this info and rerun the import.

Halfhidden · September 17th, 2009, 04:20 PM

Quote:

Originally Posted by Chuck S

That error tells me you have not inputted the correct config mysql information when asked. You can edit the config file that comes with the script and recheck this info and rerun the import.

Hi Chuck... you are right I have made a typo with the db user_name.
Sorry I did notice this and haven't been able to post.
The pictures are importing and have been for over 3 hours so far.
Is this normal for 16K pictures. It's only from one directory to another I guess... not a server transfer.
The categories don't yet show up... nor comments and the members galleries don't exist either... I guess I'll update you after the pictures have transfered and once I've run the db update in Photoportal admincp.
Kind regards,
Steff

Chuck S · September 17th, 2009, 07:22 PM

You will have to wait for the import to complete and then do the clean up work meantioned in the initial post.

Halfhidden · September 17th, 2009, 08:00 PM

Hi Chuck, done all of that and things are quite wrong. Some, not all pictures have the wrong user as the owner..... some pictures have the right comments but the wrong user name against them. Some comments have the right username but the wrong avatar..... and some users are only refered to as ip addresses.
I guess its gone wrong... what would be your suggestion please?

Chuck S · September 18th, 2009, 06:38 AM

well what do you mean users are wrong on pictures you would have to provide much more detailed info and examples for me to even guess at your issue. Remember we are simply reading the info thats in your coppermine tables and transfering it to photopost. So the userid's we get from coppermine.

Halfhidden · September 18th, 2009, 07:48 AM

Quote:

Originally Posted by Chuck S

well what do you mean users are wrong on pictures you would have to provide much more detailed info and examples for me to even guess at your issue. Remember we are simply reading the info thats in your coppermine tables and transfering it to photopost. So the userid's we get from coppermine.

After the import the pictures had the wrong users as owners. Only a few had the correct owners. forinstance; user "A" pictures were now owned by user "B" and so on.
The problem with the comments was siminlar to the pictures. Although the comments were correct the owner (original poster) was incorrect. So a comment posted by user "A" now show that user "D" posted the comment.
It seems that the users import is out of sync.
I've trashed the tables and started the whole import process again

My Coppermine setup is straight forward as far as I know. Coppermine is bridged to SMF 1.1.9 so the users table in coppermine only had about three users in it.
The import process is about half way through at the moment so there is nothing to see, so there is no point me posting a link to the gallery at this stage.
I'm not sure as to how the transfer became out of sync... but with a bit of luck it will transfer ok this time.
I'll post back once the process has completed.
Thanks for your reply.