Hello,
i have a drupal site and i bought dolphin in order to recreate my site and make it better. The problem is that in my drupal site there are over 500 user accounts and i need to transfer them into the new database.
I found several instructions for data transfer through mysql databases but with no sucess. Drupal and dolphin databases have too many differences...
Any suggestions??
Thank you
|
Only suggestion i have is to get a developer to code you a custom script to move data OR you could insert data into dolphin 1 at a time, as you have 500 accounts to move. I hope you are free for a week... so much to do.... |
Yes, the best way to do this is to have a script that will be able to transfer the profiles. One would have to look at the Drupal table that holds the profiles and matched them up as closely as possible. Then there is the matter of the passwords. One would have to check to see how Drupal encrypted the passwords, decrypt and then encrypt the Dolphin way; or you can just ask your members to set a new password by using the "password forget" feature.
I have no recommendations for who you can hire to do this.
Geeks, making the world a better place |
Then there is the matter of transferring the content of your users. Geeks, making the world a better place |
Drupals passwords are not compatible with dolphin. But i do have a mod in the market that will make dolphin able to use those passwords as well as the passwords of several other scripts. https://www.deanbassett.com |
Hello,
Thank you both for your answers. My first thought was to transfer them manually one by one but this needs more than a week... and apart from that i need to disable somehow the email notifications to members as they receive several emails for their registration.
I don't really care about the passwords as they could ask for a new password through the site, but i can't ask them to recreate their profiles. They will be furious. I guess i have to find a developer for this job,but still, these are personal data and i can't give access to someone i don't know...
|
1. Move the tables containing the user info from the drupal database into the Dolphin database with a unique prefix so you don't get them confused.
2. Move the info over using a mysql query or a simple php script that loops through the tables.
3. Delete the drupal tables from the Dolphin database.
The only tricky parts are the passwords and the content (pictures, movies etc). But if you don't care about the password just assign them all one based on their date or birth or something else unique to each person that wouldn't be easy to guess.. or use Dean's mod.
BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
If you are not sure about a developer, you can ask for references. Most of the long standing developers take pride on their reputations. I always work as if I am under a non-disclosure agreement even if I am not. If you don't have people on staff that can do the work, then you probably need to hire someone. If you just want to move the profiles, then that is not as involved as moving files such as photos. One is going to need to install Drupal if they don't know the database structure and learn how it handles content compared to Dolphin and figure out the transfer script. Geeks, making the world a better place |
Just my two cents but out of 500 likely not even 100 active I would put a nice note on the landing/splash page asking them to rejoin. The members worth keeping will join and be impressed you cared enough to upgrade. Save yourself some agony. If its not an adult site use facebook connect and the majority can join in one click. |
I actually offer a service for migrating existing websites to Dolphin. However this does not come cheap and as jksurf already mentioned, you should ask yourself if its worth migrating that few members.
If your current passwords are just md5 encrypted I can even transfer those without any issues, else deano's module might be what you need for that.
The things I can migrate for you are:
- User profiles - User avatars - User photo's (including adding a watermark if it doesn't exist already) - User friendlist - Forums (including splitting long topics, as the current forums do, after x posts)
http://www.boonex.com/m/denre-s-migration-service
Dedicated servers for as little as $32 (28 euro) - See http://denre.com for more information |
1. Move the tables containing the user info from the drupal database into the Dolphin database with a unique prefix so you don't get them confused.
2. Move the info over using a mysql query or a simple php script that loops through the tables.
3. Delete the drupal tables from the Dolphin database.
The only tricky parts are the passwords and the content (pictures, movies etc). But if you don't care about the password just assign them all one based on their date or birth or something else unique to each person that wouldn't be easy to guess.. or use Dean's mod.
I already tried something like that but i will try it one more time
|