Subject: [xsl] Re: Re-arranging an XML file (long) From: Mike Stroud <stroudmw@xxxxxxxxx> Date: Fri, 23 Jan 2009 11:36:26 +0200 |
Hello everyone, My apologies for not being more clear. Here is what I'm trying to do: This is a snippet of the XML file I have: <?xml version="1.0" encoding="UTF-8"?> <wc:COLLECTION xmlns:wc="http://www.ptc.com/infoengine/1.0"> <DeletedECN NAME="DeletedECN" TYPE="Unknown" STATUS="0"> </DeletedECN> <AddedECN NAME="AddedECN" TYPE="Unknown" STATUS="0"> </AddedECN> <ChangedECN NAME="ChangedECN" TYPE="Unknown" STATUS="0"> </ChangedECN> <UnchangedECN NAME="UnchangedECN" TYPE="Unknown" STATUS="0"> </UnchangedECN> <DeletedParts NAME="DeletedParts" TYPE="Unknown" STATUS="0"> </DeletedParts> <AddedParts NAME="AddedParts" TYPE="Unknown" STATUS="0"> <Part> <ObjectID>VR:wt.part.WTPart:18143:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <Class>com.ptc.windchill.esi.Part</Class> <LastChangedBy>demo</LastChangedBy> <Number>0000000017</Number> <StartEffectivity></StartEffectivity> <EndEffectivity></EndEffectivity> <StartSerialNumberEffectivity></StartSerialNumberEffectivity> <EndSerialNumberEffectivity></EndSerialNumberEffectivity> <StartLotNumberEffectivity></StartLotNumberEffectivity> <EndLotNumberEffectivity></EndLotNumberEffectivity> <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber> <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber> <DefaultUnit>ea</DefaultUnit> <Name>1ZBA183001-M</Name> <PartType>separable</PartType> <Source>make</Source> <Version>A</Version> <Iteration>2</Iteration> <WO>W0761000</WO> <ItemNo>178</ItemNo> <Length>70.000000000000</Length> <Width>15.500000000000</Width> <Thickness>35.000000000000</Thickness> <Qty1>1.0000000000000</Qty1> <EndItem></EndItem> <TargetID>DT01</TargetID> </Part> <Part> <ObjectID>VR:wt.part.WTPart:18167:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <Class>com.ptc.windchill.esi.Part</Class> <LastChangedBy>demo</LastChangedBy> <Number>0000000019</Number> <StartEffectivity></StartEffectivity> <EndEffectivity></EndEffectivity> <StartSerialNumberEffectivity></StartSerialNumberEffectivity> <EndSerialNumberEffectivity></EndSerialNumberEffectivity> <StartLotNumberEffectivity></StartLotNumberEffectivity> <EndLotNumberEffectivity></EndLotNumberEffectivity> <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber> <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber> <DefaultUnit>ea</DefaultUnit> <Name>1ZXX463114-BRB</Name> <PartType>separable</PartType> <Source>make</Source> <Version>A</Version> <Iteration>2</Iteration> <WO>W0761000</WO> <ItemNo>169</ItemNo> <Length>70.000000000000</Length> <Width>15.500000000000</Width> <Thickness>35.000000000000</Thickness> <Qty1>1.0000000000000</Qty1> <EndItem></EndItem> <TargetID>DT01</TargetID> </Part> </AddedParts> <ChangedParts NAME="ChangedParts" TYPE="Unknown" STATUS="0"> </ChangedParts> <UnchangedParts NAME="UnchangedParts" TYPE="Unknown" STATUS="0"> </UnchangedParts> <DeletedAlternateLinks NAME="DeletedAlternateLinks" TYPE="Unknown" STATUS="0"> </DeletedAlternateLinks> <AddedAlternateLinks NAME="AddedAlternateLinks" TYPE="Unknown" STATUS="0"> </AddedAlternateLinks> <DeletedDocuments NAME="DeletedDocuments" TYPE="Unknown" STATUS="0"> </DeletedDocuments> <AddedDocuments NAME="AddedDocuments" TYPE="Unknown" STATUS="0"> </AddedDocuments> <ChangedDocuments NAME="ChangedDocuments" TYPE="Unknown" STATUS="0"> </ChangedDocuments> <UnchangedDocuments NAME="UnchangedDocuments" TYPE="Unknown" STATUS="0"> </UnchangedDocuments> <DeletedDocumentLinks NAME="DeletedDocumentLinks" TYPE="Unknown" STATUS="0"> </DeletedDocumentLinks> <AddedDocumentLinks NAME="AddedDocumentLinks" TYPE="Unknown" STATUS="0"> </AddedDocumentLinks> <DeletedBOMs NAME="DeletedBOMs" TYPE="Unknown" STATUS="0"> </DeletedBOMs> <AddedBOMs NAME="AddedBOMs" TYPE="Unknown" STATUS="0"> <BOMHeader> <ObjectID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <Class>com.ptc.windchill.esi.BOMHeader</Class> <LastChangedBy>demo</LastChangedBy> <Number>1ZXX463003-BRB</Number> <StartEffectivity></StartEffectivity> <EndEffectivity></EndEffectivity> <StartSerialNumberEffectivity></StartSerialNumberEffectivity> <EndSerialNumberEffectivity></EndSerialNumberEffectivity> <StartLotNumberEffectivity></StartLotNumberEffectivity> <EndLotNumberEffectivity></EndLotNumberEffectivity> <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber> <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber> <Version>A</Version> <Iteration>3</Iteration> <TargetID>DT01</TargetID> </BOMHeader> </AddedBOMs> <ChangedBOMs NAME="ChangedBOMs" TYPE="Unknown" STATUS="0"> </ChangedBOMs> <UnchangedBOMs NAME="UnchangedBOMs" TYPE="Unknown" STATUS="0"> </UnchangedBOMs> <DeletedBOMComponents NAME="DeletedBOMComponents" TYPE="Unknown" STATUS="0"> </DeletedBOMComponents> <AddedBOMComponents NAME="AddedBOMComponents" TYPE="Unknown" STATUS="0"> <BOMComponent> <ObjectID>OR:wt.part.WTPartMaster:18165:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <Class>com.ptc.windchill.esi.BOMComponent</Class> <PartNumber>0000000019</PartNumber> <AssemblyPartNumber>1ZXX463003-BRB</AssemblyPartNumber> <Quantity>1</Quantity> <Unit>each</Unit> <LineNumber></LineNumber> <FindNumber></FindNumber> <AlternateItemGroup></AlternateItemGroup> <StartSerialNumberEffectivity></StartSerialNumberEffectivity> <EndSerialNumberEffectivity></EndSerialNumberEffectivity> <StartLotNumberEffectivity></StartLotNumberEffectivity> <EndLotNumberEffectivity></EndLotNumberEffectivity> <EndItem>false</EndItem> <TargetID>DT01</TargetID> </BOMComponent> <BOMComponent> <ObjectID>OR:wt.part.WTPartMaster:18141:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <Class>com.ptc.windchill.esi.BOMComponent</Class> <PartNumber>0000000017</PartNumber> <AssemblyPartNumber>1ZXX463003-BRB</AssemblyPartNumber> <Quantity>1</Quantity> <Unit>each</Unit> <LineNumber></LineNumber> <FindNumber></FindNumber> <AlternateItemGroup></AlternateItemGroup> <StartSerialNumberEffectivity></StartSerialNumberEffectivity> <EndSerialNumberEffectivity></EndSerialNumberEffectivity> <StartLotNumberEffectivity></StartLotNumberEffectivity> <EndLotNumberEffectivity></EndLotNumberEffectivity> <EndItem>false</EndItem> <TargetID>DT01</TargetID> </BOMComponent> </AddedBOMComponents> <ChangedBOMComponents NAME="ChangedBOMComponents" TYPE="Unknown" STATUS="0"> </ChangedBOMComponents> <UnchangedBOMComponents NAME="UnchangedBOMComponents" TYPE="Unknown" STATUS="0"> </UnchangedBOMComponents> <DeletedSubstitutes NAME="DeletedSubstitutes" TYPE="Unknown" STATUS="0"> </DeletedSubstitutes> <AddedSubstitutes NAME="AddedSubstitutes" TYPE="Unknown" STATUS="0"> </AddedSubstitutes> <DeletedReferenceDesignators NAME="DeletedReferenceDesignators" TYPE="Unknown" STATUS="0"> </DeletedReferenceDesignators> <AddedReferenceDesignators NAME="AddedReferenceDesignators" TYPE="Unknown" STATUS="0"> </AddedReferenceDesignators> <Transactions NAME="Transactions" TYPE="Unknown" STATUS="0"> <Transaction> <TargetID>DT01</TargetID> <TransactionID>1</TransactionID> <WaitingEventID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</WaitingEventID> <Object>1ZXX463003-BRB, A.3 (Design)</Object> <ObjectID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID> <PublishedBy>Administrator</PublishedBy> <PublishedDate>2009/01/22 7:44:08 AM</PublishedDate> <Type>com.ptc.windchill.esi.BOM</Type> <Locale>en_GB</Locale> </Transaction> </Transactions> </wc:COLLECTION> I need to know how to get selected items from the <Part> section and the <AssemblyPartNumber> item from the <BOMComponent> section into an XML file, and then to change that into a CSV file (*phew*). I'm going through w3schools at the moment and will tackle more of it over the weekend. This is really fascinating stuff! One day I'm going to ask how to split the XML above into 3 seperate XML files: 1 for Parts, 1 for the BOMHeader and the 3rd for BOMComponents... but I think I'll leave that for another day... Many Thanks and Kind Regards, Mike in SA
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] for-each(-group) - flatte, Andrew Welch | Thread | [xsl] xsl:for-each-group and identi, Jesper Tverskov |
Re: [xsl] for-each(-group) - flatte, Robert Koberg | Date | Re: [xsl] for-each(-group) - flatte, Andrew Welch |
Month |