CSV Export/Import Column Mapping

Question

I have a company database (PHP and MYSql) where products needs to be exported and imported regularly. Due to the difference in column between companies, i need to export into their column format and except their format. I am after a script that will map the columns before exporting/importing. Open source would be the preferred choice. I searched the internet all day without any joy. Thanks

You have to prolly write that script. The question is : do you need a cronbased export / import script, or a replication ? — , May 03 '14 at 18:35

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

(sorry I do not have 50 reputation to comment)

You should take a look here https://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

And then here replication between two tables with different names and which have different column names. Is it possible to create such replication

edited May 23 '17 at 10:26

Community

1
1

answered May 03 '14 at 18:31

user3599730

136
3

CSV Export/Import Column Mapping

1 Answers1