Ravik
Super Contributor
Joined 13 years ago
User Profile
User Widgets
Contributions
How to put message in MQ using TestComplete and VBScript?
How to put message in MQ using TestComplete and VBScript? Hi All, I wanted to automate a process "put message in MQ using TestComplete and VBScript" , I have followed the couple of links but , mostly related to SOUP UI. following are the links - https://support.smartbear.com/readyapi/docs/testing/jms/providers/websphere.html and https://community.microfocus.com/t5/Quality-Center-ALM-User/Connection-Of-QTP-to-IBM-Websphere-MQ-using-VbScript/td-p/1129561 any Step by Step process is available for TESTCOMPLETE and MQ, please share so using VBScript and TestCompleteSolvedRe: TestComplete: object spy should have "XPath" property for web page
It is nice to have kind of feature. It will help for automating Web based application or if integrate selenium code in TestComplete. Mostly in selenium we are using XPath and if we will get xpath in object spy, it will great help.4.6KViews0likes0CommentsTestComplete: object spy should have "XPath" property for web page
Hi Team, I am requesting TestComplete: object spy should have "XPath" property for web page. Most of the organization has limited browser access (can't use Firefox or chrome browser in our organization - can't use any third party control for identify the XPath expression for an object) we are using only IE browser and its very dificult to identify the xpath in IE (Complex or relative xpath) even a simple xpath too. I am requesting, In testcomplete OBJECT SPY window should have a "XPATH" property and it should provied the atleast basic and uniuqe XPath expression for web object and that "XPath" we can use in 'FindChildByXPath()' and 'EvaluateXPath()' method. It would be easy and very benificial for us.4.8KViews0likes5CommentsPython Version support: for TestComplete
Hi All, As we know, we have 2 major version of Python- 2.x and 3.x. I have installed 2.x version in my system for the other purpose (need of the project) I think python3.0 is get installed in TestComplete by default.hence several time get the conflict errors . How we can handled multiple version in system or how we can specified to TC to pick the modules or libraries from give path only.1.4KViews0likes1CommentRe: I have a Excel name "CCP_MARGIN_2017-09-11_risk_cpm_stg.xlsx" in C drive. I am reading it and using
You mean to say that on the basis of Date you want open sheet and wants to perform the operation !!! If it is then we can parameterize the date string. Please give the more input on it.2KViews0likes0CommentsRe: I have a Excel name "CCP_MARGIN_2017-09-11_risk_cpm_stg.xlsx" in C drive. I am reading it and using
Hi, are u sure about your file name, I had this type of problem when my file name or sheetname cross length (~36 char) . I am using "openpyxl " module to work with Excel file and I found its really helpful and compatible with excel- here are the sample, may help you #--------------------------------------------------------------------------- import openpyxl def openmyExcel(): workbookObj = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx") worksheetobj = workbookObj.get_sheet_by_name('Sheet1') rowcout = worksheetobj.max_row colCount = worksheetobj.max_column Log.Message(rowcout) Log.Message(colCount) #----------------------------------------------------------------------------- def readCellData(): workbookobj = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx") worksheetObj = workbookobj.get_sheet_by_name("Sheet1") rowcount = worksheetObj.max_row colcount = worksheetObj.max_column for introw in range(1,rowcount): celldata = worksheetObj.cell(row = introw ,column =1).value Log.Message(celldata) #----------------------------------------------------------------------------- def readAlldatainExcel(): wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx") wso = wbo.get_sheet_by_name("Sheet1") intAllRow = wso.max_row intAllCol = wso.max_column for introw in range(1, intAllRow): for intcol in range(1,intAllCol): mydata= wso.cell(row= introw, column = intcol).value #Log.Message(mydata) if (mydata == None): break Log.Message(mydata) #---------------------------------------------------------------------------------- def writeinExcel(): wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx") wso = wbo.get_sheet_by_name("Sheet1") intAllRow = wso.max_row intAllCol = wso.max_column for introw in range(1, intAllRow): for intcol in range(1,intAllCol): wso['A1'] = introw mydata= wso.cell(row= introw, column = intcol).value Log.Message(mydata) if (mydata == None): break Log.Message(mydata) #---------------------------------------------------------------------------------- def getSheetName(): wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx") wso = wbo.get_sheet_names() for shname in wso: Log.Message(shname)2KViews1like2Comments