Get Free Trial
Get Free Trial

how to connect to local CSV or local JSON

Resolved
spy asked on February 9, 2018

 When I try to use the function of connecting local files,I follow the steps below:
1.Export the corresponding data of Pivot table DEMO as CSV, as Attachment 1;
2.Connect the  Attachment 1(local CSV)into DEMO and found that the metric column is not consistent with the source data,as attachment 2;

3.save the corresponding data of Demo as JSON,as Attachment 3;
4.Connect the attachment 3(local JSON) into demo, an error:JSON data is invalid.as attachment 4
so,I want to know my steps are correct? If not correct, what should be correct?Thank you very much.

Attachments:
attachment1.csv

6 answers

Public
spy February 9, 2018

Attachment 2
 

Attachments:
attachment2.png

Public
spy February 9, 2018

3&4

Attachments:
attachment4.png

Public
Tanya Gryshko Flexmonster February 9, 2018

Hello,
Thanks for the interest in Flexmonster Pivot!
When you export the data from our demo, it is not the original data but the aggregated data you see on the grid. In case of CSV export, this data is intended to be used in Excel or Google Spreadsheets, not in Flexmonster. To check how loading of files works please try saving our sample CSV or sample JSON locally and then connect to it.
Concerning saving the corresponding data of Demo as JSON, I would like to provide you with some explanations. When you click Save button in the toolbar, a report is saved. The report is a definition of what data should be shown in the component and how it will be visualized. So basically it contains not JSON data, but information about the data source, number formatting, localization, etc. Reports are in JSON format which is why your saved report file has .json extension. To open such report, in the toolbar select Open -> Local report. Then you will see the data correctly.
Please do not hesitate to contact me if you have other questions.
Regards,
Tanya

Public
spy February 11, 2018

Hello,Tanya
Thank you for your patience.The examples mentioned in the reply CSV and JSON I tried, it is OK. If my project now need to connect to other local CSV or local JSON, what are the rules or format constraints, you can ensure that the connection is not wrong, the correct rate is higher? Where can I get these rules?
Thank you very much.

Public
Dmytro Zvazhii Flexmonster February 12, 2018

Hello,
Thank you for writing. Please find the examples for connecting to CSV and JSON data sources here in our docs – https://www.flexmonster.com/doc/csv-data-source/ and https://www.flexmonster.com/doc/data-types-in-json/.
Let us know if it works for you.
Regards,
Dmytro.

Public
spy February 14, 2018

Hello,
Thank you very much, the current problem has been solved.
Regards

Please login or Register to Submit Answer