Clueless but need Stylesheet...
Clueless but need Stylesheet...
(OP)
I didn't realize there is an XML forum...
Long story short I need a stylesheet to make particular XML importable in a usable fashion to Access...
This seems too much to trial by fire. Any help is appreciated.
thread181-1707992: Need XML stylesheet...(attribute-centric XML)
Long story short I need a stylesheet to make particular XML importable in a usable fashion to Access...
This seems too much to trial by fire. Any help is appreciated.
thread181-1707992: Need XML stylesheet...(attribute-centric XML)
RE: Clueless but need Stylesheet...
For a command line XSL processor, you can download msxsl from the Microsoft web site. For a better experience, download XMLSpy or Stylus Studio and use one of their free evaluation periods.
The Microsoft knowledgebase article has an XSLT which will process your XML, turning attributes into elements of the same name, viz
CODE -->
CODE -->
It appears you are looking for something a bit more but you are not doing a satisfactory job of describing what type of XML to which you wish to transform your input. I understand that this is not an area of expertise for you, but give it another try.
Tom Morrison
Micro Focus
RE: Clueless but need Stylesheet...
Not sure about the wording but I think I want to strip away certain parent elements to end with a common larger element and change timestamp attributes to regular text.
I really am so far removed from proper XML jargon I doubt I can talk intelligently about it... So here is an explanation of what I get based on processing the XML and issues.
My biggest issue is that the Timestamp Values are not coming in on my import (under Accession however the report header does). Another issue is that there are effectively a lot of implicit 1 to 1 relationships in the data and having multiple groupings that end up as separate identities / tables is cumbersome but I can cope if necessary.
When I import I have the following identities / tables...
AccessionHeader - Missing timestamp data - data is needed as part of lab / testcode
Address (I did play with removing tags and got this to die manually; columns are then part of clinic and lablocation)
Clinic
Lablocation
Pet -Secondary / FK data I need
ReportHeader
TestCode - Principle data I need
UnitCode - Not sure I understand where this one is coming from. It has CBC and Albumin values.
So from where I sit there ideally would be two 'tables' one for testcode which has the many side and one for everything else which has the one side... But I'd settle for getting rid of address.
The other anamoly I have is that for the test code table I have a units column that has markup encoding... So for the Name "WBC" I have units "10<sup>3</sup>/<font face="symbol">m</font>L".
This is the least annoying of issues I can always eyeball the source presentation and make replacements as necessary.
Hopefully that all makes sense.
RE: Clueless but need Stylesheet...
Before (as displayed in IE8...
CODE
After...
CODE