JSON format and guildline

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.

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

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

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

JSON data must be enclosed within brackets e.g.

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

Replied to your Email, Please check...

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.

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 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 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