How to import users from excel file?

[lue]

Does anyone know how I can import 6000 users from a csv file into the users table? I was able to use sugar's import feature to import from a csv file into the contacts table, but I'm not seeing how I can import from a csv into users.

Thanks for any help.
Lue

[roblaus]

Hi,

Unfortunately this must be done through direct DB manipulation. But since none of the available tools for MYSQL is really good for importing (IMO) I recommend to dump your users table and replace the insert values with you own ones. Then just run the result as query.
There are for sure more sophisticated ways but that's the one I use (as always: BACKUP)

rgds
rl

[egork]

You might want to save the file as tab delimited save it to /home/sugar/TABLENAME.txt and then use the mysqlimport tool. Create a script like the example below and run it. It will upload all records into TABLENAME table. You have to watch yourself for the uniqueness of primary ids etc.

/usr/local/mysql/bin/mysqlimport \
--default-character-set=latin1 \
--verbose \
--host=YOUR_HOSTNAME \
--local \
--fields-terminated-by='\t' \
--lines-terminated-by='\n' \
--ignore-lines=1 \
--user=YOUR_MYSQL_USERNAME\
-pYOUR_PASSWORD \
--columns=\
id\
,user_name\
,first_name\
,last_name\
# add other columns
,email \
YOUR_DATABASE_NAME /home/sugar/TABLENAME.txt

Also you may try jitterbit.com, they have a guid() function to generate unique ids and can connect to SugarCRM.

[Cypriot]

Hi There,
Is there any way that i can import from Excel file into SugarCRM ?

On my excel file on Each ROW i have Contact, Account and two product detail.. so thats why i need advice on this! each row is eac account with their contact and products details.

Thanks

[FreeGroup]

Hi,

you can use http://www.dbTube.org to import your Excelsheet into the database.

Greetings

Andreas