Coppermine User Import
 

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

Re: Coppermine User Import
 

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

Re: Coppermine User Import
 

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 :eek:

Re: Coppermine User Import
 

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...

Re: Coppermine User Import
 

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.

Re: Coppermine User Import
 

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.

Re: Coppermine User Import
 

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???

Re: Coppermine User Import
 

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.)

Re: Coppermine User Import
 

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.

Re: Coppermine User Import
 

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.

Re: Coppermine User Import
 

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

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?

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 ;)