JSON format and guildline
- Daniel
-
- Offline
- Administrator
-
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
-
- Offline
- Fresh Boarder
-
- Posts: 2
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.
- Daniel
-
- Offline
- Administrator
-
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
-
- Offline
- Fresh Boarder
-
- Posts: 2
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.
- Daniel
-
- Offline
- Administrator
-
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.
- Daniel
-
- Offline
- Administrator
-
Replied to your Email, Please check...
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- Alfred Tang
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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}
JSON file 2
{"BTC":{"USD":2513.63,"EUR":2181.54}}
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
Please Log in or Create an account to join the conversation.
- Alfred Tang
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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.
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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
-
Topic Author
- Offline
- Fresh Boarder
-
- Posts: 9
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.
Please Log in or Create an account to join the conversation.