Need a generic CSV parser that will be taking the file, parse the 1st line which contain the name of the column, and then use the column as the field name to be inserted into mysql
[url removed, login to view]
It will get inserted into a correspoding mysql table which has field of header1, header2, header3 and header4.
The Perl script should be generic enough to take in any file and put into mysql table as long as the condition above is fulfilled. The script should work for file up to 10 millions line.
I will provide the sample CSV file and MySQL schema upon request.
28 pekerja bebas membida secara purata $61 untuk pekerjaan ini
Hi, This is just like many other projects I have already did and I can make this for you. Please see the private message board for more details. regards VC
Hi Rob! Interesting proposal. What if there are more tables with those headers? Should we insert in all those tables that information? I'd also like to see the schema (someone wanted it too). Thanks, Anca
I look forward to the opportunity to work on this project. I have over 10 years of experience in programming and systems for the commerical and the education markets.