CSV Source
UDTS can transfer CSV files stored on US3 to MySQL data types.
CSV Source Form
| Parameter Name | Description |
|---|---|
| Save Existing Data | Enable saving existing data, the service will not clear the target stock data. If not enabled, the service will clear the existing data in the target database before starting. |
| Duplicate Data Handling | Handling method for primary key data duplication in the data target. “Ignore” will not overwrite; “Replace” means imported or newly stored data will overwrite previous data; “Update” will assign values to the data. |
| URL | Public link to the CSV |
| Column Order Adjustment | You can sequentially fill in the field names of the data target. UDTS will match the field order according to the CSV column order to adjust the transmission column order. |
| Update Strategy | When duplicate data handling is set to “Update”: Type: “CSVData” refers to the index number of the CSV file column; Data is an integer starting from 0; “Function” includes SQL-supported functions like now(); “Fixed” refers to fixed values like “people”. |
| Assignment Strategy | When duplicate data handling is set to “Update”: Type: “CSVData” refers to the index number of the CSV file column; Data is an integer starting from 0; “Function” includes SQL-supported functions like now(); “Fixed” refers to fixed values like “people”. |