Forum Discussion

jesse2's avatar
jesse2
Occasional Contributor
6 years ago
Solved

Unable to create table checkpoint from Web page table

I tried looking around here for a while before posting this, but I'm at a loss.   I am trying to create a table checkpoint for an HTML table on a webpage using TestComplete 12.50. The table is gene...
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    Table checkpoints, based upon the documentation that I'm seeing, are only supported for Desktop applications (go to the list of supported controls https://support.smartbear.com/testcomplete/docs/testing-with/checkpoints/tables/supported-controls-and-required-plug-ins.html). For web tables, you'll have to do some other work for that.

     

    The link for the extension is, indeed, broken... TanyaYatskovska... do you know if there's another location for that script extension?  It does seem like it would meet the need.

     

    Basically, though, you could manually do what is described.

     

    1) Write code to grab the table object and save the baseline of the object as an XML Checkpoint in your project

    2) Use the XML Checkpoint to compare the contents of the "live" table with the stored XML copy.

     

     

tristaanogre's avatar
tristaanogre
Esteemed Contributor

FYI, I tried out the extension on my system and did end up with an error.  As documented in the blog post, as written, the extension requires the use of the MSXML2.DOMDocument.4.0 object.  If you don't have that installed EXACTLY like that, you'll get an error...


.... SO... the beauty of ScriptExtensions is that, if you know how to do so, you can easily go in and edit/customize them.  So... I did.  Attached find version 0.5 of the ScriptExtension where, instead of MSXML2.DOMDocument.4.0, it uses just MSXML2.DOMDocument.  This worked VERY nicely for me.  Download the file to your ScriptExtensions folder, change the extension from ZIP to TCX and you should be good to go. Let me know if you run into problems.


jesse2's avatar
jesse2
Occasional Contributor
6 years ago

I tried posting this earlier, but it looks like it didn't take.

 

Thank you TanyaYatskovska for getting that back up.

 

Thanks tristaanogre. I haven't tested the script extension yet, but thanks for updating it. I have msxml6.0 on my machine, so I think you update should work for me. If not, I'll fiddle with it. My code seems to be a barebones version of the HTML script extension, so I'll compare them.

 

Anyway, for recording purposes, here's an implementation without the script extension that worked for me.

 

# Python

# Using a global dictionary to reference be able to reference XML stores by a friendly name
TableDict = {"MyTable1":XML.FirstTable,
              "MyTable2":XML.SecondTable,
              "MyTable3":XML.ThirdTable}
  
# TableAlias is the table on the webpage you want to turn into XML, it must has an outerHTML property
def GetTableOnScreenToXML(TableAlias):
  try:  
    XMLdoc = Sys.OleObject["Msxml2.DOMDocument.6.0"]
    TableHTML = TableAlias.outerHTML.replace("<br>",'') # the replace function is needed to delete any unclosed tags like <br>
    XMLdoc.loadXML(TableHTML)
    return XMLdoc
  except Exception as e:
    Log.Error("Error: " + str(e.args[0]))
 
# Take on screen report and turn put it in the XML Store 
def CreateXMLCheckPoint(StoreName, TableAlias):
  # StoreName = "FirstTable"
  # TableAlias = Aliases.browser.Reports.Table
  try:
    OnScreenXML = GetTableOnScreenToXML(TableAlias)
    if (XML.CreateXML(StoreName, OnScreenXML)):
      Log.Message("XML Checkpoint created")
  except Exception as e:
     Log.Error(str(e.args[0]))

     
# The same GetTableOnScreenToXML() is used to get the table on screen, and then the Check() function is run to verify it matches the XML store
def ValidateTable(StoredXMLName):
  # StoredXMLName refers to the XML Store of the table you want to validate
  OnScreenTable = GetTableOnScreenToXML(TableAlias)
  XMLCheckpoint = TableDict.get(StoredXMLName)
  XMLCheckpoint.Check(OnScreenTable)
  
# Testing that you can validate the HTML table against the stored XML document
def TestValidateTable():
  ValidateTable("MyTable1")