OS: Windows 2008, Windows XP, Windows 7
1. When program executed, import all *.csv files from programmed directory into MySQL database table.
2. Once each file is successfully imported into the MySQL database it must be moved to the backup directory. If the file already exists in backup directory then overwrite the existing one.
3. All program settings must be configurable by *.ini file
a. MySQL Server login settings including table name
b. Backup directory location
c. CSV Source directory location
d. Log directory location
4. Must be able to schedule this program with windows task manager every 10 minutes and it will import, then exit. No user interaction.
5. Column “E” must be converted to date when imported.
6. Primary key must be a concatenation of
a. Column “A” + “E”+” J”+”AO”
7. Primary key must update existing values if imported more than once.
8. If there is an error, please make the program create an "[url removed, login to view]"
Sample files have been attached to this project
56 pekerja bebas membida secara purata $121 untuk pekerjaan ini
Hello, I am a Java expert,I have checked the zip file, I am confident I can do this program for you in 24 hours please consider my serious bid Thanks Bing
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)