Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon JSON format and guildline

More
06 Jul 2017 10:30 #4547

JSON data must be enclosed within brackets e.g.

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

More
05 Jul 2017 13:42 #4544

Replied to your Email, Please check...


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
01 Jul 2017 12:38 #4526

FYI, There have no issue with CSV import (already tested with 1500+ records) . The issue only exist with JSON import. Please test with my files attached above at your side.

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
01 Jul 2017 12:21 #4525

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

{"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
{"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 or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
30 Jun 2017 03:07 #4518

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 or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
28 Jun 2017 15:11 #4509

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 or Create an account to join the conversation.

More
28 Jun 2017 13:55 #4504

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
27 Jun 2017 09:27 #4488

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

{"open": "2414.92"}

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
27 Jun 2017 07:31 #4487

Hi Team,

I would like to import JSON format as below:

{"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 or Create an account to join the conversation.