?
Solved

xml test harness

Posted on 2013-11-21
3
Medium Priority
?
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Suggested Courses

800 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