$$Excel-Macros$$ Re: QC results update tool
Hi Nevin, I am also looking for similar solutions, please let me know if you have figured out the solution of uploading test result from excel to Quality Centre. Thanks, Tushar On Wednesday, November 7, 2012 10:28:45 AM UTC+11, Nevin wrote: > > Hi Friends, > > Did you guys find time to look into my Question.I tried a lot but was > unsucessfull today. > > Below code is what we used for connecting quality center with no > sucess.This code might work for QUality center 10. > > But in HP ALM(Quality center 11) methodologoy is slightly different after > entering user name,password we need to click on the "authenticate button" > then we need to select domain,Project and then click on the Login button. > > It failes wehn we used the connect method (QCcon.Connect "Domain", > "Project").Iam suspecting it has to do something with the authentication > button > > Please suggest me. > > Sub CreateConnection() > Dim qcUser As String > Dim qcPassword As String > Dim qcDomain As String > Dim qcProject As String > Dim qcHostName As String > qcUser = "Username" > qcPassword = "Password" > qcDomain = DomainName > qcProject = "ProjectName" > Set QCcon = CreateObject("TDApiOle80.TDConnection") > QCcon.InitConnectionEx "HP ALM url" > QCcon.Login "UserName", "Password" > QCcon.Connect "Domain", "Project" > MsgBox "connection established" > End Sub > > On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: > >> Hi Friends, >> >> Iam not able to find the right kind of code which is used to connect >> QC test lab folder using macros.Objective is to update around 1200 tc >> using macros. >> >> It would be great if somebody is guiding me and iam very new to using >> macros.. >> >> Regards >> > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: QC results update tool
Hi Friends, Did you guys find time to look into my Question.I tried a lot but was unsucessfull today. Below code is what we used for connecting quality center with no sucess.This code might work for QUality center 10. But in HP ALM(Quality center 11) methodologoy is slightly different after entering user name,password we need to click on the "authenticate button" then we need to select domain,Project and then click on the Login button. It failes wehn we used the connect method (QCcon.Connect "Domain", "Project").Iam suspecting it has to do something with the authentication button Please suggest me. Sub CreateConnection() Dim qcUser As String Dim qcPassword As String Dim qcDomain As String Dim qcProject As String Dim qcHostName As String qcUser = "Username" qcPassword = "Password" qcDomain = DomainName qcProject = "ProjectName" Set QCcon = CreateObject("TDApiOle80.TDConnection") QCcon.InitConnectionEx "HP ALM url" QCcon.Login "UserName", "Password" QCcon.Connect "Domain", "Project" MsgBox "connection established" End Sub On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: > Hi Friends, > > Iam not able to find the right kind of code which is used to connect > QC test lab folder using macros.Objective is to update around 1200 tc > using macros. > > It would be great if somebody is guiding me and iam very new to using > macros.. > > Regards > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: QC results update tool
Hi David, Thanks for your intrest in helping me. Iam using Quality center 11(HP ALM).I have Adminstrator access so i will be able to modify create/Delete folder structures in front end. But i wont be able to alter using queries in the query builder.No i have not tried asking in HP forums. Regards Nevin On Sun, Nov 4, 2012 at 5:31 PM, David Grugeon wrote: > Hi Nevin > > I have been following this discussion and wondering how we can get the > information necessary to help you. > > Is the software you call QC the HP Quality Center software? > > If not what is it? > > Do you know any way to connect Excel with it manually? If so how do you do > it? > > If you can connect is this a read-only connection or can you alter the QC > database? > > If you want to mark a test as passed or failed in QC how do you do it? > > Please include in your answer all connection strings, file addresses, web > addresses, and screen prints as relevant. > > Have you tried asking your question opn the QC forum? What response did you > get? > > > Regards > David Grugeon > > > > On 5 November 2012 08:08, Nevin wrote: >> >> Hi Paul/Rajan/Friends, >> I have attached a POC of what exactly iam planning to do with all the >> business validation. >> My idea is to develop an macros for updating test cases results in QC.Iam >> planning to develop this tool keeping regression testing in my mind. >> When we do regression testing for an application after a patch relase >> there are very few defect and most of the cases are passed. >> >> Eg :- if 1000 test cases are availbale in Quality center and only 10 test >> cases are failed in it per regression cycle.I want to mark 10 test cases as >> fail in the excel macro and click on the button it should update those 10 >> test cases as fail in quality center and by default all remaining 990 test >> cases which are not mentioned in the excel should be marked as pass in >> quality center.This will help us reduce lot of manual redundant work which >> we are doing currently >> >> It would be great if somebody you are guiding me.Thanks a lot once again. >> >> Regards >> Nevin >> >> On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: >>> >>> Hi Friends, >>> >>> Iam not able to find the right kind of code which is used to connect >>> QC test lab folder using macros.Objective is to update around 1200 tc >>> using macros. >>> >>> It would be great if somebody is guiding me and iam very new to using >>> macros.. >>> >>> Regards >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit thi
Re: $$Excel-Macros$$ Re: QC results update tool
Hi Nevin I have been following this discussion and wondering how we can get the information necessary to help you. Is the software you call QC the HP Quality Center software? If not what is it? Do you know any way to connect Excel with it manually? If so how do you do it? If you can connect is this a read-only connection or can you alter the QC database? If you want to mark a test as passed or failed in QC how do you do it? Please include in your answer all connection strings, file addresses, web addresses, and screen prints as relevant. Have you tried asking your question opn the QC forum? What response did you get? Regards David Grugeon On 5 November 2012 08:08, Nevin wrote: > Hi Paul/Rajan/Friends, > I have attached a POC of what exactly iam planning to do with all the > business validation. > My idea is to develop an macros for updating test cases results in QC.Iam > planning to develop this tool keeping regression testing in my mind. > When we do regression testing for an application after a patch relase > there are very few defect and most of the cases are passed. > > Eg :- if 1000 test cases are availbale in Quality center and only 10 test > cases are failed in it per regression cycle.I want to mark 10 test cases as > fail in the excel macro and click on the button it should update those 10 > test cases as fail in quality center and by default all remaining 990 test > cases which are not mentioned in the excel should be marked as pass in > quality center.This will help us reduce lot of manual redundant work which > we are doing currently > > It would be great if somebody you are guiding me.Thanks a lot once again. > > Regards > Nevin > > On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: > >> Hi Friends, >> >> Iam not able to find the right kind of code which is used to connect >> QC test lab folder using macros.Objective is to update around 1200 tc >> using macros. >> >> It would be great if somebody is guiding me and iam very new to using >> macros.. >> >> Regards >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
Hi Paul/Rajan/Friends, I have attached a POC of what exactly iam planning to do with all the business validation. My idea is to develop an macros for updating test cases results in QC.Iam planning to develop this tool keeping regression testing in my mind. When we do regression testing for an application after a patch relase there are very few defect and most of the cases are passed. Eg :- if 1000 test cases are availbale in Quality center and only 10 test cases are failed in it per regression cycle.I want to mark 10 test cases as fail in the excel macro and click on the button it should update those 10 test cases as fail in quality center and by default all remaining 990 test cases which are not mentioned in the excel should be marked as pass in quality center.This will help us reduce lot of manual redundant work which we are doing currently It would be great if somebody you are guiding me.Thanks a lot once again. Regards Nevin On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: > Hi Friends, > > Iam not able to find the right kind of code which is used to connect > QC test lab folder using macros.Objective is to update around 1200 tc > using macros. > > It would be great if somebody is guiding me and iam very new to using > macros.. > > Regards > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Qc Results update tool.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: QC results update tool
There really is no way for us to help you with the limited information you've provided. Actually, that's not true. There are LOTS of ways. hundreds of thousands of ways. MOST, except for perhaps a hundred or so, are not relevent to your situation. So, to narrow it down, We would need to know specifics about what you're trying to do. Keep in mind that not everyone works in the same field that you do... I'm GUESSING that "QC" is Quality Control and "TC" is Test Case... So, you've got 1200 Test results that you're trying to put into some other format. It would be best if you can supply a sample of one of these "TC"'s and describe what you're trying to do with it. Given that much information, you're STILL going to get as many solutions as you have people responding to your request. Simply because there are so many options available. But before we can help you, we need to know what information we have to work with... Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Nevin To: excel-macros@googlegroups.com Sent: Thu, November 1, 2012 4:10:14 PM Subject: $$Excel-Macros$$ Re: QC results update tool HI Rajan/Friends, Thanks for your intrest in helping me. Objective of the tool is to update all the test case results in QC from an excel file through macros which inturn will avoid manual work. We have around 1200 TC's for every execution and once we develop it as tool it will reduce a lot of manual work which we are currently doing. Iam very new to using macros and coding.Iam finding very difficult to understand how it is working. Once again thank you. Regards Nevin-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
So , how would you like to automate the process? On Friday, 2 November 2012 01:39:51 UTC+5:30, Nevin wrote: > > HI Rajan/Friends, > > Thanks for your intrest in helping me. > > Objective of the tool is to update all the test case results in QC from an > excel file through macros which inturn will avoid manual work. > > We have around 1200 TC's for every execution and once we develop it as > tool it will reduce a lot of manual work which we are currently doing. > > Iam very new to using macros and coding.Iam finding very difficult to > understand how it is working. > > Once again thank you. > > Regards > Nevin > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
HI Rajan/Friends, Thanks for your intrest in helping me. Objective of the tool is to update all the test case results in QC from an excel file through macros which inturn will avoid manual work. We have around 1200 TC's for every execution and once we develop it as tool it will reduce a lot of manual work which we are currently doing. Iam very new to using macros and coding.Iam finding very difficult to understand how it is working. Once again thank you. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
> > Hi Friends, > Can anyone please help me with the code which is used to establish the connectivity between HP ALM and macros and also to update some fields in ALM. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.