The IoT Platform offers a feature to upload local files, allowing users to import data into custom storage tables within the DataService Studio for analysis, application development, or as a data source for the IoT Twin Engine. This topic outlines the steps to upload local data.
Prerequisites
An enterprise edition instance of the IoT Platform is purchased.
A custom storage table is now in place.
Limits
Only CSV file format is supported, and the file must include column names.
The file must be encoded in UTF-8 format.
The maximum number of data rows for a single CSV file upload is 5,000, and the file size must not exceed 5 MB.
Add Local File
In the IoT Platform console, click Overview. On the Overview tab, find the instance that you want to manage and click the instance ID or the instance name.
Navigate to the left-side navigation pane, select DataService Studio > Data Ingestion, and then click the Local Upload tab.
Click Local Data Upload.
In the dialog box that appears, configure the local data file settings.
Parameter
Description
File format
The default is CSV format, which cannot be changed.
Column delimiter
Choose from: Comma, Vertical Line, Space, Tab Character, or Customize.
If Customize is selected, enter a visible character as the delimiter.
Custom storage table
Select the previously created custom storage table for the current instance.
ImportantEnsure the custom storage table's structure is predefined.
Upload data file
Click Download Data Template to obtain the table template.
The system generates a template file based on the selected custom storage table.
Complete the template with the relevant field values and save the file.
Click Upload File and follow the on-screen instructions to upload the local CSV file.
Click Confirm.
Check the file list; if the Upload Status displays Success, the local file has been successfully added.
If the upload fails, click the icon to identify the reason for failure. Correct the file and repeat the upload process as described above.
Delete File Upload Records
This operation only removes the local file upload records and does not delete the actual files or their data.
Local files uploaded to the IoT Platform are automatically deleted after 90 days by default.
Data from uploaded local files is retained in the custom storage table.
Locate the desired file upload record in the list and click Delete Record in the Operation column.
Alternatively, select multiple records using the check boxes and click Batch Delete at the bottom of the list to remove them in bulk.
Click Confirm to finalize the deletion.