New Database from JSON


#1

It seems that New Database from JSON file only opens a new database with the field A.
Same result from Import New Database from JSON file.

Is this feature implemented?


#2

Yes, this feature is definitely implemented. However, you must have a JSON file that contains an array of records. Each element in the array will become a record in the new database. A while ago I amazed the local programming club by automatically importing various JSON files they threw at me. But it’s certainly true that not all JSON files will work.

Where did you get your JSON file?


#3

Hi Jim,

The format for the JSON file is as follows.

[
{
“source”: “”,
“threadId”: 1,
“link”: “link”,
“imageLinks”: [],
“references”: [
{
“source”: “”,
“threadId”: 2,
“link”: “”,
“imageLinks”: [],
“references”: [],
“no”: 147005381,
“uniqueId”: “0d41a344-7454-48fc-b0da-282b4da49421”,
"_unixEpoch": “1970-01-01T00:00:00Z”,
“text”: “>>Some Text”,
“postDate”: “2017-10-28T15:33:50”,
“time”: 1509219230,
“tn_h”: 0,
“tn_w”: 0,
“h”: 0,
“w”: 0,
“tim”: null,
“fsize”: 0,
“filename”: null,
“ext”: null,
“md5”: null,
“last_modified”: 0,
“sub”: null,
“com”: null,
“name”: “”,
“trip”: null,
“replies”: 0
}
],
“no”: 147012719,
“uniqueId”: “554fd19d-0803-4108-b54d-34f804586b47”,
"_unixEpoch": “1970-01-01T00:00:00Z”,
“text”: “>>147005381\More Text”,
“postDate”: “2017-10-28T16:44:28”,
“time”: 1509223468,
“tn_h”: 0,
“tn_w”: 0,
“h”: 0,
“w”: 0,
“tim”: null,
“fsize”: 0,
“filename”: null,
“ext”: null,
“md5”: null,
“last_modified”: 0,
“sub”: null,
“com”: null,
“name”: “sm”,
“trip”: null,
“replies”: 0
},
{
“source”: “”,
“threadId”: 146981635,
“link”: “”,
“imageLinks”: [],
“references”: [],
“no”: 147023341,
“uniqueId”: “9a0105fd-b145-43f5-9da6-c56052967913”,
"_unixEpoch": “1970-01-01T00:00:00Z”,
“text”: “”,
“postDate”: “2017-10-28T18:15:48”,
“time”: 1509228948,
“tn_h”: 0,
“tn_w”: 0,
“h”: 0,
“w”: 0,
“tim”: null,
“fsize”: 0,
“filename”: null,
“ext”: null,
“md5”: null,
“last_modified”: 0,
“sub”: null,
“com”: null,
“name”: “Anonymous”,
“trip”: null,
“replies”: 0
},
{
this repeats for all records
},
{
last record
}
]