Forum Discussion

Occasional Contributor

10 years ago

TestComplete returns NULL from Excel in Property Checkpoint, but returns Correct value in Jscript

I am using the Property Checkpoint to verify a value from UI with a value from an Excel. The checkpoint returns a NULL value from the Excel, but when i use a script to do the same, i get the correct ...

CHIMERA
10 years ago
Resolved!

After reading several articles on TestComplete DDT and Excel compatibility, and even after trying the apostrophe <'> hack, my problem persisted.

Taking info from other articles and the much helpful replies above, that TestComplete determines the format of a Row based on the First Cell of that Row, I Stored a junk value 'X' in all the Empty Cells(which were not required) in my Excel. Now my scripts run smoothly. :smileyvery-happy:

Thanks for your replies!

CHIMERA

Occasional Contributor

Yes, i tried that too. However, how is it possible that i get the data by using Jscript for the same Excel, but the Checkpoint returns NULL.

To make it more clear,

Log.Message(Project.Variables.QAT_ESDH_Properties.Value("IDKort")); -> returns 8760913

Property Checkpoint - reading from the same Cell -> returns NULL

I even tried removing and adding the Excel, resetting the data loop, restarting Testcomplete. and even restarting my computer.. :smileytongue:

leandroaraujoso

Contributor

10 years ago

How about if you assign the value from Excel to a variable forcing the conversion to a string, like this:

var myvar = aqConvert.VarToStr(Project.Variables.QAT_ESDH_Properties.Value("IDKort"));

and then in the checkpoint

CheckProperty(myObj, "myProperty", cmpEqual, myvar);

Please, let me know the outcome ;)

CHIMERA
Occasional Contributor
10 years ago
Hmm..i see that i'm not clear enough yet...
Ill try again..

Testcomplete returns NULL from excel when i use the "Property Checkpoint" TestStep in my Keyword Test, like below..

But when i use JScript(like below) for the same purpose, it works fantastically fine!
aqObject.CheckProperty(AliasesCaseTabPublishedPanelIdCardInfo.tableLayoutPanel1.label10, "Text", cmpEqual, Project.Variables.QAT_ESDH_Properties.Value("IDKort"), false);

Bottomline: I'm just using 2 different ways to achieve the same goal, but i want to know why is it that one works and the other doesn't.

U may suggest me to go with JScript since it works fine, but it is puzzling me and i want to know whats going wrong..
- joseph_michaud
  Moderator
  10 years ago
  What happens when you convert the Keyword test to a script and run the converted script?
  
  What does that converted script look like?
  - CHIMERA
    Occasional Contributor
    10 years ago
    Resolved!
    
    After reading several articles on TestComplete DDT and Excel compatibility, and even after trying the apostrophe <'> hack, my problem persisted.
    
    Taking info from other articles and the much helpful replies above, that TestComplete determines the format of a Row based on the First Cell of that Row, I Stored a junk value 'X' in all the Empty Cells(which were not required) in my Excel. Now my scripts run smoothly. :smileyvery-happy:
    
    Thanks for your replies!
- shailesh_singh
  Occasional Contributor
  9 years ago
  Did you parametrize your expected value in checkpoint wizard and see it like below scree-shot.