Import Contacts w/o SOAP

[madmat]

Hi folks,

maybe (most probably) this has been asked before, but I didn´t find anything too much helpful.

I want to import contacts and accounts with an ETL tool, without using SOAP, because of performance issues. (8k+ contacts)
Putting them directly into the MySQL tables would require to put the email adresses into email_addresses.. and where else?

I found this relationship diagram:


Should it be sufficient to put the email into email_addresses or do I have to genereate a bean ID somehow?

[pblag]

Hi madmat!

you can do this with mysql scripts.

sure you have to copy data to accounts,leads, tables etc.

for saving emails you have to use following tables

- email_addr_bean_rel
- email_addresses
- emails_beans

for generating id you should use mysql function UUID()

[madmat]

Hi Petro,

thank you for your reply.
First I misinterpreted the diagram I attached and only wrote to email_addr_bean_rel
and email_addresses.
Added emails_beans and import works fine now.

thx!