Poida
Occasional Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Scraping data from a desktop application
Try having a look in the Object Browser while you have the executable running. You should be able to browse it's object model and have a look at whether the values you're looking for are available to TC. That's where I'd start. Once you find it you can right click and make an alias for it then address it in code as Aliases.Blah.Blah.blah.StuffImLookingFor2.9KViews1like0CommentsRe: Testing Destination of Windows Shortcut lnk in Start Menu Win7x64
Thanks for the tips Robert. This is what I ended up with in case anyone else is looking for this later, in javascript function Test_SCExists_GetSCPath() { if (!IsShortcutValid("Programs|Accessories|Paint", "|")) { Log.Error("Shortcut is not valid"); return; } Log.Message("Shortcut is valid"); var target = GetShortcutTarget("Programs|Accessories|Paint", "|"); if (!target) { Log.Error("Shortcut doesn't exist"); return; } Log.Message(target); } function IsShortcutValid(shortcutPath, separator) { var StartDir, path, shortcut; StartDir = "C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; if (aqFileSystem.Exists(StartDir + path)) { shortcut = WshShell.CreateShortcut(StartDir + path); return aqFileSystem.Exists(shortcut.TargetPath); } return false; } function GetShortcutTarget(shortcutPath, separator) { var StartDir, path, shortcut; StartDir = "C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; if (aqFileSystem.Exists(StartDir + path)) { shortcut = WshShell.CreateShortcut(StartDir + path); return shortcut.TargetPath; } return false; }1.2KViews1like0CommentsTesting Destination of Windows Shortcut lnk in Start Menu Win7x64
Hi, I'm trying to get this JScript from https://support.smartbear.com/viewarticle/8967/ working in TestComplete 12.6 on Win7x64. It's to verify the target value of the shortcut (what it's trying to run). This script is throwing an error: JavaScript runtime error ReferenceError: ActiveXObject is not defined Error location: Unit "script unit name" Line 14 Column 18 { if (!IsShortcutValid("Programs|Accessories|Paint", "|")) { Log.Error("Shortcut is not valid"); return; } Log.Message("Shortcut is valid"); } function IsShortcutValid(shortcutPath, separator) { var WshShell, fso, startDir, allUsersStartDir, path, shortcut; WshShell = new ActiveXObject("WScript.Shell"); startDir = WshShell.SpecialFolders("StartMenu") + "\\"; allUsersStartDir = WshShell.SpecialFolders("AllUsersStartMenu") + "\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; fso = new ActiveXObject("Scripting.FileSystemObject"); if (fso.FileExists(startDir + path)) { shortcut = WshShell.CreateShortcut(startDir + path); return fso.FileExists(shortcut.TargetPath); } if (fso.FileExists(allUsersStartDir + path)) { shortcut = WshShell.CreateShortcut(allUsersStartDir + path); return fso.FileExists(shortcut.TargetPath); } return false; } Any advice greatly appreciated. PeteSolved1.3KViews0likes2CommentsRe: Find and Replace with Regular Expression in Script using Javascript
Thanks tristaanogre, that tipped me off. Needed the gi switch at the end to work and it was using the javascript re syntax not the native testcomplete one. Below is the working code. function UseRegex() { var regex = /\s+/gi; var Instr = " Words with too much space |"; var ResStr = Instr.replace(regex," "); Log.Message(ResStr); }2.2KViews2likes0CommentsFind and Replace with Regular Expression in Script using Javascript
Hi, i'm having trouble with doing a find and replace using regex on a string in a script using Javascript. The idea is to get rid of all multiple consecutive white space characters in the string and leave only single spaces in their place .... so.... | this has too much | would become | this has too much | My plan was to just locate anywhere where there's 2 or more whitespaces and replace them with a single whitespace. I couldn't figure out the {2,} style to say 2 or more then I got tangled up and now I'm here. Below is test code to demonstrate: var regEx; var ResStr = ""; var Instr = " Words with too much space |"; regex = "\b+"; ResStr = Instr.replace(regEx,' '); BuiltIn.ShowMessage(ResStr); The result is an unaltered string. The goggles.... they do nothing... Any tips on where I'm going wrong? Pete :)Solved2.2KViews0likes3CommentsDatabase Checkpoint For MS Access 2016 Database
I'm attempting to create a Database Checkpoint in a TestComplete test. The database is an MS Access 2016 accdb file and I'm running on Win7x64 as an unprivileged user on the corporate domain. In the first dialog (yes, i hit the deck and slid on my face at the first prompt) it prompts for a connection string. I am feeding it: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SharedData\AccessDatabase.accdb;Persist Security Info=False; and getting error: Unable to connect to the specified data source. The database engine reports: Provider cannot be found. It may not be properly installed. I've had a bit of a dig around online but couldn't find the answer. Any tips guys?Solved1.5KViews0likes3Comments