Find Jobs
Hire Freelancers

Automate CSV imports into MYSQL database

£100-400 GBP

Selesai
Dibuat lebih dari 8 tahun yang lalu

£100-400 GBP

Dibayar ketika dikirim
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).
ID Proyek: 9014047

Tentang proyek

28 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 according to your specifications and change if needed. I can have the program ready within 2 days. Regards, Marina Louki [login to view URL]
£111 GBP dalam 3 hari
5,0 (31 ulasan)
5,1
5,1
28 freelancer menawar dengan rata-rata £240 GBP untuk pekerjaan ini
Avatar Pengguna
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 Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
£309 GBP dalam 15 hari
4,8 (241 ulasan)
7,7
7,7
Avatar Pengguna
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 done. 3. However we would like to have some samples of the csv files that are currently being imported to have a look at. 4. The script can be run on cronjob at a set time so that, the automatic import of csv can be executed. Approximate time to complete : 6 - 7 days. Thanks, Gopal
£315 GBP dalam 6 hari
4,4 (113 ulasan)
8,0
8,0
Avatar Pengguna
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 change as well as we need to truncate the data then the best way will be to delete the existing table then recreate the table with new content. Waiting for your response!
£421 GBP dalam 3 hari
4,9 (72 ulasan)
6,9
6,9
Avatar Pengguna
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 ME. LOOKING FOR A LONG TERM RELATIONSHIP. -------------- THANKS, AJIT
£222 GBP dalam 7 hari
4,9 (159 ulasan)
6,5
6,5
Avatar Pengguna
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 dalam 5 hari
5,0 (152 ulasan)
6,6
6,6
Avatar Pengguna
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 dalam 3 hari
4,8 (22 ulasan)
5,9
5,9
Avatar Pengguna
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% satisfaction guaranteed. You can release payment after work is done. My services include Data Migration, Server Transfer, Magento, Open Cart, OS commerce, WordPress, PHP, Designing, PSD to HTML, Jquery, Angular Js and technical support. Awaiting for your positive reply and looking forward to working on your project. Feel free to ask me any question you may have. Thank you,
£300 GBP dalam 3 hari
5,0 (39 ulasan)
5,4
5,4
Avatar Pengguna
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 be added to the csv files? Could you send me old version of some CSV to show me example what changed? We can divide task to 10 milestones, if you prefer. In any case I will implement project step by step, csv by csv.
£400 GBP dalam 10 hari
4,8 (47 ulasan)
5,4
5,4
Avatar Pengguna
A proposal has not yet been provided
£263 GBP dalam 6 hari
4,6 (2 ulasan)
4,3
4,3
Avatar Pengguna
A proposal has not yet been provided
£277 GBP dalam 3 hari
5,0 (9 ulasan)
3,8
3,8
Avatar Pengguna
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 easily stored to the database. and i need to know your .csv structure. we can discuss the detail of this job and payment will be made after this job is completed 100%. thanks..
£100 GBP dalam 1 hari
5,0 (12 ulasan)
3,3
3,3
Avatar Pengguna
Hi, I can create you a bash script for importing csv files into mysql db. It can be done in maximum 2 days. If you have questions or you need more discussion, please contact me. regards, Mladen
£288 GBP dalam 2 hari
4,2 (11 ulasan)
4,1
4,1
Avatar Pengguna
come on chat now so we can discuss more....am waiting
£100 GBP dalam 1 hari
4,9 (7 ulasan)
3,0
3,0
Avatar Pengguna
A proposal has not yet been provided
£200 GBP dalam 3 hari
5,0 (2 ulasan)
2,7
2,7
Avatar Pengguna
Having gone through your requirement we can do it with cron job. So this will do it automatically. We can set a time interval
£333 GBP dalam 4 hari
4,0 (1 ulasan)
2,4
2,4
Avatar Pengguna
Hi,sir. How are you today? I have many experiences in .Net application and CSV. I will finish project in 10 hours. Please contact me and discuss more. best regards.
£100 GBP dalam 3 hari
5,0 (1 ulasan)
1,2
1,2
Avatar Pengguna
A proposal has not yet been provided
£455 GBP dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Aucune proposition n'a encore été fournie.
£285 GBP dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello! I have some questions: First server architecture. (Web, local)... I propose a solution built on Java technology. It`s suits you?
£280 GBP dalam 8 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I am Mangesh Shinde and I have read your requirements. I can write a script in PHP to import your csv files into the database tables periodically. I am an experienced web developer and have experience in working with PHP, CSS, HTML, JQUERY. Looking forward to work with you. Regards, Mangesh Shinde
£111 GBP dalam 3 hari
0,0 (1 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
Wokingham, United Kingdom
5,0
43
Memverifikasi Metode pembayaran
Anggota sejak Jan 7, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.