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.