The objective of this project is to create a utility in python which can import multiple (5-10) large JSON files into a SQL database. Each file to be imported is sized between 100 – 200 mb.
Schema for the output is up to the developer, however, the quantity and size of the individual elements varies greatly, so expectation is that the utility read the JSON file, and create a different table for each element, using the CRD number as the key element.
All elements must be stored, however under Current_Registration we need only track if the field is populated or not, the text does not need to be stored in the database.
check my profile on fiverr :)
[login to view URL]
my clients are always satisfied
I just started on freelancer.com but I have a long experience on fiverr :)
you can count on me
$55 USD in 2 days
5.0 (5 reviews)
3.8
3.8
13 freelancers are bidding on average $190 USD for this job
Dear Sir or Madam,
Thank you for considering my bid!
I just developed a Python-based tool for communicating with a web service that stores quite sizable json queries in a database.
So I'm quite comfortable with dynamically creating tables.. Working with a buffered data source is fine as well, so you can count on me regarding this project. :)
I think we might need several tables for splitting data into. Right?
Is the data schema consistent throughout the whole dataset?
Please just drop me a line ;) I'm available for a phone conversation today at about 2-3pm your time.
Have a great weekend!
Thanks for posting,
Paul
Hi
Can it not be done in anything other than Python?
Which version of SQL Database you are currently using?
From where we will get these files? Copied on local or from a remote location?
How often this import process will run?
Does it need to be adhoc on demand or automated back-end service?
Please reply to above so that I can proceed further.
Regards
AZ
Hello,
I am interested in your project. I am a software engineer and I have professional experience with MySQL and Python.
Thank you,
Best regards,
David
Hi
This is Vikas having 5+ years of experience in IT and able to do this task very professionally. I am employer oriented and you will never get disappointed. I'll be here for any future support. Hope I would be your choice.
Thank you
Regards
Vikas
Dear Sir/ Madam,
Kindly check my bid & project completion ratio before awarding.
I'm really interested to work on this project, I can start the work now , and can provide the best services from my end.
Please come on chat to discuss more about the project.
Thanks & Regards
Prog2U
I have more than 10 years of experience as a software engineer. I have worked with mainstream languages (Java, C#, Ruby, Javascript) and databases (Oracle, Postgresql, Mysql, Mongodb). I also know the basics of Python