Solved

xml test harness

Posted on 2013-11-21
3
289 Views
Last Modified: 2013-11-22
Hi,

I have been asked to set up test automation for XML files however I have never done this. I have two questions.

Does anyone have a link to a code example of one of these harnesses either in C# or VBA code? (I don't have enough experience with Java to go that route)

Can this automation be done using Excel and VBA?

Thanks,
Gwenna
0
Comment
Question by:boukaka
3 Comments
 
LVL 17

Expert Comment

by:JezWalters
ID: 39668361
Have you thought of checking the XML structure programatically in VBA, using the Microsoft XML library?
0
 

Author Comment

by:boukaka
ID: 39668747
Hmmm.... I haven't....I don't suppose you have some sort of short example of how that would work?
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 39668862
Visual Studio.NET has a unit testing framework.  This slideshow shows the screen shots:

.Net Unit Testing with Visual Studio 2010
http://www.slideshare.net/kgayda/unit-testing-in-visual-studio-2010

You can write a little code to load a list of files, load files, and validate the XML.  If you have a schema file for the XML, that would make validation better.

Validating XML Data with XmlReader
http://msdn.microsoft.com/en-us/library/hdf992b8(v=vs.110).aspx
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question