Find Jobs
Hire Freelancers

Script to import CSV into mySQL database

$30-250 AUD

Completed
Posted over 3 years ago

$30-250 AUD

Paid on delivery
Project summary: A script to populate MySQL tables with information stored in CSV files is required. The script should be able to execute via cron on a cPanel hosting server. The script should do the following: 1. Gather all CSVs in a directory that contains the data to be imported into the database table. It may be necessary to merge the files into a single CSV for the next steps. 2. Update any existing records in the database with updated values based on unique key 3. Create any new records in the database that are not already present 4. Remove any records for data that is no longer present in the CSV files. 5. Send email notification with a status report for a number of records updated, created and deleted. If there are any errors, these should also be reported. The CSV files contain information regarding AD user accounts. There are approximately 15 fields in the dataset. There are three tables that will need to be created for data import: - Staff - Students - Parents The CSV files for each table are stored in a separate directory so that the script can just recurse through all the files in each directory. The script should be well documented with inline comments and variables defined as required.
Project ID: 28232345

About the project

26 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Data processing and automation scripting is part of my sysadmin job. I will happily complete your task. I will need example source data set and MySQL schema the data needs to be imported to. Thank you!
$140 AUD in 3 days
5.0 (31 reviews)
4.5
4.5
26 freelancers are bidding on average $165 AUD for this job
User Avatar
Hello, I have checked your requirement and have experience to do this type of work. I assure you that you will get your complete solution on time with quality. Lets have a quick conversation on the details to proceed further with this project. Looking forward working with you. Thank you, Govind sharma
$140 AUD in 7 days
5.0 (609 reviews)
8.5
8.5
User Avatar
I can write a script to import CSV into MySQL. PHP Programmer with 12+ years of experience. Please check my reviews and then decide on me. Looking for a long term relationship.
$150 AUD in 3 days
4.9 (287 reviews)
6.8
6.8
User Avatar
Hi there, I am web and desktop app developer with 7+ years of experience. I have read the details and should be an easy job for me as I have already completed similar projects for automating importing and exporting data from to files and database. Have a look at my profile for similar projects I've completed with reviews. Message me, we can discuss further details over chat.
$400 AUD in 3 days
4.9 (97 reviews)
6.5
6.5
User Avatar
Hi, I am a shell script, mysql and csv expert, i can help you to export and import the csv data into mysql kindly ping me further discussion Thanks
$220 AUD in 3 days
5.0 (103 reviews)
6.6
6.6
User Avatar
Hi, I'm an experienced PHP developer. I can create a script for you which can automatically adds, updates, and deletes data from your MySQL database tables based on the data in the CSV files. I need your database tables' schema (layout or structure) and some sample CSV files to this project. If you'd like to discuss your project with me then feel free to send me a message even when I appear offline. I usually reply back within a few minutes when online otherwise in a few hours when offline.
$150 AUD in 2 days
5.0 (79 reviews)
6.5
6.5
User Avatar
This is an easy task for me. I will create a php cronjob script on your cpanel hosting to import your csv files to mysql and do data manipulation on the database. I will provide you with well document written code as well. Share me your cpanel credential so i can start to work now and finish fast. Looking forward for your reply. Dr. Syafiq Affandi PHP Specialist
$150 AUD in 2 days
5.0 (20 reviews)
6.5
6.5
User Avatar
⭐⭐⭐I can make the script u want.⭐⭐⭐ Hi, dear client. I hope u a being well. I've read your proposal carefully and am getting interested in your project. I will prove my ability by implementing your requirments. You can see my profile on https://www.freelancer.com/u/stepanbohanov. awaiting your reply. thanks. Stepan
$160 AUD in 2 days
5.0 (46 reviews)
6.0
6.0
User Avatar
I'm a PHP expert familiar with MySQL and CSV. I have just checked your description and I understood your requirements. I have already completed a project similar to this one. https://www.freelancer.com/projects/python/Populate-database/payments I can satisfy you with same results as you want. Hope your kind contact. Thanks.
$200 AUD in 1 day
5.0 (19 reviews)
5.9
5.9
User Avatar
Hello sir I can create php script to read data from csv file and add/edit/delete in database by compare unique key. For all csv row i compare with database table by unique id if available than update otherwise create new records. and save unique id in array. than again run a function for all table records in loop to delete record which are not in array. please text me so we can discuss more about task. thanks
$160 AUD in 5 days
5.0 (53 reviews)
5.6
5.6
User Avatar
====================== i'll build it in 184 USD ======================= Hi There, I hope to do well, • I am a dedicated full stack Web Developer Having 4+ Year Experience. In Past, I have done 100+ Projects including CRM, ERP , POS, Inventory management,School Management,project management, E-commerce Projects, Websites with Admin Dashboard, multiple large database handling, • I'm experts In PHP and it's MVC framework Like as Laravel, CodeIgniter And CMS like as WordPress and HTML, CSS, Bootstrap, Jquery, Ajax, MySQL, And Other Web Development Skills • Once you start working with me you will see that I am very resourceful and my dedication towards your project will surely impress you. • I will do my best to finish all your projects perfectly within your affordable rate and timeline. • Let’s get start, chat with me, we will start the Project Soon. • i'm working as full time freelance developer since 2+ years. you can check my profile to see work history and reviews. -------if you want Portfolio i'll share in chats---------- Regard Hardik J. Ponkiya :) Thanks
$184 AUD in 6 days
5.0 (105 reviews)
5.4
5.4
User Avatar
Hello I can make script for you CSV file import to SQL database according to your requirements. please send me message for more details. thank you Rahul
$100 AUD in 5 days
4.6 (23 reviews)
5.6
5.6
User Avatar
Hi, Sir. I am interested in your project and I can deiver you good result as soon as possible. I am familiar with php and My SQL so that I sm sure I can make your project perfectly. Let's discuss on chat and make success!. Than you. Best Regards.
$140 AUD in 7 days
4.8 (12 reviews)
5.5
5.5
User Avatar
Hello. How are you ? i have just checked your project descripttion i am very interesting yours can we discuss more detail in order to go ahead?
$140 AUD in 1 day
5.0 (17 reviews)
5.3
5.3
User Avatar
Hello. As a python and C# specialist, I can build the program that collects the data from csvs and save them to the database. After that I can setup the cron job. I am ready to start work now. Thanks.
$200 AUD in 7 days
5.0 (11 reviews)
5.1
5.1
User Avatar
Hello, I am PHP and MySQL database expert, as well as good in CSV data management. I can start work now and will finish it soon. It's easy work for me to parse CSV in PHP script and save and update in Mysql DB. Also I can make it to Cron job and run in Hosting server Periodically. I have done similar tasks many times and I can do it very well. Please kindly contact to me and let me start your project right now. Thank you. Ruslan.
$200 AUD in 3 days
5.0 (8 reviews)
4.8
4.8
User Avatar
Hello There, I checked and understood about "Import CSV from directory using CRONJOB" I can make script for import csv and check if exist then update or not exist then create new record in table. I have worked on several CSV import plugin and custom PHP script in projects. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks!!
$180 AUD in 2 days
5.0 (22 reviews)
4.7
4.7
User Avatar
⭐⭐⭐⭐⭐ Hi there ! ⭐⭐⭐⭐⭐ I am confident that your requirement of creating Script to import CSV into mySQL database, will be perfectly within tight deadline. As fullstack/mernstack developer, I have over 6 years of rich experience by developing with almost all PHP, Python and JS frameworks in small and big websites including eCommerce, Company website, Cloud Services, AWS, Web Scraping, SEO, API integration, Payment Gateway Integration. I am always online, hard working and a take positive attitude on this matter. I am available from Monday To Saturday, 6 ~ 8 hours a day, and my timezone is very flexible for you. ----------- Feel free reach me out so that we can discuss the project further. Regards.
$100 AUD in 7 days
4.6 (7 reviews)
4.8
4.8
User Avatar
Hello, We can make a script which you can run via cron job or server to input data into database tables from CSV files. We can merge and process different CSV files. We have done this CSV import task for so many projects, so this won't be an issue for us. Please contact us for more detailed discussion so I can provide you the exact cost. Let me tell you that we are a Highly Reputed and Growing IT Company in our locality. We are in the market since 2013 and have designed & delivered 600+ projects till now. We have a highly Qualified Staff all having 8+ years of experience in their respective field. So, if you're looking for the Quality Work, we can be the "End Of Your Search". [***PLEASE CONTACT US BEFORE PLACING THE ORDER***] Regards, Rohan Sanghani
$100 AUD in 7 days
4.9 (8 reviews)
4.0
4.0
User Avatar
hey I can build your script within a day.....I just build this script in php. let me know if you are interested. thanks
$133 AUD in 1 day
4.8 (29 reviews)
3.9
3.9
User Avatar
Hi Being a full stack PHP developer and DBA for 7+ years , looking at the requirements I can assure you to complete the job with 100% accuracy and jitter Please provide me an opportunity to serve your purpose Thanks, Somnath Paul.
$111 AUD in 1 day
4.9 (11 reviews)
3.2
3.2

About the client

Flag of AUSTRALIA
Australia
5.0
8
Payment method verified
Member since Nov 26, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.