PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Import Scripts

Photopost Pro Import Scripts Looking to upgrade to PhotoPost? We'll post any importers we develop here.

Reply
 
Thread Tools Rating: Thread Rating: 23 votes, 4.22 average. Display Modes
Old May 19th, 2009, 09:07 AM   #121
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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
Radek Havelka is offline   Reply With Quote
Old May 19th, 2009, 09:11 AM   #122
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
Code:
Content visible to verified customers only.
This does not work?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old May 19th, 2009, 09:13 AM   #123
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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.

Last edited by Radek Havelka; May 19th, 2009 at 09:32 AM.
Radek Havelka is offline   Reply With Quote
Old May 19th, 2009, 09:15 AM   #124
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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
Radek Havelka is offline   Reply With Quote
Old May 19th, 2009, 10:00 AM   #125
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
Well we dont claim to natively support all foreign languages so might be an option in the future.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old May 31st, 2009, 02:42 AM   #126
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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.
Radek Havelka is offline   Reply With Quote
Old May 31st, 2009, 09:03 AM   #127
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old May 31st, 2009, 10:14 AM   #128
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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 ?
Radek Havelka is offline   Reply With Quote
Old May 31st, 2009, 10:30 AM   #129
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
You can run it again.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 1st, 2009, 03:57 AM   #130
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
did it, no difference
Radek Havelka is offline   Reply With Quote
Old June 1st, 2009, 04:07 AM   #131
Radek Havelka
Junior Member
Verified Customer
 
Join Date: May 2009
Location: Prague, CZ
Posts: 9
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
Radek Havelka is offline   Reply With Quote
Old June 1st, 2009, 09:09 AM   #132
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
Okay glad you sorted that
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 17th, 2009, 09:50 AM   #133
Halfhidden
Member
 
Join Date: Sep 2009
Location: Penzance UK
Posts: 159
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 is offline   Reply With Quote
Old September 17th, 2009, 09:54 AM   #134
Halfhidden
Member
 
Join Date: Sep 2009
Location: Penzance UK
Posts: 159
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
Halfhidden is offline   Reply With Quote
Old September 17th, 2009, 01:00 PM   #135
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 17th, 2009, 03:20 PM   #136
Halfhidden
Member
 
Join Date: Sep 2009
Location: Penzance UK
Posts: 159
Quote:
Originally Posted by Chuck S View Post
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
Halfhidden is offline   Reply With Quote
Old September 17th, 2009, 06:22 PM   #137
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
You will have to wait for the import to complete and then do the clean up work meantioned in the initial post.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 17th, 2009, 07:00 PM   #138
Halfhidden
Member
 
Join Date: Sep 2009
Location: Penzance UK
Posts: 159
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?
Halfhidden is offline   Reply With Quote
Old September 18th, 2009, 05:38 AM   #139
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,129
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old September 18th, 2009, 06:48 AM   #140
Halfhidden
Member
 
Join Date: Sep 2009
Location: Penzance UK
Posts: 159
Quote:
Originally Posted by Chuck S View Post
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.
Halfhidden is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
4images Importer Chuck S Photopost Pro Import Scripts 33 July 29th, 2013 09:20 AM
Albinator Importer Chuck S Photopost Pro Import Scripts 23 May 19th, 2006 04:25 AM
4images importer ? H@K@N Before You Buy 10 November 15th, 2005 12:22 PM
Invision Gallery Importer yorkguy Before You Buy 3 October 16th, 2005 04:02 PM


All times are GMT -5. The time now is 12:25 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.