Find Jobs
Hire Freelancers

Automate CSV imports into MYSQL database

£100-400 GBP

Terminado
Publicado hace más de 8 años

£100-400 GBP

Pagado a la entrega
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 del proyecto: 9014047

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
5,0 (29 comentarios)
5,0
5,0
30 freelancers are bidding on average £232 GBP for this job
Avatar del usuario
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 en 15 días
4,8 (238 comentarios)
7,6
7,6
Avatar del usuario
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). I'm qualified .Net developer. I have an rich experience in development and support of the solutions using .Net and SQL. Thanks
£100 GBP en 3 días
5,0 (42 comentarios)
7,3
7,3
Avatar del usuario
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 en 6 días
4,4 (104 comentarios)
7,8
7,8
Avatar del usuario
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 en 3 días
4,9 (70 comentarios)
6,9
6,9
Avatar del usuario
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 en 7 días
4,9 (152 comentarios)
6,4
6,4
Avatar del usuario
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 en 5 días
5,0 (127 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
4,8 (22 comentarios)
6,0
6,0
Avatar del usuario
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 en 3 días
5,0 (39 comentarios)
5,4
5,4
Avatar del usuario
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 en 10 días
4,8 (44 comentarios)
5,2
5,2
Avatar del usuario
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 en 1 día
5,0 (12 comentarios)
3,3
3,3
Avatar del usuario
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 en 2 días
4,2 (11 comentarios)
4,1
4,1
Avatar del usuario
come on chat now so we can discuss more....am waiting
£100 GBP en 1 día
4,9 (7 comentarios)
3,1
3,1
Avatar del usuario
A proposal has not yet been provided
£200 GBP en 3 días
5,0 (2 comentarios)
2,7
2,7
Avatar del usuario
A proposal has not yet been provided
£263 GBP en 6 días
4,0 (1 comentario)
3,1
3,1
Avatar del usuario
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 en 4 días
4,0 (1 comentario)
2,5
2,5
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,4
1,4
Avatar del usuario
A proposal has not yet been provided
£277 GBP en 3 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
A proposal has not yet been provided
£455 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Aucune proposition n'a encore été fournie.
£285 GBP en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello! I have some questions: First server architecture. (Web, local)... I propose a solution built on Java technology. It`s suits you?
£280 GBP en 8 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Wokingham, United Kingdom
5,0
41
Forma de pago verificada
Miembro desde ene 7, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.