DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Import JSON file to DIADEM

Highlighted

Hi, I need some help. Do you know how can I import a JSON file to DIADEM? Currently I'm importing the data with Excel using Queries and then to DIADEM. But I would like to save some steps.

0 Kudos
Message 1 of 3
(664 Views)

Hi Chegolata,

 

I'm not familiar with querying a JSON file for data.  If this is an SQL query, then we could reproduce that in a DIAdem VBScript using Microsoft ADO objects for the SQL access.  It might also be possible that we could write a DataPlugin to read your JSON files.  Could you post one?

 

Brad Turpin

DIAdem Product Support Engineer

National Instruments

0 Kudos
Message 2 of 3
(632 Views)

There is an vbs based json implementation at

http://demon.tw/my-work/vbs-json.html

There is a fix that needs to be attached to read empty arrays.

 

In additional jq.exe can be used to convert json files to CSV files that can easily be imported.

0 Kudos
Message 3 of 3
(627 Views)