DebeG
asked on
I need advice on how to use JAVA to append data from XML files to one CSV file.
I am working with a very large, very complicated schema. I currently use this schema in JAVA to create XML files based on Job Information. I am now being asked to also capture the data from each XML file and save to a CSV file, appending records for each job processed. Data from each job varies, so I need to make sure that the CSV file contains all nodes from the schema. I need advice on how to accomplish this.
Thanks,
Thanks,
We probably need to see samples
ASKER
Here is just one node in the schema. The SpecComponent node is a One to Many Node and the number of components vary between jobs. One job may have only two components, one may have 15. Also, no two jobs are exactly the same. One job may contain DecorationSpecs and one may FinishSpecs. Because of this, I need to make sure the CSV file contains all possible nodes. And need to know code to accomplish this.
<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2008 (http://www.altova.com)-->
<pn:SpecComponent xsi:schemaLocation="http://www.papinet.org/v2r40 CoatSpecificationV2R40_ABC_BTB.xsd" xmlns:pn="http://www.papinet.org/v2r40" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:Classification>
<pn:ClassificationCode Agency="AFPA">a</pn:ClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:Classification>
<pn:SubClassification>
<pn:SubClassificationCode Agency="AFPA">a</pn:SubClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:SubClassification>
<pn:SubClassification>
<pn:SubClassificationCode Agency="AFPA">a</pn:SubClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:SubClassification>
<pn:Classification>
<pn:ClassificationCode Agency="AFPA">a</pn:ClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:Classification>
<pn:SubClassification>
<pn:SubClassificationCode Agency="AFPA">a</pn:SubClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:SubClassification>
<pn:SubClassification>
<pn:SubClassificationCode Agency="AFPA">a</pn:SubClassificationCode>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:SubClassification>
<pn:CoatClassification CoatClassificationType="Assembly">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:CoatSubClassification CoatSubClassificationType="2PieceCarton">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:CoatSubClassification>
<pn:CoatSubClassification CoatSubClassificationType="2PieceCarton">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:CoatSubClassification>
</pn:CoatClassification>
<pn:CoatClassification CoatClassificationType="Assembly">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:CoatSubClassification CoatSubClassificationType="2PieceCarton">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:CoatSubClassification>
<pn:CoatSubClassification CoatSubClassificationType="2PieceCarton">
<pn:ClassificationDescription>a</pn:ClassificationDescription>
<pn:ClassificationDescription>a</pn:ClassificationDescription>
</pn:CoatSubClassification>
</pn:CoatClassification>
<pn:NumberPerProduct>1234567891.12345678</pn:NumberPerProduct>
<pn:PlacementInOrderOfMatter PlacementLocation="Inside" PlacementReference="BackCover" RelativeLocation="a" PlacementSequence="12">
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:PlacementInOrderOfMatter>
<pn:PlacementInOrderOfMatter PlacementLocation="Inside" PlacementReference="BackCover" RelativeLocation="a" PlacementSequence="12">
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:PlacementInOrderOfMatter>
<pn:FinishedSize>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
<pn:Height>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Height>
<pn:FlapWidth FlapLocation="Back">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:FlapWidth>
<pn:FlapWidth FlapLocation="Back">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:FlapWidth>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:FinishedSize>
<pn:SuppliedComponentFinishSpecs>
<pn:FinishSpecs>
<pn:Coating FinishType="Bond" CoatingLocationType="Top" CoatingCoverageType="FullCoverage">AnimalGlueableStampableFilm</pn:Coating>
<pn:Coating FinishType="Bond" CoatingLocationType="Top" CoatingCoverageType="FullCoverage">AnimalGlueableStampableFilm</pn:Coating>
<pn:DecorationSpecs DecorationType="Debossing" DecorationLocationType="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfHits>1234</pn:NumberOfHits>
<pn:DecorationCoverage>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DecorationCoverage>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:DecorationSpecs>
<pn:DecorationSpecs DecorationType="Debossing" DecorationLocationType="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfHits>1234</pn:NumberOfHits>
<pn:DecorationCoverage>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DecorationCoverage>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:DecorationSpecs>
</pn:FinishSpecs>
<pn:FinishPrep FinishPrepOutputType="DirectToFilm">
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
</pn:FinishPrep>
<pn:FinishPrep FinishPrepOutputType="DirectToFilm">
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
</pn:FinishPrep>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
</pn:SuppliedComponentFinishSpecs>
<pn:PressComponent BarcodeSuppliedByPublisher="Yes">
<pn:NumberOfPages>123456</pn:NumberOfPages>
<pn:Signatures>
<pn:PagesPerSignature>1234</pn:PagesPerSignature>
<pn:NumberOfSignatures>1234</pn:NumberOfSignatures>
<pn:SignatureID>a</pn:SignatureID>
</pn:Signatures>
<pn:Signatures>
<pn:PagesPerSignature>1234</pn:PagesPerSignature>
<pn:NumberOfSignatures>1234</pn:NumberOfSignatures>
<pn:SignatureID>a</pn:SignatureID>
</pn:Signatures>
<pn:PressPrep PressPrepOutputType="DirectToFilm">
<pn:PressPrepInput MediaType="CD">
<pn:PressPrepInputType>4PageImposedFilm</pn:PressPrepInputType>
</pn:PressPrepInput>
<pn:PressPrepInput MediaType="CD">
<pn:PressPrepInputType>4PageImposedFilm</pn:PressPrepInputType>
</pn:PressPrepInput>
</pn:PressPrep>
<pn:ManufacturingSpecifications PressImpositionType="HeadToHead" PressType="Cameron">
<pn:Margins>
<pn:Head Bleed="Yes">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Head>
<pn:Thumb Bleed="Yes">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Thumb>
<pn:Gutter Bleed="Yes">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Gutter>
<pn:Foot Bleed="Yes">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Foot>
</pn:Margins>
<pn:InkCharacteristics>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:ColourSpecs ColourLocation="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
</pn:ColourSpecs>
<pn:ColourSpecs ColourLocation="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
</pn:ColourSpecs>
</pn:InkCharacteristics>
<pn:FinishSpecs>
<pn:Coating FinishType="Bond" CoatingLocationType="Top" CoatingCoverageType="FullCoverage">AnimalGlueableStampableFilm</pn:Coating>
<pn:Coating FinishType="Bond" CoatingLocationType="Top" CoatingCoverageType="FullCoverage">AnimalGlueableStampableFilm</pn:Coating>
<pn:DecorationSpecs DecorationType="Debossing" DecorationLocationType="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfHits>1234</pn:NumberOfHits>
<pn:DecorationCoverage>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DecorationCoverage>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:DecorationSpecs>
<pn:DecorationSpecs DecorationType="Debossing" DecorationLocationType="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfHits>1234</pn:NumberOfHits>
<pn:DecorationCoverage>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DecorationCoverage>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:ProductIdentification>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
</pn:ProductIdentification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:DecorationSpecs>
</pn:FinishSpecs>
<pn:FinishPrep FinishPrepOutputType="DirectToFilm">
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
<pn:FinishPrepInput MediaType="CD">
<pn:FinishPrepInputType>4PageImposedFilm</pn:FinishPrepInputType>
</pn:FinishPrepInput>
</pn:FinishPrep>
<pn:PrintedMediaSpecs RoundCornered="Yes" Collated="Yes" Drilled="Yes" DieCut="Yes" Perforated="Yes" Scored="Yes" Folded="Yes">
<pn:NumberOfSides>12</pn:NumberOfSides>
<pn:DieCutDescription>a</pn:DieCutDescription>
<pn:FlatSize>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:FlatSize>
<pn:Wrap WrapProperties="Bleached" WrapType="Cardboard" WrapLocation="None">
<pn:NumberOfWraps>1.12</pn:NumberOfWraps>
<pn:Brand>a</pn:Brand>
</pn:Wrap>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:PrintedMediaSpecs>
<pn:Perforation PerforationType="Pattern">
<pn:DistanceFromEdge EdgeType="Bottom" DistanceMeasuredTo="Edge">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DistanceFromEdge>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Perforation>
<pn:Perforation PerforationType="Pattern">
<pn:DistanceFromEdge EdgeType="Bottom" DistanceMeasuredTo="Edge">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:DistanceFromEdge>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Perforation>
<pn:PrintingMaterials>
<pn:MaterialCharacteristics FinishType="Bond">
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:BasisWeight SampleType="Average" ResultSource="AutoLab" ProductBasisSizeType="GramsPerSquareMeter" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
<pn:IncrementalValue UOM="AirDryMetricTonne">1234567891.12345678</pn:IncrementalValue>
<pn:IncrementalValue UOM="AirDryMetricTonne">1234567891.12345678</pn:IncrementalValue>
</pn:BasisWeight>
<pn:Brightness SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Brightness>
<pn:Caliper SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Caliper>
<pn:ColourSpecs ColourLocation="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
</pn:ColourSpecs>
<pn:Opacity SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Opacity>
<pn:PPI>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:PPI>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:GrainDirection>Any</pn:GrainDirection>
<pn:RecycledCharacteristics RecycledRequired="Yes">
<pn:Recycled SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Recycled>
</pn:RecycledCharacteristics>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
</pn:MaterialCharacteristics>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:PrintingMaterials>
<pn:PrintingMaterials>
<pn:MaterialCharacteristics FinishType="Bond">
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductIdentifier Agency="AFPA" ProductIdentifierType="BrandName">a</pn:ProductIdentifier>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:ProductDescription Language="eng">a</pn:ProductDescription>
<pn:BasisWeight SampleType="Average" ResultSource="AutoLab" ProductBasisSizeType="GramsPerSquareMeter" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
<pn:IncrementalValue UOM="AirDryMetricTonne">1234567891.12345678</pn:IncrementalValue>
<pn:IncrementalValue UOM="AirDryMetricTonne">1234567891.12345678</pn:IncrementalValue>
</pn:BasisWeight>
<pn:Brightness SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Brightness>
<pn:Caliper SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Caliper>
<pn:ColourSpecs ColourLocation="Front">
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
<pn:ColourCode Agency="AFPA">a</pn:ColourCode>
<pn:ColourDescription>a</pn:ColourDescription>
<pn:NumberOfColours>1234</pn:NumberOfColours>
<pn:InkTypeDescription>a</pn:InkTypeDescription>
<pn:ColourMatchDescription>a</pn:ColourMatchDescription>
<pn:ColourShade Agency="AFPA">a</pn:ColourShade>
<pn:InkCoverage InkCoverageType="AcrossFlap">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:InkCoverage>
</pn:ColourSpecs>
<pn:Opacity SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Opacity>
<pn:PPI>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:PPI>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:GrainDirection>Any</pn:GrainDirection>
<pn:RecycledCharacteristics RecycledRequired="Yes">
<pn:Recycled SampleType="Average" ResultSource="AutoLab" TestAgency="ASTM" TestMethod="a">
<pn:DetailValue UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailValue>
<pn:DetailRangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMin>
<pn:DetailRangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:DetailRangeMax>
<pn:StandardDeviation UOM="AirDryMetricTonne">123456789123.123456</pn:StandardDeviation>
<pn:SampleSize>123</pn:SampleSize>
<pn:TwoSigmaLower UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaLower>
<pn:TwoSigmaUpper UOM="AirDryMetricTonne">1234567891.12345678</pn:TwoSigmaUpper>
</pn:Recycled>
</pn:RecycledCharacteristics>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
</pn:MaterialCharacteristics>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:PrintingMaterials>
</pn:ManufacturingSpecifications>
<pn:Halftones IsHalftones="Yes">
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:Halftones>
<pn:Length>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Length>
<pn:Width>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:Width>
</pn:PressComponent>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:SpecReference AssignedBy="Auditor" SpecReferenceType="AccountNumber">a</pn:SpecReference>
<pn:SpecReference AssignedBy="Auditor" SpecReferenceType="AccountNumber">a</pn:SpecReference>
<pn:SafetyAndEnvironmentalInformation Agency="AFPA" SafetyAndEnvironmentalType="Agricultural">
<pn:LicenceNumber>a</pn:LicenceNumber>
<pn:ChainOfCustody CertificationBody="String">a</pn:ChainOfCustody>
<pn:SafetyAndEnvironmentalCertification>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:SafetyAndEnvironmentalCertification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:SafetyAndEnvironmentalInformation>
<pn:SafetyAndEnvironmentalInformation Agency="AFPA" SafetyAndEnvironmentalType="Agricultural">
<pn:LicenceNumber>a</pn:LicenceNumber>
<pn:ChainOfCustody CertificationBody="String">a</pn:ChainOfCustody>
<pn:SafetyAndEnvironmentalCertification>
<pn:Value UOM="AirDryMetricTonne">1234567891.12345678</pn:Value>
<pn:RangeMin UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMin>
<pn:RangeMax UOM="AirDryMetricTonne">1234567891.12345678</pn:RangeMax>
</pn:SafetyAndEnvironmentalCertification>
<pn:AdditionalText>a</pn:AdditionalText>
<pn:AdditionalText>a</pn:AdditionalText>
</pn:SafetyAndEnvironmentalInformation>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
<pn:ABCReference ABCAssignedBy="CARP" ABCReferenceType="ArchiveJobNumber">a</pn:ABCReference>
<pn:ABCCustomerReferences>
<pn:ABCCustomerReference ABCCustomerReferenceType="BSGRef01">
<pn:ABCReferenceTag>a</pn:ABCReferenceTag>
<pn:ABCReferenceValue>a</pn:ABCReferenceValue>
</pn:ABCCustomerReference>
<pn:ABCCustomerReference ABCCustomerReferenceType="BSGRef01">
<pn:ABCReferenceTag>a</pn:ABCReferenceTag>
<pn:ABCReferenceValue>a</pn:ABCReferenceValue>
</pn:ABCCustomerReference>
</pn:ABCCustomerReferences>
<pn:ABCComment ABCAssignedBy="CARP" ABCCommentType="AAN">a</pn:ABCComment>
<pn:ABCComment ABCAssignedBy="CARP" ABCCommentType="AAN">a</pn:ABCComment>
<pn:ABCProductAttributes ABCPrintManagementIndicator="Yes" ABCCriticalIndicator="Yes" ABCErrortIndicator="Yes">a</pn:ABCProductAttributes>
</pn:SpecComponent>
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
ok, Not sure I realized that. I can convert the XML into a CSV file, but it only included the nodes in the XML. I couldn't figure out how to get all nodes from xsd. Sounds like it isnt really possible.
So, I currently create one xml file for each job. I am being asked to save and accumulate all data for a certain customer. Any other possible way to do this?
So, I currently create one xml file for each job. I am being asked to save and accumulate all data for a certain customer. Any other possible way to do this?
It's conceivable that there are spreadsheet (not CSV) methods of organising tree-like structures. I haven't used them so am not familiar with them
ASKER
This didnt really resolve my issue, but he did answer my question.