Solved

xml test harness

Posted on 2013-11-21
3
279 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

This article will show, step by step, how to integrate R code into a R Sweave document
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now