Data

Introduction

The data menu contains components for Serializing and de-Serializing grasshopper objects in addition with working with data tables.

Data Menu Components
Data Menu Components

Json

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

Data tables

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:

2015-06-23_225309

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)
  • HTML
  • RTF
  • UNICODE text

 

 

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *