how to connect to local CSV or local JSON
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.
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.
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.
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.
Thank you very much, the current problem has been solved.