7 SIOCS UI Spreadsheet Data Loader
Use EICS Spreadsheet Data Loader to upload data to the EICS application tables from spreadsheets. Spreadsheet Data Loader is applicable to small or medium data file up to a few Megabytes.
EICS UI spreadsheets loader provides following features:
-
Download the templates
-
Upload user store assignments
-
Upload user role assignments
-
Data Validations
Upload Store Assignments
You can assign users to stores using EICS Spreadsheet data loader in EICS Admin Security screen. User must exist in credential store (for example, Oracle IDCS).
You must have the Application Administrator job role or privileges.
Spreadsheet Templates
UserAssignmentsTemplate.xlsx/Store Assignments:
Table 7-1 Spreadsheet Templates
Field | Description | Required |
---|---|---|
Action |
The assignment action, choose value from dropdown, assign, revoke. |
Yes |
Action Value |
N/A |
No |
Username |
The username to assign the store. |
Yes |
Store ID |
The store Id to assign to user. |
Yes |
See Oracle Retail Enterprise Inventory Cloud Service Security Guide and Oracle Retail Enterprise Inventory Cloud Service User Guide Security chapter.
Upload Role Assignments
You can assign users to roles using EICS Spreadsheet data loader in EICS Admin Security screen. User must exist in credential store (for example, Oracle IDCS or OCI IAM).
The role must exist in EICS.
You must have the Application Administrator job role or privileges.
Spreadsheet Templates
UserAssignmentsTemplate.xlsx/Role Assignments:
Table 7-2 Spreadsheet Templates
Field | Description | Required |
---|---|---|
Action |
The assignment action, choose value from dropdown, assign, revoke. |
Yes |
Action Value |
N/A |
No |
Username |
The username to assign the store. |
Yes |
Role Name |
The role name to assign to user. |
Yes |
Store ID |
The store Id to assign to user. |
No |
Start Date |
User start date. |
No |
End Date |
User end date. |
No |
See Oracle Retail Enterprise Inventory Cloud Service Security Guide and Oracle Retail Enterprise Inventory Cloud Service User Guide Security chapter.