In Progress

Automate CSV imports into MYSQL database

Hi, I regularly import csv files into my database and I would like a procedure created that can do this automatically.

There are 10 or so csv files located in a directory on the server. Each of these files is associated with a table in the database. For each csv file, the associated table should be first truncated and then the new data loaded into the table.

Sometimes additional columns will be added to the csv files so it may be necessary to update the table structure (either by adding additional fields or dropping and recreating the table).

Skills: MySQL

See more: codeigniter csv database mysql, add information database mysql using csv, update mysql database via php csv file, php upload csv database mysql, mysql timestamp csv columns, php mysql upload csv add update database, update database csv cre loaded, create database mysql csv, front end database mysql

About the Employer:
( 22 reviews ) Wokingham, United Kingdom

Project ID: #9014047

Awarded to:

Attractionnet

Hello. I'm a mysql vb.net expert. I have created may applications for converting data. I will create a program that will get the input files. make any conversions and add them to your mysql. Everything can be done acco More

£111 GBP in 3 days
(13 Reviews)
3.3

32 freelancers are bidding on average £231 for this job

gemol

Hi, I can develop this program as .Net application (Windows or Web)with using of C# or VB.Net. This program can be standalone program or Windows service (with configurable parameters of CSV files' searching/processing More

£100 GBP in 3 days
(35 Reviews)
7.3
graphicaa

IS THIS right time to chat with you? 1. The automatic option to import csv files into the database can be done. 2. The additional columns to be added to the database table when the csv file format changes can be do More

£315 GBP in 6 days
(71 Reviews)
6.9
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

£309 GBP in 15 days
(158 Reviews)
7.2
csajit

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON More

£222 GBP in 7 days
(129 Reviews)
6.2
stdhtelkom

Hello, I am very interested and love to help you. Looking forward to talk on details and working with you. Thanks and all the best, Steve

£100 GBP in 3 days
(19 Reviews)
5.9
searchtechnow

I AM READY TO START NOW. I assume you will upload CSV file on FTP with the name of table we need to pick them from that location and need to save the data in DB. Correct? As you have said that structure may be ch More

£421 GBP in 3 days
(35 Reviews)
6.0
developerhunk

Hello , I have read your project descriptions and requirements very carefully and I am very much confident that I can do it in time because I know MYSQL well . Please talk to me and give me a little [url removed, login to view] can c More

£157 GBP in 2 days
(24 Reviews)
6.3
juliasoft

// if you have foreign keys SET foreign_key_checks = 0; // truncate table delete from your_table; // or simple an faster truncate table your_table; // load data from csv LOAD DATA INFILE '[url removed, login to view]' INTO TAB More

£148 GBP in 3 days
(46 Reviews)
5.4
phpprogramming

I have gone-through your requirements and confident to do it properly. I have great experience in php, mysql, smarty, jquery, css, CakePHP, CodeIgniter, yii, opencart, cubecart, wordpress. [url removed, login to view] More

£222 GBP in 3 days
(68 Reviews)
5.8
scmwonjin

Dear Sir i am mysql expert. i already developed the project that import csv file into database. i would like discuss with you about your project. thank you. Best Regard.

£263 GBP in 3 days
(9 Reviews)
5.4
expertcoder1vw

Hi, I"m an expert MySQL / CSV / database/ Windows application developer and can deliver for you a Windows application to do the import to MySQL for you. If you require scheduling functionality I can do that too; I More

£250 GBP in 4 days
(16 Reviews)
4.8
rylkov

Could you attach CSVs? Do you mean MySQL Stored Procedure? Or I can write PHP (or other language) script to implement this task? Do you want to update the table structure automatically when additional columns will More

£400 GBP in 10 days
(39 Reviews)
5.0
Alex1x23

Hello Sir/Mam, We have an experienced team of developers and designer for your project. Our motive is to satisfy you 100% while doing the project and also help you after delivering the work. So you can check our work More

£200 GBP in 3 days
(13 Reviews)
4.9
malviyamanish

Dear Client Greetings, Hopefully you are doing well. I have working experience of more than 6 years in Web Site design & development and have developed more than 300 websites here on [url removed, login to view] & more than 400 More

£315 GBP in 3 days
(14 Reviews)
5.2
harshatilva

Hi, I hope you are doing fine. I am new to freelancing but I have 4 to 5 year experience in designing and developing. I read your project description and would like to work with you. I will provide you 100% sa More

£300 GBP in 3 days
(12 Reviews)
4.0
shahid864

Hi, I am working as a web developer from the past five years. I believe in providing quality work with long term relation with clients . let discuss and start now. Please give a chance. thanks

£222 GBP in 5 days
(41 Reviews)
4.2
smitakad89

come on chat now so we can discuss more....am waiting

£100 GBP in 1 day
(7 Reviews)
3.1
Skinner

7+ years PHP, MySQL, HTML, CSS, Javascript, Jquery. Latest clients include [url removed, login to view], [url removed, login to view], [url removed, login to view], m-vision, o'reilly ST & yorkprintcompany.co.uk. Java/C++ coder with BSc Computer Science.

£277 GBP in 3 days
(7 Reviews)
3.2
sovenkoaavenkoaa

A proposal has not yet been provided

£200 GBP in 3 days
(2 Reviews)
2.7
nurzazin

i am developer website from indonesia, i have a lot of experience about mysql and others which used to build a website. i already have the php function that can convert .csv or .xls files to data and the it can be More

£100 GBP in 1 day
(5 Reviews)
2.2