The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> AutomatedQA / SmartBear TestComplete

Pages: 1
atrep2000
Newbie


Reged: 06/03/10
Posts: 1
Using Object Name Mapping from Excel spreadsheet
      #629092 - 06/03/10 04:38 AM

Hi, Is it possible to direct TestComplete to an Excel spreadsheet to find the path of objects instead of using the built-in Name Mapping feature? I have a spreadsheet that contains all the objects paths and is always up-todate.

eg,
First column has the object name - like "btnOK"
Second column has the full path.

Thanks...


Post Extras: Print Post   Remind Me!   Notify Moderator  
David_SmartBear
Junior Member


Reged: 05/12/04
Posts: 1203
Re: Using Object Name Mapping from Excel spreadsheet [Re: atrep2000]
      #629335 - 06/04/10 07:09 AM

Hi,

You can use DDT for this purpose (see the "DDT.ExcelDriver" online help topic).

You can find an example of using DDT.ExcelDriver in the "Using DDT Drivers" help topic.

--------------------
Best regards,
David - SmartBear Support


Post Extras: Print Post   Remind Me!   Notify Moderator  
Vaishnavi_Patil
Newbie


Reged: 03/25/10
Posts: 2
Re: Using Object Name Mapping from Excel spreadsheet [Re: David_SmartBear]
      #630191 - 06/10/10 11:26 PM

Hey We have used a different approach for this in our project,hope this will help you.

For name mapping of Objects that u are saying u can maintain a OR(Object Repository) sheet and a Datasheet can be maintained to keep track of object values(that u need to punch in the Application).

We have Library functions which can help us to retrive data from these sheets.


Post Extras: Print Post   Remind Me!   Notify Moderator  
kumarasjit
Member


Reged: 06/13/07
Posts: 39
Re: Using Object Name Mapping from Excel spreadsheet [Re: Vaishnavi_Patil]
      #632971 - 06/30/10 11:41 AM

Hey Vaishnavi

Is it possible to share your library functions?

~Thanks

--------------------
Ajit,Pune

Edited by kumarasjit (06/30/10 11:42 AM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
ikemuk
Member


Reged: 07/20/09
Posts: 40
Re: Using Object Name Mapping from Excel spreadsheet [Re: Vaishnavi_Patil]
      #633453 - 07/05/10 04:32 AM

Hi Vaishnavi_Patil

I am looking at alternatives from using Namemapping in TC7 and your reply to original post has made me curious how Excel Object Mapping works.

Am I correct in saying that you have a function that runs before any testing begins using DDT to retrieve all object paths and assign them to Global Variables with Names same as object TC7 will be interacting with? Global because the Objects Names is then available across all scripts for that project(Same as using Namemapping). Is this correct?

Also how do you handle when properties of an object changes, so how do know which property has changed and at what level of the object path the change happened?

How do you handle property of objects that changes at runtime? (With Namemapping I handle it using the project Variable).

Also what are the risks of using this type of object mapping if any?

I know I have asked a lot of questions, I really appreciate that you'll be using your precious time to answer.I'll be eternally grateful if you're able answer . Just when I think I know everything someone comes up with a better solution (Always the way I guess).

Thanks in advance

Edited by ikemuk (07/05/10 04:43 AM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
MVG
Member


Reged: 01/16/07
Posts: 33
Loc: NJ, USA
Re: Using Object Name Mapping from Excel spreadsheet [Re: ikemuk]
      #634548 - 07/13/10 07:23 PM

Vaishnavi:
Can you please post a sample so we can also take your approach,


Post Extras: Print Post   Remind Me!   Notify Moderator  
redpiyo
Newbie


Reged: 05/18/10
Posts: 20
Re: Using Object Name Mapping from Excel spreadsheet [Re: MVG]
      #634585 - 07/14/10 03:45 AM

May i know what is the benefits of using a spreadsheet instead of the build in name mapping feature?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Vaishp
Newbie


Reged: 03/28/10
Posts: 17
Re: Using Object Name Mapping from Excel spreadsheet [Re: redpiyo]
      #719907 - 11/20/12 11:43 PM

Hi,

I found a very good method called FindChild that we had used in our last project in TestComplete 9.
I am really sorry I cant share the Library function but you may get help on FindChild methods on Smartbear site.
All we need to do is pass the Property names and Property values from the excel sheets .
I guess this will help.
Thanks


Post Extras: Print Post   Remind Me!   Notify Moderator  
Vaishp
Newbie


Reged: 03/28/10
Posts: 17
Re: Using Object Name Mapping from Excel spreadsheet [Re: Vaishp]
      #719908 - 11/20/12 11:48 PM

Hi redpiyo,

We had experienced this issue with Name mapping ,if we have more than 2 people working on different modules in Application,merging and maintaining the Name mapping files was always a cumbersome task.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 16 anonymous users are browsing this forum.

Moderator:  NickAQA, Robert Martin, martinh, brentpaine 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 6257

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5