Spreadsheet Structure
- Last UpdatedNov 30, 2021
- 6 minute read
Although the import utility is flexible and allows customisation of the spreadsheet, there is a convention that needs to be followed for the data to be valid.
The first column (column A in a sheet) of every row that contains data (except for comment lines) must contain a keyword. All keywords are case sensitive.
|
Keyword |
Data Type |
|---|---|
|
TEAM |
Team |
|
USER |
User |
|
AUTHUSER |
Authenticated User |
|
DATABASE |
Database |
|
COPYFOREIGN |
Foreign Copy |
|
FOREIGN |
Foreign Include |
|
EXTRACT |
Extract |
|
WORKEXTRACT |
Working Extract |
|
MDB |
Multiple Database (MDB) |
|
ACR |
Access Control Right (ACR) |
|
ACRGROUP |
ACR Group |
|
SCOPE |
Scope |
|
ROLE |
Role |
|
PEROP |
Permissible Operatio (Perop) |
A row can also be used as a comment row. If that is the case then first populated cell in the row needs to begin with hash character (#), it does not need to be a cell in column A in the Excel sheet.
If a row does not begin with a keyword and is not a comment line then it is invalid and the Import operation will not be successful.
The following table lists the cells of a Team row:
|
Column |
Values |
|
|---|---|---|
|
A |
Keyword |
TEAM |
|
B |
Name |
Name of the Team consisting only of letters (A-Z). Lowercase will be automatically changed to uppercase. |
|
C |
Description |
Description of the Team. |
The following table lists the cells of a User row:
|
Column |
Values |
|
|---|---|---|
|
A |
Keyword |
USER |
|
B |
Name |
Name of the User. Avoid the use of Spaces and the following characters ' |