stanl
01-04-2007, 01:11 PM
.xsd files are really xml files meant to replace the DTD documentation standard. In effect they are validation schemas to insure that xml data is passed correctly to and from applications. Creating an xsd is not that difficult and there are plenty of free tutorials. However, consider being given one and asked to parse it in such a way that you get an understanding of the 'rules' contained within the various nodes.
Anyway, I found the free Logparser COM dll ideal in that it accepts xsd as input and can output as .csv, creating header rows. Problem is the csv is redundant, and it would be nice if it could be loaded into excel and a Pivot created to represent a semi-treeview.
The attached zip has an xsd that is part of a large validation structure for SIF (Schools Interoperability Framework - the next 'holy grail' of data consistency). Then there is a .csv created from it via LogParser [could be done as a single command line if you don't want to use the dll).
Question: might it be possible to format the csv as a meaningful pivot?:doh: Stan
Anyway, I found the free Logparser COM dll ideal in that it accepts xsd as input and can output as .csv, creating header rows. Problem is the csv is redundant, and it would be nice if it could be loaded into excel and a Pivot created to represent a semi-treeview.
The attached zip has an xsd that is part of a large validation structure for SIF (Schools Interoperability Framework - the next 'holy grail' of data consistency). Then there is a .csv created from it via LogParser [could be done as a single command line if you don't want to use the dll).
Question: might it be possible to format the csv as a meaningful pivot?:doh: Stan