Load JSON data into MySQL table -- 2
$10-30 USD
Paiement à la livraison
Need to load large JSON file into MySQL table.
Only need a few of the fields within JSON data.
Table fields needed: id, label, searchTerms, svg_regular (raw), svg_duotone(raw), height, width
Sample JSON entry:
{
"angle-left": {
"changes": [
"3",
"5.0.0",
"5.11.0"
],
"ligatures": [],
"search": {
"terms": [
"arrow",
"back",
"caret",
"less",
"previous"
]
},
"styles": [
"solid",
"regular",
"light",
"duotone"
],
"unicode": "f104",
"label": "angle-left",
"voted": false,
"svg": {
"solid": {
"last_modified": 1546440861354,
"raw": "<svg xmlns=\"[login to view URL]\" viewBox=\"0 0 256 512\"><path d=\"M31.7 239l136-136c9.4-9.4 24.6-9.4 33.9 0l22.6 22.6c9.4 9.4 9.4 24.6 0 33.9L127.9 256l96.4 96.4c9.4 9.4 9.4 24.6 0 33.9L201.7 409c-9.4 9.4-24.6 9.4-33.9 0l-136-136c-9.5-9.4-9.5-24.6-.1-34z\"/></svg>",
"viewBox": [
"0",
"0",
"256",
"512"
],
"width": 256,
"height": 512,
"path": "M31.7 239l136-136c9.4-9.4 24.6-9.4 33.9 0l22.6 22.6c9.4 9.4 9.4 24.6 0 33.9L127.9 256l96.4 96.4c9.4 9.4 9.4 24.6 0 33.9L201.7 409c-9.4 9.4-24.6 9.4-33.9 0l-136-136c-9.5-9.4-9.5-24.6-.1-34z"
},
"regular": {
"last_modified": 1546440861218,
"raw": "<svg xmlns=\"[login to view URL]\" viewBox=\"0 0 192 512\"><path d=\"M4.2 247.5L151 99.5c4.7-4.7 12.3-4.7 17 0l19.8 19.8c4.7 4.7 4.7 12.3 0 17L69.3 256l118.5 119.7c4.7 4.7 4.7 12.3 0 17L168 412.5c-4.7 4.7-12.3 4.7-17 0L4.2 264.5c-4.7-4.7-4.7-12.3 0-17z\"/></svg>",
"viewBox": [
"0",
"0",
"192",
"512"
],
"width": 192,
"height": 512,
"path": "M4.2 247.5L151 99.5c4.7-4.7 12.3-4.7 17 0l19.8 19.8c4.7 4.7 4.7 12.3 0 17L69.3 256l118.5 119.7c4.7 4.7 4.7 12.3 0 17L168 412.5c-4.7 4.7-12.3 4.7-17 0L4.2 264.5c-4.7-4.7-4.7-12.3 0-17z"
},
"light": {
"last_modified": 1546440861036,
"raw": "<svg xmlns=\"[login to view URL]\" viewBox=\"0 0 192 512\"><path d=\"M25.1 247.5l117.8-116c4.7-4.7 12.3-4.7 17 0l7.1 7.1c4.7 4.7 4.7 12.3 0 17L64.7 256l102.2 100.4c4.7 4.7 4.7 12.3 0 17l-7.1 7.1c-4.7 4.7-12.3 4.7-17 0L25 264.5c-4.6-4.7-4.6-12.3.1-17z\"/></svg>",
"viewBox": [
"0",
"0",
"192",
"512"
],
"width": 192,
"height": 512,
"path": "M25.1 247.5l117.8-116c4.7-4.7 12.3-4.7 17 0l7.1 7.1c4.7 4.7 4.7 12.3 0 17L64.7 256l102.2 100.4c4.7 4.7 4.7 12.3 0 17l-7.1 7.1c-4.7 4.7-12.3 4.7-17 0L25 264.5c-4.6-4.7-4.6-12.3.1-17z"
},
"duotone": {
"last_modified": 1568845464125,
"raw": "<svg xmlns=\"[login to view URL]\" viewBox=\"0 0 256 512\"><defs><style>.fa-secondary{opacity:.4}</style></defs><path d=\"M223.83 352.44a24 24 0 0 1 0 33.86L201.32 409l-.18.18a23.76 23.76 0 0 1-33.6-.18l-96.15-96.5 56.47-56.5z\" class=\"fa-secondary\"/><path d=\"M167.81 102.87l-.17.18L32.11 239a24 24 0 0 0-.17 33.93l.06.07 39.39 39.51L224 159.66a23.92 23.92 0 0 0 0-33.84l-22.54-22.74a23.77 23.77 0 0 0-33.62-.23z\" class=\"fa-primary\"/></svg>",
"viewBox": [
"0",
"0",
"256",
"512"
],
"width": 256,
"height": 512,
"path": [
"M223.83 352.44a24 24 0 0 1 0 33.86L201.32 409l-.18.18a23.76 23.76 0 0 1-33.6-.18l-96.15-96.5 56.47-56.5z",
"M167.81 102.87l-.17.18L32.11 239a24 24 0 0 0-.17 33.93l.06.07 39.39 39.51L224 159.66a23.92 23.92 0 0 0 0-33.84l-22.54-22.74a23.77 23.77 0 0 0-33.62-.23z"
]
}
},
"free": [
"solid"
]
}
}
Nº du projet : #22509656
À propos du projet
Décerné à:
Hi! How many such json objects are there? Is it a one-time transfer to mysql or ongoing? Do you have a preference for the programming language to be used? I can do this in a couple of hours, so let me know!
10 freelances font une offre moyenne de 25 $ pour ce travail
I am good in mysql, json along with powershell I can extract the json data via powershell and load into mysql db, please let me know if you are good to award this project to me
Dear Hiring Manager, I have 5+ year of experience in web development. I read your requirements. I can do it. Can we discuss about the project? thanks
Hi! I'm Renaud. I'm an experienced Web developper. I can parse the JSON file and load it to your MySQL database. Have a good day!
I have php and j query knowledge. I can build simple php code to load j data into mysql file with in 1 hour. Then it is automatically updated sql file Relevant Skills and Experience Php mysql j query
I can help you to do by teaching the algorithm , then you you will be able to work with json correctly.
Hey sir, i can help you to put all those data in your database, i've such experience into scrapping / parsing etc..