Find Jobs
Hire Freelancers

Convert json to sql data

€8-30 EUR

Completed
Posted over 3 years ago

€8-30 EUR

Paid on delivery
I have 3 types of JSON files which have different structures (they have little differences). All of these files have nested objects. That's why I am unable to use freely available JSON-to-CSV converter to upload this content to my PostgreSQL database I need to do this conversion to create test data for my project. You can write a simple PHP file.. no framework needed! Steps to do 1. A form which allows me to upload JSON file & also select the JSON objects type (3 types should be supported) (Depending upon the selected type, you know how the JSON object structure will look like) 2. Upload the given objects into PostgreSQL table (Make unique check before). Each object has a unique id. Insert a JSON object to SQL table only when it doesn't exist. 3. Empty cells should be set to NULL in db 4. Date value should be saved with timezone 5. No data should be lost! Note: all the 3 formats will use the same table to insert data.
Project ID: 28847697

About the project

15 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
Hello, I can help you to Convert json to sql data I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. https://www.freelancer.com/u/globalseo614 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, [login to view URL]
€30 EUR in 1 day
5.0 (3 reviews)
2.2
2.2
15 freelancers are bidding on average €24 EUR for this job
User Avatar
Hi, my name is George, I will be glad to help you with your json to sql task. I can start immediately. Thanks!
€34 EUR in 1 day
5.0 (65 reviews)
6.5
6.5
User Avatar
Hi. I have written many automation apps for parsing files including JSON also database apps including MySQL. Can parse any JSON templates. Ready to write your project. Will complete within 1 day
€30 EUR in 1 day
5.0 (89 reviews)
6.3
6.3
User Avatar
Hello, I can write a PHP script for that purpose. Just provide me with the JSON files and the MySQL table structure.
€10 EUR in 1 day
5.0 (78 reviews)
5.9
5.9
User Avatar
Hello I read your proposal "Write a Simple PHP script for test data..." I am a full stack developer. So I am confident for this job. Please let me help you. Thanks.
€22 EUR in 1 day
4.8 (22 reviews)
5.9
5.9
User Avatar
JSON to SQL conversion expert , did many similar project , very interested , can we talk on chat ....
€30 EUR in 2 days
4.9 (32 reviews)
5.8
5.8
User Avatar
Hello PHP, JSON, SQL EXPERT I have read your description and I am so interested in your project. You can see well experienced and skillful PHP+15 years of experience in software development. Confident in your project and I can finish it clearly on time. Working with me, you will have a good experience and a good friend and save more time and money. Best regards!
€20 EUR in 1 day
5.0 (31 reviews)
5.4
5.4
User Avatar
Hi, I am glad to place a bid on your project I can start your project right now. Please start conversation so we can understand whole requirement in detail to implement better quality of product. Waiting for your kind response. Regards
€15 EUR in 1 day
5.0 (3 reviews)
3.4
3.4
User Avatar
Hey dear how you doing i think you are doing good. I can do this job within a time. Lets have a chat. I will not charge until i am done with the job. Thank You dear.
€8 EUR in 1 day
4.5 (4 reviews)
2.8
2.8
User Avatar
Hello there ! I can insert data from JSON to MySQL in one day. I am mastered in PHP/JSON/MySQL for 5 years. I will wait for your reply. Best regards.
€20 EUR in 7 days
5.0 (5 reviews)
2.4
2.4
User Avatar
Hello there! I am PHP/MySQL expert and I can complete your project within a day. I will keep your data and it will be satisfy for you. I will wait for your reply. Best regards.
€40 EUR in 1 day
4.4 (4 reviews)
2.1
2.1
User Avatar
Hello. I read your requirement carefully. I have rich experience in PHP/JavaScript/JSON/SQL with 6 years and Your work just matched my skills. So It's a piece of cake for me. Please give me chance and I'll do my best. Best regards.
€30 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have hard experience with json and mysql database, in 3 days your project is finished. I need the database access and the json templates.
€25 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Berlin, Germany
5.0
34
Payment method verified
Member since Mar 30, 2017

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.