Find Jobs
Hire Freelancers

A script that will import data from a remote JSON source to local MySQL table - Python or PHP

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
A script that will import data from a remote JSON source to local MySQL table - Python or PHP 1) The script should create a respective data table in MySql if it does not exist 2) The script should import data from a remote JSON source to the earlier created MySql tables 2.1) During import a proper data conversion should be made (e.g. from Unix timestamp to date) 2.2) There will be a couple (4) different JSON calls required to gather and combine all the data 3) The script will run once a day (as a cron job) 3.1) The data should be imported to the local database only if the new ones are available in the JSON source - full data should not be imported every time the script runs Other notes: *) In the first step of the project, the MySql table structure should be confirmed. *) Errors should be written to a log file *) no 3rd party commercial (paid) libraries should be used
Project ID: 17779699

About the project

22 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
I have 5 years of experience in php and mysql . I also have good expertise in API using json so I can do it easily Feel free to contact me .
$75 USD in 3 days
4.9 (55 reviews)
5.1
5.1
22 freelancers are bidding on average $163 USD for this job
User Avatar
Dear Sir. Thank for the opportunity to bid on this project. I have read your description in carefully and so I think this job is best fit to me. I am a full time web developer with 50+ good experience. My skills are : -php, C#, Java, Python, javascript, Css -Mysql, Nosql, MongoDB, Html 5 -Laravel, CI, ASP.NET, Django, JSP(Spring, Hibernate) -AWS, ajax, Shopify, eBay, Google Map API... I am ready to work your project immediately. We can discuss more details through chatting. Looking forward to working with you. Best regards.
$200 USD in 3 days
5.0 (82 reviews)
7.6
7.6
User Avatar
Hello sir I am a qualified python developer with 8 years of professional experience. I recently made a very similar script. I am interested in this project and can deliver it in 2 days. Looking forward to hearing from you soon. Best Regards, Yongtao
$155 USD in 2 days
4.9 (129 reviews)
7.7
7.7
User Avatar
Hi there! I have more than 7 years of experience in php web development. Please do not ignore me as a new profile. I can give you more quality work on time. Regards Ranit Majumder
$122 USD in 3 days
5.0 (162 reviews)
7.0
7.0
User Avatar
Hello, Hope you are doing well. I can help with your project A script that will import data from a remote JSON source to local MySQL table - Python or PHP. I can assure you the quality job. I have good experience in JSON, MySQL, PHP, Python. We have worked on several similar projects before! Please have a look at my portfolio below: https://www.freelancer.com/u/schoudhary1553 We have worked on 400+ 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 (131 reviews)
7.2
7.2
User Avatar
Hello. I'm a python developer with a lot of experience in databases and JSON. I have done many similar projects. Please contact me over chat to discuss more. Best regards.
$150 USD in 3 days
5.0 (71 reviews)
6.7
6.7
User Avatar
Hi i can do this with a custom php script, that will do the remote JSON data extraction, db existing record checking and insert that will be executed by cronjob, can finish within 2 days, i'll need to see the JSON source and db structure... please contact me for more info
$200 USD in 2 days
5.0 (20 reviews)
5.7
5.7
User Avatar
today I can work on your task, if u may be interested
$111 USD in 1 day
5.0 (6 reviews)
4.6
4.6
User Avatar
Hello I am working in scripting technologies for 16+years. I worked in Shell scripts, perl, Python, PHP. Can we talk more in details? Thanks!
$220 USD in 3 days
5.0 (21 reviews)
4.5
4.5
User Avatar
Dear sir, I would like to work with your project as per your requirement. I am working with PHP, Codeigniter, Laravel framework, Slim framework, wordpress, mysql, AJAX, JSON, javascript, jQuery, bootstrap, css3 and html5. thanks taiabur rahman
$155 USD in 3 days
5.0 (19 reviews)
4.3
4.3
User Avatar
Hi I believe we have to create mysql tables only one, and I am guessing you will provide us information on which whcih is to be converted to which format(like you mentioned timaestamp to datetime). How much data are we talking about per day ?? Hope the api doesnt take a long time as it might break the script. Does the api provide unique reference to each chunk of data?? Please message me if interested and we can get started. Regards
$250 USD in 7 days
4.7 (5 reviews)
4.0
4.0
User Avatar
Hi there, I am a experienced developer, mostly with such tasks. I can write you a small java app to do all these things easier. If java doesn't fit for you, I can write it in python as well. Please give me the json object structure, how do you want them in the final entry in db and then we can get cracking. Looking forward for more details, Ioan
$300 USD in 3 days
5.0 (6 reviews)
3.8
3.8
User Avatar
Hi, I am very interested in your job description. I am a PHP & Mysql with JSON skills. I have rich experiences in building lots of script with various features using PHP & Mysql, JSON data. Well, Do you have any links for JSON data source or as files? Regards.
$155 USD in 3 days
4.8 (5 reviews)
3.4
3.4
User Avatar
I'm a senior Laravel developer with extensive experience in building high quality sites. My experiences includes building financial apps with capacity of handling 30,000 plus transactions a day. I have working experience with Bank level APIs including PayTM, TJSB , Equitas Bank. I have also successfully Integrated NPCI BBPS APIs for an Indian based payment app. I can do the described job as I have experience of doing similar thing for a project. we can have a chat to further discuss about this projects. Looking forward to work with you
$30 USD in 3 days
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi, I have read out your job description and got the idea what you need exactly. I am highly interested to work on your project so that I'm ready for a technical interview at any time. I would like to discuss more about your project to finalize it to start work asap. Looking forward to your positive response and wish to work with you. Thanks and Regards,
$155 USD in 3 days
4.9 (6 reviews)
2.6
2.6
User Avatar
Dear Sir, I am very pleased to place my offer on your project. I really appreciate your clearness with the requirements and the description, have done similar tasks plenty of times within my professional software developer career. Please take a look at my profile and feel free to ask extra questions.
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of POLAND
Warszawa, Poland
5.0
12
Member since Oct 15, 2013

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.