Upload Files

Navigation

A user can upload files either from the Home Screen in the left navigation menu or in drop down menu via the Execute tab in the main header.

Add Files

Upon clicking on , a window will appear that prompts the user to select files. Only compatible file types will be displayed as the user navigates through various folders to search for a desired file.

File Size Limit

Files uploaded via File Loader must be less than 1GB in size.

File Types Permitted

Acceptable files include delimited files such as files with an extension of tsv, csv or txt.

The selected files will appear in the File Loader, displaying the file name, size, and an option to to or uploading per file.

Start Upload

The user can upload all files by clicking on the button towards the top of the queue or via the button that allows an upload per file. If a user has uploaded individual files, the button will upload the remaining files in the queue.

When a file has been successfully uploaded, the user will see a progress bar that appears in green and the button will be replaced by the button.

Drag & Drop Files

A user can easily drag and drop files into the queue from a desktop or folder, particularly when uploading mass files.

An error will be displayed when attempting to upload incompatible file types.

Cancel Upload

• The button towards the top of the queue allows the user to completely clear the queue of all of the files that were previously added.

• When a file has been successfully uploaded, the button will be replaced by the button.

Configuring Files

When the user clicks on the button per file, the following can be configured:

File Configuration

• The file configuration allows a user to override the file parsing parameters.

• Delimiter - This will be populated with the auto-detected delimiter that's used to separate columns

• Quote character - The character that's used to identify quoted text

• Line terminator - This is how new lines (records) are read from the file

• Header - Boolean that indicates whether or not the first row in the column contains column names

Target Configuration

• Select Connection - The target connection to load the file

• Select Schema - The schema to which the file will be loaded

• Select Table - The table to which the file will be uploaded

• The Load Strategy

  • Recreate Target - Drops and recreates the target table

  • Append - Inserts all records to the target table

  • Merge - Updates records that already exist using the defined primary key and inserts records that do not currently exist

• Audit Dates - This determines whether or not Kodda includes standard audit dates when loading the file (SI_Insert_Date, SI_Update_Date)

Column Configuration

• Override column names

• Identify the primary key

• Set the proper data types to the target

• The button towards the top of the queue allows the user to completely clear the queue of all of the files that were previously added.

• When a file has been successfully uploaded, the button will be replaced by the button.

Manage Files

• All successfully uploaded files can be found by clicking on the button located above the queue.

  • The file name, size and last date modified will be displayed, as well as the option to configure or permanently delete the file.

• Additional files can be uploaded from this page by clicking on the "Upload Files" button in the upper right-hand corner.