Find Jobs
Hire Freelancers

Build script to Import data from CSV URL list, to Amazon Web Services RDS MySQL database every day

$30-250 USD

Completed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
I need a script able to download every day the CSV data from a list of URLs and upload it to my Amazon Web Services RDS MySQL database (in one table the data of every link). This script must be hosted in the server and must be triggered every day automatically.
Project ID: 17229586

About the project

24 proposals
Remote project
Active 6 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
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
$300 USD in 7 days
5.0 (15 reviews)
4.2
4.2
24 freelancers are bidding on average $175 USD for this job
User Avatar
Hi There, I have already worked with Amazon RDS to store data. I have done the automation also. Looking forward to work with you Thanks
$250 USD in 14 days
4.9 (1199 reviews)
9.2
9.2
User Avatar
HI there, I'm sure that will be able to help you with your CSV importer tool. I suppose, 150$ and 1 day for delivery should be enough. However, you have not provided any real details, so price may change after detailed discussion. Question #1: Do all CSVs have same format ?
$150 USD in 1 day
5.0 (399 reviews)
7.9
7.9
User Avatar
Hi, I have experience of working on similar projects, I can develop a script to import data from CSV to amazon via api. Please see below for similar product/inventory automation project I have done in past: Inventory Sync projects: Prestashop: Import file xml to shop online prestashop - https://www.freelancer.com/projects/PHP-Software-Architecture/Import-file-xml-shop-online/ Import products and categories with xml file in prestashop - https://www.freelancer.com/projects/XML-Website-Design/Import-products-categories-with-xml/ WooCommerce: ERP API integration with WooCommerce site - https://www.freelancer.com/projects/php/ERP-API-integration-with-WooCommerce-16472100/ Wordpress Cloning and Installation Script - https://www.freelancer.com/projects/PHP-Script-Install/Wordpress-Cloning-Installation-Script/ External Wordpress Automation - https://www.freelancer.com/projects/Wordpress/External-Wordpress-Automation/ Opencart: Import Icecat data project for opencart system. - https://www.freelancer.com/projects/PHP-MySQL/Import-Icecat-data-project-for.4509417/ Virtuemart: Scraping ecommerce site into virtuemart - https://www.freelancer.com/projects/Web-Scraping-eCommerce/Scraping-ecommerce-site-into-virtuemart/ virtuemart update from cvs - https://www.freelancer.com/projects/PHP-Data-Processing/virtuemart-update-from-cvs/ Please let me know about time when you would be available so we can discu
$250 USD in 5 days
4.8 (277 reviews)
8.2
8.2
User Avatar
I have 16 years of experience in web hosting, server administration and php programming See my previous works at https://www.freelancer.com/u/Netfreehost Message me, let's discuss the project.
$150 USD in 4 days
5.0 (1289 reviews)
7.7
7.7
User Avatar
Hello I am a qualified python developer with 8 years of professional experience. I understood the job description and am confident to this project. I am familiar with web scraping and Amazon RDS. I am going to use Requests and Boto3 packages. I am ready to start the work. Looking forward to hearing from you soon. Best Regards, Yongtao
$155 USD in 3 days
4.9 (128 reviews)
7.7
7.7
User Avatar
Hello, I can help with you in your project Build script to Import data from CSV URL list, to Amazon Web Services RDS MySQL database every day. I have more than 5 years of experience in Amazon Web Services, MySQL, PHP, Python, Software Architecture. We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD in 3 days
4.9 (151 reviews)
7.4
7.4
User Avatar
Hi, I have done this before. The trick is to use "LOAD DATA LOCAL INFILE" in the import. How will the csv be obtained by the script ?
$100 USD in 1 day
5.0 (21 reviews)
6.5
6.5
User Avatar
Hola estoy interesado en tu proyecto, podrias darme mas detalles? cuantos archivos CSV? ya tienes la estructura de base de datos creada? puedo hacerlo con PHP saludos
$150 USD in 1 day
5.0 (95 reviews)
6.5
6.5
User Avatar
Hello, can you please list the URLs from which you want the script to download the CSV files and kindly also answer the following questions: Q1: Do all of the CSV files have a similar structure? Q2: Are you interested in all fields of the CSV files or just in some particular fields? Q3: Can you please describe the structure of your MySQL DB table. The answers to these questions are absolutely necessary in order to proceed with your project. I can write a script for you in PHP that will retrieve the CSV files, extract data from them, and upload that data to the Amazon Web Services RDS MySQL database table. You can set a CRON job on your server to invoke the script daily. About Me ======== I'm a Software Developer. I have experience in modern web technologies including PHP and REST APIs. Just recently I developed a script for a client that allows her to interact with Google Sheets API.
$200 USD in 8 days
5.0 (52 reviews)
6.1
6.1
User Avatar
Expert developer. Amazon web services expert.
$99 USD in 1 day
5.0 (37 reviews)
5.7
5.7
User Avatar
Hello, I can write you python or php script. Can you share more details about this project, please? Do you need to reformat data in csv? I worked with Amazon RDS MySQL before and we can use cron to your script on time. Thank You Josef
$100 USD in 3 days
4.7 (54 reviews)
5.5
5.5
User Avatar
Hello, i am an application architect. I am expert on Python and AWS. I interested in your project. Please contact me. Thanks.
$120 USD in 3 days
4.9 (40 reviews)
5.4
5.4
User Avatar
Hi, I can see what you want, a single cron can run the script anytime you'd like (once per day in this case). The rest I will code in the script and connect it using API functionalities. I think this job can be completed within 1 day. Allow me to work on this project and complete it as soon as possible.
$133 USD in 1 day
5.0 (5 reviews)
3.5
3.5
User Avatar
I can create you an efficient script that achieves all your requirements. I would like us to chat for more details
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
Madrid, Spain
5.0
19
Payment method verified
Member since Jan 1, 2014

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.