Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon JSON format and guildline

More
11 May 2018 10:34 #5981

Hello,
It seems the problem is non-compatibility of the profile settings and the data you are importing. Please check the following post:

www.wdmtech.com/forum/vdata/836-import-export-error#3518

It seems you have chosen the insert operation and you have also included primary key values i.e. ID in the Data file. It doesn't insert if you provide the primary key values.
Or You have chosen the update operation and there is no data record in the database with the primary keys you are importing that's why It's not updating any record. Please check it and let us know if you could figure out the issue as per above explanation.


Thanks
Daniel

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

  • De Ville Dimitri
  • De Ville Dimitri's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
09 May 2018 14:40 #5975

Yes , and this is what I have ( I replace the IP by 1--.2--.--.-- )

#Date: 2018-05-09 12:25:21 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority clientip category message
2018-05-09T12:25:21+00:00 INFO 1--.2--.--.-- com_vdata Import Profile title - Import Joomla Articles
2018-05-09T12:25:21+00:00 INFO 1--.2--.--.-- com_vdata Import Table - #__content
2018-05-09T12:25:21+00:00 INFO 1--.2--.--.-- com_vdata Import Format - JSON
2018-05-09T12:25:21+00:00 INFO 1--.2--.--.-- com_vdata Imported Record count - 0

so not really helping

Thanks

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

More
09 May 2018 12:45 #5972

Hi,
Did you check the log file in Log section?


Thanks
Daniel

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

  • De Ville Dimitri
  • De Ville Dimitri's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
09 May 2018 12:21 #5969

Hi ,

I have the same problem that the system told me data successfully imported but 0 import.
Is there a way to see a log more detailed that what is on the menu ?

Thanks

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

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.