Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
The Import Menu enables a user to import bulk data into a specific form and doing a simple column-to-field mapping.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition
定义

的  导入菜单  使用户能够批量数据导入到特定的形式,并且做一个简单的列到字段映射。

 

 
Figure 1: Import Menu in Userview
NameDescription
Select File

Extensions supported are:-

  • csv
  • xls
  • xlsx
Import Mode

This would allow you to manage existing records. Choices are:-

  • Import new record only
  • Import new record or update existing record
  • Delete record
Validate data?When checked, value from source will be validated against the specific form element's validator that it is mapped to in the "Column Mappings" property.

 

Image Removed

Figure 2: Post submission result in Userview

Image Removed

Figure 3: Import Menu Properties

NameDescription
Custom ID

Item link slug. Optional field.

Info
titleUnique field

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

LabelMenu label.
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 Mapping

Image Removed

NameDescription
Column NumberColumn number from the source file. Column number starts from zero.
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.

Info
titleExample
Image Removed

Subform ID: subform

Form ID set in the Subform: child

Field ID in the subform: name

Field Name: subform_child_name

Key Column NumberDefine column number that defines the record id. Column number starts from zero.
Start From Row NumberDefine which row number to start processing. Row number starts from zero.

Image Removed

Figure 4: Import Menu Properties - Actions

NameDescription
Confirmation MessageConfirmation Message.
Message shown when error occurMessage shown when error occur.
Message shown after data importedMessage shown after data imported.
Redirection (Hyperlink)URL to redirect.

Image Removed

Figure 5: Import Menu Properties - UI

NameDescription
Custom Header Custom Header in HTML.
Custom Footer Custom Footer in HTML.

 

Image Removed

Figure 6: Import Menu Properties - Advanced

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

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

Example:

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

Image Removed

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

Image Removed

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

Image Removed

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

图1:用户视图中的导入菜单

名称
描述
选择文件

支持的扩展名是: -

  • CSV
  • XLS
  • XLSX
导入模式

这将允许您管理现有的记录。选择是:

  • 仅导入新记录
  • 导入新记录或更新现有记录
  • 删除记录
验证数据?选中时,将根据源映射到“ 列映射 ”(Column Mappings)属性中的特定表单元素的验证器对来自源的值进行验证。

 

Image Added

图2:在Userview中提交结果

Image Added

图3:导入菜单属性

名称描述
自定义ID

物品链接slu </s>。可选字段。

Info
title独特的领域

在这里定义的值必须是唯一的用户视图菜单的其余部分,因为第一个匹配的名称将被调用。

标签菜单标签。
形成

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

Info
title如何存储工作?

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

Info
title邮政表格提交处理

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

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

列映射

Image Added

名称描述
列号来自源文件的列号。列号从零开始。
字段名称

对应的要被映射到的上面形式的元素ID。

如果您在目标表单中引用了一个子表单,请记住在子表单元素ID后跟一个下划线前面加上字段名称。

Info
title
Image Added

表单ID:子表单

子窗体中设置的窗体ID:子窗体

子窗体中的字段ID:名称

字段名称:subform_child_name

关键列号定义定义记录ID的列号。列号从零开始。
从行号开始定义要开始处理的行号。行号从零开始。

Image Added

图4:导入菜单属性 - 操作

名称描述
确认消息确认消息。
错误发生时显示消息错误发生时显示消息。
消息显示在数据导入后消息显示在数据导入后。
重定向(超链接)要重定向的网址

Image Added

图5:导入菜单属性 - UI

名称描述
自定义标题 HTML中的自定义标题。
自定义页脚 HTML中的自定义页脚

 

Image Added

图6:导入菜单属性 - 高级

名称描述
用户视图键名称

对应的要映射到上面形式的元素ID(与上面“ 列映射 ”中的映射相同)。

定义后,用户视图键值将被保存到此处定义的字段中。

UTF-8编码检查?选中后,它将检查上传的文件是否是有效的UTF-8编码文件。


例:

通过以上配置,我们将尝试在下面的屏幕截图中导入以下数据。

Image Added

图7:源数据突出显示将被导入到目标表单的数据库表(主)的数据


Image Added

图8:写入表格的数据(主)


Image Added

图9:源数据突出显示将被导入到目标窗体的子窗体的数据库表(子窗体)


Image Added
图10:写入表格的数据(子)
Image Removed
Figure 10: Data written into the form table (child)

 

Panel
borderColorpurple
borderWidth1
titleBGColor#ddccff
borderStylesolid
title
PerformanceYou 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.
性能

您可以在此UserView元素中配置“ 性能”设置,以允许缓存现有内容以提高性能和加载速度。使用Userview缓存进行性能改进,了解更多信息。