Sedang Disiapkan

Automatic *.CSV to MySQL Program Required

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

Kemahiran: Pengaturcaraan C, Java, MySQL, Kejuruteraan Perisian, Visual Basic

Lihat lebih lanjut: programming schedule, automatic programming, mysql database manager, windows automatic, mysql backup, windows server 2012 program directory, automatic java, column already exists, csv update, mysql update values, mysql backup table, update values mysql, windows program login project, table csv, java import file, mysql create table, csv table, file backup program, java file manager, program backup files, java project manager, java location windows, import csv database, mysql update table, mysql user login

Tentang Majikan:
( 32 ulasan ) melbourne, Australia

ID Projek: #4073492

Dianugerahkan kepada:

eperfections

As discussed! Please accept.

$100 AUD dalam sehari
(335 Ulasan)
7.2

14 pekerja bebas membida secara purata $139 untuk pekerjaan ini

triyama

Hello, Does your windows PC have PHP installed? Can we do this using PHP? If yes, we can finish this in a couple of hours. We have done bulk-import using CSV on several of our projects before and it would be very Lagi

$200 AUD dalam 15 hari
(108 Ulasan)
7.8
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.

$119 AUD dalam 2 hari
(86 Ulasan)
7.1
cheapexcell

Hello, I am an expert in C# & MySQL with over 5 years of experience. Let's get started. Thanks, Alex

$195 AUD dalam 2 hari
(102 Ulasan)
5.6
initSoftware

Hello Sir, Interested in doing this project. Thanks.

$250 AUD dalam 5 hari
(17 Ulasan)
4.7
weberysoft

Dear Sir, I know PHP, MySQL, JavaScript, jQuery, HTML(5), CSS(3). I have experience in Custom CMS and various PHP framework like CakePHP, Symfony, and many open source customization like OsCommerce, Joomla, Magento, Ze Lagi

$100 AUD dalam sehari
(2 Ulasan)
4.4
abhius

Done Sir :)

$149 AUD dalam 4 hari
(15 Ulasan)
4.4
narendragautam

Hi, I have developed similar application which convert execel file to sqlite database table. you can check at [url removed, login to view] Let me know you face any issue in download Lagi

$250 AUD dalam 10 hari
(7 Ulasan)
3.8
topcoder9793

Hi I am interested in this project. Please see PMB. Thanks

$100 AUD dalam 3 hari
(4 Ulasan)
2.5
FcsMiranda

Good day. I have experience in develop procedures like this. I am ready to assist. Please see PM. Thanks.

$80 AUD dalam 0 hari
(3 Ulasan)
1.8
nmlemus

I do the job, but I have some questions. I create a program to export the csv to MySQL but I create only one table in MySQL. I think that we can create some other tables and do a more functional data base. So, if you a Lagi

$100 AUD dalam 2 hari
(1 Ulasan)
1.4
dharmeshs

Hi please read pm.

$100 AUD dalam 2 hari
(1 Ulasan)
0.4
dvya19

Dear Sir, I have good experience in automating data import/migration. Please consider my bid Thanks, Divya

$100 AUD dalam 5 hari
(0 Ulasan)
0.0
harekrishna10820

Work 3 years as a Software Developer. Familiar with Enterprise technologies (Different Application Servers) and many programming languages. Technical Skills: Programming Languages ( 5 years ) Agil Lagi

$101 AUD dalam 2 hari
(0 Ulasan)
0.0