Importing and Exporting Form List Permissions

This manual is in pilot operation.

Importing Form List Permissions

Based on data registered in an Excel sheet (via the clipboard), it’s possible to add or delete form list permissions (rows in the Form List Permission Table) in bulk. This feature is referred to as "importing form list permissions."


Format of Importable Data

The import process involves taking data from an Excel sheet via the clipboard. Specifically, you copy the range that contains the settings from an Excel sheet to the clipboard and then import it to the Form List Permission Table editing screen. On the sheet, each item is written in its column.

Below is a detailed explanation of the format of data that can be imported. If it seems confusing, try exporting the form list permissions to an Excel sheet and pasting it there. The exported data can be imported as it is, following the rules below.

General Rules on Notation

Case is not distinguished.

Rules on the Order of Rows

The range to be copied on the Excel sheet starts with one "Header Row," followed by any number of "Detail Rows." The Header Row indicates the meaning of each field in the Detail Rows. Detail Rows each represent an instruction to add or delete a single form list permission, namely, a pair of a form list and an access permission type. Empty Rows can be placed at any position within the range to be copied and are simply ignored.

The rules regarding the arrangement of Header and Detail Rows are as follows:

  1. The first (non-empty) row within the range must be a Header Row.

  2. After the Header Row, you can place any number of Detail Rows. The arrangement of fields in these Detail Rows must follow the instructions given in the preceding Header Row.

  3. Within the range, multiple Header Rows can appear.

  4. Detail Rows are processed in the order they appear on the sheet.


This command instructs to clear form list permissions (delete all "rows (form list permissions)" registered).

To specify this command, write "CLEAR_FORM_LIST_PERMISSIONS" in the first field of a row. There is no distinction between Header and Detail Rows.


These commands instruct the registration and deletion of form list permissions.

Rules on Header Row Content

The Header Row consists of the fields listed in the table below.

Field Name Mandatory Number of Fields Field Position Specification (Field Symbol)



Always the first field

One of the following:



Record Type


Always the second field

Fixed value "HDR"

Form List



Fixed value "FORM_LIST"

Access Permission Type




The command "ADD_OR_UPDATE_FORM_LIST_PERMISSION" indicates that the following Detail Rows are instructions for adding or updating form list permissions. Similarly, the command "DELETE_FORM_LIST_PERMISSION" indicates that the following Detail Rows are instructions for deleting form list permissions.

The record type "HDR" indicates that this row is a Header Row.

The order of fields other than Command and Record Type is arbitrary.

Rules on Detail Row Content

In Detail Rows, appropriate values are specified for each field designated in the Header Row. Therefore, each Detail Row must have the same number of fields as the preceding Header Row. The fields in a Detail Row correspond to those in the Header Row in the order they appear. The specified values for each field in a Detail Row are as follows.

Field Name Specification (Field Value)


Specify the same command as in the preceding Header Row

Record Type

Fixed value "DTL"

Indicates this row is a Detail Row.

Form List

The label of the form list that is the subject of the registration or deletion permission.

Access Permission Type

The label of the access permission type that is the subject of the registration or deletion permission.

Exporting Form List Permissions

You can paste all form list permissions in the format described above for import into an Excel sheet (by exporting the data to the clipboard and then pasting it from the clipboard into an Excel sheet). You can modify this sheet’s content and re-import it.