The 18.05 update of EDMCS added a new feature to load requests to multiple Viewpoints via Excel. The Viewpoints must be within the same View; but if you have multiple updates to the same application metadata this could be a slick way to bulk-load updates. This step-by-step shows a simple example of how to leverage this functionality.

Just a reminder: EDMCS Request Scripts need to be in .xlsx format, and the top row must have a header with the required columns for your update.

Below is a list of the available Actions that can be completed via the Request Script:Screen Shot 2018-05-22 at 11.18.53 AM.png

Here’s a reference for Request Scripts header column names: Screen Shot 2018-05-22 at 11.19.14 AM

To test out the new functionality, I created a simple Request Script with two tabs: Account and Product. For Account, I am adding a dummy account using the “Add” Action Code. For Product, I am updating the default alias, using the “Update” Action Code:

Screen Shot 2018-05-22 at 11.23.40 AM


When looking at my View, I have 3 Viewpoints, including the 2 that I want to update with my Request File (Account & Product). This View is the default application View for an EPBCS application I have registered via the OOTB adapter.

I press “New Request” in the upper right hand corner to open the request panel to edit the hierarchies; then the “…” icon to select “Load Request Items” which opens the panel to upload my Request Script.

Screen Shot 2018-05-22 at 11.37.13 AM

Screen Shot 2018-05-22 at 11.43.25 AM

After uploading the Request File, I can see the changes to the interface that allow for toggling from one workbook tab/Viewpoint to another:

Screen Shot 2018-05-22 at 1.09.51 PM

There’s also a toggle button to allow the user to opt-out of a load of a specific workbook within the panel. The number of sheets is displayed under the Request File name, and shows how many workbook tabs have been loaded into EDMCS.

Screen Shot 2018-05-22 at 11.03.26 AM

Press the “Load” button to load the selected sheets. In EDMCS, both items appear in my Request panel on the left side. I can also review the added Account and updated Product by toggling between the two Viewpoints.

The Account Viewpoint with the added “Test – Rate”:

Screen Shot 2018-05-22 at 11.07.01 AM

The Product Viewpoint with the updated alias:

Screen Shot 2018-05-22 at 1.20.51 PM

Press the “Submit” button to apply the changes to the Viewpoints and update the metadata for the downstream EPBCS application.