| Table of Contents |
|---|
Introduction
The userview Import Menu is a feature to import bulk data (in a .csv or Excel file) into a specific Joget form. The Import Menu properties allow you to perform simple column-to-field mapping. When importing records, you can specify the following import mode:
| Info |
|---|
| During import, you can click the "Validate data" checkbox to perform data validation based on the form field validation rules. |
Figure 1: Import Menu in Userview Runtime
Import Menu Properties
Configure Import Menu
Name
Label: The userview menu label. You can add Font Awesome Icons into your menu labels.
| Info | ||
|---|---|---|
| ||
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 Mapping
:
Column Number
: Column number from the source file. Column number starts from zero.
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.
Example:
| Info | ||
|---|---|---|
|
Subform ID: subform Form ID set in the Subform: child Field ID in the subform: name Field Name: subform_child_name |
Use Formatted Value
: Check this field to use Formatted Value instead of the default Raw/Cell Value.
Example:
Key Column Number
: Define column number that defines the record id. Column number starts from zero.
Start From Row Number
: Define which row number to start processing. Row number starts from zero.
Custom CSV Delimiter Character
: Symbol to represent the delimiter separater.
Custom CSV Quote Character
: Symbol to represent the regular quote character.
Figure 2: Import Menu Properties
Action Properties
Figure 3: Action Properties
UI Properties
Custom Header
: Custom Header in HTML.
Custom Footer
: Custom Footer in HTML.
Disable delete record feature
: Disables the option for end users to delete records.
Figure 5: UI Properties
Advance Properties
When defined, the Userview Key value will be saved into the field defined here.
Figure 6: Import Menu Properties - Advanced
Figure 6: Import Menu Properties - Advanced
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Example: With the configurations above, we will attempt to import the following data in the screenshot below.
Figure 7: Source data highlighting data that will be imported into the target form's database table (master)
Figure 8: Data written into the form table (master)
Figure 9: Source data highlighting data that will be imported into the target form's subform's database table (child)  Figure 10: Data written into the form table (child) |
Performance & Offline Properties
Import Menu For Joget User Records
The Joget User Mgnt Utility has an import menu to import user records into Joget DX. You can download the app from Joget Marketplace.
Download Demo App
Download the following sample app and CSV file to demonstrate the use of Import Menu.
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|
...