Find Jobs
Hire Freelancers

PHP script that can import csv into mysql database

$250-750 USD

Cerrado
Publicado hace casi 8 años

$250-750 USD

Pagado a la entrega
I need a php script that can cycle through all the csv files in a directory and load them to MySQL. Here are the requirements Needs to be able to specify the directory to look in for the files Needs to be able to load the csv to an existing table if It is there or create a new table if it isn't Needs to be able to skip duplicates IE it could be a full table dump file that 90% of the records already exist in the database Need to have the ability to replace the table if the user selects the flag Needs to delete the file once it has processed it Needs to log any issues to a log file Needs ability to be scheduled as a cron job to run nightly if possible
ID del proyecto: 10782115

Información sobre el proyecto

54 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
54 freelancers están ofertando un promedio de $345 USD por este trabajo
Avatar del usuario
Hello.. Nice to see your project posted here. I have read details. I think as far as this point is concerned: "Needs to be able to skip duplicates IE it could be a full table dump file that 90% of the records already exist in the database" - we need to know if it will check all columns against that table to detect a duplicate or there is a single column to decide on the duplication? Tx
$275 USD en 5 días
4,9 (679 comentarios)
8,8
8,8
Avatar del usuario
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactorily completed. I estimate a 5-7 day turnaround (including weekends) on this project. ftp details to your server will be required. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$450 USD en 7 días
4,9 (767 comentarios)
8,3
8,3
Avatar del usuario
Hi I have +10 years of experience in programming. I can make such script for you in 48 hours! Are you interested?! Let's start just now;) Thanks, Helmot
$300 USD en 5 días
4,8 (193 comentarios)
8,1
8,1
Avatar del usuario
Hi there, I’d like to be considered for your Project. I’m a designer and developer with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress, MySql, magento, joomla,etc. For 6 years I’ve developed many complex and extensive custom sites of varied extents and complexity. I have a deep passion for research and guarantee that all of my work is 100% working. I highly value professionalism and hold myself strictly accountable to my clients. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Asad Sajjad
$555 USD en 22 días
5,0 (86 comentarios)
7,8
7,8
Avatar del usuario
Hi there, I can build the csv import script. "Needs to be able to load the csv to an existing table if It is there or create a new table if it isn't" Q: how will the script know the table name of table it needs to import the data into? "Needs to be able to skip duplicates IE it could be a full table dump file that 90% of the records already exist in the database" Q: Can I consider the first column in the csv to be the unique identifier? "Need to have the ability to replace the table if the user selects the flag" Q: Understand this, but if you're planning to run it via cron at night, there will be no user input or option for user to set the flag to replace table for that given csv file. Looking forward to hearing from you. Regards, Julijan
$277 USD en 3 días
5,0 (130 comentarios)
7,3
7,3
Avatar del usuario
Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **
$555 USD en 10 días
4,9 (452 comentarios)
7,4
7,4
Avatar del usuario
Hello, my name is Josef, i'm experienced developer, and i would like to offer you my services. I have written similar scripts in the past, and i can deliver PHP script importing CSV files into the MySQL as per your specification. Most of the project is clear, but i need more information about some of the requirements. In case you will pick me for this project, we should discuss them by private message. I hope you will pick me, and i'm looking forward to our cooperation. Kind regards, Josef
$250 USD en 3 días
4,9 (265 comentarios)
7,3
7,3
Avatar del usuario
Hi, I am very good in php/smarty/mysql/bootstrap/css/wordpress i have read the description and quite sure i am able to do the work with desired accuracy hope to hear from you soon thanks
$555 USD en 20 días
4,9 (359 comentarios)
7,0
7,0
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
$300 USD en 7 días
4,9 (273 comentarios)
6,8
6,8
Avatar del usuario
Hello Sir, We have checked your job detail and as per that we are able to do your job and we have very good experience in WordPress, Wordpress custom plugin, Joomla, Joomla modual and component, PSD to CMS, PHP, HTML, Magento, TYPO3, Cubecart etc. As well knowledge on Mobile app screen Designing logo, layout, mock up and HTML, Android, Yii, Amazon webservices. We will sure give you our best work and complete your job as soon as possible. If you have any query please send me message in here. We will reply you as soon as possible. Waiting for your reply Thanks, Pinakin
$250 USD en 10 días
4,9 (145 comentarios)
6,4
6,4
Avatar del usuario
Dear Sir, PHP expert here. I understood the requirement. First I will create the import job run form. It will have a text field to enter the CSV directory, a text field to enter table name (it will create new one if that table doesn't exists), a checkbox to indicate whether it should empty the table first, and a checkbox to indicate if it should run later and if this is selected then another field will appear to enter date and time to run. When it runs it will skip the duplicates(when all fields are identical) and log all events(starts, ends, errors). After a run it will delete all CSVs under selected directory. The CSV should have a header row so that the script can create fields while creating the table or it will create fields like 'field1', 'field2' etc. All fields will be text field as the data type of a particular column of the CSV is not known. Thanks...........
$250 USD en 10 días
4,9 (138 comentarios)
6,6
6,6
Avatar del usuario
Hello There, I am excited to share with you the proposal for creating the PHP Script capable of cycling all the csv files in the directory and loading them into mysql.I am a EXPERT PHP Developer having extensive experience of building Web applications.I will be able to deliver this project within time frame and budget with 100% customer satisfaction.I highly value professionalism and hold myself strictly accountable to represent my client’s brand.I aim to form a long-term working relationship. I Hope to hear from you soon so that we can start working on this. I look forward to your response. All the very best
$555 USD en 10 días
4,9 (96 comentarios)
5,8
5,8
Avatar del usuario
HI, I very much interested to work on this projects. Sent the sample CSV files, we immediately within 1 or 2 day we deliver the project. Once we completed, we show the demo, If you like the demo then offer us. I eagerly wait for your reply. Cheers, Joshua
$527 USD en 10 días
5,0 (32 comentarios)
5,2
5,2
Avatar del usuario
Hi Friend, I am having 8 years of experience in LAMPP Technologies. I can start the work immediately. How can we identify the table name ?. is it same as file name ?. Thanks
$277 USD en 10 días
5,0 (81 comentarios)
4,9
4,9
Avatar del usuario
Dear, I am new in freelancer but I have 4 years experience in PHP ,If you hire me i will give excellent work and quality services for you and your requirements. Have a nice day!
$261 USD en 3 días
5,0 (62 comentarios)
5,0
5,0
Avatar del usuario
Hi, how are you If you are interested I can help with this project and I can do right now If you agree send me a message Thanks for your time
$311 USD en 0 día
4,8 (62 comentarios)
5,3
5,3
Avatar del usuario
Hi, I can develop a php script that can import csv data in to mysql database Also, yes it is possible to run cronjob Please share sample csv file to check Waiting for your positive reply Thank you, Brijesh
$250 USD en 2 días
4,9 (32 comentarios)
5,1
5,1
Avatar del usuario
Please contact me and i do it for you ASAP. Regards, Alex
$250 USD en 5 días
5,0 (20 comentarios)
4,6
4,6
Avatar del usuario
Hi, Understanding of work: - I have to develop a php script that can import csv into mysql database - Also need more requirement as per below points: Needs to be able to specify the directory to look in for the files Needs to be able to load the csv to an existing table if It is there or create a new table if it isn't Needs to be able to skip duplicates IE it could be a full table dump file that 90% of the records already exist in the database Need to have the ability to replace the table if the user selects the flag Needs to delete the file once it has processed it Needs to log any issues to a log file Needs ability to be scheduled as a cron job to run nightly if possible Yes possible to run cron job I would like to see the sample csv file with data I can do it Waiting for your positive response Thank you, Vipul
$250 USD en 3 días
4,9 (39 comentarios)
4,6
4,6
Avatar del usuario
I can develop your php script according to your specifications and provide you support at any time. My experience in web development is enough to ensure that everything will function and look properly. Moreover, note, that i'll not ask you to release any milestones before completing the project. Looking forward to your response. Greetings from Greece.
$460 USD en 8 días
4,9 (13 comentarios)
4,8
4,8

Sobre este cliente

Bandera de CANADA
calgary, Canada
5,0
3
Forma de pago verificada
Miembro desde mar 2, 2001

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.