title: What is the best way to flatten XML Hierarchy to CSV?
body: <p>I am having a problem converting a XML file to a flat csv file. 
  I cannot seem to find a good way to flatten the xml file.  I have tried many that I see online but I can only find one site that does it for me (<a href="http://convertcsv.com/xml-to-csv.htm" rel="nofollow noreferrer">http://convertcsv.com/xml-to-csv.htm</a>) This formats it the way i need it, But I need to wrap my process in a SSIS package so using a site will not work.</p>
  
  <p>I am using C# to read the XML file and then doing a transform with XslCompiledTransform</p>
  
  <p>Here is the source file. </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;GTINItemInfoProxy xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.xxxxx.com/schemas/GS1"&gt;
    &lt;header version="2.0" xmlns=""&gt;
      &lt;messageId&gt;00000000000001.US.00000008&lt;/messageId&gt;
      &lt;creationDateTime&gt;2019-02-08T11:52:15&lt;/creationDateTime&gt;
      &lt;businessUnit&gt;Example&lt;/businessUnit&gt;
      &lt;sourceSystem&gt;HCS&lt;/sourceSystem&gt;
    &lt;/header&gt;
    &lt;GTINItemInfo version="2.0" xmlns=""&gt;
      &lt;item&gt;
        &lt;gtin&gt;00000000000001&lt;/gtin&gt;
        &lt;informationProviderGLN&gt;0000000000001&lt;/informationProviderGLN&gt;
        &lt;internalId&gt;24008&lt;/internalId&gt;
        &lt;state&gt;RELEASED&lt;/state&gt;
        &lt;lastStateModifiedDate&gt;0001-01-01T00:00:00&lt;/lastStateModifiedDate&gt;
        &lt;internalProductDescription&gt;Example&lt;/internalProductDescription&gt;
        &lt;effectiveDate&gt;2018-06-20T14:25:09&lt;/effectiveDate&gt;
        &lt;globalAttributes&gt;
          &lt;productType&gt;EA&lt;/productType&gt;
          &lt;globalClassificationCategory&gt;
            &lt;code&gt;3213213213&lt;/code&gt;
          &lt;/globalClassificationCategory&gt;
          &lt;gtinNameList&gt;
            &lt;gtinName lang="en"&gt;Example&lt;/gtinName&gt;
          &lt;/gtinNameList&gt;
          &lt;brandName&gt;Example&lt;/brandName&gt;
          &lt;brandOwnerGLN&gt;000010001010&lt;/brandOwnerGLN&gt;
          &lt;netContentList&gt;
            &lt;netContent uom="EA"&gt;1&lt;/netContent&gt;
          &lt;/netContentList&gt;
          &lt;totalQuantityOfNextLowerTradeItem&gt;1&lt;/totalQuantityOfNextLowerTradeItem&gt;
          &lt;isBaseUnit&gt;Yes&lt;/isBaseUnit&gt;
          &lt;isConsumerUnit&gt;Yes&lt;/isConsumerUnit&gt;
          &lt;isVariableWeightItem&gt;No&lt;/isVariableWeightItem&gt;
        &lt;/globalAttributes&gt;
        &lt;targetMarketList&gt;
          &lt;targetMarketAttributes&gt;
            &lt;targetMarket&gt;US&lt;/targetMarket&gt;
            &lt;alternateItemIdentificationList&gt;
              &lt;alternateItemIdentification&gt;
                &lt;agency&gt;Example&lt;/agency&gt;
                &lt;id&gt;31321&lt;/id&gt;
              &lt;/alternateItemIdentification&gt;
              &lt;alternateItemIdentification&gt;
                &lt;agency&gt;Example&lt;/agency&gt;
                &lt;id&gt;1&lt;/id&gt;
              &lt;/alternateItemIdentification&gt;
            &lt;/alternateItemIdentificationList&gt;
            &lt;shortDescriptionList&gt;
              &lt;shortDescription lang="en"&gt;Example&lt;/shortDescription&gt;
            &lt;/shortDescriptionList&gt;
            &lt;productDescriptionList&gt;
              &lt;productDescription lang="en"&gt;Example&lt;/productDescription&gt;
            &lt;/productDescriptionList&gt;
            &lt;additionalDescriptionList&gt;
              &lt;additionalDescription lang="en"&gt;Example&lt;/additionalDescription&gt;
            &lt;/additionalDescriptionList&gt;
            &lt;isDispatchUnitList&gt;
              &lt;isDispatchUnit&gt;No&lt;/isDispatchUnit&gt;
            &lt;/isDispatchUnitList&gt;
            &lt;isInvoiceUnitList&gt;
              &lt;isInvoiceUnit&gt;No&lt;/isInvoiceUnit&gt;
            &lt;/isInvoiceUnitList&gt;
            &lt;isOrderableUnitList&gt;
              &lt;isOrderableUnit&gt;No&lt;/isOrderableUnit&gt;
            &lt;/isOrderableUnitList&gt;
            &lt;packagingMarkedReturnable&gt;No&lt;/packagingMarkedReturnable&gt;
            &lt;minimumTradeItemLifespanFromProductionList&gt;
              &lt;minimumTradeItemLifespanFromProduction&gt;1825&lt;/minimumTradeItemLifespanFromProduction&gt;
            &lt;/minimumTradeItemLifespanFromProductionList&gt;
            &lt;nonGTINPalletHi&gt;0&lt;/nonGTINPalletHi&gt;
            &lt;nonGTINPalletTi&gt;0&lt;/nonGTINPalletTi&gt;
            &lt;numberOfItemsPerPallet&gt;0&lt;/numberOfItemsPerPallet&gt;
            &lt;hasBatchNumber&gt;Yes&lt;/hasBatchNumber&gt;
            &lt;productMarkedRecyclable&gt;No&lt;/productMarkedRecyclable&gt;
            &lt;depth uom="in"&gt;12&lt;/depth&gt;
            &lt;height uom="in"&gt;8&lt;/height&gt;
            &lt;width uom="in"&gt;12&lt;/width&gt;
            &lt;grossWeight uom="lb"&gt;0.3213&lt;/grossWeight&gt;
            &lt;netWeight uom="lb"&gt;0.3213&lt;/netWeight&gt;
            &lt;totalUnitsPerCase&gt;1&lt;/totalUnitsPerCase&gt;
            &lt;preDefinedFlex&gt;
              &lt;alternateClassificationList&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;Example&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;Example&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;Example&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;Example&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;Example&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
              &lt;/alternateClassificationList&gt;
              &lt;brandOwnerAdditionalTradeItemIdentificationList&gt;
                &lt;brandOwnerAdditionalTradeItemIdentification&gt;
                  &lt;brandOwnerAdditionalIdType&gt;Example&lt;/brandOwnerAdditionalIdType&gt;
                  &lt;brandOwnerAdditionalIdValue&gt;Example&lt;/brandOwnerAdditionalIdValue&gt;
                &lt;/brandOwnerAdditionalTradeItemIdentification&gt;
              &lt;/brandOwnerAdditionalTradeItemIdentificationList&gt;
              &lt;consumerSalesConditionList&gt;
                &lt;consumerSalesCondition&gt;FALSE&lt;/consumerSalesCondition&gt;
              &lt;/consumerSalesConditionList&gt;
              &lt;countryOfOriginList&gt;
                &lt;countryOfOrigin&gt;US&lt;/countryOfOrigin&gt;
              &lt;/countryOfOriginList&gt;
              &lt;dataCarrierList&gt;
                &lt;dataCarrierTypeCode&gt;Example&lt;/dataCarrierTypeCode&gt;
              &lt;/dataCarrierList&gt;
              &lt;donationIdentificationNumberMarked&gt;No&lt;/donationIdentificationNumberMarked&gt;
              &lt;doesTradeItemContainLatex&gt;No&lt;/doesTradeItemContainLatex&gt;
              &lt;exemptFromFDAPreMarketAuthorization&gt;No&lt;/exemptFromFDAPreMarketAuthorization&gt;
              &lt;fDA510KPremarketAuthorization&gt;Example&lt;/fDA510KPremarketAuthorization&gt;
              &lt;fDAMedicalDeviceListingList&gt;
                &lt;fDAMedicalDeviceListing&gt;Example&lt;/fDAMedicalDeviceListing&gt;
              &lt;/fDAMedicalDeviceListingList&gt;
              &lt;gs1TradeItemIdentificationKey&gt;
                &lt;code&gt;Example&lt;/code&gt;
                &lt;value&gt;14&lt;/value&gt;
              &lt;/gs1TradeItemIdentificationKey&gt;
              &lt;isTradeItemManagedByManufactureDate&gt;true&lt;/isTradeItemManagedByManufactureDate&gt;
              &lt;manufacturerList&gt;
                &lt;manufacturer&gt;
                  &lt;gln&gt;0100000000000&lt;/gln&gt;
                &lt;/manufacturer&gt;
              &lt;/manufacturerList&gt;
              &lt;manufacturerDeclaredReusabilityType&gt;SINGLE_USE&lt;/manufacturerDeclaredReusabilityType&gt;
              &lt;mRICompatibilityCode&gt;UNSPECIFIED&lt;/mRICompatibilityCode&gt;
              &lt;serialNumberLocationCodeList&gt;
                &lt;serialNumberLocationCode&gt;NOT_MARKED&lt;/serialNumberLocationCode&gt;
              &lt;/serialNumberLocationCodeList&gt;
              &lt;tradeChannelList&gt;
                &lt;tradeChannel&gt;Example&lt;/tradeChannel&gt;
              &lt;/tradeChannelList&gt;
              &lt;tradeItemContactInfoList&gt;
                &lt;tradeItemContactInfo&gt;
                  &lt;availableTime lang="en"&gt;2019-02-08T00:00:00&lt;/availableTime&gt;
                  &lt;contactInfoGLN&gt;0000000000002&lt;/contactInfoGLN&gt;
                  &lt;contactType&gt;ABC&lt;/contactType&gt;
                  &lt;targetMarketCommunicationChannel&gt;
                    &lt;communicationChannelList&gt;
                      &lt;communicationChannel&gt;
                        &lt;communicationChannelCode&gt;TELEPHONE&lt;/communicationChannelCode&gt;
                      &lt;/communicationChannel&gt;
                    &lt;/communicationChannelList&gt;
                  &lt;/targetMarketCommunicationChannel&gt;
                &lt;/tradeItemContactInfo&gt;
              &lt;/tradeItemContactInfoList&gt;
              &lt;uDIDDeviceCount&gt;1&lt;/uDIDDeviceCount&gt;
            &lt;/preDefinedFlex&gt;
          &lt;/targetMarketAttributes&gt;
          &lt;targetMarketAttributes&gt;
            &lt;targetMarket&gt;CA&lt;/targetMarket&gt;
            &lt;alternateItemIdentificationList&gt;
              &lt;alternateItemIdentification&gt;
                &lt;agency&gt;AB&lt;/agency&gt;
                &lt;id&gt;123245&lt;/id&gt;
              &lt;/alternateItemIdentification&gt;
              &lt;alternateItemIdentification&gt;
                &lt;agency&gt;ABC&lt;/agency&gt;
                &lt;id&gt;1&lt;/id&gt;
              &lt;/alternateItemIdentification&gt;
            &lt;/alternateItemIdentificationList&gt;
            &lt;shortDescriptionList&gt;
              &lt;shortDescription lang="en"&gt;Something&lt;/shortDescription&gt;
            &lt;/shortDescriptionList&gt;
            &lt;productDescriptionList&gt;
              &lt;productDescription lang="en"&gt;Something&lt;/productDescription&gt;
            &lt;/productDescriptionList&gt;
            &lt;isDispatchUnitList&gt;
              &lt;isDispatchUnit&gt;No&lt;/isDispatchUnit&gt;
            &lt;/isDispatchUnitList&gt;
            &lt;isInvoiceUnitList&gt;
              &lt;isInvoiceUnit&gt;No&lt;/isInvoiceUnit&gt;
            &lt;/isInvoiceUnitList&gt;
            &lt;isOrderableUnitList&gt;
              &lt;isOrderableUnit&gt;No&lt;/isOrderableUnit&gt;
            &lt;/isOrderableUnitList&gt;
            &lt;packagingMarkedReturnable&gt;No&lt;/packagingMarkedReturnable&gt;
            &lt;minimumTradeItemLifespanFromProductionList&gt;
              &lt;minimumTradeItemLifespanFromProduction&gt;1234&lt;/minimumTradeItemLifespanFromProduction&gt;
            &lt;/minimumTradeItemLifespanFromProductionList&gt;
            &lt;nonGTINPalletHi&gt;0&lt;/nonGTINPalletHi&gt;
            &lt;nonGTINPalletTi&gt;0&lt;/nonGTINPalletTi&gt;
            &lt;numberOfItemsPerPallet&gt;0&lt;/numberOfItemsPerPallet&gt;
            &lt;hasBatchNumber&gt;Yes&lt;/hasBatchNumber&gt;
            &lt;productMarkedRecyclable&gt;No&lt;/productMarkedRecyclable&gt;
            &lt;depth uom="in"&gt;1&lt;/depth&gt;
            &lt;height uom="in"&gt;1&lt;/height&gt;
            &lt;width uom="in"&gt;1&lt;/width&gt;
            &lt;grossWeight uom="lb"&gt;0.3&lt;/grossWeight&gt;
            &lt;netWeight uom="lb"&gt;0.2&lt;/netWeight&gt;
            &lt;totalUnitsPerCase&gt;1&lt;/totalUnitsPerCase&gt;
            &lt;unitsPerConsumerUnit&gt;1&lt;/unitsPerConsumerUnit&gt;
            &lt;preDefinedFlex&gt;
              &lt;alternateClassificationList&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;1234657&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;M000&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;K000000&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;acb&lt;/code&gt;
                  &lt;scheme&gt;Example&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
                &lt;alternateClassification&gt;
                  &lt;code&gt;12346&lt;/code&gt;
                  &lt;scheme&gt;XXXX&lt;/scheme&gt;
                &lt;/alternateClassification&gt;
              &lt;/alternateClassificationList&gt;
              &lt;brandOwnerAdditionalTradeItemIdentificationList&gt;
                &lt;brandOwnerAdditionalTradeItemIdentification&gt;
                  &lt;brandOwnerAdditionalIdType&gt;XXXX&lt;/brandOwnerAdditionalIdType&gt;
                  &lt;brandOwnerAdditionalIdValue&gt;100000000&lt;/brandOwnerAdditionalIdValue&gt;
                &lt;/brandOwnerAdditionalTradeItemIdentification&gt;
              &lt;/brandOwnerAdditionalTradeItemIdentificationList&gt;
              &lt;canadaSpecificAttributes&gt;
                &lt;operatorDescriptionList&gt;
                  &lt;operatorDescription lang="en"&gt;"Sample"&lt;/operatorDescription&gt;
                &lt;/operatorDescriptionList&gt;
              &lt;/canadaSpecificAttributes&gt;
              &lt;consumerSalesConditionList&gt;
                &lt;consumerSalesCondition&gt;FALSE&lt;/consumerSalesCondition&gt;
              &lt;/consumerSalesConditionList&gt;
              &lt;countryOfOriginList&gt;
                &lt;countryOfOrigin&gt;US&lt;/countryOfOrigin&gt;
              &lt;/countryOfOriginList&gt;
              &lt;dataCarrierList&gt;
                &lt;dataCarrierTypeCode&gt;128&lt;/dataCarrierTypeCode&gt;
              &lt;/dataCarrierList&gt;
              &lt;donationIdentificationNumberMarked&gt;No&lt;/donationIdentificationNumberMarked&gt;
              &lt;doesTradeItemContainLatex&gt;No&lt;/doesTradeItemContainLatex&gt;
              &lt;exemptFromFDAPreMarketAuthorization&gt;No&lt;/exemptFromFDAPreMarketAuthorization&gt;
              &lt;fDA510KPremarketAuthorization&gt;K000000&lt;/fDA510KPremarketAuthorization&gt;
              &lt;fDAMedicalDeviceListingList&gt;
                &lt;fDAMedicalDeviceListing&gt;D000000&lt;/fDAMedicalDeviceListing&gt;
              &lt;/fDAMedicalDeviceListingList&gt;
              &lt;gs1TradeItemIdentificationKey&gt;
                &lt;code&gt;Code&lt;/code&gt;
                &lt;value&gt;14&lt;/value&gt;
              &lt;/gs1TradeItemIdentificationKey&gt;
              &lt;isTradeItemManagedByManufactureDate&gt;true&lt;/isTradeItemManagedByManufactureDate&gt;
              &lt;manufacturerList&gt;
                &lt;manufacturer&gt;
                  &lt;gln&gt;0100000000000&lt;/gln&gt;
                &lt;/manufacturer&gt;
              &lt;/manufacturerList&gt;
              &lt;manufacturerDeclaredReusabilityType&gt;SINGLE_USE&lt;/manufacturerDeclaredReusabilityType&gt;
              &lt;mRICompatibilityCode&gt;UNSPECIFIED&lt;/mRICompatibilityCode&gt;
              &lt;serialNumberLocationCodeList&gt;
                &lt;serialNumberLocationCode&gt;NOT_MARKED&lt;/serialNumberLocationCode&gt;
              &lt;/serialNumberLocationCodeList&gt;
              &lt;tradeChannelList&gt;
                &lt;tradeChannel&gt;TradeChanngelExample&lt;/tradeChannel&gt;
              &lt;/tradeChannelList&gt;
              &lt;tradeItemContactInfoList&gt;
                &lt;tradeItemContactInfo&gt;
                  &lt;availableTime lang="en"&gt;2019-02-08T00:00:00&lt;/availableTime&gt;
                  &lt;contactInfoGLN&gt;0000000000002&lt;/contactInfoGLN&gt;
                  &lt;contactType&gt;CYC&lt;/contactType&gt;
                  &lt;targetMarketCommunicationChannel&gt;
                    &lt;communicationChannelList&gt;
                      &lt;communicationChannel&gt;
                        &lt;communicationChannelCode&gt;TELEPHONE&lt;/communicationChannelCode&gt;
                      &lt;/communicationChannel&gt;
                    &lt;/communicationChannelList&gt;
                  &lt;/targetMarketCommunicationChannel&gt;
                &lt;/tradeItemContactInfo&gt;
              &lt;/tradeItemContactInfoList&gt;
              &lt;tradeItemMarketingMessageList&gt;
                &lt;tradeItemMarketingMessage lang="en"&gt;"SampleMessage"&lt;/tradeItemMarketingMessage&gt;
              &lt;/tradeItemMarketingMessageList&gt;
              &lt;uDIDDeviceCount&gt;1&lt;/uDIDDeviceCount&gt;
            &lt;/preDefinedFlex&gt;
          &lt;/targetMarketAttributes&gt;
        &lt;/targetMarketList&gt;
      &lt;/item&gt;
    &lt;/GTINItemInfo&gt;
  &lt;/GTINItemInfoProxy&gt;
  </code></pre>
  
  <p>I am not tied to using the xslt method but I dont really know of a better way.</p>
  
  <pre><code>        XslCompiledTransform transform = new XslCompiledTransform();
  
          XsltSettings xsltSettings = new XsltSettings();
          xsltSettings.EnableDocumentFunction = true;
  
          transform.Load("XML_Flatten.xslt", xsltSettings, null);
  
          System.IO.File.Delete(@"C:\Testing\sourceFile_Flat.csv");
          transform.Transform(@"C:\Testing\sourceFile.XML", 
          @"C:\Testing\sourceFile_Flat.csv");
  </code></pre>
  
  <p>This is an example of what I have tried for the xslt
           
            </p>
  
  <pre><code>      &lt;xsl:strip-space elements="*" /&gt;
  
        &lt;xsl:template match="/*/child::*"&gt;
          &lt;xsl:for-each select="child::*"&gt;
            &lt;xsl:if test="position() != last()"&gt;
              "&lt;xsl:value-of select="normalize-space(.)"/&gt;",
            &lt;/xsl:if&gt;
            &lt;xsl:if test="position()  = last()"&gt;
              "&lt;xsl:value-of select="normalize-space(.)"/&gt;"&lt;xsl:text&gt;&amp;#xD;&lt;/xsl:text&gt;
            &lt;/xsl:if&gt;
          &lt;/xsl:for-each&gt;
        &lt;/xsl:template&gt;
  
      &lt;/xsl:stylesheet&gt;
  </code></pre>
  
  <p>What I am trying to accomplish is the output of the CSV to be flattened.
  similar to the result here.
  <a href="http://convertcsv.com/xml-to-csv.htm" rel="nofollow noreferrer">http://convertcsv.com/xml-to-csv.htm</a></p>
  
  <p>I would love to have the column names match the XML tags.  but thats a bonus.</p>
  
  <p>Here is the format that I would expect.
  <a href="https://pastebin.com/G7M08dj6" rel="nofollow noreferrer">https://pastebin.com/G7M08dj6</a></p>
  
  <pre><code>targetMarket,alternateItemIdentificationList/alternateItemIdentification/0/agency,alternateItemIdentificationList/alternateItemIdentification/0/id,alternateItemIdentificationList/alternateItemIdentification/1/agency,alternateItemIdentificationList/alternateItemIdentification/1/id,shortDescriptionList/shortDescription/_lang,shortDescriptionList/shortDescription/__text,productDescriptionList/productDescription/_lang,productDescriptionList/productDescription/__text,additionalDescriptionList/additionalDescription/_lang,additionalDescriptionList/additionalDescription/__text,isDispatchUnitList/isDispatchUnit,isInvoiceUnitList/isInvoiceUnit,isOrderableUnitList/isOrderableUnit,packagingMarkedReturnable,minimumTradeItemLifespanFromProductionList/minimumTradeItemLifespanFromProduction,nonGTINPalletHi,nonGTINPalletTi,numberOfItemsPerPallet,hasBatchNumber,productMarkedRecyclable,depth/_uom,depth/__text,height/_uom,height/__text,width/_uom,width/__text,grossWeight/_uom,grossWeight/__text,netWeight/_uom,netWeight/__text,totalUnitsPerCase,preDefinedFlex/alternateClassificationList/alternateClassification/0/code,preDefinedFlex/alternateClassificationList/alternateClassification/0/scheme,preDefinedFlex/alternateClassificationList/alternateClassification/1/code,preDefinedFlex/alternateClassificationList/alternateClassification/1/scheme,preDefinedFlex/alternateClassificationList/alternateClassification/2/code,preDefinedFlex/alternateClassificationList/alternateClassification/2/scheme,preDefinedFlex/alternateClassificationList/alternateClassification/3/code,preDefinedFlex/alternateClassificationList/alternateClassification/3/scheme,preDefinedFlex/alternateClassificationList/alternateClassification/4/code,preDefinedFlex/alternateClassificationList/alternateClassification/4/scheme,preDefinedFlex/brandOwnerAdditionalTradeItemIdentificationList/brandOwnerAdditionalTradeItemIdentification/brandOwnerAdditionalIdType,preDefinedFlex/brandOwnerAdditionalTradeItemIdentificationList/brandOwnerAdditionalTradeItemIdentification/brandOwnerAdditionalIdValue,preDefinedFlex/consumerSalesConditionList/consumerSalesCondition,preDefinedFlex/countryOfOriginList/countryOfOrigin,preDefinedFlex/dataCarrierList/dataCarrierTypeCode,preDefinedFlex/donationIdentificationNumberMarked,preDefinedFlex/doesTradeItemContainLatex,preDefinedFlex/exemptFromFDAPreMarketAuthorization,preDefinedFlex/fDA510KPremarketAuthorization,preDefinedFlex/fDAMedicalDeviceListingList/fDAMedicalDeviceListing,preDefinedFlex/gs1TradeItemIdentificationKey/code,preDefinedFlex/gs1TradeItemIdentificationKey/value,preDefinedFlex/isTradeItemManagedByManufactureDate,preDefinedFlex/manufacturerList/manufacturer/gln,preDefinedFlex/manufacturerDeclaredReusabilityType,preDefinedFlex/mRICompatibilityCode,preDefinedFlex/serialNumberLocationCodeList/serialNumberLocationCode,preDefinedFlex/tradeChannelList/tradeChannel,preDefinedFlex/tradeItemContactInfoList/tradeItemContactInfo/availableTime/_lang,preDefinedFlex/tradeItemContactInfoList/tradeItemContactInfo/availableTime/__text,preDefinedFlex/tradeItemContactInfoList/tradeItemContactInfo/contactInfoGLN,preDefinedFlex/tradeItemContactInfoList/tradeItemContactInfo/contactType,preDefinedFlex/tradeItemContactInfoList/tradeItemContactInfo/targetMarketCommunicationChannel/communicationChannelList/communicationChannel/communicationChannelCode,preDefinedFlex/uDIDDeviceCount,unitsPerConsumerUnit,preDefinedFlex/canadaSpecificAttributes/operatorDescriptionList/operatorDescription/_lang,preDefinedFlex/canadaSpecificAttributes/operatorDescriptionList/operatorDescription/__text,preDefinedFlex/tradeItemMarketingMessageList/tradeItemMarketingMessage/_lang,preDefinedFlex/tradeItemMarketingMessageList/tradeItemMarketingMessage/__text
  US,Example,31321,Example,1,en,Example,en,Example,en,Example,No,No,No,No,1825,0,0,0,Yes,No,in,12,in,8,in,12,lb,0.3213,lb,0.3213,1,Example,Example,Example,Example,Example,Example,Example,Example,Example,Example,Example,Example,FALSE,US,Example,No,No,No,Example,Example,Example,14,true,0100000000000,SINGLE_USE,UNSPECIFIED,NOT_MARKED,Example,en,2019-02-08T00:00:00,0000000000002,ABC,TELEPHONE,1,,,,,
  CA,AB,123245,ABC,1,en,Something,en,Something,,,No,No,No,No,1234,0,0,0,Yes,No,in,1,in,1,in,1,lb,0.3,lb,0.2,1,1234657,Example,M000,Example,K000000,Example,acb,Example,12346,XXXX,XXXX,100000000,FALSE,US,128,No,No,No,K000000,D000000,Code,14,true,0100000000000,SINGLE_USE,UNSPECIFIED,NOT_MARKED,TradeChanngelExample,en,2019-02-08T00:00:00,0000000000002,CYC,TELEPHONE,1,1,en,"""Sample""",en,"""SampleMessage"""
  </code></pre>