UpdateSpreadsheetRowValues - EcoSys - Help

EcoSys Functional Automation Framework

English (United States)
Search by Category
EcoSys Version

Find the row on the spreadsheet and update it with the values specified in the data provider.

Object- xPath to the spreadsheet table (See Spreadsheet section of working with xPath)

Data- A data provider that provides the data to find the row and update the row with the specified values. The data provider and data field provide the framework with information on how to find the correct row and what to update the cells to.

To create the data provider:

Go to the ProjectData tab and scroll to the first free line in the sheet.

Leaving a blank row between the last row with data, enter a name for the data provided in the Column of a spreadsheet.

  1. In the row below the Data Provide Name, in the first column set the value as Action.

  2. In the remaining columns of this row, enter the column headers of the spreadsheet as they appear in the UI.

    You only need the columns to identify a unique row and the data you want to update.

  3. In the next row, enter ‘Find’ in the first column under the Action header.

    1. For the remaining columns in this row, enter the values of the row as they appear in the EcoSys spreadsheet.

      This is used to uniquely identify the row in the spreadsheet that you want to update. There must be enough information to uniquely identify the row from other rows.

      • If this is a CostObject Spreadsheet, s Hierarchy Path ID would be sufficient

      • If this is a Transaction spreadsheet, Cost Object Hierarchy Path would not be sufficient so you might need to add version, categories, custom fields, dates to uniquely identify it.

  4. In the next row, for the first column, enter ‘Insert’ for the Action. This will enter the data provided on the rest of this row into EcoSys

    To create the data for the data cell of the test step:

  5. In the Data cell, enter the following text, where data provider name is the name from step 2, column name is the name of the column you want to click on and value to click on is the value of that cell.

    DataProvider_ProjectData=data provider name>ColName=column name>ClickRowVal=value to click on

    For updating a row, it does not matter what cell within the row you instruct the framework to click on, it can be anyone. The framework uses a common method to locate the row that is shared with ClickSpreadsheetrowvalues so the configuration of the data cell is similar.

    For example, updating a Unit Rate table and finding the row to update by Cost Object ID. The data cell would have colName=Cost Object ID and ClickRowVal = to the Cost Object ID value.

The data cell for the test step would be:

The data provider would be:

The Find row would have the value we are using to uniquely identify the row. It could be 1 or many values, in this example it is only one.

The Action row provides the values to insert into the spreadsheet during the update.

The values in the number/text filed are user-defined. You can enter the value that you want in these fields.

For Lookup Fields, the automation suggests using Type-Ahead string, so the value must be the Type-Ahead string completely:

  • In few instances, the framework will use the lookup field, as it will open and select the value itself. However, the string must be a full value displayed in the lookup that you want to select. If it is a hierarchy, use > symbol as the delimiter for each level.

  • In few instances, during the automation run time, when you enter the value, it does not get saved correctly. In such cases, you must override the automation tool to use the lookup selection and add ‘ FORCE_LOOKUP’ text at the end of the column.