Create a import script

[Baldinato]

Hi to all!!!

I'm creating a php script to import data from different db to mySQL. I create a part of this script and also i scheduled it. Thanks to all for this. Now i'm trying to add also an email address, but i don't understand the right procedure. I know that all email addresses are stored in the email_addresses table. This table has a primary key in the id field, this id is different respect, for example, the id contacts, presents in the contacts table. I don't understand how to create a procedure to make insert in the contacts table and relative email address in the emailaddresses table.

Thanks to all

[andopes]

Hi, Baldinato

When inserting a new record that has email (e.g. Contacts) you have to insert a new record in 3 tables:
Example for Contacts module:

contacts
primary key: id
email_addresses
primary key: id
email_addr_bean_rel
primary key: id
foreign keys:
email_address_id: email_addresses.id
bean_id: contacts.id
bean_module: Contacts


Cheers

[Baldinato]

Really thanks for your question.

I solve the trouble.

Cheers

[Cypriot]

Really thanks for your question.

I solve the trouble.

Cheers

Hi There,
what is the script that we can use for this please ?

Regards