Contributions
changes in some control of application, how to manage existing script
Hi If there are some changes in the application control: Say, 1. Change in the name of control 2. Change in some properties like size of the control 3. Replacing the control with some other 3rd party control (say dropdown from 3rd party A was in used when scripting was done. now we replace it with dropdown from 3rd part B) 4. Some other changes which you can think of How to manage the existing code in each of these scenarios? In case of scenario1 we can uses Aliases and just edit the alias statement (to edit the name) to make the replay work as earlier right? What about other scenarios? Do we need to re-record the script? Please also list other changes in UI which might usually occur and also let me know what is the solution in those cases? Please reply ASAP. Thanks, Laxmi9.4KViews0likes1CommentObject Mapping
Hi, I have a 'DevComponents.DotNetBar.TabStrip' control in my application. I tried recorded this control and noticed that the tabs are identified as pixels in strip and not by their names. I opened Edit->Properties of project and in Object mapping, i have added this class to Win32 controls. Then i tried recording again. But still i see that its being recorded as pixels. Does Object mapping not support mapping this way and treat this control similar to Win32 tab control and record by tab names? Please reply. Thanks, Laxmi16KViews0likes2Comments- 2.5KViews0likes0Comments
Re: cant find the item in Object Browser
Regarding Query 1, This problem is found with Combo Boxes, Menus and Context Menus. My concern is that: Many times in our application, the contents of the Combo Boxes keep changing depending on other settings. Say initially Combo box A has items one, two, three, four and in same order. And say i have recorded this combo box and chose item 'two'. Next time because of some settings, the items can be one, three, two,five, six, four and in same order in Combo Box A. Now will the replay be a success by chosing the item 'two' again? Please clear me on this. Thanks, Laxmi2.1KViews0likes0CommentsRe: Read and Write Data into Excel
Hi, The code, Set objRange2 = objDriverSheet.Range(”B1″) just fetches data from the cell B1, i.e. a single cell. However if we try to modify the same into something like dim arrayA(10) Set arrayA(10) = objDriverSheet.Range(”B1:B10") ' reading a range of data or Set arrayA(10) = objDriverSheet.Range(”RangeName1″) ' reading a named range and which has 10 cells Log.Message arrayA(0) The script runs successfully but always returns 0. Please let me know the exact code to read these ranges. Also please let me know a way to read from excel documents in our application as i have specified in my earlier post. Thanks, Laxmi2.5KViews0likes0CommentsRe: Read and Write Data into Excel
Hi Jared, Query1: I have found this code by searching online. But this code opens an excel from a specific path, here d:\B.xlsx Sub WriteDataIntoExcel set objexcel = createobject("excel.application") Set objWorkbook = objExcel.WorkBooks.Open("d:\B.xlsx") Set objDriverSheet = objWorkbook.Worksheets("Sheet2") Delay 3000 ' Wait until Excel starts objDriverSheet.cells(2,3) = 45 End Sub But in our application we dont deal with already existing excels in the system in some path. Instead we create an excel by populating it with data from the database when user tries to open the a document by clicking in the application. So i am trying to find out if it is possible to attach an already opened excel to this code and try to read\write data from that excel using the code. Please let me know if this can be done. Query2: Also we work with named ranges in excel. But i am not able to modify this code to work with either a named range or with range of data like A1:A10. So please send me code which would be able to read and write data from named ranges and range of data. We are searching for an appropriate testing tool for our application. If Test Complete satisfies our requirements, we would buy some licenses. Please help me with my queries. There is one more which i raised - Title : cant find the item in Object Browser. Please respond to that as well. Thanks, Laxmi2.5KViews0likes0Commentscant find the item in Object Browser
Hi, Request 1: I am using the trial version of 7.50 to see if it suits our application. I have been facing a problem with some controls I have tested so far. Dropdowns: I have recorded some actions over few dropdowns and noticed that I can find the dropdown in object tree (in Object Browser).. But I am not able to trace out where I can find the item I chose in the dropdown in the object tree. Eg: Dropdown ‘Languages’ has options ‘VB Script’, ‘C++’ and ‘C#’ When I record choosing of VB Script in application and go to object tree I can find the object Dropdown ‘Languages’, but don’t find these 3 items anywhere in the tree I even tried ‘Object Properties window’. Using this, I tried viewing the properties of item in dropdown , ‘VB Script’. And then tried to click on ‘Highlight Object in Object Tree’, but it’s not able to highlight anything in Object Tree. Same is the case with context menu items and few other controls. I am not able to find them in object tree. If I can’t see them in object tree, how can I handle when there are changes in UI and if I have to remap the objects. These both are getting recorded something like this : Set nonLogicalAdornerDecorator = telerik_Windows_Examples.HwndSource_PopupRoot.PopupRoot.Decorator.NonLogicalAdornerDecorator Set radComboBoxItem = nonLogicalAdornerDecorator.RadComboBoxItem1 Call radComboBoxItem.Click(170, 18) Call stackPanel.RadComboBox2.Click(332, 13) Call radComboBoxItem.Click(152, 12) Call stackPanel.RadComboBox3.Click(271, 12) Call nonLogicalAdornerDecorator.RadComboBoxItem2.Click(139, 10) Call stackPanel.RadComboBox4.Click(334, 2) Call nonLogicalAdornerDecorator.RadComboBoxItem.Click(155, 28) Request 2: Please let me know the procedure to do remapping of objects in case of UI changes. Please reply me ASAP. Thanks & Regards, Laxmi.17KViews0likes6CommentsRead and Write Data into Excel
Hi, In our application, we open some excel documents from data base and read\write data into that excel document and perform some calculations. When i try to record excel document, i see that individual cells in the excel are not recorded and instead pixel positions are recorded. Is there some way to read and write data into excel which is already opened. I found some code for reading data from Excel, but it specified the path where excel is present. But it may not help us as we dont have excel's stored in the machine. We fetch them from DataBase. Please help me find a way to do this. Thanks in advance, Laxmi.20KViews0likes6Comments