Forum Discussion

nastester's avatar
nastester
Regular Contributor
7 months ago
Solved

Issue using Excel and variables in name mapping

I am using variables in name mapping objects to pull data from an Excel sheet and then verify with Property Checkpoints. It is working fine for the first 3 rows in my sheet. But on the fourth row I ...
Variables
  • nastester's avatar
    nastester
    7 months ago

    All, thank you for your responses. I finally uncovered the issue. The issue was some of the data the mock API is returning had spaces in the address field (which was truncated by table so not noticeable when looking at the UI). The data from the UI was copied into the spreadsheet so it didn't have the space.  I still don't know why TC didn't log the ER/AR and show that they didn't match but when I updated the mock data to not have spaces, everything worked. 

nastester's avatar
nastester
Regular Contributor
7 months ago

All, thank you for your responses. I finally uncovered the issue. The issue was some of the data the mock API is returning had spaces in the address field (which was truncated by table so not noticeable when looking at the UI). The data from the UI was copied into the spreadsheet so it didn't have the space.  I still don't know why TC didn't log the ER/AR and show that they didn't match but when I updated the mock data to not have spaces, everything worked. 

  • rraghvani's avatar
    rraghvani
    Icon for Champion Level 3 rankChampion Level 3
    7 months ago

    I thought you were reading the spreadsheet and populating the UI?

    What's ER/AR?

    • nastester's avatar
      nastester
      Regular Contributor
      7 months ago

      Expected result/actual result.

      And no, the test is verifying that the data table on the UI is displaying the expected data from the API in the right location. It isn't inputting any data. 

      • rraghvani's avatar
        rraghvani
        Icon for Champion Level 3 rankChampion Level 3
        7 months ago

        What you have described sounds pretty much like Data-Driven Testing, but you're not using the spreadsheet to "drive" the data, but instead you are comparing the UI fields with the data in the spreadsheet.

        Ideally, you should get the UI control object, followed by the contentText property value, and then compare this, with the value from the spreadsheet. This will give a clear indication if the UI control content doesn't match with the value shown in the spreadsheet, as opposed to using "//div[.='%StreetAddr_KW%']".

        "//div[.='%StreetAddr_KW%']"  This could make your test brittle as it is based on the format of the address - I agree scot1967 

  • Hassan_Ballan's avatar
    Hassan_Ballan
    Icon for Champion Level 3 rankChampion Level 3
    7 months ago

    Since your NameMapping is parameterized and your object XPath statement is using equal for comparison, the values do not match due to the spaces you described. As result, the object in question will not be found due to the incorrect value. For the EV/AV, look at the log warnings before the error, self-healing decided to use another object with blank value, which again fails as values are not equal.

    I am surprised it works for you as is. You still need to add to your code RefreshMappingInfo. In the following example if I comment out the RefreshMappingInfo statements after each "Set Variable value", it will fail.