You can achieve this by clicking on the Import button. A modal dialog like the one below will appear.

The dialog above has 2 steps:

  1. Enter the data
  2. Validation

During this process your data will be validated and if it has a correct format it will allow you to import it, which will create the new data table.

Fields description:

NameDescription
Name

This is the name you want to provide for the data table. The value in this field will be used to generate a unique and valid measurement .

MeasurementThe measurement must have a valid format and it will be generated from the name field above. The modal dialog will automatically take care of this as you enter the name above.
CSV Content

This field is where you enter your data in a CSV format that matches the following criteria in order to be valid

  • The first row must contain the column definitions in the format <name>::<type>
    • The name part can be anything you want
    • The type can be one of the following: tag, string, boolean, int and float
    • The first column must be time. Because this is a time series table it must always have a time column
    • The columns must contain at least one field (not time and not tag type)
  • The following rows will contain the actual data that goes into each column, and must match the following criteria:
    • Each rows must contain the same number of columns as described in the first row
    • Each column value must match the correct type described in the first row.
      • For tag the type should be a string
    • The column time must contain the value of time formatted as RFC3339(eg: 2006-01-02T15:04:05Z)

Example of valid data format:

time,co2::int,humidity::float,device::tag,closed::boolean

time,co2::int,humidity::float,device::tag,closed::boolean
2006-01-02T15:04:05Z,776,41.3,elsys-2,false
2006-01-02T15:04:05Z,76,1.3,elsys-3,true
CODE

After entering the required data above you can click on the `Validate` button which will validate the required information. The second step in this dialog will display if the validation worked or failed and it will provide an appropriate error message to help you correct the problem.

If everything is valid, the second dialog will display a preview of the data and clicking on the Import button will create the table and import the provided data and the table will now be available in the list of User created data tables.