Contributions
Get keywordTest results from Project logs
I need to get the results of each keywordtest executed in the specific project. So i could update my test coverage via API function I added at the end of the project in a script. I do not need any details, only if OK / Failed. I included an image of the "TestItems" tab of one of my projects, that demonstrates the structure of my projects test items. Best regards, Anastasios Kalogeropoulos1.4KViews0likes2CommentsPassing an array as function parameters from KeyWordTest?
Hi all, I created a function to find a single objecton vue from a webpage. If i call the function from script ex: "tblObject = findObject(["ObjectType","innerHTML"],["Table","*ckColumn*"],null);", it work perfectly but ièm not able to make it work when I call it from a keywordTest. I included the code of the function. I also included an screen capture of the parameters window from KeywordTest. Best reagrds, Anastasios function findObject(mType,mFieldName,mObject) { var myObject; var depth = 10; Sys.Refresh(); if(mObject == null) { mObject = Sys.Browser("iexplore").Page(getURL()); depth = 20; } myObject = mObject.Find(mType,mFieldName,depth,false); if(myObject.Exists == true) { return myObject; } else { Log.Message("The object with the " + myFieldName + " parameters was not found"); return null; } CollectGarbage(); }Solved2.5KViews0likes4CommentsError code "530 5.7.1 Client was not authenticated" sending email.
I'm getting the erreur code "530 5.7.1 Client was not authenticated" when i try to send an email. I was working before but since IT has update the email server it stop working. They provide me with username and password to use in my code but it still does not work. Code: function SendEmail(mFrom, mTo, mSubject, mBody, mAttach) { var i, schema, mConfig, mMessage; try { schema = "http://schemas.microsoft.com/cdo/configuration/"; mConfig = Sys.OleObject("CDO.Configuration"); mConfig.Fields.Item(schema + "sendusing") = 2; // cdoSendUsingPort mConfig.Fields.Item(schema + "smtpserver") = "ServerName"; // SMTP server mConfig.Fields.Item(schema + "smtpserverport") = 25; // Port number mConfig.Fields.Item(schema + "smtpauthenticate") = 0; // Authentication mechanism mConfig.Fields.Item(schema + "sendusername") = Username; // User name (if needed) mConfig.Fields.Item(schema + "sendpassword") = Password; // User password (if needed) mConfig.Fields.Update(); mMessage = Sys.OleObject("CDO.Message"); mMessage.Configuration = mConfig; mMessage.From = mFrom; mMessage.To = mTo; mMessage.Subject = mSubject; mMessage.HTMLBody = mBody; if(mAttach != "") { aqString.ListSeparator = ","; for(i = 0; i < aqString.GetListLength(mAttach); i++) mMessage.AddAttachment(aqString.GetListItem(mAttach, i)); } mMessage.Send(); } catch (exception) { Log.Error("E-mail cannot be sent", exception.description); CollectGarbage(); return false; } Log.Message("Message to <" + mTo + "> was successfully sent"); CollectGarbage(); return true; Best regards, Anastasios.1.9KViews0likes1CommentConnect to SQL Server via ADO object
I'm trying to connect SQL database using the ADO object. Everything installed on same machine, TC(v10.60), SQL Express 2014. I'm getting the followingerror message. Named Pipes Provider: Could not open a connection to SQL Server [53] function checkDatabse() { var AConnection; AConnection = ADO.CreateADOConnection(); AConnection.ConnectionString = "Provider=SQLNCLI11;Server=myserver\SQLEXPRESS;Database=MyDatabase;Uid=User;Pwd=password;"; AConnection.LoginPrompt = false; try { AConnection.Open(); Log.Message("Database Opened") } catch(e) { Log.Message(e.message) } } Best regards, Anastasios Kalogeropoulos939Views0likes2CommentsUnexpected character in query string while parsing in XML 4.0
I need to extract certain information and compile it into an email. Then send when all the tests are done. I serach and found this bit of code onSmartbear community. When I execute the code, i get the following error message: Unexpected character in query string. Nodes/Node[@na--><--me="root"]/Prp[@name="warning count"]/@value Here is my code in JScript: function getInformationData() { //var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\" + Math.floor(Math.random() * 10000) + "\\"; var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\testXML\\"; aqFileSystem.CreateFolder(tempFolder); Log.SaveResultsAs(tempFolder, lsXML); var xDoc = Sys.OleObject("MSXML2.DOMDocument.4.0"); xDoc.load(tempFolder + "Description.tcLog"); Log.Message(xDoc.xml); // Warning count var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning count"]/@value').text); //var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning test count"]/@value').text); //Error count var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error count"]/@value').text); //var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error test count"]/@value').text); //Execution time var startTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="start time"]/@value').text); var stopTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="stop time"]/@value').text); aqFileSystem.DeleteFolder(tempFolder, true); var res = "Errors: " + errC + "\r\n" + "Warnings: " + wrnC + "\r\n" + "Start Time: " + DateTimeToStr(startTime) + "\r\n" + "Stop Time: " + DateTimeToStr(stopTime) + "\r\n" + "Run Time: " + aqConvert.DateTimeToFormatStr(stopTime - startTime, "%H:%M:%S"); Log.Message(res); //return res; } I also included a screen capture of the error message: Best regards, Anastasios Kalogeropoulos962Views0likes0CommentsUnexpected character in query string in msxml4.dll
I copie the code I found in the smartbear community. Everytime I execute the keywordtest and then i run the function "getInformationData()", so i could retrieve warning /error count and the time it took to execute the test. Error message: Unexpected character in query string. Nodes/Node[@na--><--me="root"]/Prp[@name="warning count"]/@value Here is the codeJScript : function getInformationData() { //var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\" + Math.floor(Math.random() * 10000) + "\\"; var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\testXML\\"; aqFileSystem.CreateFolder(tempFolder); Log.SaveResultsAs(tempFolder, lsXML); var xDoc = Sys.OleObject("MSXML2.DOMDocument.4.0"); xDoc.load(tempFolder + "Description.tcLog"); Log.Message(xDoc.xml); // Warning count var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning count"]/@value').text); //var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning test count"]/@value').text); //Error count var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error count"]/@value').text); //var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error test count"]/@value').text); //Execution time var startTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="start time"]/@value').text); var stopTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="stop time"]/@value').text); aqFileSystem.DeleteFolder(tempFolder, true); var res = "Errors: " + errC + "\r\n" + "Warnings: " + wrnC + "\r\n" + "Start Time: " + DateTimeToStr(startTime) + "\r\n" + "Stop Time: " + DateTimeToStr(stopTime) + "\r\n" + "Run Time: " + aqConvert.DateTimeToFormatStr(stopTime - startTime, "%H:%M:%S"); Log.Message(res); //return res; Best reagrds, Anastasios Kalogeropoulos601Views0likes0CommentsRe: TestComplete 10.6 - Problems with parameters in Run Keyword Test
The link you provided does not work. WhenI click on TestComplete, it directs me to another page that displays "http://smartbear.force.com/License is under construction". I'm not able to request the patch. Best regards, Anastasios Kalogeropoulos4.8KViews0likes1Comment