Forum Discussion

mschofer's avatar
mschofer
Occasional Contributor
3 years ago

Python Pointer

Long time no posting. In Python what is the best way to extract information from tables.  I am able to find the values quite easily and write to variables. 
Is beautiful soup the recommended route.? 

Script Extensions
Script Tests
  • mschofer's avatar
    mschofer
    3 years ago

    I got it working

     

    def chechdetails():
    browser = Aliases.browser
    page = browser.Page("*")
    CurrPage = browser.Page("*")
    PropArray = ["ObjectType","ContentText"]
    ValuesArray = ["Cell",aqConvert.DateTimeToFormatStr("12/1/2021", "%m/%d/%Y")];

    myDateTable = page.FindChild(PropArray, ValuesArray,10)
    Log.Message(myDateTable.RowIndex)
    # for r in range(1, 999):
    # checkNum = currPage.FindElements("//form[@id='']/div/table/tbody/tr[" + str(r) + "]/td[1]")
    # if len(rowOfCells) == 0:
    # break
    # if checkNum.innerText == "CK" + marksCheckNumFromExcel:
    # targetRow = r
    # break
    # if targetRow == 0:
    # Log.Error("couldn't find check #")
    # else:
    myText21 = CurrPage.FindElement("//table[@border=1]/tbody/tr["+str(myDateTable.RowIndex + 1)+"]/td[3]/div/table/tbody/tr[2]/td[2]")
    if (myText21.Exists):
    Log.Message(myText21.contentText)
    myText22 = CurrPage.FindElement("//table[@border=1]/tbody/tr["+str(myDateTable.RowIndex + 1)+"]/td[3]/div/table/tbody/tr[3]/td[2]")
    if (myText22.Exists):
    Log.Message(myText22.contentText)
    myText23 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[4]/td[2]")
    if (myText23.Exists):
    Log.Message(myText23.contentText)
    myText24 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[5]/td[2]")
    if (myText24.Exists):
    Log.Message(myText24.contentText)
    myText25 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[6]/td[2]")
    if (myText25.Exists):
    Log.Message(myText25.contentText)
    myText26 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[7]/td[2]")
    if (myText26.Exists):
    Log.Message(myText26.contentText)
    # myText27 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[8]/td[2]")
    # if (myText27.Exists):
    # Log.Message(myText27.contentText)
    myText28 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[9]/td[2]")
    if (myText28.Exists):
    Log.Message(myText28.contentText)
    # myText29 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[10]/td[2]")
    # if (myText29.Exists):
    # Log.Message(myText29.contentText)

  • mikef's avatar
    mikef
    Staff
    3 years ago

    Hi mschofer 

     

    Are you trying to extract the table data directly from the HTML using Python and BeautifulSoup, or by using TestComplete functionality?

     

    To access and modify table values it a Table in the Stores repository to your project, use the Tables.values[] property: Tables.Values method 

     

    To create a table in Stores based on a table of values in your UI, add the Stores repository to your Project, then add a table object. More info on Tables objects here: About Tables Collections 

    • mschofer's avatar
      mschofer
      Occasional Contributor
      3 years ago

      I am using Test Complete and Python and No Soup.  I am just getting back to this.

      So I answered my original question. I can write to a variable or use RETURN making it a function.

      My challenge is getting the correct row. (The table has many rows, It is actually a table within a table. I will be going that in a FOR loop

      with logic to identify the row, 

       

      def chechdetails():
      browser = Aliases.browser
      page = browser.Page("*")
      CurrPage = browser.Page("*")
      myText21 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[2]/td[2]")
      if (myText21.Exists):
      Log.Message(myText21.contentText)
      myText22 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[3]/td[2]")
      if (myText22.Exists):

      • mschofer's avatar
        mschofer
        Occasional Contributor
        3 years ago

        I got it working

         

        def chechdetails():
        browser = Aliases.browser
        page = browser.Page("*")
        CurrPage = browser.Page("*")
        PropArray = ["ObjectType","ContentText"]
        ValuesArray = ["Cell",aqConvert.DateTimeToFormatStr("12/1/2021", "%m/%d/%Y")];

        myDateTable = page.FindChild(PropArray, ValuesArray,10)
        Log.Message(myDateTable.RowIndex)
        # for r in range(1, 999):
        # checkNum = currPage.FindElements("//form[@id='']/div/table/tbody/tr[" + str(r) + "]/td[1]")
        # if len(rowOfCells) == 0:
        # break
        # if checkNum.innerText == "CK" + marksCheckNumFromExcel:
        # targetRow = r
        # break
        # if targetRow == 0:
        # Log.Error("couldn't find check #")
        # else:
        myText21 = CurrPage.FindElement("//table[@border=1]/tbody/tr["+str(myDateTable.RowIndex + 1)+"]/td[3]/div/table/tbody/tr[2]/td[2]")
        if (myText21.Exists):
        Log.Message(myText21.contentText)
        myText22 = CurrPage.FindElement("//table[@border=1]/tbody/tr["+str(myDateTable.RowIndex + 1)+"]/td[3]/div/table/tbody/tr[3]/td[2]")
        if (myText22.Exists):
        Log.Message(myText22.contentText)
        myText23 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[4]/td[2]")
        if (myText23.Exists):
        Log.Message(myText23.contentText)
        myText24 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[5]/td[2]")
        if (myText24.Exists):
        Log.Message(myText24.contentText)
        myText25 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[6]/td[2]")
        if (myText25.Exists):
        Log.Message(myText25.contentText)
        myText26 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[7]/td[2]")
        if (myText26.Exists):
        Log.Message(myText26.contentText)
        # myText27 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[8]/td[2]")
        # if (myText27.Exists):
        # Log.Message(myText27.contentText)
        myText28 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[9]/td[2]")
        if (myText28.Exists):
        Log.Message(myText28.contentText)
        # myText29 = CurrPage.FindElement("//div[@id='amtDtl.0_2']/table/tbody/tr[10]/td[2]")
        # if (myText29.Exists):
        # Log.Message(myText29.contentText)