CSV Local
The CSV Local task in Gaio DataOS allows you to automatically import CSV files that have been uploaded to a local directory within the platform environment. This is ideal for handling input files delivered manually or through integrations with external systems that deposit files into internal folders for processing.
How to Use
1. Open the Task
Navigate to: Tasks > ETL > CSV Local
2. Fill in the Task Fields
Task label: (Optional) Name to identify the task in your flow.
Result table: Name of the table to be created or updated with the CSV content.
Separator: Delimiter used in the CSV (
comma,semicolon,tab, etc.)Folder: Folder path where the CSV file was uploaded (e.g.,
~/content/apps/31/imports/)
You must enter only the folder path, not the file name.
3. Advanced Options
Auto detect schema (column names) Automatically detects column names and data types from the first row of the file.
Insert mode: append records to table If enabled, new CSV records will be appended to the existing table. If disabled, the table will be overwritten.
Delete after import Deletes the file from the folder after successful import. Recommended to prevent reprocessing or cluttering the folder.
4. Save and Execute
Click Save to add the task to your flow.
When the flow runs, the system will automatically retrieve the most recent CSV file from the specified folder and import its content based on your settings.
Use Cases
Process files uploaded manually or via FTP/SFTP
Integrate systems that export CSV files to internal directories
Automate batch data ingestion (e.g., sales, inventory, customer records)
Manage file lifecycle with automatic deletion after import
Last updated