Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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
|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.
Map the source file's CSV values to the target form fields.
|Key Column Number|
Column number that holds the primary key value.
|Start From Row Number||Row number to start importing data. Integer only, starts from 0.|
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.
|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.|
|Custom CSV Delimiter Character||Symbol to represent the delimiter separater.|
|Custom CSV Quote Character||Symbol to represent the regular quote character.|
|Useful debugging information will be printed out in the server log when Debug Mode is turned on.|