Vec84
Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Keyword Test Parameters Issue.
I don't believe there is a way to update them all at once and it is an issue I came across when using parameters. I had some really good advice from Rob in the attached post which he mentioned using properties instead in a object oriented way in which you can add properties without needing to update all the functions that use it. https://community.smartbear.com/t5/TestComplete-General-Discussions/Using-Properties-instead-of-Params/m-p/1408321.3KViews2likes0CommentsRe: TestExecute 12 is still working in VM?
Do you have issues running tests or installing it on to a VM? If it's running tests then you might want to uncheck the module the modules that you don't have as This can sometimes cause problems in tests. If you right click on testexecute in the VM, select Install Extensions and un-tick the modules you don't have, like web, mobile or desktop.1KViews0likes0CommentsPassing a Test within a folder
In my script I append a folder everytime it loops the function. Some folders pass and some fail however it never shows green on the ones that pass. The folder that pass just show the speech bubble with the "i" in it. Is there a way to show these folders as passing.Solved2.1KViews0likes3CommentsParsing a htm file
I am trying to obtain text from an email body in Outlook 2007. The text is within cells within the body. So I have saved the email as a htm file and I have tried to work with it by parsing it with the online example however i can't seem to get it to work with a file. Is there a better way to get this informatiom from an email? Or is it a different way to parse htm files. I have tried exporting the email to csv and it puts all the body in one cell which makes it difficult to work with. The email is from an online form with questions which I need to obtain the answers from the certain questions.620Views0likes0CommentsRe: Store data in an object in script (Jscript)
The answer showed different on my emails so i guess you edited the response sorry. Would i be able to create a multi-dimensional Array to save the data, i couldn't find this on the Msdn site. Even so, i could just add a project table variable and add columns and rows every time and then write them out to excel after.2.6KViews0likes1CommentRe: Store data in an object in script (Jscript)
Hello Robert, Thanks for the your reply. One of our developers mentioned a data table object however i couldn't find one in the jscript language. I didn't even think of adding it to a Table Variable. You save the day again...Not all hero's wear capes :smileyvery-happy:2.6KViews0likes0CommentsStore data in an object in script (Jscript)
Hello, I have a function that writes in to excel with certain results i obtain from the test i am running. After every loop of the data driven test this excel function is called and writes to the worksheet. This isn't very efficient and sometimes causes errors due to the amount of times it is called. I would like to store the results into an object and then write them out to excel once the data loop has been completed(Sample of my function) function WriteDataToExcel(fname, sheetName,testTime, errorCount, warnCount){ var app = Sys.OleObject("Excel.Application"); var book = app.Workbooks.Open(fname); var sheet = book.Sheets.Item(sheetName); var rowCount = sheet.UsedRange.Rows.Count+1; var columnCount = sheet.UsedRange.Columns.Count; var Logs; var Count; // Obtains the object that holds the list of project logs Logs = Project.Logs; Count = Logs.LogItemsCount; var TestResult = Logs.LogItem(Count-1).Status; switch (TestResult) //previously it is like Status which is undefined { case 0: TestResult = "Passed" break; case 1: TestResult = "Warnings" break; case 2: TestResult = "Failed" break; default : TestResult = "Error" break; } var arrayLogData = [aqConvert.DateTimeToFormatStr(aqDateTime.Now(), "%d/%m/%y %H:%M"), Logs.LogItem(Count-1).Name, TestResult, testTime, errorCount, warnCount] // When you need to add additional data, just add the new element here sheet.Range("A" + rowCount).Value = alignData(arrayLogData[0]); sheet.Range("B" + rowCount).Value = alignData(arrayLogData[1]); sheet.Range("C" + rowCount).Value = alignData(arrayLogData[2]); sheet.Range("D" + rowCount).Value = alignData(arrayLogData[3]); sheet.Range("E" + rowCount).Value = alignData(arrayLogData[4]); sheet.Range("F" + rowCount).Value = alignData(arrayLogData[5]); // If you want add more columns then you can add like below //sheet.Range("G" + inputRow).Value = alignData(arrayLogData[6]); book.Save(); app.Quit(); }Solved2.7KViews0likes7Comments