Project Description:
Make csv file to upload dump file to mysql. I need the easiest and most automatic procedure to export data daily. from (Cl-Export.csv) to (clf_ads). matching field values to (clf_ads). keeping clf_ads headings. One column (cityid) will need to be queried from file (Cl-Export.csv) column (city) and (clf_cities.xls) heading . Column Heading (subcatid) will need to be queried from (Cl-Export.csv) heading column Category and from (clf_subcats.xls) heading subcatid and subcatname. Please see SQL-table.xls attachment for notes and instructions.