CSV Import Tool enables a user to import bulk data into a specific form's table by retrieving the CSV, XLS or XLSX file from a form field and doing a simple column-to-field mapping.
It is formerly known as CSV Import Tool in Joget Workflow v4.
Figure 1: CSV Import Tool Properties
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| File Upload Form | Specify the source Form where File Upload element resides. | ||||||
| Upload Field ID | File Upload element ID in the specified form above. | ||||||
| Store Data Form | Specify on where to store the data by choosing a target form.
| ||||||
| Column Mappings | Map the source file's CSV values to the target form fields.
| ||||||
| Key Column Number | Column number that holds the primary key value. If nothing is defined, a UUID will be assigned when importing. | ||||||
| Start From Row Number | Row number to start importing data. Integer only, starts from 1. | ||||||
| Foreign Keys | Define other values that can not be found in the CSV file such as Foreign Key value associations data. You may also define hard-coded value here too.
| ||||||
| Import Mode |
| ||||||
| Validate data? | Data to be imported will be validated in according to the form's fields' validations. | ||||||
UTF-8 Encoding Checking? | Check if the file is encoded with UTF-8. | ||||||
Debug Mode | Useful debugging information will be printed out in the server log when Debug Mode is turned on. |