Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Insight Required
-
Guys I really appreciate your work on the look and feel of the new UI. It seems to work well and I do like the new Datasources screen however there is one area that I need your advice on how to overcome, the removal of the csv DS import export has perplexed me as I see no viable solution to building large interrelated meta datapoint models using JSON only. We build out meta points in an excel spreadsheet so we dynamically inter relate the xid's in the script point event triggers and then import this through csv to create the 2000 point meta data sources . Which tools can convert the csv to proper json to make it appropriate for import?
. -
@Phillip-Weeks There is a CSV export and import on the new data sources page -
-
OMG thank you... That's a relief, thank goodness.
-
When I am importing what do I put in all these extra fields like pointfolderid and id ???
Plus a lot of fields exported with the word OBJECT in them what does this mean on import? -
@phillip-weeks said in Insight Required:
When I am importing what do I put in all these extra fields like pointfolderid and id ???
You can leave them blank.
Plus a lot of fields exported with the word OBJECT in them what does this mean on import?
OBJECT means the property is an object with nested properties. ARRAY means it is a list. Basically don't touch these, I would suggest
- Create one data point in the UI
- Export the single point as CSV
- Copy the row, fill down etc
- Change the action column to CREATE
- Import CSV
-
Thanks for the help I am navigating through the new UI and getting most of it to work as I need. I was able to get the DS import working.
One last question about the JSON importing. I create the Excel reports normally by exporting the report template in csv then manipulating the references in Excel and then back in again using the csv import. How should I now get this excel Report template exported to a csv format and re-imported back into the system as an excel report template?
