Forum Discussion

Rajesh2's avatar
Rajesh2
Contributor
8 years ago

How to fetch the data from a Grid/dataset/table?

Hi,   Greetings,   NOTE: Please solve my queries on the basis of Python language as i am working in Python   I am working in a project where in we are using TestComplete with Python language. I...
  • Rajesh2's avatar
    Rajesh2
    8 years ago

    Hi baxatob Thank you so much for the solution.

     

    But we are facing some issue. It is returning the value of only first row. 

     

    As Pavan name was in first row it returned the Age of that Name.

     

    But when i gave Log.Message("Raj") which is in third row, the code isn't working.

     

    while not source.EOF():
        if source.Value["NAME"] == name:
            return source.Value["AGE"]
        source.Next()

     

    Can we know why it is not working for the same. If you know the solution, Can you please help us with the same..!!

  • baxatob's avatar
    baxatob
    8 years ago

    Hi,

     

    You should call the get_value() routine within Log.Message():

     

    Log.Message(get_value("Raj"))

    It works for me.

  • baxatob's avatar
    baxatob
    8 years ago

    In your case get_value() is a class method. You should use a keyword self as a first argument, while defining your function:

     

    class Excel:
    
    def get_value(self, RowValue, ColumnName, name):
        ...

     

     

    P.S. You do not need these delays : Delay(1000)

  • baxatob's avatar
    baxatob
    8 years ago

    At first you need to import your class:

     

    from Script1 import Excel

class Common_Functions(Excel):
    ...
baxatob's avatar
baxatob
Community Hero

1. Please go carefully through this topic: https://support.smartbear.com/testcomplete/docs/app-objects/specific-tasks/grids/index.html 

 

2. You can create a DBTable variable from your excel file. Then you can use it something like this:

 

def get_value(column_name):

    source = Project.Variables.your_dbtable_variable
    source.Reset()
    while not source.IsEOF():
        Log.Message(source.Value[column_name])
        source.Next()

The code above will save all values under the column_name into the Log.

 

3. Enable Post image on error option in your Project -> Properties -> Playback -> Log

 

4. You can't do it out-of-the-box, however you can create your own script or extension for this purpose.

Rajesh2's avatar
Rajesh2
Contributor
8 years ago

Hi baxatob, Thank you for the response.

 

1. The link which you have sent is throwing 404 error. Can you please check the same?

 

2. Thank you, Will check the same.

 

3. I want the screen shot to be stored in the desktop folder. How to store it externally with log files.

 

4. Ok, Will try with the same. By creating our own method to fetch into excel report.

  • baxatob's avatar
    baxatob
    Community Hero
    8 years ago

    Hi,

     

    I have updated the link >>

     

    You can use the following code for taking a screenshot:

     

    def take_screenshot(path):
    Sys.Desktop.Picture().SaveToFile(path)


     path should be a string with full path to your destination, e.g. "C:\\Users\\User\\Desktop\\shot.jpg"
    Sys.Desktop will provide a screenshot from the whole desktop. You can use any mapped object instead of Sys.Desktop