Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 19

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.
Image Removed

Image Added
Figure 1: Import Menu in Userview Runtime

Import Menu Properties

Configure Import Menu


Name
ID: 
DescriptionScreens (Click to view)
IDMenu element unique id. Userview will use this id in the URL for the menu if the Custom ID is empty.

Image Added

Figure 2: Import Menu Properties



Custom ID

Optional custom menu id. Value defined here must be unique to the rest of the Userview Menus as the first matching name will be called upon.

Label
The userview menu label. You can add Font Awesome Icons into your menu labels.
Form

Specify on where to store the data by choosing a target form. 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 Modified

Column Mapping
:
NameDescription
Column Number

Column number from the source file. Column number starts from zero.

Image Modified

Field Name
:  

Corresponding element ID in the form set above to be mapped to.

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: 

Image Removed
Info
titleExample
Image Added

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.

Info
titleExample
:

Image Modified

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.

Action Properties

Image Removed

Figure 2: Import Menu Properties


NameDescriptionScreens (Click to view)
Action Properties
Confirmation Message
Confirmation Message.

Image Added
Figure 3: Action Properties

Message to show when error occur
Message shown when error occur.
Message to show after data imported
Message shown after data imported.
Redirection (Hyperlink)
URL to redirect, for example, to redirect to the CRUD datalist.

UI Properties

Image Removed

Figure 3: Action Properties
NameDescriptionScreens (Click to view)
UI Properties
Custom Header
Custom Header in HTML.

Image Added

Figure 5: UI Properties

Custom Footer
Custom Footer in HTML.
Disable delete record feature
Disables the option for end users to delete records.

Advance Properties

Image Removed

Figure 5: UI Properties

Advance Properties


NameDescriptionScreens (Click to view)
Userview Key Name

Corresponding element ID in the form set above to be mapped to (same like the mapping in "Column Mapping" above).

When defined, the Userview Key value will be saved into the field defined here.

Image Added
Figure 6: Import Menu Properties - Advanced

UTF-8 Encoding Checking?
When checked, it will check the uploaded file if it is a valid UTF-8 encoded file.

Image Removed

Figure 6: Import Menu Properties - Advanced


Panel
borderColorblue
borderWidth1
borderStylesolid

Example:

With the configurations above, we will attempt to import the following data in the screenshot below.

Image Modified

Figure 7: Source data highlighting data that will be imported into the target form's database table (master)


Image Modified

Figure 8: Data written into the form table (master)


Image Modified

Figure 9: Source data highlighting data that will be imported into the target form's subform's database table (child)


Image Modified
Figure 10: Data written into the form table (child)


Performance & Offline Properties

You can configure the Performance settings in this Userview Element which allows one to cache existing content for improved performance and loading speed. Read more at Performance Improvement with Userview Caching.

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
nameAPP_jusermanager-user-import-menu.jwa
height150
  
View file
namesample_import_user.csv
height150