MySQL Forums
Forum List  »  MySQL Workbench

unable to import JSON file in Workbench
Posted by: Jorge Rodriguez
Date: September 27, 2017 07:54AM

I am unable to import JSON files into my database. I have tried 4 different JSON files, all unsuccessful. Below are examples of the types of errors I have received:

"09:32:25 [ERR][ pymforms]: Unhandled exception in Python code: 0
<traceback object at 0x0000028A988FE7C8>"

"[ERR][sqlide_power_import_export_be.py:analyze_file:757]: Unable to parse JSON file: C:\JSON_FILES\file2.json,Extra data: line 78 column 1 - line 93 column 101 (char 1040 - 1839)" this also gives me the following error in the UI: "Can't analyze file. Please try to change encoding type. If that doesn't help, maybe the file is not: json, or the file is empty."

"[ERR][sqlide_power_import_export_be.py:analyze_file:757]: JSON file contains data that's in unknown structure: C:\JSON_FILES\file4.json"


I'm not sure how to post the data, but I have included couple of excerpts below (each one is a single line as it appears in the file):

From file1:
{"business_id":"0DI8Dt2PJp07XkVvIElIcQ","name":"Innovative Vapors","neighborhood":"","address":"227 E Baseline Rd, Ste J2","city":"Tempe","state":"AZ","postal_code":"85283","latitude":33.3782141,"longitude":-111.936102,"stars":4.5,"review_count":17,"is_open":0,"attributes":["BikeParking: True","BusinessAcceptsBitcoin: False","BusinessAcceptsCreditCards: True","BusinessParking: {'garage': False, 'street': False, 'validated': False, 'lot': True, 'valet': False}","DogsAllowed: False","RestaurantsPriceRange2: 2","WheelchairAccessible: True"],"categories":["Tobacco Shops","Nightlife","Vape Shops","Shopping"],"hours":["Monday 11:0-21:0","Tuesday 11:0-21:0","Wednesday 11:0-21:0","Thursday 11:0-21:0","Friday 11:0-22:0","Saturday 10:0-22:0","Sunday 11:0-18:0"],"type":"business"}

from file2:
{"time":["Fri-0:2","Sat-0:1","Sun-0:1","Wed-0:2","Sat-1:2","Thu-1:1","Wed-1:1","Sat-2:1","Sun-2:2","Thu-2:1","Wed-2:1","Fri-3:1","Sun-3:3","Thu-4:1","Tue-4:1","Sun-6:1","Wed-6:1","Fri-10:1","Sat-10:1","Mon-11:1","Wed-11:2","Mon-12:1","Sat-12:1","Tue-12:1","Sat-13:2","Thu-13:1","Tue-13:2","Wed-13:2","Fri-14:2","Sat-14:1","Wed-14:1","Fri-15:1","Sat-15:1","Thu-15:1","Tue-15:1","Fri-16:1","Sat-16:2","Sun-16:1","Tue-16:1","Sat-17:3","Sun-17:1","Fri-18:1","Mon-18:1","Sat-18:2","Sun-18:1","Tue-18:2","Wed-18:1","Fri-19:2","Mon-19:1","Sun-19:2","Thu-19:1","Wed-19:1","Mon-20:1","Sun-20:5","Thu-20:1","Tue-20:1","Wed-20:2","Fri-21:2","Sun-21:1","Thu-21:4","Tue-21:1","Wed-21:1","Fri-22:1","Thu-22:1","Fri-23:1","Mon-23:1","Sat-23:3","Sun-23:1","Thu-23:2","Tue-23:1"],"business_id":"7KPBkxAOEtb3QeIL9PEErg","type":"checkin"}


fromfile3:
{"text":"Get here early enough to have dinner.","date":"2012-07-15","likes":0,"business_id":"tJRDll5yqpZwehenzE2cSg","user_id":"zcTZk7OG8ovAmh_fenH21g","type":"tip"}


from file4:
{"user_id":"FIk4lQQu1eTe2EpzQ4xhBA","name":"Carol","review_count":841,"yelping_since":"2010-08-26","friends":["qewG3X2O4X6JKskxyyqFwQ","-50XWnmQGqBgEI-9ANvLlg","rof9DyrMxiWY1NyQHtjeDA","VHVTRZenFFw4DTvg3DSNXw","ae3qusoF3IwcQuL7QIx1dQ","A4Y4galaNBWAqIFpaRT5Eg","j0X-fLIBoGciGS17WC-V3g","4IvBFoLH1HOpDcZBY-NpJg","PUx5KWODerm6IzdfemCbag","A5TpQoVp9sWLrAByD5C4Mg","SfY0jEFqBkrqq9bVi6P31Q","oZ9NBQVAIXhTAUlUIPRBsQ","75COHfu_drTAx1G9rtZnAA","VtOFyPwzlQl02IvRtQT7sg","pwIPsyhSPmteSEImgwPgCQ","dWK4Ok3X8A4k92zj3BrpNA","W70unD2V2qYBxDwTz3R-jw","B8lQG26YMl0igTCVPFDlEA","rRSX6CLmQryEQFUvOTlYrw","cQzo2WX1TyPEmS5jPzOUoA","3h38QgaoxooCojoN6pZNUA","WfBV6d4TQeh-WVaycOM1Iw","TprC8sujz8MkwuomrqUSiw","jpaBV6e6Sf3_CgvShteDSQ","jtM-lajwSwW65wJRaMuFxg","9cohgQXRyRUbNtUfLA_JZw","LNPyE5X1K5B_flcTCH9StQ","Hw67S7Apfo7mF3tuaCpUMA","kEbMsY0LNbu4VaoEAMc9tg","WeIrA7LbdfS5HeV13iymuw","IzBQ-tzwG2GIPcb-Uo5gVg","vp93T_AshEE9blhTGtJWLg","U_W_kAAMIUHBgYWM1mFaEw","CUrT6fq-jQUit87xNCSFHA","bzU8Cl6B9nqV1i5NReobvw","IVTJIQEWwgZZBZjVtguJDQ","YByX2U8wZ7hwMntyWrib4g","EnCvbE7FnCkD6wM7e0opnw","QJI9OSEn6ujRCtrX06vs1w","Qx5bz4luino7htScnjwsMA","R9Sg7UkLOTle_7lyXXOTEw","Z4O1QlshQtbqy9u448odOw","4YvOoGQW-qGEJoCY--7OvQ","A5A34ixb-yy6nwL42iZsnw","1hmgpQsxOnUUZ3qTpntaTw","rKkpHJkJ27xOwnhy_bMkvA","Ke3keV7nNw4nTB85KYqDrw","RG2beJ7PQwVk1g7eQRkLbA","B4uiwCTX977cYBspBT61cg","CaajeceFCAYdWW9GoNVZmw","7Q6nBHl6NJ9gbJ900FkkAg","OSBuJ3L4w-eqO90q8RKXnQ","_pE9wtP4DhTxlPw_fbwrlQ","Ou8pUgyhcsiIIFCcePvP0Q","tihoT04S5TKHHHwX8INXnA","O7i2mBzCtH4mf6Yysgvtog","iLsfSX_JeNp7HgSYW2nZbw","Rdt-JiAN7Qlw3dJ7UVdNtw","3CMiTAhq_o_GP1tLs-ihbg","0FMte0z-repSVWSJ_BaQTg","g5tXcnN30wnSNkuq0MSpaw","LbeHQ0frxP6sJew2fKZ8fw","vMWOzEq7ODezcozHEva3fQ","7nA9P6EukhTwZi67JB-UTg","yV5GOIgaB2U2ilb7kj1ybg","AjqnFBC-Vw4_8y4weB2C_A","5Io-bhRkhdZRRNnhTs241w","oNojocV-CPbwiDRLGb7_jw","QabyP1AgalM0RNgFEDFlTg","4Y_Mo5HjkG_FHt4ZCNSruQ","53YUwKtZk1j64CCD1N1T-w","2HyZwme72aze2Ruf2S0baA","esIRdWcNinkl_ErNoRqLJw","fzV-0gh2m5anmq7onUnUtQ","rdysF0ymVkMX82Bu_8x3nA","QCtHk02W_Asu2LFfdmGQDA","7PtUMFXJKOqGxblr_jCgxw","HEvyblFw4I-UsMqgPGYY_Q","-xDW3gYiYaoeVASXywTPgw","Nayuw4L9jhr0G5-CRJC2hQ","77wo69hNeqoPVBRRLzO1hw","tH0uKD-vNwMoEc3Xk3Cbdg","9HIvolCkyeJSYtroEDnliA","vD9hqKHYXezL1ONv5G2unQ","pHc0kb_9W6zhQfWdBp-5ew","3uyBZNbDk2vRFBBWZOdIUA","BHjS6rIkmYSJC4o5pLnhXA","yKcrC-MfRjqSi9GrVXEr3w","bwFtrw0eFsAvyEArRyKwtw","vvxIVr_OR6sHBzGPG9dRXg","z908ldotiE_K0-gJv0qk8Q","TgW-w80-ketnwdUsjsAaNw","fUBrVn8tfrqRvVeq5INx2g","TP84hS-tDZGv0vEDSowrxQ","KtIh1kjkVESCqd2CCsQnhA","as_TLbwua9ehBmX6vQ07_Q","j1AFelum0Vzlc3qVgRY6Tw","MeDuKsZcnI3IU2g7OlV-hQ","C98Aj-m5A-qW5jKNCDKHfA","uPqxK1uSZrjk9hRX_y3zRg","xEbCNG-3GTw-OxFusnVP9g","kl_yCsj4ESbUphmpCfVvRA","I7AVnd5Akgy4tPXBbDzFHA","6prF0WhmTxT99_tIlkFOiQ","UYcmGbelzRa0Q6JqzLoguw","j1tqWHCnEG9kTbTeipojDQ","N56lUYVdBJyCsSUQN1dfWg","kStCtAEv1lYM2PJIssngXg","bgJLZAEaB04x9UQIm3sATQ","GB9UCvNr3MBCoLNmMydEZA","GiVCWhX8N7Doaij6tRtM4g","geRvdMGGQhTOv62vR2kXWA","03FWBi8ackcSksjO1o2GSQ","uLzh3rxI3Csxx4wPTDSYCA","CimYf7SDMlS4a4OUjUtC1Q","dnQzdLHYduCH6tooEkiGYA","5I6-yegWr4p1mtUMwNkVtg","Hmjo4sLUIHpuBs5aenOT7w","wVbz8w4h0cROQZneFimAgA","kzRq4H_nSf4b3F_sdymWSw","LPoy2HWhhjHBjII9R5fIgw","U0WU9d6gpMNkO_tPXK58Sg","8lEywHSvti2UjFP8ODbnHg","oG9VFtr_ye8v2tDnS3NOYw","RKJmcG-4dnnIp0jXd-U29A","Fv0e9RIV9jw5TX3ctA1WbA","A4SkLpePy9izLoYMgXlIMQ","DOxPQ3iVmlj2A7C1h4bXsw","L_sc37uHCMdpobzze2lyUw","3-1Qm_X_fD48tCw3GICiVA","ryqJ5re09J5u94jDVImCew","Snx8bwlNXf2V1xTTgPdo0w","y79u5Rj4F_HF_Uh-bsXH8A","nOIaazW2_RJ08O0U79SeWg","vzw1ZryOiTYGzl8N1yILtw","uG35h72BAMutvXAWdRpqCQ","8SgjU2fID9VqKQooFt1DIQ","q4KO8W-QDtdqJVsdQGEhnA","ELfzWgdf64VBLi5z1ECItw","4N-HU_T32hLENLntsNKNBg","NiSSUa7HLSPjQh6I_WpQ0w","PKEzKWv_FktMm2mGPjwd0Q","BbwldZQM1i89cAvV7fce3A","PAma-vb1sHSFpLyAw24ezg","Nfu7BbEYFxP4Vf2feQ33ig","YUzqKt7hmG5BkRykHeZ0gg","PwZLJIt7l_d67yJ041oTpg","YLeDSZ1Nh1N0hNsSyQdE3A","NqhbWEVJU4pyAUMOVcps8g","ccl5JZivv93oVySmX6TBjQ","y6To06jltp9_C0SHy48sSw","6PLgyvmPGW3bmFcp3lUmBw","6H4Zj-c7FqM9mCsXvwaEQw","ift8I64TyUl2_O_B3qNG1Q","KAFPkgydk-deihl_HmkPtg","3MO--ENqKScLFQFuW1751g","MMQ1myKKyaoOVBf8eq8K7Q","jrMxBHW3SlUGVGYWvPsHWA","OSKQ-Y-mCdV2HsNlFwLkNg","zrvk0-B91ahJRSB-UcAmIA","J8YbJ6s8SuMPrvCkqqbqkw","FEwPxhjdVKxSPVQQAHX2gg","v6oGFvXjuJ5DMT3pUqMXnw","0LzxzSM6oqOilJ_Tx8AXzg","t_7ngdXz_NgOxbPC0e0xoA","Epu165O9lGjvY6QTJpDp9g","2VABkVdFhHGMo7wAqfofGA","wRY6wk5N6MRR6QVikwn17A","1C4Je7vr5Su2mr1RA9bYQg","J9c0XM-wV_KQmtZYxvIFFQ","EG6qatWgJ2WTJnzBCCH_Dg","omzK_8C8RdZoulHbC8t3Ug","WNZfkL4DBspueoGSUOMAqA","TpmLjxsatnfkR6EEQ4DNbg","9KCoXFS7alSJsGfFsZANFQ","HaTKotEGtnqVClYAfqnbHA","3Qv2rjPXC2eNKyV5lh3J_g","q9jCDNZDRUYl2Pwlgxocig","NRGJ4IvauajqqCbhT640cw","cJh4F1zFNJb2wXCNT1uNWQ","deL6e_z9xqZTIODKqnvRXQ","nRdfX_I0CaOq7lJunJMPpA","gtwM4ijo65AN4DvXdgCu_w","-kRQLEDxrEBVNXImyAt_ug","q15RfTeehDLp_KJjpiNoIA","tiOV_Lt-OHvOngm2J1B_3Q","8v3aEuuHEJU_8h0OgmsfDA","Rcxb65dtZZlk-HjBaP5DKw","0tvCcnfJnSs55iB6mqPk3w","z69aniROyfLXw-vOhUQ91g","MC0e6zrMjetYx9zIjrV8cw","TwPlaNvnziaN2wB3lk_9Mw","tqyXKbsMBxi2ZMAdGZPtTA","wnO99pBbGqwqOoTQM25iCw","zAi4eOuxvOU62bG_yaefIA","VLy7oiZZktwfAoU2ZNgZ2A","bnKo6L4MgcUbLZH7fmnkrA","QsS90dZ1l99plc7mX1iTOA","3dbkO9K5vcvJXuKrVu4BMA","8QKrhvVqhEkD8xo4E4s0GQ","HK-TlD0yVA_tpTXZxfzu2w","bnk8hI3N5tprKm_lMK4I-w","Op_W0OGeb4ZMdXSj0X_soQ","xJg6TqMIl3u2wNGSPqOAyQ","S0QKUiKUIoi9VeTJnbCREQ","MRBnMDGjzXg6isL_EOknyA","nmqX1cxPOYHwql5e4U9LuA","o_8sVoYIFnoVun5YY_lAEg","xa0L2F-y8xI3Pt7LYZ0UPA","evdhQ5oFk_aRoX2rvBotEQ","Cnz21ijYCVx3SYnlaLsM0Q","QFjqxXn3acDC7hckFGUKMg","6lm42Cm_WQe8OXpQjCJJtA","Y0VnJ2K995OgFVt-P7qThA","Dkb-TJFNSWl4PYR8wEcWcw","W1AFbtC37Q1RzdrKS51NmQ","DoRCeCcJbrsM2BiAKj3trA","Bj8P0bj9W0IVAJIfXh1QMA","1GzQnGD28RUsT3chwgterw","LdRoZDoCfWREjgVcOTpzQQ","ciXbPDNtF_-MZDY2XQOrnw","-MRW5b_OiA4833cL4v53jQ","Ft4MLLN34b8k07T_sfAAWQ","nDyEOdSPkDboIcyBEYgHkA","z8wN6EQuw_JF-zTjcNgsLw","PomQayG1WhMxeSl1zohAUA","j4yFkHVZUs5QNe_VumkwbQ","U7-2c6WAT_ne4AJc1SQJQQ","Y-MZ52J82c0culy39QM_VQ","nG7DVwBPak2Eq8PZSmrasQ","8Sdo9NL9imYlVrMx4bh8MA","goKkCPVsdpANIibUSfwedw","8aNbMx5pu7rw86_tKFE5uw","-AxSFgjqisJ0LvVf7LLXbQ","yWfbvo0LXhssOsH9FNJ8Jw","g0YhdOrFV_MSNuR5KGpqtA","KsKjA0sjTdG4vHOBH3E3-A","37S80IUIfb8yMsSwWWDsFA","MMvb1gg-8o9xYj-xZ24uvw","udpfGxriuoBdWRBdplJl-w","25ZO5kQc5tlSFirJu4Uvcg","Z5FNvdnmj0KLIcKFPi1XIg","gDy6k3AqlkcN4cEIkWnx_A","_RxcqySz1rYyTwCS_lLBpQ","JUeGFCsprKVUYok4oLsdEA","me7RdUuFmpOqrTIlFlmXtg","Riebwb-s7yC8Qs7lAQchXA","AL4hosjTZzsLt99egmBszA","pm7K54T6OmsDHREtiVBWGQ","n4jYWMUXAq9qA6YRyMbBsQ","Yg08tRMxm0eaL-rXyNIAHw","FpB44ccQnPntnZQmWTTKDA","quDu_Z0-i9TCYvdHRnULEw","jL0Gu-B8TuLeftoPTvmONQ","3nDUQBjKyVor5wV0reJChg","mlyWbiBf2l0fX_5pYL3rCA","shYLM4g_3C5LU4Jb7KW0eQ","1afPtEJkkXDrdXSr7ftf-g","BpJWttiu9h5cgxtVkQZGXw","2N_EYWT6kNt9P3z1Y0ECWw","s0DX_KzUAbZAbRIcRudDNg","8DEyKVyplnOcSKx39vatbg","N5ICqTttK-2jLJp3vW2VKQ","9nrji23HpxUgC_N_q9TaqQ","GJelZyn48oBrhMp6xlTrtw","np2cEu_LDw4R8Xg7sZK3zQ"],"useful":58,"funny":6,"cool":5,"fans":48,"elite":["2011","2016","2017","2013","2014","2015","2012"],"average_stars":4.15,"compliment_hot":14,"compliment_more":10,"compliment_profile":3,"compliment_cute":1,"compliment_list":2,"compliment_note":21,"compliment_plain":23,"compliment_cool":36,"compliment_funny":36,"compliment_writer":28,"compliment_photos":4,"type":"user"}

Options: ReplyQuote


Subject
Views
Written By
Posted
unable to import JSON file in Workbench
78
September 27, 2017 07:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.