deviprasad Posted June 29, 2013 Share Posted June 29, 2013 i am using a window based application.auto it spy is able to spy the datatable control but i dont know how to retrive the data from the data table. i need to select a value from the data table. following are the summry of the cotrol ============================== >>>> Window <<<< Title: Archive List Class: #32770 Position: 455, 143 Size: 594, 386 Style: 0x94CC004C ExStyle: 0x00010100 Handle: 0x00000000000711CA >>>> Control <<<< Class: DataTbl Instance: 1 ClassnameNN: DataTbl1 Name: Advanced (Class): [CLASS:DataTbl; INSTANCE:1] ID: 503 Text: Position: 7, 81 Size: 555, 217 ControlClick Coords: 189, 73 Style: 0x500301FD ExStyle: 0x00000004 Handle: 0x00000000004308B2 >>>> Mouse <<<< Position: 659, 327 Cursor ID: 0 Color: 0xFFFFFF >>>> StatusBar <<<< >>>> ToolsBar <<<< >>>> Visible Text <<<< Company it will be llay help ful if any body can help me on this Link to comment Share on other sites More sharing options...
water Posted June 29, 2013 Share Posted June 29, 2013 Welcome to AutoIt and the forum! What have you coded so far? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 nothing, i am not finding any idea how to do a action on this table Link to comment Share on other sites More sharing options...
water Posted June 29, 2013 Share Posted June 29, 2013 Try ControlGetData("Archive List", "", " [CLASS:DataTbl; INSTANCE:1]") Do you want to retrieve the whole datatable or only a selected item? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 can i retrive every row from data table and can i select a specific row ? please help Link to comment Share on other sites More sharing options...
water Posted June 29, 2013 Share Posted June 29, 2013 What application do you try to automate? Is it an application with a database in the background? It might be easier to directly access the database. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 no database , actually i need to very the contents of the table each time. Link to comment Share on other sites More sharing options...
water Posted June 29, 2013 Share Posted June 29, 2013 I searched the forum but didn't find a working solution. Can you manually copy and paste the content of the datatable to Excel or Notepad? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 Policy# Name Status 1 X Active 2 Y Inactive 3 Z Expired here is the similar kind of structure present in my table application, can i retrive this and write is a exce file? Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 Policy# Name Status 1 X Active 2 Y Inactive 3 Z Expired please follw this, ignore the above one Link to comment Share on other sites More sharing options...
water Posted June 29, 2013 Share Posted June 29, 2013 There are two possible solutions to your problem: Access the datatable control and extract the required data Haven't found a way yet. Might not be possible You copy/paste the content of the table to another application and then AutoIt process this data Have you tried to copy/paste the data from your application? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
deviprasad Posted June 29, 2013 Author Share Posted June 29, 2013 ControlGetData("Archive List", "", " [CLASS:DataTbl; INSTANCE:1]") this is not working and controlgetdata is not a valid one. first solution is not working,can we go ahead with solution 1 Link to comment Share on other sites More sharing options...
deviprasad Posted July 5, 2013 Author Share Posted July 5, 2013 Can any one got the solution for the above concern.Please do help.i stuck from that place Link to comment Share on other sites More sharing options...
deviprasad Posted July 9, 2013 Author Share Posted July 9, 2013 IS THERE ANY ALTERNATIVE OF DOING IT Link to comment Share on other sites More sharing options...
deviprasad Posted July 9, 2013 Author Share Posted July 9, 2013 THE ALTERNATIVE WAY OF DOIN IS TO GO FOR COORDINATES WILL DO THE ACTION, BUT I DO NT THINK IT WILL BE A BEST PRACTICE Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted July 9, 2013 Moderators Share Posted July 9, 2013 HOW ABOUT YOU NOT POST IN ALL CAPS Can you please post a screenshot of the policy application, to give us an idea of what you're seeing? That will help us help you. Blank out any sensitive data if you need to. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
deviprasad Posted July 12, 2013 Author Share Posted July 12, 2013 i have attached a data table of the application, which has mulitple records with the chek boxes. and the check boxes are also part of data table. which autoit spy not able to identify individually.do let me know how can i select a check box based on the my prameters. Link to comment Share on other sites More sharing options...
deviprasad Posted July 18, 2013 Author Share Posted July 18, 2013 Any updates? Link to comment Share on other sites More sharing options...
deviprasad Posted July 26, 2013 Author Share Posted July 26, 2013 Any updates guys Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now