Em Andamento

Import csv file into MySQL Table

Import to MySQL Table

*please note, table has already been created with primary keys. This job is only to develop the software.

1. CSV file will be put into incoming folder

2. When program is executed, it must process each file that is in the incoming folder and load into MYSQL database table. The program must run with no user involvement (As I will schedule it with windows task manager). Everything must be configurable from a configuration file and must produce a log file so we can diagnose if any errors.

a. Directory where files are dropped.

b. Backup directory

c. Log file

3. Once finished processing move the csv file to the backup folder, if file already exist in backup folder then rename file to have an increment of “1” on the end. This will allow the old file not to be over written.

4. Data must update existing data in database if imported and there is a match

Key Notes

1. Line 1 in csv please exclude heading

2. Must run in Windows 7 (32 and 64bit) and Windows 2008.

3. Must be able to schedule with windows task manager

4. Must have a [url removed, login to view] file where we can configure database login, table name.

Habilidades: Programação C, Java

Ver mais: file csv, csv mysql, log into, java database programming, java configuration manager, mysql database manager, mysql backup, csv file, import csv data mysql, java mysql job, csv update, table heading, mysql import csv data, mysql backup table, import files folder, table csv, windows config update, csv files processing, mysql data directory, java import file, job schedule task, csv table, line csv, mysql load csv file, import java processing

Acerca do Empregador:
( 32 comentários ) melbourne, Australia

ID do Projeto: #5085704

Premiar a:

eperfections

Simple enough. Ready to do it. Please accept my bid and create milestone. Thanks.....................................

$100 AUD em 3 dias
(321 Avaliações)
6.9

17 freelancers estão ofertando em média $127 para este trabalho

IMSeriousBidder

Hello Sir, I am Bing ,how are you. I am very very good at this kind data transform&load work, I have 11 years programming experience,I can do this task very quickly , please consider my serious bid. Than Mais

$207 AUD in 2 dias
(99 Comentários)
7.2
qspsolutions

Hi, professional Delphi developer here. Long story short, I can make this tool to import data in table. It would be able to run without user interaction, so with scheduler. It would load all necessary settings from Mais

$315 AUD in 7 dias
(11 Comentários)
5.5
gangabass

Hi, I can provide you excellent solution in less than two days for the best price here. I'm talking about command line exe program (you can place it in Windows Scheduler to run automatically) which will read config Mais

$83 AUD in 2 dias
(33 Comentários)
4.8
chinbochen

Hello, I'm an experienced Java, J2EE application developer, I'm very happy to get this project done for you. Thanks.

$100 AUD in 3 dias
(9 Comentários)
4.4
artursharipov

Hi, requirements are clear. Do you have specific requirements about programming language? I can do it in C# or Java, whatever is more suitable for you. Regards, Artur

$200 AUD in 2 dias
(6 Comentários)
4.0
cheapexcell

Hello, I am an expert in MySQL & Windows programming. I have done many similar jobs. Ready to start. Thanks, Alex

$80 AUD em 1 dia
(6 Comentários)
3.8
hemantjani

hello Will be very happy to do your project as this are our field of expertise. just need to ask few thing the rest is pretty much clear and we can start right away. I have an expert team of 10 that can handle a Mais

$147 AUD in 7 dias
(2 Comentários)
1.6
muhammadnagy

Hello, I have a wide experience in database application. I can finish this small project very soon with the best performance. Regards, Muhammad Nagy Software Engineer

$154 AUD in 3 dias
(1 Comentário)
1.5
rengrish

Quite Simple job, Ready to take up immediately. I have very good experience in this . I have done many data import from Excel/CSV using Java JDBC. I assure you 100% quality job .please let me know .

$155 AUD in 3 dias
(1 Comentário)
0.9
vanpham

Hello, I read your requirements. I don't think it is so hard. The problem is the csv file may be big. So, in this case we will have to optimize the code for a best performance. I can handle this project. Thanks. Mais

$111 AUD in 3 dias
(0 Comentários)
0.0
tuanbn1812

I think this is a simple job. I can do this job for 2 days. I use window service (.NET) for this project.

$66 AUD em 1 dia
(0 Comentários)
0.0
mackmorris

I'm a Developer with 10+ years experience. My experience includes Java and MySQL. I currently have a full time job as a Java developer and I'm looking to earn a little money on the side.

$83 AUD in 7 dias
(0 Comentários)
0.0
photonzephyr

Hello. I have read through your requirements and I do have a question. What language would you like this program written in? I noticed you listed it under C and Java.

$77 AUD in 5 dias
(0 Comentários)
0.0
flossga

I work for a company who is into ETL as well. The requirement is a very small subset of our product achieves. Anyway I cannot take the product and put it for you, as the product belongs to the company! But I hope I Mais

$77 AUD em 1 dia
(0 Comentários)
0.0
koomie

I have more experiences with java programming. I'm available to server this project for you now. Please ping message to me.

$111 AUD in 3 dias
(1 Comentário)
0.0
AccuPro

Hello, I can help. Have done several such implementations earlier. With over 2 decades of database experience, Best regards, AccuPro.

$100 AUD in 3 dias
(0 Comentários)
0.0