I gang

Automated *.csv to MySQL Program required with no user interaction

Program Requirements:

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

Færdigheder: C programmering, Java, MySQL, Software Arkitektur, Visual Basic

Se mere: programming schedule, user settings, windows 7 program, mysql database manager, mysql backup, interaction, windows server 2012 program directory, column already exists, converted mysql, csv update, mysql update values, mysql windows server 2008, mysql backup table, update values mysql, windows program login project, table csv, java import file, mysql create table, csv table, file backup program, mysql converted, java file manager, program backup files, java project manager, java location windows

Om arbejdsgiveren:
( 32 bedømmelser ) melbourne, Australia

Projekt-ID: #4048611

Tildelt til:

eperfections

Thanks for the invitation. Please check INBOX!

$125 AUD in 2 dage
(335 bedømmelser)
7.2

56 freelancers are bidding on average $121 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$120 AUD in 3 dage
(86 bedømmelser)
7.1
srinichal

I am an expert in automation and can deliver the project

$250 AUD in 8 dage
(110 bedømmelser)
6.9
IMSeriousBidder

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

$120 AUD på 1 dag
(57 bedømmelser)
6.7
ineedWorkJob

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)

$100 AUD in 3 dage
(161 bedømmelser)
6.6
marchent

i am interested on this project. but first want to see your mysql table!

$100 AUD in 7 dage
(146 bedømmelser)
6.1
barundebnath

Hi, I expert in making automation tools. This is a few hours job for me. Thanks

$80 AUD in 2 dage
(57 bedømmelser)
5.8
ddumitrascu

Hi, The requirements are very clear. I am ready to start. Thank You, Dan

$100 AUD in 2 dage
(128 bedømmelser)
5.6
appwiz

Hi there, please see my private message for further bid info

$200 AUD in 5 dage
(46 bedømmelser)
5.6
rylkov

I can implement this program with use of Java.

$120 AUD in 3 dage
(59 bedømmelser)
5.4
norberto108vw

Hi, I have experience in batch file processing on telecom industry. Let me help you on this project. Regards, Norberto

$250 AUD in 7 dage
(24 bedømmelser)
5.2
poornachand

I have 5+ years experience in JAVA and MySQl and ready to start your work.

$60 AUD in 2 dage
(26 bedømmelser)
5.1
csanuragjain

hi i can do this contact if interested

$100 AUD in 10 dage
(23 bedømmelser)
5.1
bharatkasodariya

Hi, I am interested in your project. Please check my profile.

$100 AUD in 2 dage
(16 bedømmelser)
5.0
aoefmpes

pl check your inbox

$150 AUD in 3 dage
(32 bedømmelser)
4.9
zaxidelercoder

The requirement is very clear.

$100 AUD in 5 dage
(40 bedømmelser)
4.9
kalpesh2804

Hi, I have experience in Data Conversion. Please check my completed projects.

$30 AUD in 3 dage
(34 bedømmelser)
4.8
mike25

More details via inbox. Regards, Mike

$110 AUD in 15 dage
(19 bedømmelser)
4.7
diamond1027

Hi, I can do it perfectly. Please see the PM. Regards.

$100 AUD in 3 dage
(29 bedømmelser)
4.6
stefanache

Hello, Please consult your PMB. Thanks.

$111 AUD in 5 dage
(8 bedømmelser)
4.5
jr593

Program is ready for you, please see PMB

$100 AUD på 1 dag
(1 bedømmelse)
4.4