Issue using Excel and variables in name mapping
I am using variables in name mapping objects to pull data from an Excel sheet and then verify with Property Checkpoints. It is working fine for the first 3 rows in my sheet. But on the fourth row I am getting an error for the address. The previous 3 addresses worked fine. The local variable was updated and checkpoint passed. Also the first four checkpoints for this fourth row of data worked fine, it just fails on the address. I cannot figure out why this fourth one is failing. Any ideas? Lots of info/screenshots below that will hopefully help. Name Mapping object using variable: Project level variable: Excel sheet with address data: function ReadManifestData() { // Get the sheet of the Excel file var excelFile = Excel.Open(Project.ConfigPath + "Datasheet.xlsx"); var excelSheet = excelFile.SheetByTitle("ViewData"); // Read data from the Excel file var RowIndex = KeywordTests.CheckManifestScreen.Variables.RowIndex_KW; var Order_Num = excelSheet.Cell("A", RowIndex).Value; var HIN_Num = excelSheet.Cell("B", RowIndex).Value; var TrackNum = excelSheet.Cell("C", RowIndex).Value; var Forecasted = excelSheet.Cell("D", RowIndex).Value; var Street_Addr = excelSheet.Cell("E", RowIndex).Value; var ServiceLevel = excelSheet.Cell("F", RowIndex).Value; var Commit_Time = excelSheet.Cell("G", RowIndex).Value; var Cons_Name = excelSheet.Cell("H", RowIndex).Value; var Floor_Num = excelSheet.Cell("I", RowIndex).Value; var Postal_Code = excelSheet.Cell("J", RowIndex).Value; var City_Name = excelSheet.Cell("K", RowIndex).Value; var State_Name = excelSheet.Cell("L", RowIndex).Value; var Country_Code = excelSheet.Cell("M", RowIndex).Value; var Urbanization = excelSheet.Cell("N", RowIndex).Value; Project.Variables.Order_Num_KW = Order_Num; Project.Variables.HIN_Num_KW = HIN_Num; Project.Variables.TrackNum_KW = TrackNum; Project.Variables.Forecasted_KW = Forecasted; Project.Variables.StreetAddr_KW = Street_Addr; Project.Variables.ServiceLevel_KW = ServiceLevel; Project.Variables.Commit_Time_KW = Commit_Time; Project.Variables.ConsName_KW = Cons_Name; Project.Variables.Floor_Num_KW = Floor_Num; Project.Variables.Postal_Code_KW = Postal_Code; Project.Variables.City_Name_KW = City_Name; Project.Variables.State_Name_KW = State_Name; Project.Variables.Country_Code_KW = Country_Code; Project.Variables.Urbanization_KW = Urbanization; } Keyword test: Log:
Name Mapping not working on remote browser
The name mapping and test cases work fine on local browsers, but would complain about page or object not found when running headless remote browsers and in parallel testing. I have the following setup for browser name mapping: For headless setup I have: server = "localhost" capabilities = { "browserName": "chrome", "headless" : "true", "screenResolution": "1920x1080", "platform" : "Headless", "record_video": "true" } Browsers.RemoteItem[server, capabilities].Run(url) Is this the correct way to work with name mapping on headless browser?
KeywordTests - Setting Random Name
Brand new to using testcomplete and I don't have coding experience. I have a lastname field in my application and I want to record a test that will generate a random name. I've used the Generate Data wizard to create a LastNameVar and FirstNameVar in my project. I then select those for the value where I'm trying to pass them in to my application. However, when I reach that step, nothing is passed, and I receive an exception stating 'A row index must be an integer value'. Not sure what I'm doing wrong. Suggestions?Change the OS region format all at once
Hi all, is there a way to change the regional setting so that we change the format based on a given format such as French-France ('fr-FR') : I saw that i can use the script to change the SetLocaleInfo to change each properties one by one, but i would prefer to use the Format pre-set settings to tests. Thank you.
(JavaScript) Unable to get value(s) from TableVariable passed to a function
Hi folks, I want to pass a Table Variable to my custom function and obtain value from defined row number and column name. At first, I tried to follow the sample code from TC User Guide: https://support.smartbear.com/testcomplete/docs/reference/program-objects/tablevariable/index.html But the sample fails at Iterator.Reset(); line with "cannot read property" error... But the problem seems to be at previous line MyIterator = MyVar.Iterator; which does not return Iterator object, although the MyVar successfully loads Table variable "steps". I also renamed the Iterator variable to MyIterator, just to make sure it does not interfere with Iterator property, but no luck either. Does anyone have an idea what's wrong? Is there something missing, the sample code is obsolete or I found a bug? Thank you in advance. BTW, is there a way to get the value from table variable via column name/row index?How to keep date from excel in the same format
I am currently setting a date in excel and extracting that date to be used as a variable. I need the variable to be displayed in the format DD/MM/YY so in excel I have formatted the cell so it displays that way e.g. 06/02/24. However when testcomplete gets the data from the excel cell it sets the variable in the format DD/MM/YYYY e.g. 06/02/2024 How can I get it to keep the data exactly how it's being displayed in excel? ThanksHow to increment a variable value when using Genarte Data to test
I am trying to create a test scenario for creating a new account. Whenever I run the test case I want to use a new name value for the account I create, so I am using Generate data and use the Name option and first name. Still, whenever I run the test, it only shows the 1st name in that column; when I run the test 2nd or 3rd time, it uses the same name every time. can anyone help me with this issue, I don't know programming or how to use VB script or Java script. appreciate your help and support. thanks, Gill
