In Progress

Import text files into MySQL Database automatically.

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.

Extra Notes

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.

Skills: C Programming, MySQL

See more: programming schedule, log into, beginning programming, beginning c programming, mysql database manager, mysql backup, log files, files manager, mysql database import, mysql load text, start windows service, load text mysql, import csv data mysql, mysql append data, mysql append, program directory instructions, please check log files, mysql update values, mysql import csv data, update values mysql, mysql data directory, csv text file, service log configuration, windows service 2013, mysql load csv file

About the Employer:
( 32 reviews ) melbourne, Australia

Project ID: #4811885

Awarded to:

eperfections

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.

$526 AUD in 5 days
(138 Reviews)
6.8

35 freelancers are bidding on average $422 for this job

buraqtech

Check your PMB for details!!!

$572 AUD in 8 days
(32 Reviews)
7.1
hoangvandungbk

hello, i can help you this project

$736 AUD in 7 days
(139 Reviews)
6.4
whoi

Hi, I'm experienced with MySQL and Windows programming for many years. It is easy for me.

$515 AUD in 3 days
(16 Reviews)
6.6
kaloyan13

C/C++ programmer with experience in parsing and DBs.

$315 AUD in 4 days
(205 Reviews)
6.7
nirandas

Hello, c# .net 4.5 solution

$684 AUD in 10 days
(81 Reviews)
6.7
pivn

Let expert do this

$555 AUD in 3 days
(109 Reviews)
5.9
cheapexcell

Please see PMB

$401 AUD in 3 days
(59 Reviews)
5.9
JoomlaVogue

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$412 AUD in 12 days
(23 Reviews)
6.3
weonlydo

Thank you for your detailed requirements. Please see private bid details in PM.

$421 AUD in 4 days
(40 Reviews)
5.6
juliasoft

Please, see private message

$598 AUD in 7 days
(54 Reviews)
5.5
truongngocthanh

Hello, Please check your PM for more detail. Thanks

$500 AUD in 6 days
(39 Reviews)
6.0
PHPsoldier

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...

$333 AUD in 5 days
(45 Reviews)
5.4
gkan1234

Hi I will do this for you. Please check PM.

$250 AUD in 5 days
(29 Reviews)
4.5
zhoumo

Hi, I have done many C projects, and let me help you.

$555 AUD in 5 days
(10 Reviews)
4.8
romanuwa

I can do this for you, please check PMB.

$250 AUD in 4 days
(22 Reviews)
4.2
quatroo

I can help you.

$277 AUD in 5 days
(7 Reviews)
3.5
hardikshah83

Hello, Please see pmb, programmer with more than 10 years of experience here.

$250 AUD in 3 days
(10 Reviews)
3.4
kaleshwarchand83

Hi, please see pm

$250 AUD in 10 days
(10 Reviews)
3.0
udk1dev

Please, check your PMB.

$498 AUD in 2 days
(1 Review)
2.7
RaciSolutions

Hello! I am interested in your project. Please check PM!

$300 AUD in 7 days
(3 Reviews)
2.5