Importing Data

Introduction

Feature(s)

For a designed form, you can add or update data by importing Excel files.

Application Scenario(s)

This feature is used when you need to import or update data in batches. The followings are the import modes available:

Who Imports

Where to Import

Import Mode

Admin

Manage Data

Member

Permission sets

Preview

For example, you can select Add Data Only in Import Mode to import the prepared customer information as follows.

Setting Procedure

Where to Import

1. Import Excel files as an admin.

Select the form to be edited, and click Edit > Manage Data > Import.

2. Import Excel files as a member.

Access a form, switch to the permission set, in which you are granted the importing permission, and click Import.

Validating Data

1. Where to validate

a. For an admin, go to Manage Data > Import, and tick Trigger Validation upon Import. Then format and required field validations will be performed upon imported data.

b. For a member, click Import from the corresponding permission set, and Trigger Validation upon Import is ticked by default. In that case, format and required field validations will be performed upon imported data.

2. Validation rules

a. Untick Trigger Validation upon Import.

When importing data, if you do not tick Trigger Validation upon Import, only basic validation will be performed upon certain fields. Detailed validation rules are as follows:

Field Type

Validation Type

Validation Rules

Number

Format Validation

The content can be converted to a valid number.

Date&Time

Format Validation

The content can be converted to a valid date.

SubForm

Subform Data Validation

The validation is performed upon each sub-record.

Member

Matching Validation

The content can be matched to a unique member.

Members

Matching Validation

Each value in the array can be matched to a unique member.

Department

Matching Validation

The content can be matched to a unique department.

Departments

Matching Validation

Each value in the array can be matched to a unique department.

b. Tick Trigger Validation upon Import.

When importing data, if you tick Trigger Validation upon Import, the validation will be performed upon certain fields. Detailed validation rules are as follows:

Field Type

Validation Type

Validation Rules

Single Line

Format Validation

After being converted to a string, the content is consistent with a phone number, a postal code, an ID card number, or an Email address.

Number

Format Validation

The content can be converted to a valid number.

Value Range Validation

The converted value is within the value range.

Date&Time

Format Validation

The content can be converted to a valid date.

Radio

Option Validation

After being converted to a string, the content can be matched in the options.

Checkbox

Option Validation

After being converted to a string and separated by commas, the separated content can all be matched in the options.

Single Select

Option Validation

After being converted to a string, the content can be matched in the options.

Multi Select

Option Validation

After being converted to a string and separated by commas, the separated content can all be matched in the options.

SubForm

Subform Data Validation

The validation is performed upon sub-record.

Member

Matching Validation

The content can be matched to a unique member.

Members

Matching Validation

Each value in the array can be matched to a unique member.

Department

Matching Validation

The content can be matched to a unique department.

Departments

Matching Validation

Each value in the array can be matched to a unique department.

3. Validation upon duplicates

When you choose the modes (including Adding data only, Updating date only, and Updating and adding data) to import data, the system will validate duplicates for the fields for which you ticked No duplicates.

The system will validate:

  • For one field, whether the data to be imported are the same with the existing data in the form.
  • For one field, whether the data to be imported are the same with other to-be-imported.

Handling Data Importing Failure

1. Modify failed records.

If you fail to import some records because of failed validation, modify those failed records manually. Then you can re-import the modified records.

Note:

1. You can manually modify the failed records only when the number of failed records is less than 30.

2. In the case of importing data in the format of Number and Date&Time, if the format validation fails, the system will not prompt you to modify the failed data. However, in such cases, the fields that failed the validation will be left empty after the import process.

2. Download the error report.

You can also check the reason for importing failure by downloading the error report to modify the records accordingly.

Note:

If the number of failed records is greater than 30, you can only re-import the modified data after downloading the error report.

3. Handle the importing failure caused by duplicate member/department names.

You cannot import records that contain member/department fields with the same name. For solutions, see Solutions for Importing Same Named Members/Dept.

Notes

1. Records in the imported file cannot exceed 50,000 rows and 200 columns.

2. Suppose you tick No duplicates under Validation in a form. No matter whether you tick Trigger Validation upon Import when importing data under permission sets, the system will validate for duplicates. However, if you do not tick Trigger Validation upon Import when importing data on the Manage Data page, the system will not validate for duplicates, field formats, and so on.

3. In a workflow form, if the node after the start node of the workflow is a child workflow, and you enable Initiate Workflow upon Import when importing an Excel file, the child workflow will not be triggered after the data is imported, which means the data will stay at the start node.

4. Data of the following field types cannot be imported currently: Divider, Select Data, Query Data, and Signature.

5. For details about importing the data of special fields, see Importing the Data of Special Fields.

6. Here are the importing rules for the Serial No. field:

Import Mode

Import Rule

Cannot import the serial number existed in the imported Excel file. The value of the Serial No. field will be generated automatically based on the rules you set.

Allowed to import the serial number existed in the imported Excel file.

Only allowed to import the serial number existed in the imported Excel file for the data to be updated. For the data to be created, you cannot do so.

Was this information helpful?
Yes
NoNo
Need more help? Contact support