9 Replies Latest reply on Apr 4, 2014 7:26 AM by BluShadow

    External Table for XML import

    San

      Hi Guys,

       

      I am using Oracle 10 g and i am trying import XML file using External table.

       

      My XML Contains

       

      <Dealer>
        <Id>10004</Id> 
        <InternalId xsi:nil="true" /> 
        <LegalName xsi:nil="true" /> 
      </dealer>
      

       

      How i need to handle Internal id and leagalname in Extrenal table create script since it doesnt have end tag.

       

      Could some one please help me out

       

       

      Cheers,

      San In

        • 1. Re: External Table for XML import
          BluShadow

          You would be better off reading the file as a CLOB, doing a quick conversion of datatype to XMLTYPE, and then using XMLTABLE witihn SQL to process the XML.

          You'll just make things harder for yourself by using External Tables for this requirement.

           

          Plus, if the XML you're handling is expected to be large, and the process something you need to do often, consider using the XMLDB (possibly with a Registered XML Schema) to automatically shred the XML into tables.

           

          Look at the examples mdrake posted on this thread:

           

          Re: XML file processing into oracle

          1 person found this helpful
          • 2. Re: External Table for XML import
            San

            Thanks for your quick response.

             

            Even i am trying XMLTABLE Since very new to this trying understand , Yes i agree file size is 1.5 Gb many child nodes are present in the file

             

            For sample i have created one , but bad luck its gives error.

             

              CREATE OR REPLACE VIEW shan_v AS

            SELECT *

            FROM XMLTable('/Dealer'

                    PASSING XMLTYPE(

                             bfilename('DEV_CSG_DIR','dealer2.xml')

                            , nls_charset_id('AL32UTF8')

                            )

                            columns id           varchar2(10) path 'Id'

                    --,               dbaname     varchar2(30) path 'DbaName'

                   );

            Here with i have posted a record from my XML file

             

            1. <?xml version="1.0" encoding="UTF-8" ?>  
            2. - <Dealers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            3. - <Dealer> 
            4.   <Id>10004</Id>  
            5.   <InternalId xsi:nil="true" />  
            6.   <LegalName xsi:nil="true" />  
            7.   <DbaName>A-P SUPER SERVICE, INC.</DbaName>  
            8.   <Client>ALLY</Client>  
            9.   <Frequency>30</Frequency>  
            10.   <OutstandingBalance>705354.00</OutstandingBalance>  
            11.   <Active>true</Active>  
            12.   <GroupId xsi:nil="true" />  
            13.   <Tag>07</Tag>  
            14.   <SecurityContext>045</SecurityContext>  
            15.   <CreditLimit xsi:nil="true" />  
            16.   <RiskRating>8+</RiskRating>  
            17.   <Comment xsi:nil="true" />  
            18. - <PrimaryAccountManager> 
            19.   <Id>01</Id>  
            20.   <InternalId xsi:nil="true" />  
            21.   <Name>UNKNOWN</Name>  
            22.   <Title xsi:nil="true" />  
            23.   <BusinessPhone xsi:nil="true" />  
            24.   <CellPhone xsi:nil="true" />  
            25.   <Email xsi:nil="true" />  
            26.   </PrimaryAccountManager> 
            27.   <SecondaryAccountManagers xsi:nil="true" />  
            28. - <PrimaryLocation> 
            29.   <Id>01</Id>  
            30.   <InternalId xsi:nil="true" />  
            31.   <Name>A-P SUPER SERVICE, INC.</Name>  
            32.   <Address1>338 N THIRD ST</Address1>  
            33.   <Address2 xsi:nil="true" />  
            34.   <City>ROGERS CITY</City>  
            35.   <State>MI</State>  
            36.   <Zip>49779</Zip>  
            37.   <County xsi:nil="true" />  
            38.   <Country xsi:nil="true" />  
            39.   <Latitude xsi:nil="true" />  
            40.   <Longitude xsi:nil="true" />  
            41.   <Phone>9897342941</Phone>  
            42.   <Fax>9897343343</Fax>  
            43. - <PrimaryContact> 
            44.   <Id>01</Id>  
            45.   <InternalId xsi:nil="true" />  
            46.   <Name>UNKNOWN</Name>  
            47.   <Title xsi:nil="true" />  
            48.   <BusinessPhone xsi:nil="true" />  
            49.   <CellPhone xsi:nil="true" />  
            50.   <Email xsi:nil="true" />  
            51.   </PrimaryContact> 
            52.   <SecondaryContacts xsi:nil="true" />  
            53.   </PrimaryLocation> 
            54.   <SecondaryLocations xsi:nil="true" />  
            55. - <Units> 
            56. - <Unit> 
            57.   <Id>1C4NJDEB7ED740827</Id>  
            58.   <InternalId xsi:nil="true" />  
            59.   <SerialNumber>1C4NJDEB7ED740827</SerialNumber>  
            60.   <Year>2014</Year>  
            61.   <Make>JEEP</Make>  
            62.   <Model>COMPASS</Model>  
            63.   <Series xsi:nil="true" />  
            64.   <Color xsi:nil="true" />  
            65.   <Mileage xsi:nil="true" />  
            66.   <LocationId xsi:nil="true" />  
            67.   <StockId xsi:nil="true" />  
            68.   <Description>L</Description>  
            69.   <FloorDate>2014-03-04T00:00:00</FloorDate>  
            70.   <FloorAmount>25344.00</FloorAmount>  
            71.   <OutstandingBalance>25344.00</OutstandingBalance>  
            72.   <InvoiceNumber xsi:nil="true" />  
            73.   <MaturityDate xsi:nil="true" />  
            74.   <PayoffDate xsi:nil="true" />  
            75.   <PreviousStatus xsi:nil="true" />  
            76.   <FloorPlanCode>LT</FloorPlanCode>  
            77.   <Comment xsi:nil="true" />  
            78.   <ProductLine xsi:nil="true" />  
            79.   <ProductLineCategory xsi:nil="true" />  
            80.   <ProductLineDescription xsi:nil="true" />  
            81.   <Curtailments xsi:nil="true" />  
            82. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            83. - <LaunchExtensions xmlns=""> 
            84.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            85.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            86.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            87.   <Item Name="NewUsed" Type="System.String">N</Item>  
            88.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            89.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-20T00:00:00</Item>  
            90.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            91.   </LaunchExtensions> 
            92.   </Custom> 
            93.   </Unit> 
            94. - <Unit> 
            95.   <Id>1C4NJRFB8ED799073</Id>  
            96.   <InternalId xsi:nil="true" />  
            97.   <SerialNumber>1C4NJRFB8ED799073</SerialNumber>  
            98.   <Year>2014</Year>  
            99.   <Make>JEEP</Make>  
            100.   <Model>PATRIOT</Model>  
            101.   <Series xsi:nil="true" />  
            102.   <Color xsi:nil="true" />  
            103.   <Mileage xsi:nil="true" />  
            104.   <LocationId xsi:nil="true" />  
            105.   <StockId xsi:nil="true" />  
            106.   <Description>L</Description>  
            107.   <FloorDate>2014-03-21T00:00:00</FloorDate>  
            108.   <FloorAmount>24172.00</FloorAmount>  
            109.   <OutstandingBalance>24172.00</OutstandingBalance>  
            110.   <InvoiceNumber xsi:nil="true" />  
            111.   <MaturityDate xsi:nil="true" />  
            112.   <PayoffDate xsi:nil="true" />  
            113.   <PreviousStatus xsi:nil="true" />  
            114.   <FloorPlanCode>LT</FloorPlanCode>  
            115.   <Comment xsi:nil="true" />  
            116.   <ProductLine xsi:nil="true" />  
            117.   <ProductLineCategory xsi:nil="true" />  
            118.   <ProductLineDescription xsi:nil="true" />  
            119.   <Curtailments xsi:nil="true" />  
            120. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            121. - <LaunchExtensions xmlns=""> 
            122.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            123.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            124.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            125.   <Item Name="NewUsed" Type="System.String">N</Item>  
            126.   <Item Name="VtmsCode" Type="System.String">42</Item>  
            127.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-21T00:00:00</Item>  
            128.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            129.   </LaunchExtensions> 
            130.   </Custom> 
            131.   </Unit> 
            132. - <Unit> 
            133.   <Id>1C4RDJDG8DC604750</Id>  
            134.   <InternalId xsi:nil="true" />  
            135.   <SerialNumber>1C4RDJDG8DC604750</SerialNumber>  
            136.   <Year>2013</Year>  
            137.   <Make>DODG</Make>  
            138.   <Model>DURANGO</Model>  
            139.   <Series xsi:nil="true" />  
            140.   <Color xsi:nil="true" />  
            141.   <Mileage xsi:nil="true" />  
            142.   <LocationId xsi:nil="true" />  
            143.   <StockId xsi:nil="true" />  
            144.   <Description>L</Description>  
            145.   <FloorDate>2013-10-02T00:00:00</FloorDate>  
            146.   <FloorAmount>27965.00</FloorAmount>  
            147.   <OutstandingBalance>25168.00</OutstandingBalance>  
            148.   <InvoiceNumber xsi:nil="true" />  
            149.   <MaturityDate xsi:nil="true" />  
            150.   <PayoffDate xsi:nil="true" />  
            151.   <PreviousStatus xsi:nil="true" />  
            152.   <FloorPlanCode>FA</FloorPlanCode>  
            153.   <Comment xsi:nil="true" />  
            154.   <ProductLine xsi:nil="true" />  
            155.   <ProductLineCategory xsi:nil="true" />  
            156.   <ProductLineDescription xsi:nil="true" />  
            157.   <Curtailments xsi:nil="true" />  
            158. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            159. - <LaunchExtensions xmlns=""> 
            160.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            161.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            162.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            163.   <Item Name="NewUsed" Type="System.String">U</Item>  
            164.   <Item Name="VtmsCode" Type="System.String" />  
            165.   <Item Name="VtmsDate" Type="System.DateTime" />  
            166.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            167.   </LaunchExtensions> 
            168.   </Custom> 
            169.   </Unit> 
            170. - <Unit> 
            171.   <Id>1C6RR7GGXES144098</Id>  
            172.   <InternalId xsi:nil="true" />  
            173.   <SerialNumber>1C6RR7GGXES144098</SerialNumber>  
            174.   <Year>2014</Year>  
            175.   <Make>RAM</Make>  
            176.   <Model>TRUCK</Model>  
            177.   <Series xsi:nil="true" />  
            178.   <Color xsi:nil="true" />  
            179.   <Mileage xsi:nil="true" />  
            180.   <LocationId xsi:nil="true" />  
            181.   <StockId xsi:nil="true" />  
            182.   <Description>L</Description>  
            183.   <FloorDate>2014-02-27T00:00:00</FloorDate>  
            184.   <FloorAmount>34268.00</FloorAmount>  
            185.   <OutstandingBalance>34268.00</OutstandingBalance>  
            186.   <InvoiceNumber xsi:nil="true" />  
            187.   <MaturityDate xsi:nil="true" />  
            188.   <PayoffDate xsi:nil="true" />  
            189.   <PreviousStatus xsi:nil="true" />  
            190.   <FloorPlanCode>LT</FloorPlanCode>  
            191.   <Comment xsi:nil="true" />  
            192.   <ProductLine xsi:nil="true" />  
            193.   <ProductLineCategory xsi:nil="true" />  
            194.   <ProductLineDescription xsi:nil="true" />  
            195.   <Curtailments xsi:nil="true" />  
            196. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            197. - <LaunchExtensions xmlns=""> 
            198.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            199.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            200.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            201.   <Item Name="NewUsed" Type="System.String">N</Item>  
            202.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            203.   <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item>  
            204.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            205.   </LaunchExtensions> 
            206.   </Custom> 
            207.   </Unit> 
            208. - <Unit> 
            209.   <Id>1C6RR7GT1ES219073</Id>  
            210.   <InternalId xsi:nil="true" />  
            211.   <SerialNumber>1C6RR7GT1ES219073</SerialNumber>  
            212.   <Year>2014</Year>  
            213.   <Make>RAM</Make>  
            214.   <Model>TRUCK</Model>  
            215.   <Series xsi:nil="true" />  
            216.   <Color xsi:nil="true" />  
            217.   <Mileage xsi:nil="true" />  
            218.   <LocationId xsi:nil="true" />  
            219.   <StockId xsi:nil="true" />  
            220.   <Description>L</Description>  
            221.   <FloorDate>2013-11-27T00:00:00</FloorDate>  
            222.   <FloorAmount>39863.00</FloorAmount>  
            223.   <OutstandingBalance>39863.00</OutstandingBalance>  
            224.   <InvoiceNumber xsi:nil="true" />  
            225.   <MaturityDate xsi:nil="true" />  
            226.   <PayoffDate xsi:nil="true" />  
            227.   <PreviousStatus xsi:nil="true" />  
            228.   <FloorPlanCode>LT</FloorPlanCode>  
            229.   <Comment xsi:nil="true" />  
            230.   <ProductLine xsi:nil="true" />  
            231.   <ProductLineCategory xsi:nil="true" />  
            232.   <ProductLineDescription xsi:nil="true" />  
            233.   <Curtailments xsi:nil="true" />  
            234. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            235. - <LaunchExtensions xmlns=""> 
            236.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            237.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            238.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            239.   <Item Name="NewUsed" Type="System.String">N</Item>  
            240.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            241.   <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item>  
            242.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            243.   </LaunchExtensions> 
            244.   </Custom> 
            245.   </Unit> 
            246. - <Unit> 
            247.   <Id>1C6RR7KT7ES312137</Id>  
            248.   <InternalId xsi:nil="true" />  
            249.   <SerialNumber>1C6RR7KT7ES312137</SerialNumber>  
            250.   <Year>2014</Year>  
            251.   <Make>RAM</Make>  
            252.   <Model>TRUCK</Model>  
            253.   <Series xsi:nil="true" />  
            254.   <Color xsi:nil="true" />  
            255.   <Mileage xsi:nil="true" />  
            256.   <LocationId xsi:nil="true" />  
            257.   <StockId xsi:nil="true" />  
            258.   <Description>L</Description>  
            259.   <FloorDate>2014-03-07T00:00:00</FloorDate>  
            260.   <FloorAmount>37962.00</FloorAmount>  
            261.   <OutstandingBalance>37962.00</OutstandingBalance>  
            262.   <InvoiceNumber xsi:nil="true" />  
            263.   <MaturityDate xsi:nil="true" />  
            264.   <PayoffDate xsi:nil="true" />  
            265.   <PreviousStatus xsi:nil="true" />  
            266.   <FloorPlanCode>LT</FloorPlanCode>  
            267.   <Comment xsi:nil="true" />  
            268.   <ProductLine xsi:nil="true" />  
            269.   <ProductLineCategory xsi:nil="true" />  
            270.   <ProductLineDescription xsi:nil="true" />  
            271.   <Curtailments xsi:nil="true" />  
            272. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            273. - <LaunchExtensions xmlns=""> 
            274.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            275.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            276.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            277.   <Item Name="NewUsed" Type="System.String">N</Item>  
            278.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            279.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-24T00:00:00</Item>  
            280.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            281.   </LaunchExtensions> 
            282.   </Custom> 
            283.   </Unit> 
            284. - <Unit> 
            285.   <Id>2A8HR54P08R749355</Id>  
            286.   <InternalId xsi:nil="true" />  
            287.   <SerialNumber>2A8HR54P08R749355</SerialNumber>  
            288.   <Year>2008</Year>  
            289.   <Make>CHRY</Make>  
            290.   <Model>TOWN COUNTRY</Model>  
            291.   <Series xsi:nil="true" />  
            292.   <Color xsi:nil="true" />  
            293.   <Mileage xsi:nil="true" />  
            294.   <LocationId xsi:nil="true" />  
            295.   <StockId xsi:nil="true" />  
            296.   <Description>L</Description>  
            297.   <FloorDate>2013-12-02T00:00:00</FloorDate>  
            298.   <FloorAmount>8435.00</FloorAmount>  
            299.   <OutstandingBalance>8435.00</OutstandingBalance>  
            300.   <InvoiceNumber xsi:nil="true" />  
            301.   <MaturityDate xsi:nil="true" />  
            302.   <PayoffDate xsi:nil="true" />  
            303.   <PreviousStatus xsi:nil="true" />  
            304.   <FloorPlanCode>U</FloorPlanCode>  
            305.   <Comment xsi:nil="true" />  
            306.   <ProductLine xsi:nil="true" />  
            307.   <ProductLineCategory xsi:nil="true" />  
            308.   <ProductLineDescription xsi:nil="true" />  
            309.   <Curtailments xsi:nil="true" />  
            310. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            311. - <LaunchExtensions xmlns=""> 
            312.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            313.   <Item Name="SecondaryCode" Type="System.String" />  
            314.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            315.   <Item Name="NewUsed" Type="System.String">U</Item>  
            316.   <Item Name="VtmsCode" Type="System.String" />  
            317.   <Item Name="VtmsDate" Type="System.DateTime" />  
            318.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            319.   </LaunchExtensions> 
            320.   </Custom> 
            321.   </Unit> 
            322. - <Unit> 
            323.   <Id>2C3CCACG3CH142608</Id>  
            324.   <InternalId xsi:nil="true" />  
            325.   <SerialNumber>2C3CCACG3CH142608</SerialNumber>  
            326.   <Year>2012</Year>  
            327.   <Make>CHRY</Make>  
            328.   <Model>300</Model>  
            329.   <Series xsi:nil="true" />  
            330.   <Color xsi:nil="true" />  
            331.   <Mileage xsi:nil="true" />  
            332.   <LocationId xsi:nil="true" />  
            333.   <StockId xsi:nil="true" />  
            334.   <Description>C</Description>  
            335.   <FloorDate>2013-12-02T00:00:00</FloorDate>  
            336.   <FloorAmount>14840.00</FloorAmount>  
            337.   <OutstandingBalance>14840.00</OutstandingBalance>  
            338.   <InvoiceNumber xsi:nil="true" />  
            339.   <MaturityDate xsi:nil="true" />  
            340.   <PayoffDate xsi:nil="true" />  
            341.   <PreviousStatus xsi:nil="true" />  
            342.   <FloorPlanCode>U</FloorPlanCode>  
            343.   <Comment xsi:nil="true" />  
            344.   <ProductLine xsi:nil="true" />  
            345.   <ProductLineCategory xsi:nil="true" />  
            346.   <ProductLineDescription xsi:nil="true" />  
            347.   <Curtailments xsi:nil="true" />  
            348. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            349. - <LaunchExtensions xmlns=""> 
            350.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            351.   <Item Name="SecondaryCode" Type="System.String" />  
            352.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            353.   <Item Name="NewUsed" Type="System.String">U</Item>  
            354.   <Item Name="VtmsCode" Type="System.String" />  
            355.   <Item Name="VtmsDate" Type="System.DateTime" />  
            356.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            357.   </LaunchExtensions> 
            358.   </Custom> 
            359.   </Unit> 
            360. - <Unit> 
            361.   <Id>2C4RC1BG2ER236662</Id>  
            362.   <InternalId xsi:nil="true" />  
            363.   <SerialNumber>2C4RC1BG2ER236662</SerialNumber>  
            364.   <Year>2014</Year>  
            365.   <Make>CHRY</Make>  
            366.   <Model>TOWN COUNTRY</Model>  
            367.   <Series xsi:nil="true" />  
            368.   <Color xsi:nil="true" />  
            369.   <Mileage xsi:nil="true" />  
            370.   <LocationId xsi:nil="true" />  
            371.   <StockId xsi:nil="true" />  
            372.   <Description>L</Description>  
            373.   <FloorDate>2013-12-17T00:00:00</FloorDate>  
            374.   <FloorAmount>30636.00</FloorAmount>  
            375.   <OutstandingBalance>30636.00</OutstandingBalance>  
            376.   <InvoiceNumber xsi:nil="true" />  
            377.   <MaturityDate xsi:nil="true" />  
            378.   <PayoffDate xsi:nil="true" />  
            379.   <PreviousStatus xsi:nil="true" />  
            380.   <FloorPlanCode>LT</FloorPlanCode>  
            381.   <Comment xsi:nil="true" />  
            382.   <ProductLine xsi:nil="true" />  
            383.   <ProductLineCategory xsi:nil="true" />  
            384.   <ProductLineDescription xsi:nil="true" />  
            385.   <Curtailments xsi:nil="true" />  
            386. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            387. - <LaunchExtensions xmlns=""> 
            388.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            389.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            390.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            391.   <Item Name="NewUsed" Type="System.String">N</Item>  
            392.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            393.   <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item>  
            394.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            395.   </LaunchExtensions> 
            396.   </Custom> 
            397.   </Unit> 
            398. - <Unit> 
            399.   <Id>2C4RC1BG5DR689365</Id>  
            400.   <InternalId xsi:nil="true" />  
            401.   <SerialNumber>2C4RC1BG5DR689365</SerialNumber>  
            402.   <Year>2013</Year>  
            403.   <Make>CHRY</Make>  
            404.   <Model>TOWN COUNTRY</Model>  
            405.   <Series xsi:nil="true" />  
            406.   <Color xsi:nil="true" />  
            407.   <Mileage xsi:nil="true" />  
            408.   <LocationId xsi:nil="true" />  
            409.   <StockId xsi:nil="true" />  
            410.   <Description>L</Description>  
            411.   <FloorDate>2013-10-02T00:00:00</FloorDate>  
            412.   <FloorAmount>21165.00</FloorAmount>  
            413.   <OutstandingBalance>19048.00</OutstandingBalance>  
            414.   <InvoiceNumber xsi:nil="true" />  
            415.   <MaturityDate xsi:nil="true" />  
            416.   <PayoffDate xsi:nil="true" />  
            417.   <PreviousStatus xsi:nil="true" />  
            418.   <FloorPlanCode>FA</FloorPlanCode>  
            419.   <Comment xsi:nil="true" />  
            420.   <ProductLine xsi:nil="true" />  
            421.   <ProductLineCategory xsi:nil="true" />  
            422.   <ProductLineDescription xsi:nil="true" />  
            423.   <Curtailments xsi:nil="true" />  
            424. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            425. - <LaunchExtensions xmlns=""> 
            426.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            427.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            428.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            429.   <Item Name="NewUsed" Type="System.String">U</Item>  
            430.   <Item Name="VtmsCode" Type="System.String" />  
            431.   <Item Name="VtmsDate" Type="System.DateTime" />  
            432.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            433.   </LaunchExtensions> 
            434.   </Custom> 
            435.   </Unit> 
            436. - <Unit> 
            437.   <Id>3C6JR7DT2EG241740</Id>  
            438.   <InternalId xsi:nil="true" />  
            439.   <SerialNumber>3C6JR7DT2EG241740</SerialNumber>  
            440.   <Year>2014</Year>  
            441.   <Make>RAM</Make>  
            442.   <Model>TRUCK</Model>  
            443.   <Series xsi:nil="true" />  
            444.   <Color xsi:nil="true" />  
            445.   <Mileage xsi:nil="true" />  
            446.   <LocationId xsi:nil="true" />  
            447.   <StockId xsi:nil="true" />  
            448.   <Description>L</Description>  
            449.   <FloorDate>2014-03-26T00:00:00</FloorDate>  
            450.   <FloorAmount>29649.00</FloorAmount>  
            451.   <OutstandingBalance>29649.00</OutstandingBalance>  
            452.   <InvoiceNumber xsi:nil="true" />  
            453.   <MaturityDate xsi:nil="true" />  
            454.   <PayoffDate xsi:nil="true" />  
            455.   <PreviousStatus xsi:nil="true" />  
            456.   <FloorPlanCode>LT</FloorPlanCode>  
            457.   <Comment xsi:nil="true" />  
            458.   <ProductLine xsi:nil="true" />  
            459.   <ProductLineCategory xsi:nil="true" />  
            460.   <ProductLineDescription xsi:nil="true" />  
            461.   <Curtailments xsi:nil="true" />  
            462. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            463. - <LaunchExtensions xmlns=""> 
            464.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            465.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            466.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            467.   <Item Name="NewUsed" Type="System.String">N</Item>  
            468.   <Item Name="VtmsCode" Type="System.String">42</Item>  
            469.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-26T00:00:00</Item>  
            470.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            471.   </LaunchExtensions> 
            472.   </Custom> 
            473.   </Unit> 
            474. - <Unit> 
            475.   <Id>1B3CB3HA6BD106858</Id>  
            476.   <InternalId xsi:nil="true" />  
            477.   <SerialNumber>1B3CB3HA6BD106858</SerialNumber>  
            478.   <Year xsi:nil="true" />  
            479.   <Make xsi:nil="true" />  
            480.   <Model xsi:nil="true" />  
            481.   <Series xsi:nil="true" />  
            482.   <Color xsi:nil="true" />  
            483.   <Mileage xsi:nil="true" />  
            484.   <LocationId xsi:nil="true" />  
            485.   <StockId xsi:nil="true" />  
            486.   <Description />  
            487.   <FloorDate xsi:nil="true" />  
            488.   <FloorAmount>0.00</FloorAmount>  
            489.   <OutstandingBalance>0.00</OutstandingBalance>  
            490.   <InvoiceNumber xsi:nil="true" />  
            491.   <MaturityDate xsi:nil="true" />  
            492.   <PayoffDate>2014-03-26T00:00:00</PayoffDate>  
            493.   <PreviousStatus xsi:nil="true" />  
            494.   <FloorPlanCode xsi:nil="true" />  
            495.   <Comment xsi:nil="true" />  
            496.   <ProductLine xsi:nil="true" />  
            497.   <ProductLineCategory xsi:nil="true" />  
            498.   <ProductLineDescription xsi:nil="true" />  
            499.   <Curtailments xsi:nil="true" />  
            500. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            501. - <LaunchExtensions xmlns=""> 
            502.   <Item Name="IW_DAC_KEY" Type="System.Int32">0</Item>  
            503.   <Item Name="SecondaryCode" Type="System.String" />  
            504.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            505.   <Item Name="NewUsed" Type="System.String">U</Item>  
            506.   <Item Name="VtmsCode" Type="System.String" />  
            507.   <Item Name="VtmsDate" Type="System.DateTime" />  
            508.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            509.   </LaunchExtensions> 
            510.   </Custom> 
            511.   </Unit> 
            512. - <Unit> 
            513.   <Id>1C3CDZCG4DN687530</Id>  
            514.   <InternalId xsi:nil="true" />  
            515.   <SerialNumber>1C3CDZCG4DN687530</SerialNumber>  
            516.   <Year>2013</Year>  
            517.   <Make>DODG</Make>  
            518.   <Model>AVENGER</Model>  
            519.   <Series xsi:nil="true" />  
            520.   <Color xsi:nil="true" />  
            521.   <Mileage xsi:nil="true" />  
            522.   <LocationId xsi:nil="true" />  
            523.   <StockId xsi:nil="true" />  
            524.   <Description>C</Description>  
            525.   <FloorDate>2013-10-30T00:00:00</FloorDate>  
            526.   <FloorAmount>13965.00</FloorAmount>  
            527.   <OutstandingBalance>11171.50</OutstandingBalance>  
            528.   <InvoiceNumber xsi:nil="true" />  
            529.   <MaturityDate xsi:nil="true" />  
            530.   <PayoffDate xsi:nil="true" />  
            531.   <PreviousStatus xsi:nil="true" />  
            532.   <FloorPlanCode>FA</FloorPlanCode>  
            533.   <Comment xsi:nil="true" />  
            534.   <ProductLine xsi:nil="true" />  
            535.   <ProductLineCategory xsi:nil="true" />  
            536.   <ProductLineDescription xsi:nil="true" />  
            537.   <Curtailments xsi:nil="true" />  
            538. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            539. - <LaunchExtensions xmlns=""> 
            540.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            541.   <Item Name="SecondaryCode" Type="System.String" />  
            542.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            543.   <Item Name="NewUsed" Type="System.String">U</Item>  
            544.   <Item Name="VtmsCode" Type="System.String" />  
            545.   <Item Name="VtmsDate" Type="System.DateTime" />  
            546.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            547.   </LaunchExtensions> 
            548.   </Custom> 
            549.   </Unit> 
            550. - <Unit> 
            551.   <Id>1C4PJMCS3EW246710</Id>  
            552.   <InternalId xsi:nil="true" />  
            553.   <SerialNumber>1C4PJMCS3EW246710</SerialNumber>  
            554.   <Year>2014</Year>  
            555.   <Make>JEEP</Make>  
            556.   <Model>CHEROKEE</Model>  
            557.   <Series xsi:nil="true" />  
            558.   <Color xsi:nil="true" />  
            559.   <Mileage xsi:nil="true" />  
            560.   <LocationId xsi:nil="true" />  
            561.   <StockId xsi:nil="true" />  
            562.   <Description>L</Description>  
            563.   <FloorDate>2014-03-21T00:00:00</FloorDate>  
            564.   <FloorAmount>29436.00</FloorAmount>  
            565.   <OutstandingBalance>29436.00</OutstandingBalance>  
            566.   <InvoiceNumber xsi:nil="true" />  
            567.   <MaturityDate xsi:nil="true" />  
            568.   <PayoffDate xsi:nil="true" />  
            569.   <PreviousStatus xsi:nil="true" />  
            570.   <FloorPlanCode>LT</FloorPlanCode>  
            571.   <Comment xsi:nil="true" />  
            572.   <ProductLine xsi:nil="true" />  
            573.   <ProductLineCategory xsi:nil="true" />  
            574.   <ProductLineDescription xsi:nil="true" />  
            575.   <Curtailments xsi:nil="true" />  
            576. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            577. - <LaunchExtensions xmlns=""> 
            578.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            579.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            580.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            581.   <Item Name="NewUsed" Type="System.String">N</Item>  
            582.   <Item Name="VtmsCode" Type="System.String">42</Item>  
            583.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-21T00:00:00</Item>  
            584.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            585.   </LaunchExtensions> 
            586.   </Custom> 
            587.   </Unit> 
            588. - <Unit> 
            589.   <Id>1C4RJFAG3EC477904</Id>  
            590.   <InternalId xsi:nil="true" />  
            591.   <SerialNumber>1C4RJFAG3EC477904</SerialNumber>  
            592.   <Year>2014</Year>  
            593.   <Make>JEEP</Make>  
            594.   <Model>GR CHEROKEE</Model>  
            595.   <Series xsi:nil="true" />  
            596.   <Color xsi:nil="true" />  
            597.   <Mileage xsi:nil="true" />  
            598.   <LocationId xsi:nil="true" />  
            599.   <StockId xsi:nil="true" />  
            600.   <Description>L</Description>  
            601.   <FloorDate>2014-03-24T00:00:00</FloorDate>  
            602.   <FloorAmount>34359.00</FloorAmount>  
            603.   <OutstandingBalance>34359.00</OutstandingBalance>  
            604.   <InvoiceNumber xsi:nil="true" />  
            605.   <MaturityDate xsi:nil="true" />  
            606.   <PayoffDate xsi:nil="true" />  
            607.   <PreviousStatus xsi:nil="true" />  
            608.   <FloorPlanCode>LT</FloorPlanCode>  
            609.   <Comment xsi:nil="true" />  
            610.   <ProductLine xsi:nil="true" />  
            611.   <ProductLineCategory xsi:nil="true" />  
            612.   <ProductLineDescription xsi:nil="true" />  
            613.   <Curtailments xsi:nil="true" />  
            614. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            615. - <LaunchExtensions xmlns=""> 
            616.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            617.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            618.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            619.   <Item Name="NewUsed" Type="System.String">N</Item>  
            620.   <Item Name="VtmsCode" Type="System.String">42</Item>  
            621.   <Item Name="VtmsDate" Type="System.DateTime">2014-03-24T00:00:00</Item>  
            622.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            623.   </LaunchExtensions> 
            624.   </Custom> 
            625.   </Unit> 
            626. - <Unit> 
            627.   <Id>1C6RR7FG7ES142150</Id>  
            628.   <InternalId xsi:nil="true" />  
            629.   <SerialNumber>1C6RR7FG7ES142150</SerialNumber>  
            630.   <Year>2014</Year>  
            631.   <Make>RAM</Make>  
            632.   <Model>TRUCK</Model>  
            633.   <Series xsi:nil="true" />  
            634.   <Color xsi:nil="true" />  
            635.   <Mileage xsi:nil="true" />  
            636.   <LocationId xsi:nil="true" />  
            637.   <StockId xsi:nil="true" />  
            638.   <Description>L</Description>  
            639.   <FloorDate>2013-09-10T00:00:00</FloorDate>  
            640.   <FloorAmount>32138.00</FloorAmount>  
            641.   <OutstandingBalance>32138.00</OutstandingBalance>  
            642.   <InvoiceNumber xsi:nil="true" />  
            643.   <MaturityDate xsi:nil="true" />  
            644.   <PayoffDate xsi:nil="true" />  
            645.   <PreviousStatus xsi:nil="true" />  
            646.   <FloorPlanCode>LT</FloorPlanCode>  
            647.   <Comment xsi:nil="true" />  
            648.   <ProductLine xsi:nil="true" />  
            649.   <ProductLineCategory xsi:nil="true" />  
            650.   <ProductLineDescription xsi:nil="true" />  
            651.   <Curtailments xsi:nil="true" />  
            652. - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/"> 
            653. - <LaunchExtensions xmlns=""> 
            654.   <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item>  
            655.   <Item Name="SecondaryCode" Type="System.String">LT</Item>  
            656.   <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" />  
            657.   <Item Name="NewUsed" Type="System.String">N</Item>  
            658.   <Item Name="VtmsCode" Type="System.String">50</Item>  
            659.   <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item>  
            660.   <Item Name="BarsDeliveryDate" Type="System.DateTime" />  
            661.   </LaunchExtensions> 
            662.   </Custom> 
            663.   </Unit> 
            664. - <Unit> 
            665.   <Id>1C6RR7LG6ES308730</Id