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.
6. Primary key must be column A
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