We require a import program which will import text files into our MySQL database.
I have attached a zip file with the database, files to be imported and also further detailed instructions. When testing i will be loading in over 5000 files so the program needs to handle this.
1. When importing, please trim white space from start and beginning of all values.
2. I must be able to change the name of columns in the database and this will not affect the import program.
2. If importing data and data already exist in database, data must update existing data.
3. Program must be able to check import directory every 5 minutes and load data into database.
5. When imported successfully, move file to backup directory. If file already exist in backup directory, then append a number to the end of the file so we can keep backup of everything.
4. Everything must be configurable from a configuration file and must produce a log file so we can diagnose if any errors.
a. CSV output directory
b. Directory where files are dropped.
c. Backup directory
d. Log file
5. Must run in windows xp, 7, 2008 in x32 and x64 bit environment.
6. Must be able to run as an unattended. Either I can schedule via windows task manager every 5 minutes, or runs as a windows service.
Hi, We have worked before. I have developed many text file parsers. I can write a flexible application which will handle all your requirements. Looking to start.
35 freelancers are bidding on average $422 for this job
DEAR SIR, EXPERT PROGRAMMER HERE. I CAN DO IT MEETING ALL REQUIREMENTS. I AM EXPERT IN DATA PARSING AND AUTOMATA. PLEASE TAKE A LOOK AT MY REVIEWS AND RATING. THANKS...