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
Solved

xml test harness

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

839 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