Panel |
---|
borderColor | green |
---|
borderWidth | 1 |
---|
titleBGColor | #ddffcc |
---|
borderStyle | solid |
---|
title | Definition |
---|
|
English |
---|
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. Info |
---|
| The target form's store binder will be called upon for data storage. |
Info |
---|
title | Post Form Submission Processing |
---|
| Any Tool mapped under Post Form Submission Processing of the target form will be triggered each time a record updated or created. Important: The tool mapped will be triggered regardless of the Run Tool on attribute.
 |
|
Column Mappings | Map the source file's CSV values to the target form fields. Name | Description |
---|
Column Number | Refers to the column number in the source CSV. Integer only, starts from 0. | Field ID | Must be a element ID in the target form specified above, "Store Data Form". |
|
Key Column Number | Column number that holds the primary key value. Info |
---|
If nothing is defined, a UUID will be generated and assigned when importing. |
|
Start From Row Number | Row number to start importing data. Integer only, starts from 0. |
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. Name | Description |
---|
Field Id | Field id in the target form. | Value | Value to be set. Hash Variable is accepted. |
|
Import Mode | - Import new record or update existing record
- Import new record only
- Delete record
|
Validate data? | Data to be imported will be validated in according to the form's fields' validations. |
| 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. |
...