Since I see a lot of people had this question and I didn't see an answer, I thought I'd post what I did in case it can help someone. I know that the developers mentioned that they were working on a script, but I really wanted to take my site live and needed this. This worked, but maybe someone can improve on this. I'm far from expert. I'm working on getting the pictures imported next, but that's a bit more complicated.

Either have both coppermine and dragonfly installed in the same mysql database, or import the users table from coppermine into the dragonfly database with a different prefix so that they don't step on each other. Here, I have cms for the dragonfly prefix and cpg11d as the coppermine prefix. Then I run the following SQL to import the users. I tried to capture all the fields that were clearly present in both tables. It's possible that there are one or two useful columns that I didn't get, and you might not want to include the previous registration date, but this works.

SQL:

insert into cms_users (user_group_cp, user_active_cp, username, user_password, user_lastvisit,
user_regdate, user_email, user_website, user_interests) select cpg11d_users.user_group, cpg11d_users.user_active, cpg11d_users.user_name, cpg11d_users.user_password, cpg11d_users.user_lastvisit, cpg11d_users.user_regdate, cpg11d_users.user_email, cpg11d_users.user_website, cpg11d_users.user_interests from cpg11d_users;

update cms_users set user_password=md5(user_password)

Hi dawnwich, How glad was I when a search threw up your post

I have over 100 albums and 1200 pictures but only 6 users in my gallery which I have had online for over a year now.

I have been looking for a CMS to play with and this one seems to support coppermine so I have given it a shot.

The problem is, not being too clued up on SQL etc, I dont know how to copy the albums etc over to the CMS database. In fact, although I can sort of follow your script, I have no idea where to place it in order to get it to work.

My coppermine database is called jcburns_copp1, luckily all my files are also in cpg11d_xxxxx as well.

So firstly, How do I use your script to copy my 6 users over?

I have cpanel access to phpmyadmin which I guess is the starting point.

I have managed to figure out how to look at the structure of a table within there and also export it, but I fail so far in trying to figure out how to copy, although from comparing the two (CMS and standalone) they seem to be fairly different.. eg: votes are seperate in cpg11d but appear to be combined within the picture table in cms! so I guess it is a translation from cpg11d to cms tables etc

The alternative is to re-do the gallery from scratch using batch upload... not a job I realy want to do

Cheers


Regards,


Jason

Oh, I'm so glad that this was useful! From your phpmyadmin panel, click on SQL and then cut and paste the SQL commands into them and click go.

I am suffering with the pictures right now. I had a script written that looked pretty good to me, with the minor drawback that it didn't work. I'm going to take another stab at it this weekend and see if I get anywhere, and if I do then I will post that one as well.

i'm one of the many who want to migrate cpg to dragonfly ... really eager to see a converter script.

i have only one user (i.e. the admin) in my cpg132, would it be easier? Would it work simply by copying corresponding tables from cpg to dragonfly (the common fields)? Or there's something else i need to take care?

great thanks to dawnwich!

With one user, I wouldn't bother with this. If I succeed in migrating pictures, then I'll be sure to let everyone know.

This is very similar to what I am trying to do right now. I have two users, really only need one in my standalone Coppermine Gallery. Currently, our stats are "232 files in 22 albums and 3 categories with 705 comments viewed 160407 times". I want to move it all over to Dragonfly's CPG. I actually copied the albums folder over to the one in cpg hoping that would make things easier. Then I tried going into phpMyAdmin and copying the tables over from my standalone to cpg with no luck. There are also tables that are in one and not the other. This is what I have:

excerpt from my Dragonfly db:
cms_cpg_albums
cms_cpg_categories
cms_cpg_comments
cms_cpg_config
cms_cpg_exif
cms_cpg_installs ????
cms_cpg_pictures
cms_cpg_usergroups
cms_cpg_votes

in my coppermine db:
cpg_albums
cpg_banned xxx
cpg_categories
cpg_comments
cpg_config
cpg_ecards xxx
cpg_exif
cpg_filetypes xxx
cpg_pictures
cpg_temp_data xxx
cpg_usergroups
cpg_users xxx
cpg_votes


The ???? is a table not in Coppermine standalone, and the xxx are tables not in CPG. When I try to copy from Coppermine to CPG I get an error telling me that I already have that table (I am trying to copy over the existing one using structure and data). Then I tried to copy only the data, and it gave me an error saying that "#1136 - Column count doesn't match value count at row 1 ".

Honestly, at this point, I dunno what I am doing or where to go from here. I just want to keep all my content and move it over to CPG. I don't have a lot of users to worry about or anything. This should be easy.

btw: Since there is no ecards table in CPG, does this mean that ecards are not supported in Dragonfly's CPG?

Has anyone been able to do this?

Mag, did you see this post?

dragonflycms.org/Forum...10059.html

Ah! Thanks Sarah. I was looking for a reply here, and didn't see it in my quick scan. *goes to other thread*

Just to add to this a bit: apparently, coppermine allowed usernames with spaces and punctuation in them, and dragonfly does not. So, importing users from coppermine will give potential illegal usernames in the new system. I've been cleaning them up one at a time as I notice them, but I thought I'd mention it so other people would know to look for them. It might be nice to change the script so that it cleaned them all up.

It did't work out for me. I could transfer all my 200 members from my stand alone Coppermine into CPGNuke but all passwords was lost! (Or didn't work)Even my own admin pw! Deleted the database and reinstalled CPGNuke. Still couldn't login now because I had done to many login attempts. I had no idea where to find out what file to edit to overcome that so I had to delete all cpg files and upload hole cpg again and install. Now I can login of course, but I'm scared to try moving members from coppermine db into cpg db again. I probobly loose all passwords again. Has it anything to do with encryption of pw or can anyone explain whats wrong and what to do about it please?

you want to delete everything in your cache folder except .htaccess. that's how you get more login attempts. doing so will not harm your site in anyway but never ever delete .htaccess.

There is an encryption on the passwords. In the script that I posted, note the "md5" on the password line. That's crucial. If you copy over raw passwords, then you will get the behavior that you described.

Thanks! Works fine. Any luck with script for tranfer pics, albums from standalone?

Ok. Not much help or action here. I soleved it myself. It wasn't very hard. It all works fine.