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."
Procedure:
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.
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:
-
The first (non-empty) row within the range must be a Header Row.
-
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.
-
Within the range, multiple Header Rows can appear.
-
Detail Rows are processed in the order they appear on the sheet.
CLEAR_FORM_LIST_PERMISSIONS Command
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.
ADD_OR_UPDATE_FORM_LIST_PERMISSION Command, DELETE_FORM_LIST_PERMISSION Command
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) |
|---|---|---|---|---|
Command |
✓ |
One |
Always the first field |
One of the following: For addition: "ADD_OR_UPDATE_FORM_LIST_PERMISSION" For deletion: "DELETE_FORM_LIST_PERMISSION" |
Record Type |
✓ |
One |
Always the second field |
Fixed value "HDR" |
Form List |
✓ |
One |
Any |
Fixed value "FORM_LIST" |
Access Permission Type |
✓ |
One |
Any |
Fixed value "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) |
|---|---|
Command |
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. |