The data menu contains components for Serializing and de-Serializing grasshopper objects in addition with working with data tables.
Json is a way to serialize in memory objects to an equivalent string representation. This allows the object to be stored persistently outside of memory in a text file, excel file or database. For example, a nurbs curve could be saved to excel and then rebuilt directly from excel In. New rhino session.
- Json write – serialize an object
- Json read – deserialize and object
A data table is an in memory representation of the table of a database or an excel database. It is a no SQL definition in that no external database file needs to be created. A data table is composed of records. Each record is composed of a key, and a series of fields. Fields have a field name and a field value. A record is represented by a string where the field values are separated from one another by a user defined delimiter.
Once a data table had been created the get datatable component can be used for filtering the data in a table and/or displaying the data in a table.
Filtering considers one or all of the following
- Filter by field name
- Filter by filed value
- Sort by field value
The syntax for filtering is based upon the MSDN format see here
By double clicking on the get datatable component the user can view the data table – see below:
Values may be filtered in real time. Data can be exported directly from this grid view as:
- Text file
- Excel worksheet
- Windows explorer
Data can be copied directly from a data table to the clipboard in the following formats
- Default (Tab delimited)
- CSV (Comma separated Values)
- TEXT (Values separated by text)
- UNICODE text