Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Image AddedImage Removed

Figure 1: CSV Import Tool Properties

NameDescription
File Upload FormSpecify the source Form where File Upload element resides.
Upload Field IDFile Upload element ID in the specified form above.
Store Data Form

Specify on where to store the data by choosing a target form.

Info
titleHow storing works?

The target form's store binder will be called upon for data storage.

Info
titlePost 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.
Image Added

Column Mappings

Map the source file's CSV values to the target form fields.

NameDescription
Column NumberRefers to the column number in the source CSV. Integer only, starts from 0.
Field Name

Must be a element ID in the target form specified above, "Store Data Form".

If you are referring to a Subform in the target form, remember to prepend the field name with subform element ID followed by an underscore.

Info
titleExample

Subform ID: account_crm

Field ID: account_id

Field Name: account_crm_account_id

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 NumberRow number to start importing data. Integer only, starts from 10.
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.

NameDescription
Field NameField name 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.
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.
Info
titleNew feature added in version 5.0.7

The Import Status tab is newly added in Joget Workflow Enterprise version 5.0.7.

 

Image Added

NameDescription
Import StatusThis is a new feature added in Joget Workflow Enterprise version 5.0.7 and onwards giving one clarity over the execution of the import. One can choose to save the import status data to form data table of the originating file (upload) or into workflow variables.