Coppermine User Import

StuartDH · April 14th, 2005, 02:51 PM

I've managed to import my coppermine gallery with all pictures appearing to go in the right categories and the correct info of the photographer attached to each, but no user accounts have migrated properly.

If I click on the name link of a photographer I get the info of someone else and many of the photographers haven't even made it in to the users database.

Click on any of the name links on the gallery and you should be able to see what I mean:

http://www.wildaboutbritain.co.uk/gallery

Any info on how I can sort it would be much appreciated

Thanks

Stuart

ConqSoft · April 14th, 2005, 02:53 PM

Did you try running the Username update in the Maintenance section under Gallery's AdminCP?

StuartDH · April 14th, 2005, 05:00 PM

I've just updated the usernames but it seems to have deleted some of the members from the database and now most of the photos have been attributed to the wrong members as well

permalink · April 14th, 2005, 05:24 PM

The import should use the same info as your coppermine database... If you didn't have coppermine integrated with your vB user accounts though there's not really a way for it to determine what images were supposed to belong to what vB user...

StuartDH · April 14th, 2005, 06:03 PM

So I need to integrate my original Copperine gallery with VB first and then import it to the vba gallery?

The original import put the right users with the right photos (the profiles didn't match the username links) but then it all went pear-shaped when I used the username update.

StuartDH · April 14th, 2005, 07:11 PM

I haven't done a VB & coppermine integration yet, but I've just done a new import of the coppermine gallery to the vba gallery.

http://www.wildaboutbritain.co.uk/gallery

I'm now back to the situation where all the images are in the right place, with the correct members credited to each picture. The only problem is that the name links for every member either produces an error 'Invalid user spcified...' or it shows the profile of a different user.

This happens on all the member name links, whether they are forum members or not. Also, none of the original coppermine members show up in the forum member list and so they can't login to the forum with the coppermine details.

StuartDH · April 15th, 2005, 07:42 AM

I still haven't worked out the best way to tackle this. Basically, the names for the user IDs for coppermine don't match the names for user IDs on VB (and consequently the Gallery as well)

Any tips on how I could get them to match up would be a big help.

I'd have thought that this would be a very common problem, unless people just aren't buying the Gallery because they can't import Coppermine and integrate it with the gallery properly???

ConqSoft · April 15th, 2005, 08:11 AM

Sounds like you need a small script/process to go through the Gallery database, look at the NAME, compare it to the NAME in the vB database, and update the user ID in the Gallery database. (Probably can be done with a single SQL statement.)

ConqSoft · April 15th, 2005, 08:24 AM

Something like this. Though, this hasn't been tested, and was just typed off the top of my head.

UPDATE adv_gallery_images SET userid = (SELECT user.userid FROM user WHERE adv_gallery_images.username = user.username)

and

UPDATE adv_gallery_posts SET userid = (SELECT user.userid FROM user WHERE adv_gallery_posts.username = user.username)

And if you have any user-owned/created categories in Coppermine, you'd need to run a similar update on the Gallery category table.

permalink · April 15th, 2005, 10:26 AM

If you can just keep things as is and submit a support ticket then I can write a quick script to grab the info and have your images updated with the userid associated with each username. This would only work though if the usernames in your Coppermine installation match the usernames with your vB installation.

StuartDH · April 15th, 2005, 03:19 PM

Thanks guys. I've just submitted a support ticket and checked to make sure that all users from the gallery import are also present in the forum db.

Cheers

Stuart

dendrob · March 20th, 2006, 01:11 PM

I've got exactly the same problem. I moved from a phpBB with coppermine to vbulletin with photopost

VB was a snap, but importing from coppermine to photopost let all the users missmatched.

Any clues? Do you by any chance still have that script?

Chuck S · March 20th, 2006, 01:53 PM

Well your mismatch has nothing to do with PhotoPost.

Your mismatch is from switching from phpBB to Vbulletin and there is a script in our photopost importers forum to realign userid's when switching to vb from phpbb etc