Versions Compared

Old Version 1

changes.mady.by.user Hugo

Saved on

compared with

New Version 2

changes.mady.by.user sjk

Saved on

Key

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

通过导入工具，用户可以通过从表单字段中检索CSV，XLS或XLSX文件并进行简单的列到字段映射，将批量数据导入特定表单的表格。

它以前被称为Joget Workflow v4中的CSV导入工具。

Image Added

图1：CSV导入工具属性

名称描述
文件上传表单指定File Upload元素所在的源表单。
上传字段ID文件上传指定表单中的元素ID。
存储数据表单

通过选择一个目标表单指定在哪里存储数据。

Info
title如何存储工作？

目标表单的商店联编程序将被调用以进行数据存储。

Info
title邮政表格提交处理

每次更新或创建记录时，都会触发目标表单的“表单后提交处理 ” 下映射的任何工具。

重要说明：无论“ 运行工具”属性如何，映射的工具都将被触发。
Image Added

列映射

将源文件的CSV值映射到目标表单字段。

名称描述
列号指源CSV中的列号。整数，从0开始。
字段名称

必须是上面指定的目标表单中的元素ID，即“ 存储数据表单 ”。

关键列号

保存主键值的列号。

Info

如果没有定义，则导入时将生成并分配UUID。

从行号开始行号开始导入数据。整数，从0开始。
外键

定义在CSV文件中找不到的其他值，如外键值关联数据。你也可以在这里定义硬编码值。

名称描述
字段名称目标表单中的字段名称。
值

值被设置。

哈希变量被接受。

导入模式
  • 导入新记录或更新现有记录
  • 仅导入新记录
  • 删除记录
验证数据？要导入的数据将根据表单字段的验证进行验证。
UTF-8编码检查？
检查文件是否使用UTF-8编码。
调试模式
调试模式打开时，有用的调试信息将打印在服务器日志中。
Info
title在版本5.0.7中添加了新功能

在导入状态选项卡中Joget企业的工作流程5.0.7版本新添加。

 

Image Added

名称描述
导入状态这是Joget Workflow Enterprise 5.0.7版本中增加的一个新功能，它使得导入的执行更加清晰。可以选择保存导入状态数据，以形成原始文件（上传）的数据表或工作流变量。

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

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".

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

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 Removed

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.