Applellial Posted June 10, 2011 Share Posted June 10, 2011 Hello, I run a fairly large & popular community based website but currently cannot afford to pay someone to update my import scripts (php/mysql), which import data from affiliates to populate a table in our database. Problem is the partners/affiliates are sometimes changing their schema, which they have done recently. I'm therefore currently inserting the data manually, but its taking a good 5 minutes a row, and there are thousands of rows ahead of me. I'm therefore wondering if there is available software that allows you to import data by simply matching fields in a csv file to the database fields? Some rows would need to be new, some rows would need just a few fields updating. Is there software that can do this? It would need to fuzzy match a 'Name' field for each row etc. There are some linked tables but I could bypass those for now. I realise i could be clutching at straws here but any info would be appreciated. Many thanks! Link to comment https://forums.phpfreaks.com/topic/238951-program-to-import-mysql-data-for-me/ Share on other sites More sharing options...
mikosiko Posted June 10, 2011 Share Posted June 10, 2011 LOAD DATA [LOCAL] INFILE could be your solution Link to comment https://forums.phpfreaks.com/topic/238951-program-to-import-mysql-data-for-me/#findComment-1227922 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.