JSON format and guildline

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4487 by Alfred Tang

Need help for this data structure was created by Alfred Tang

Hi Team,

I would like to import JSON format as below:

Code:

{"high": "2444.62", "last": "2393.70", "timestamp": "1498548468", "bid": "2393.71", "vwap": "2406.5", "volume": "565.02362564", "low": "2380.00", "ask": "2398.43", "open": "2414.92"}

However I still have "parsererror" while trying to load Fields while importing. I have built a DB table with same field names. Please advise anything I can fix this? Thanks.

Attachments:

Please Log in to join the conversation.

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4488 by Alfred Tang

Replied by Alfred Tang on topic Need help for this data structure

I tried with a very simple JSON structure like this, I still get the parsererror; FYI.

Code:

{"open": "2414.92"}

Please Log in to join the conversation.

Daniel
Offline
Administrator

8 years 2 months ago #4504 by Daniel

Replied by Daniel on topic Need help for this data structure

Hello,
Please share your backend & FTP login credentials via Contact us form, We'll look into it.

Thanks
Daniel

Please Log in to join the conversation.

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4509 by Alfred Tang

Replied by Alfred Tang on topic Need help for this data structure

Hi Daniel, I have sent you those info via contact form and please let me know if things go smoothly, or if you have any findings. Thank you.

Please Log in to join the conversation.

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4518 by Alfred Tang

Replied by Alfred Tang on topic Need help for this data structure

Hi Daniel/ Team,

Any update on this? You may try the data I've provided in this post to see if it's data issue , import script issue (program bug?) or my installation issue. Thanks you very much.

Please Log in to join the conversation.

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4525 by Alfred Tang

Replied by Alfred Tang on topic JSON format and guildline

Hi Team,

After a lot trials from using the JSON file import via vData, I found there are some strange behavior form the import script; may need your further investigation from your testing server as I guess it is possibly the program BUG or issue.

JSON file 1

Code:

{"ETH":9.13,"USD":2518.29,"EUR":2179.58}

Result: Got "parsererror" while trying to "Load Fields". Profile settings for fields = String, as it is. I guess your program/script is unable to decode JSON file with only 1 level hierarchy. If this is the case, please fix this as a program bug.

JSON file 2

Code:

{"BTC":{"USD":2513.63,"EUR":2181.54}}

Result: Okay when press "Load Fields" but no record is imported : Data successfully imported ( 0 records ); The program/script seems accept JSON file with 2 level hierarchy but no record is being imported.

FYI, I have created DB table with below fields:
BTC : float (being skipped in the profile)
USD : float
EUR : float

Please test from your side with your test server; I am quite confident it a program error / bug. If this is not the case, please do let me know what JSON file format is truly accepted by vData. Above JSON format already the default / stand JSON file already, unless it's required to provide special json format required by vData.

Please help asap as I need to catch up and consider a refund within the refund period if this is not really vData can do for importing a standard JSON file. Thank you.

p.s. sample files provided

Attachments:

Please Log in to join the conversation.