HIOKI
GENNECT
Cloud
One
Cross
Top
Functions
FAQ
Manual
Contact Us
This website uses cookies.
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services. You consent to our cookies if you continue to use our website.

Import GENNECT polled data and external CSV files

You can import GENNECT polled data (CSV format) exported from another GENNECT Cloud account or from another measurement group.
You can also import CSV files with time-series data according to the format shown below and handle them in the same way as GENNECT polled data.
This function is available only for GENNECT Cloud Pro.

Import procedure

Click [GENNECT polled data] on the drive page.
Click [Import] and select the CSV file you wish to import from your terminal and upload it.

File format

Below is an example format for importing an external CSV file.

Models,LR8514,LR8514,PW3360,PW3360,PW3360
Serials,111222333,111222333,111222444,111222444
IDs,CH1_temp,CH2_humidity,U1_Ins,Psum,WP+
Units,℃,%rh,V,W,Wh

2023-05-15T09:15:00,20,50,100,2000,2000
2023-05-15T09:16:00,22,50,100,2000,4000
2023-05-15T09:17:00,23,51,100,2000,6000
2023-05-15T09:18:00,23,51,100,2000,8000
2023-05-15T09:19:00,24,51,100,2000,10000

Import specifications (external CSV file)

  1. Use ,(comma) as the delimiter.
  2. Files with up to 300,000 lines can be imported.
  3. Data with the same channel ID and serial cannot be entered.
  4. The IDs line is required. Enter channel IDs.
  5. The number of channel IDs that can be entered in one file is 1 to 32.
  6. The Models, Serials, and Units lines are optional. Enter the model name, serials, and units, respectively.
  7. The period of data that can be entered is from 1/1/2020 to 1 month after the time of entry.
  8. The date format follows ISO 8601 (without time zone notation). The time zone will follow the one set in the account.
  9. The minimum interval of data that can be entered is 1 minute. All seconds in the time are rounded to the nearest 00 seconds, and only the first one applies to duplicate data.
  10. Decimal points can be entered using .(period). ,(comma) is not allowed.
  11. Only single-byte alphanumeric characters, _(underscore), and -(hyphen) are allowed for IDs, Models, and Serials. The number of characters allowed in IDs, Models, and Serials is limited to 20.
  12. Units can contain up to 20 characters.
  13. Only single-byte alphanumeric characters, _(underscore), -(hyphen), +(plus), and .(period) can be used in the data section. The maximum number of characters that can be entered in the Data section is 30.
Want help or have questions?

Search


Table of contents


Create new account
Login