Skip to main content
Use the File Loader to upload delimited files from your computer and load them into a table on any target connection, without first defining a connection or mapping for the file. Open the File Loader from Execute > Upload File in the main header, or Upload Files in the left navigation menu.

​
Add Files

Click + Add files… to choose one or more files from your computer, or drag and drop files onto the Drag and drop files here area. Only compatible file types are accepted.

​
File types permitted

Delimited text files with a .csv, .tsv or .txt extension.

​
File size limit

Each file must be smaller than 1 GB. Files are uploaded in chunks, so large files are resumed automatically if a chunk fails. The selected files appear in the queue with their name and size. Click × next to a file to remove it from the queue before uploading.
An error is displayed if you attempt to add a file of an unsupported type or one that exceeds the size limit.

​
Start Upload

Click Start upload to upload every file in the queue. A green progress bar shows each file’s progress. When a file has finished uploading, the × button is replaced by two buttons:
  • Config ⚙ — opens the configuration panels for the file, described below.
  • Delete 🗑 — permanently deletes the uploaded file from the server.

​
Cancel Upload

Click Cancel upload to clear the queue of all files that have not yet been uploaded.

​
Configuring and Loading a File

Click the Config ⚙ button next to an uploaded file. Kodda reads the file, detects its format, and opens three panels on the right side of the screen.

​
File Configuration

The parsing parameters are detected automatically from the file. Override them here if the detection is wrong.
  • Delimiter — the character that separates columns, for example , or \t.
  • Quote Character — the character used to enclose quoted text, for example ".
  • Line Terminator — how the end of each record is detected, for example \r\n or \n.
  • Header (toggle) — on if the first row contains column names.
  • Preview Data — parses the file with the current settings and shows the first rows in the Data Preview panel. Use this to check that columns are being split correctly.
  • Apply Changes — re-reads the file with your overrides and refreshes the Column Configuration.

​
Target Configuration

  • Connection — the target connection to load the file into.
  • Schema — the schema in that connection. Choose an existing schema or type a new name.
  • Table — the table to load. Choose an existing table or type a new name to create one.
  • Load Type
    • Append — inserts all records into the target table.
    • Merge (Insert/Update) — updates records that already exist, matched on the columns marked PK in the Column Configuration, and inserts records that do not.
    • Recreate Target — drops and recreates the target table, then inserts all records.
    • Truncate/Load — empties the existing target table, then inserts all records. Unlike Recreate Target, the table definition is kept.
  • Audit Dates (toggle) — when on, Kodda adds its standard audit date columns (si_create_date, si_update_date) to the target table.
  • Load — loads the file into the target with the settings above. Selecting the connection, schema and table populates the target columns in the Column Configuration first, so review those before clicking Load.

​
Column Configuration

One row per column detected in the file:
  • Position, Name, Type, Length (Precision) and Scale — what Kodda detected from the file data.
  • PK — check the columns that make up the primary key. Required for the Merge load type.
  • Target Name — the column name to use in the target table. Defaults to the file column name.
  • Target Type and Target Syntax — the data type for the target column, in the target connection’s native syntax. Defaults are chosen from the detected type; change them if, for example, a numeric-looking column should be loaded as text.

​
Manage Files

Click Manage Files above the queue to list every file that has been uploaded to the server.
  • The list shows the file Name, Size and Last Modified date.
  • Config ⚙ opens the configuration panels so a file can be loaded again, or loaded to a different target.
  • Delete 🗑 permanently deletes the file from the server. There is no confirmation prompt.
  • Click Upload Files in the upper right corner to return to the upload queue.