Read excel data/links in javascript test complete
Hi team, I have tried to read the data file using javascript in test complete.But shows error as "Type error: cannot read the property 'SheetByTitle' of null" functionExcelRead() { varexcelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx"); varexcelSheet = excelFile.SheetByTitle("Sheet1"); varvalueA = excelSheet.Cell("A", 3).Value; varvalueB = excelSheet.Cell(2, 3).Value; varvalueC = excelSheet.CellByName("C3").Value; } Can any one help regarding this issue or I want to fetch the weblinks from excel file one by one that links need to execute. Thanks in advance.Solved5.3KViews0likes4CommentsShare NameMapping, scripts unit working with team
Hello, I was thinking about how best to reuse NameMapping and script with other projects, so that a change in one project reflects on another project. File jpg is attachment. So, only map objects at General Projects. Merge each NameMapping project at NameMapping from General Projects. Share generic scripts with others projects(I know it's possible, Script > Add > Existing Item). About control version at Team Foundation Version Control: If we are working with teams, is this the better way to share same objects in NameMapping and functions already created ? Is better way to reuse ? I didn't find something like that.Solved4.4KViews0likes10CommentsCopy and rename a file using JavaScript
Hello, I am trying to copy an xml file, and rename it so I can use it in my tests. Only I can't seem to figure out what I am doing wrong. I used the TestComplete documentation, as I got the code from there. I tried to modify it in different ways, but nu success. This is the code I currently have: aqFile.Copy("\\bs-international.nl\group\ICT\Applicatiebeheer\TestComplete\NewPackingTable xml files\NewPackingTable_BIT-ERP_Order.xml", "\\bs-international.nl\group\ICT\Applicatiebeheer\TestComplete\NewPackingTable xml files\NewPackingTable_BIT-ERP_Order-copy.xml"); function RenameXMLFile() { var OldPath = "\\bs-international.nl\group\ICT\Applicatiebeheer\TestComplete\NewPackingTable xml files\NewPackingTable_BIT-ERP_Order-copy.xml"; var NewPath = "\\bs-international.nl\group\ICT\Applicatiebeheer\TestComplete\NewPackingTable xml files\NewPackingTable_BIT-ERP_Order- "+ VarToStr(aqDateTime.Now())+ ".xml"; // Renames the file aqFileSystem.RenameFile(OldPath, NewPath); } I hope someone can help me get back on track.Solved4.2KViews0likes8Comments.exe file run in test execute
Hi, Is it possible to convert the project suite(with project scripts, keywords) into binary executable? And run in Test Execute Tool. Since, Test execute support file format -> .pjs and .mds. Does the Extensions(has installed with .net framework) will run .exe file? (Note: Test Execute providing .Net Framework->so, Can we run .exe file)Solved4KViews0likes14CommentsTestComplete JIRA Script Extension
Hi everyone, With the release of TestComplete 14.4, Smartbear has released a new JIRA script extension, so that we can use it in more ways than just the toolbar option that we see in our test logs. It can be downloaded in the Smartbear github link below, following the instructions as described in the readme file. This may be old news to alot of you by now as well. https://github.com/SmartBear/testcomplete-jira-extension I think this is a great step forward in creating some more elegant workflows with JIRA, which has sort of become the de facto issue tracking software for many agile organizations. We can see all of the methods that are available here within the docs page: https://support.smartbear.com/testcomplete/docs/reference/program-objects/jira/login.html With this new script extension, this means we can elegantly and automatically create new issues, and update old ones, possibly even using event handlers to update the relevant issues with more context like the visually pleasing mht files. Recently though, I came across a question of whether or not we could move resolution statuses (i.e backlog, selected for development, done, etc.) based on those same type of triggers (i.e onLogError, or conditionally based on logerrorcount). After a quick google search, it seems that jira workflow statuses aren't fields that can be set; they need to be transitioned. This meant that we couldnt use our new jira script extension, and the setField or setFieldJson methods to do just that. Thinking a little bit further about this, it makes sense, because why have a kanban board, unless we want to visually confirm some facts about our issues and physically move them across the various stages of development. Also, we probably don't want our issues to move drastically via automation (my worst nightmare would be waking up to 40 emails from JIRA telling me that all of my issues changed resolution statuses, and later find out that these moves were mistakenly triggered via a CI framework because of a bug in a one of the systems under test) The only way to "transition" the workflow statuses seems to be through accessing JIRA's api. There are certainly endpoints that do this for us. (along with some external libraries aka pip install jira) But as for whether or not we should be doing that? I dont know. ----and now moving this to our tc ide3.2KViews2likes5CommentsBoost TestComplete code autoCompletion
Has anyone ever tried to write their intellisense plug-in for e.g. WebStorm with TestComplete interface structure? or vice versa through "script extension" and their available code completion read files and create a 'better' intellisense than it is now in TestComplete IDE? Additional question. Have you encountered somewhere in the files or in the online sources with the object interface declaration currently available in the Intellisense TestComplete IDE?Solved2.9KViews3likes7CommentsExtension - Using combo in Operation parameter
HOw to put a comboboxin Operation parameter with pre defined value? I'm familiar how to setup a parameter on xml but i dont know how to make it combo with a value, a sample is the Log which have a "Priority" parameters with a predefine selection of value in cmobo.2.8KViews0likes7CommentsPython 3.7 support
We internally have produced a product that has a Python library based on 3.7.3 (all dlls are compiled aginst 3.7.3) I've been struggling taking my standlone Python 3.7.3 scripts to work in Test Complete. After banging my head against a brick wall I found out that installing python 3.6 locally causes the same issue.. Hence TestComplete does not work. So I'm after a TestComplete Python 3.7 update... ie. replacement of the 'aqPyScript36.dll' and Python36 folder. (TestComplete included python3.6 was complied in 2016!!) can anyone help.?Solved2.7KViews0likes5CommentsWPF Automation peers
Hi, What do I need to do for Test Complete to be able to recognize WPF objects's automation peer id/name? If that is not possible. Is there any way to write a custom script that would extract the WPF automation peer id and make it accessible to Test Complete (for object mapping purposes)? References: https://msdn.microsoft.com/en-us/library/ms747327(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/cc165614(v=vs.110).aspx More Details: I have the UI Automation plugin enabled and my list of accepted windows is *(all), DirectUIHWND, Windows.UI.Core.CoreWindow This allows me to see the UI Automation properties of the main window ONLY, not the buttons. ..but the XAML does have Automation properties for the buttons: <Button x:Name="Test_B" Content="Test B" AutomationProperties.AutomationId="Test A ID" AutomationProperties.Name="Test A Name" HorizontalAlignment="Left" Margin="214,161,0,0" VerticalAlignment="Top" Width="75"/> Am I in the right track here?2.6KViews0likes4CommentsHow to change cursor to hourglass from a TestComplete Extension
I wrote a TestComplete extension to update Keyword-Test signature from TestComplete in to an external tool. However, this action takes very long time. That's why I need to change the cursor from arrow to hourglass, and back to arrow after action is done. (Using a try-catch-finaly, of course.) The module doing the opperation is writen in js. However, my script extension contains vbs modules too and methods, I can successfully call from the js module. If I try to use the following code, suggested by TestComplete code completition in the vbs module: Win32API.SetCursor(Win32API.IDC_WAIT); I got the error "Object expected". I.e., the TestComplete extension does not know About Win32API object, despite the code completition suggestion, and despite the correct installation and activation of the win32api extension. (checked via File | Install extensions) Ommiting the Win32API. prefix has similar effect. I did not found any aq*.* methods allowing changing the cursor. SmartBears description on writing extentions seems to contain no hint about changing the cursor in a ScriptExtension. Please appologize, if I overlook it. (PS: I am using an old TestComplete 10.60x Version; however, I guess, this is not the Point.) Any suggestions are appreciated. Thanx in advice for your F1!Solved2.3KViews0likes6Comments