Importing Data from MysqlDB into Accounts DB

[masmith]

Hi...

I have a modified AccountsDb, and I'm trying to find the best approach to importing the data from an external MySQL db/tbl.

Should I just create a basic php app to do the select/insert process from the internal tbl, into the SugarCRM acounts tbl(s). If so, which tbls(s) on the SugarCRM side need to be inserted into/modified??

I;m running on a fedora/mysql platform with v5.0 of SugarCRM.

Thanks

mark
caliventures@yahoo.com

[kuske]

You can directly import accounts to the accounts table of SugarCrm in mySQL query browser.
You only need a unique index in column id which can be any string of 36 chars or less.
This can be the old unique id in you accounts database.
If you want to define new ids you can use the uuid() function of mysql.