MySQL Forums
Forum List  »  Newbie

importing single csv fields to multiple mysql tables
Posted by: Randeep Raman
Date: May 31, 2014 06:59AM

Hi All,

I'm using vTiger crm 5.4.0. I have a csv file with a lot of data which I want to import to vtiger mysql database.

I can do this using vtiger web interface. But the problem is, I have to import the csv file to database every 30 minutes as csv file get updated often. So I thought of writing a mysql query and set a cronjob.

Each row in csv file has about 70 columns.

The problem here is when I upload the csv via web interface and I found that data is stored in three different tables.

For example. I'm importing the csv file contains contact details.
Name and email address is storing in contactdetails table
company names stored in accounts table
custom fields stored in contactscf table.

How can I do this with mysql queries.

I checked load data command. but it stores in only one table.
Is there any way to do this?

Please help.

Regards,
Randeep

Options: ReplyQuote


Subject
Written By
Posted
importing single csv fields to multiple mysql tables
May 31, 2014 06:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.