Load JSON data into MySQL table -- 2

Terminé Publié le il y a 4 ans Paiement à la livraison
Terminé 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"

]

}

}

JSON MySQL PHP Python XML

Nº du projet : #22509656

À propos du projet

10 propositions Projet à distance Actif il y a 4 ans

Décerné à:

dyausp

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!

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(33 Commentaires)
5.7

10 freelances font une offre moyenne de 25 $ pour ce travail

goodwork20k

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

$30 USD en 2 jours
(30 Commentaires)
5.2
kajalgupta0098

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
4.3
WOANAYR

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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
4.2
eranga119

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.6
marcellaasgard

I can help you to do by teaching the algorithm , then you you will be able to work with json correctly.

$30 USD en 7 jours
(0 Commentaires)
0.0
rQwk

Hey sir, i can help you to put all those data in your database, i've such experience into scrapping / parsing etc..

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0