topic Re: Import JSON Files in Discussions

Import JSON Files

dkraeuter_sunne — Tue, 18 Sep 2018 14:34:42 GMT

I am trying to import JSON files and the data comes in with the wrong formatting. Attached you will see images of the corrrect and incorrect way that the files import. To get the correct import view I have to save the file as a text file and then re-import the text file. What should I do to fix the import issues

Wrong Formatting

Right Formatting

Re: Import JSON Files

Craige_Hales — Wed, 19 Sep 2018 10:18:13 GMT

You don't need to copy or rename the file to use JMP's text import. Use

open("$desktop/jsonfiles/zips.json","text")

the "text" option uses the CSV-style text import, which sees the Comma Separated Values in the json file and might do an acceptable import. Often not, since the records won't be on one line and the columns won't get reasonable names.

Can you share the file, or the first few lines of the file? I'd like to have that example as a test case.

What version of JMP are you using?

Re: Import JSON Files

dkraeuter_sunne — Wed, 19 Sep 2018 14:00:26 GMT

I cannot attach the file because it is not a valid extension allowed by the website. Is there another way that I can send this to you?

I tried the text import you listed below and it is closer to what I need, but it missed one set of columns because of the brackets that are around it.