Gaio DataOS
Gaio DataOS
Gaio DataOS
  • 👋 Welcome to Gaio DataOS
  • GETTING STARTED
    • Gaio DataOS Console
    • Quickstart
  • FUNDAMENTALS
    • Data Projects
    • Studio
    • Database
    • Workflow
  • Data Sources
  • TASKS
    • ETL
      • Builder
      • SQL
      • Source SQL
      • Insert Table
      • Insert Row
      • Update
      • Delete
      • Create Table
      • Quick Table
      • Quick Upload
      • Pivot Table
      • Unpivot Table
      • REST
      • Parameters to Table
      • Table to Parameters
      • Define parameter value
      • Users
      • CSV Web
      • CSV Local
      • Google Spreadsheet
    • Analytics
      • Sample
      • Cluster
      • Principal Components
      • Association Rules
      • Forecast
      • Python
    • Delivery
      • Content
      • Form Card
      • Export CSV
    • Map Editor
Powered by GitBook
On this page
  • How to Use
  • 1. Open the Task
  • 2. Fill in the Task Fields
  • 3. Advanced Options
  • 4. Save and Execute
  1. TASKS
  2. ETL

CSV Local

PreviousCSV WebNextGoogle Spreadsheet

Last updated 9 days ago

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