Example File Description Documents

Here are the file description documents for the invoice and purchase order examples.

Sample InvoiceCSVSourceDescription.xml
<?xml version="1.0" encoding="UTF-8"?>
<CSVSourceFileDescription
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="CSVSourceFileDescription.xsd">
<PhysicalCharacteristics>
    <RecordTerminator value="W"/>
    <ColumnDelimiter value=","/>
    <TextDelimiter value="&quot;"/>
  </PhysicalCharacteristics>
  <XMLOutputCharacteristics>
    <DocumentBreakColumn value="2"/>
    <PartnerBreakColumn value="1"/>
    <SchemaLocationURL value="CSVInvoice.xsd"/>
  </XMLOutputCharacteristics>
  <Grammar ElementName="Invoice">
    <RowDescription ElementName="InvoiceLine">
      <ColumnDescription FieldNumber="1"
          ElementName="CustomerNumber" DataType="AN"/>
      <ColumnDescription FieldNumber="2"
          ElementName="InvoiceNumber" DataType="AN"/>
      <ColumnDescription FieldNumber="3"
          ElementName="InvoiceDate" DataType="DMMsDDsYYYY"/>
      <ColumnDescription FieldNumber="4"
          ElementName="PONumber" DataType="AN"/>
      <ColumnDescription FieldNumber="5"
          ElementName="DueDate" DataType="DMMsDDsYYYY"/>
      <ColumnDescription FieldNumber="6"
          ElementName="ShipToName" DataType="AN"/>
      <ColumnDescription FieldNumber="7"
          ElementName="ShipToStreet1" DataType="AN"/>
      <ColumnDescription FieldNumber="8"
          ElementName="ShipToStreet2" DataType="AN"/>
      <ColumnDescription FieldNumber="9"
          ElementName="ShipToCity" DataType="AN"/>
      <ColumnDescription FieldNumber="10"
          ElementName="ShipToStateOrProvince" DataType="AN"/>
      <ColumnDescription FieldNumber="11"
          ElementName="ShipToPostalCode" DataType="AN"/>
      <ColumnDescription FieldNumber="12"
          ElementName="ShipToCountry" DataType="AN"/>
      <ColumnDescription FieldNumber="13"
          ElementName="ItemID" DataType="AN"/>
      <ColumnDescription FieldNumber="14"
          ElementName="ItemQuantity" DataType="R"/>
      <ColumnDescription FieldNumber="15"
          ElementName="UnitPrice" DataType="R"/>
      <ColumnDescription FieldNumber="16"
          ElementName="ItemDescription" DataType="AN"/>
      <ColumnDescription FieldNumber="17"
          ElementName="ExtendedPrice" DataType="R"/>
    </RowDescription>
  </Grammar>
</CSVSourceFileDescription>

Sample PurchaseOrderCSVTargetDescription.xml
<?xml version="1.0" encoding="UTF-8"?>
<CSVTargetFileDescription
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="CSVTargetFileDescription.xsd">
  <PhysicalCharacteristics>
    <RecordTerminator value="U"/>
    <ColumnDelimiter value=","/>
    <TextDelimiter value="&quot;"/>
  </PhysicalCharacteristics>
  <Grammar ElementName="PurchaseOrder">
    <RowDescription ElementName="POLine">
      <ColumnDescription FieldNumber="1"
          ElementName="CustomerNumber" DataType="AN"/>
      <ColumnDescription FieldNumber="2"
          ElementName="PONumber" DataType="AN"/>
      <ColumnDescription FieldNumber="3"
          ElementName="PODate" DataType="DMMsDDsYYYY"/>
      <ColumnDescription FieldNumber="4"
          ElementName="RequestedDeliveryDate"
          DataType="DMMsDDsYYYY"/>
      <ColumnDescription FieldNumber="5"
          ElementName="ShipToName" DataType="AN"
          DelimitText="true"/>
      <ColumnDescription FieldNumber="6"
          ElementName="ShipToStreet1" DataType="AN"
          DelimitText="true"/>
      <ColumnDescription FieldNumber="7"
          ElementName="ShipToStreet2" DataType="AN"
          DelimitText="true"/>
      <ColumnDescription FieldNumber="8"
          ElementName="ShipToCity" DataType="AN"
          DelimitText="true"/>
      <ColumnDescription FieldNumber="9"
          ElementName="ShipToStateOrProvince" DataType="AN"/>
      <ColumnDescription FieldNumber="10"
          ElementName="ShipToPostalCode" DataType="AN"/>
      <ColumnDescription FieldNumber="11"
          ElementName="ShipToCountry" DataType="AN"/>
      <ColumnDescription FieldNumber="12"
          ElementName="ItemID" DataType="AN"/>
      <ColumnDescription FieldNumber="13"
          ElementName="OrderedQty" DataType="R"/>
      <ColumnDescription FieldNumber="14"
          ElementName="UnitPrice" DataType="R"/>
      <ColumnDescription FieldNumber="15"
          ElementName="ItemDescription" DataType="AN"
          DelimitText="true"/>
    </RowDescription>
  </Grammar>
</CSVTargetFileDescription>

Note that in these documents and in the associated schemas, the URLs for the schema locations are all relative. They specify only the file name and not the full path location. So, a processor would expect these to all reside in the same path. I'll follow this convention in this and the next two chapters.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset