Upload Files
Last updated
Last updated
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.
Files uploaded via File Loader must be less than 1GB in size.
Acceptable files include delimited files such as files with an extension of tsv, csv or txt.
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.
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
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)
Override column names
Identify the primary key
Set the proper data types to the target
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.
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.
The selected files will appear in the File Loader, displaying the file name, size, and an option to to or uploading per file.
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.
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.
When the user clicks on the button per file, the following can be configured:
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.
All successfully uploaded files can be found by clicking on the button located above the queue.
