(Question) Multiple File Importing for JSON coded; whilst files extensions are different

joelahn

Hi,

 

I am struggling to convert some dataset of XML and JSON into JMP.

I am currently using JMP15.1; so I have import wizard all ready.

 

Current problem is that I can open up with designated col & row setting for those files extension changed from ".prc" to ".json", manually.

* my tool generates files in json format, yet with extension name differently (=.prc).

 

However my target is not to go through those conversion process, and obtain filtered rows and columns from files DB.

 

# So, if I change the attached .json file extension to .prc; JMP will not be able to read it properly.

Temp_set.json

txnelson

You can handle this issue easily by either having JMP find all of the .prc files and to rename them and then do the Multiple File Import, and when that is done, change the file extensions back to .prc

or

Use "Load Text File()" to read in each file, and save it to a $TEMP sub directory, using "Save Text File()", with the .json file extension and then read the in the Mulitple File Import

 

JMP can easily return all of the file names in  a folder, and from there, you can do the rename or the copy.