Move user database from Joomla to Dolphin

Hi,

I am looking towards moving all my users from Joomla to Dolphin. Does anyone know how to go about doing this?

Thank you,

bigfoot_3000

You should transfer profiles between these databases.

Hi AndreyP,

I am relatively new to all this, please can you give details on how to go about this move from one mySQL database for Joomla to the other mySQL database for Dolphin.

I know that the Joomla passwords are encrypted - does this change/alter/affect anything in Dolphin for users to login?

Regards,

bigfoot_3000

Anyone can give me exact details on how to do this?

Search for one of CALTRADE's posts....he has done something similar.

Playing around with fields of dbase might give you some headache, I have learned that lesson crashing my site 3 times and 3 times members have to register again, stopped only when members threatened to smash my thick skull.

those who really like your site will register again no worries about that, so consider installing a fresh install of dbase a database pruning, deleting inactive members , active members will re-register once they find out they cant log in.

just my 2 cents.

I had moved my previous website from Joomla to Dolphin and the only way I figured to do it was simply this:

1: Backed up EVERYTHING twice.

2: Went into the joomla datebase choose the Table that holds the profiles, choose "search tab" at the top, highlighted the fields 'id', 'username', 'password', 'email' - click the go button. Make sure the complete inserts and extended inserts are checked in the data section of the page before you click the go button on the search results page. This will create a sql file that has only #1 insert into table , instead of an insert before every entry, because you have to open the sql file and change this table name. Joomla and dolphin doesnt have the same table name for this. Plus you need to change any of the table's column names like 'pass' to 'password' to match the new dolphin database. Remove the section at the top that says "create table". then save the changed sql file.

3: Then you can import the changed sql file into your new dolphin database.

These items in the database were the only things I could move from joomla to dolphin because of the difference in setups, once they are all imported into your database then go into your admin of dolphin and send a mass email confirm, to insure they confirm their email and then they will have to go to your site to update any profile information that you have set as "Mandatory" for joining. but you get to keep your members.

The passord encryption if using the same method on the joomla site as the new dolphin site it shouldnt change anything and will work the same. (..md5 on both for example).

Yes, I hear you AlphaOmega168, it would be rather a bad thing if I screw up the database.

I'm gonna see what COLTRADE did off the back of Ircepton's suggestion.

Thank you both.

<<additional: mmm, I just saw LinkSys7's post, let me look into that.>>

I just mean that need to import user table from joomla to dolphin and create transfer script, that will depends on joompa ProfileTable fields.

So this is just ordinar job :)

You could harm your db tables if you do a manual editing /  transfer. I used a professional   dolphin-joomla integration script I got from www.dolphindesigns.info   to safely transfer all users from my  joomla site to Dolphin 7   with everything (username/passwords) still intact.