HI There,
I'm working on a little application where a user can import data from a CSV and insert that data to the database. This bits work fine provided that the csv column are in the define order eg Firstname Lastname Age Country. But if someone import a CSV where the column is Country, Lastname ,Firstname Age. The data will be wrongly imported on the wrong column. I was wondering if there a way where we can assign the column of the database to match a specific column of the csv file.
E.g
once the CVS imported, but not inserted in the database so far. we have drop down which display the column name from the database on the left and on the right the column name from the csv file. There we can match which data should go in which field.
Hope this is clear, else please do not hesitate to get back to me.
Start Free Trial
