Upload Local File
You can upload local files to import data into custom storage tables in DataService Studio for analysis, application development, or as a data source for IoT Twin Engine.
Prerequisites
-
An Enterprise Edition instance of IoT Platform is purchased.
-
A custom storage table is created.
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, go to the Overview page and click the ID or alias of the target Enterprise Edition instance.
-
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
Fixed to CSV. This value cannot be changed.
Column delimiter
Select a delimiter: Comma, Vertical Line, Space, Tab Character, or Customize.
If Customize is selected, enter a visible character as the delimiter.
Custom storage table
Select the custom storage table that you created for the current instance.
ImportantMake sure the custom storage table structure is predefined.
Upload data file
-
Click Download Data Template to obtain the table template.
A template file is generated based on the selected custom storage table.
-
Fill in 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.
In the file list, if the Upload Status displays Success, the local file is uploaded.
If the upload fails, click the icon
Delete File Upload Records
This operation removes only the upload records, not the actual files or their data.
-
Local files uploaded to IoT Platform are automatically deleted after 90 days by default.
-
Data from uploaded local files is retained in the custom storage table.
-
Find the target upload record in the list and click Delete Record in the Operation column.
You can also select multiple records and click Batch Delete at the bottom of the list to delete them in bulk.
-
Click Confirm to finalize the deletion.