Standard XML Pipeline Example

 

Below is an example of a XML request to update or add an order. The data elements, such as “StartLoad” are listed within the MoversSuite XML schema file: InternalImport.xsd. Download raw source file: XML Internal Import Schema and download this example file through the following link: StandardXMLImportExample.xml.

 

<?xml version="1.0" encoding="utf-8"?>

<MSS:Order xsi:schemaLocation="" OrderSeg="XX12345" PSeg="" OSeg="" SSeg="" EstimateNo="" ExternalVanlineCode="X" xmlns:MSS="MssXsd-InternalImport.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <MSS:StartLoad>2015-06-03</MSS:StartLoad>

    <MSS:FirstName>JOHN</MSS:FirstName>

    <MSS:LastName>SMITH</MSS:LastName>

    <MSS:Email>JSMITH@EWSGROUP.COM</MSS:Email>

    <MSS:FromCounty>MIDDLESEX</MSS:FromCounty>

    <MSS:ToCounty>QUEBEC</MSS:ToCounty>

    <MSS:StartPack>2015-06-01</MSS:StartPack>

    <MSS:StartDeliv>2015-06-07</MSS:StartDeliv>

    <MSS:EndDeliv>2015-06-08</MSS:EndDeliv>

    <MSS:Account>054035001002</MSS:Account>

    <MSS:BookAgent>0207</MSS:BookAgent>

    <MSS:OrgAgent>2189</MSS:OrgAgent>

    <MSS:DestAgent>0547</MSS:DestAgent>

    <MSS:VanlineShipmentStatus>UND</MSS:VanlineShipmentStatus>

    <MSS:Commodity>A</MSS:Commodity>

    <MSS:RatePlan>400N</MSS:RatePlan>

    <MSS:Section>03</MSS:Section>

    <MSS:EstimatedWeight>7892</MSS:EstimatedWeight>

    <MSS:Weight>15000</MSS:Weight>

    <MSS:EstAmt>1993.26</MSS:EstAmt>

    <MSS:Discount>64.20</MSS:Discount>

    <MSS:DiscountLinehaul>1993.26</MSS:DiscountLinehaul>

    <MSS:SitDiscount>543.21</MSS:SitDiscount>

    <MSS:Miles>117</MSS:Miles>

    <MSS:HaulAgent>0214</MSS:HaulAgent>

    <MSS:EndPack>2015-06-02</MSS:EndPack>

    <MSS:EndLoad>2015-06-04</MSS:EndLoad>

    <MSS:BillToName>SWEETNESS EMPLOYMENT INC</MSS:BillToName>

    <MSS:BillToContact>LINDA SNOOK</MSS:BillToContact>

    <MSS:BillToAddress1>% CORP</MSS:BillToAddress1>

    <MSS:BillToAddress2>6400 LIPSCOMB ST</MSS:BillToAddress2>

    <MSS:BillToCity>PALM BAY</MSS:BillToCity>

    <MSS:BillToState>FL</MSS:BillToState>

    <MSS:BillToPostalCode>32905-4512</MSS:BillToPostalCode>

    <MSS:BillToCountryCode>USA</MSS:BillToCountryCode>

    <MSS:PhoneNumbers>

        <MSS:PhoneNumber>

           <MSS:AreaCode>786</MSS:AreaCode>

           <MSS:LocalNumber>555-1951</MSS:LocalNumber>

           <MSS:Extension>123456</MSS:Extension>

           <MSS:Type>Origin Home</MSS:Type>

        </MSS:PhoneNumber>

        <MSS:PhoneNumber>

           <MSS:AreaCode>702</MSS:AreaCode>

           <MSS:LocalNumber>555-1212</MSS:LocalNumber>

           <MSS:Extension>987654</MSS:Extension>

           <MSS:Type>Destination Home</MSS:Type>

        </MSS:PhoneNumber>

    </MSS:PhoneNumbers>

    <MSS:Addresses>

        <MSS:Address>

           <MSS:Address1>999999 VFW PARKWAY</MSS:Address1>

           <MSS:Address2 xsi:nil="1" />

           <MSS:City>CHESTNUT HILL</MSS:City>

           <MSS:State>MA</MSS:State>

           <MSS:PostalCode>02467-9876</MSS:PostalCode>

           <MSS:CountryCode>USA</MSS:CountryCode>

           <MSS:AddressType>Origin</MSS:AddressType>

        </MSS:Address>

        <MSS:Address>

           <MSS:Address1>999999 HARVARD AVENUE</MSS:Address1>

           <MSS:Address2 xsi:nil="1" />

           <MSS:City>MONTREAL</MSS:City>

           <MSS:State>QC</MSS:State>

           <MSS:PostalCode>H4B1A1999</MSS:PostalCode>

           <MSS:CountryCode>CAN</MSS:CountryCode>

           <MSS:AddressType>Destination</MSS:AddressType>

        </MSS:Address>

    </MSS:Addresses>

    <MSS:OrderConsigns>

        <MSS:OrderConsign ConsignType="Origin">

           <MSS:Contact>JOHN SMITH</MSS:Contact>

        </MSS:OrderConsign>

        <MSS:OrderConsign ConsignType="Destination">

           <MSS:Contact>JACK TAYLOR</MSS:Contact>

        </MSS:OrderConsign>

    </MSS:OrderConsigns>

    <MSS:PayType>

        <MSS:VanLineCode>A</MSS:VanLineCode>

    </MSS:PayType>

    <MSS:Valuation>

        <MSS:Amount>90000</MSS:Amount>

        <MSS:VanLineCode>6</MSS:VanLineCode>

    </MSS:Valuation>

    <MSS:OrderEmployees>

        <MSS:OrderEmployee EmployeeType="Coordinator">

           <MSS:UserID>BIBBSIZE</MSS:UserID>    

        </MSS:OrderEmployee>             

        <MSS:OrderEmployee EmployeeType="Driver">

           <MSS:FirstName>CARRIER</MSS:FirstName>

           <MSS:LastName>CAR</MSS:LastName>

           <MSS:VanLineID>9999-4276</MSS:VanLineID>

           <MSS:Agent>0200</MSS:Agent>

        </MSS:OrderEmployee>

        <MSS:OrderEmployee EmployeeType="Salesperson">

           <MSS:FirstName>DON</MSS:FirstName>

           <MSS:LastName>HILL</MSS:LastName>

           <MSS:UserID>9999-08</MSS:UserID>

        </MSS:OrderEmployee>

        <MSS:OrderEmployee EmployeeType="OA Surveyor">

           <MSS:FirstName>DAVE</MSS:FirstName>

           <MSS:LastName>WOODSON</MSS:LastName>

           <MSS:UserID>9999-05</MSS:UserID>

        </MSS:OrderEmployee>

    </MSS:OrderEmployees>

    <MSS:Memos>

        <MSS:Memo AllowUpdate="1">

           <MSS:CreateDate>2015-06-12 16:45:32</MSS:CreateDate>

           <MSS:VanLineCode>092</MSS:VanLineCode>

           <MSS:NoteSubject>General Remarks (001)</MSS:NoteSubject>

           <MSS:NoteMemo>#A-9962/ACCT 2 RCV INV W/IN 60 DZ FRM COMPL OF SVCS-SUBMIT DOCS ASAP/IF ACT WT IS 10% OV R EST-MST REWGH/DEST;FL PK/CUST UNPK;2BR DUP LEX; 51/40&quot; LCD TVS; HIVAL:CRYSTAL</MSS:NoteMemo>

        </MSS:Memo>

        <MSS:Memo AllowUpdate="1" MatchByCreateDate="1">

           <MSS:CreateDate>2015-03-07 10:48:54</MSS:CreateDate>

           <MSS:VanLineCode>158</MSS:VanLineCode>

           <MSS:NoteSubject>Order Related (001)</MSS:NoteSubject>

           <MSS:NoteMemo>CUSTOM PACK CONTAINER SERVICE SHALL APPLY. IN ANY CASE, CARRIER SHALL APPLY CUSTOM UNPACK CONTAINER SERVICE FOR ANY BOXES UNPACKED. IF FULL PACK CONTAINER SERVICES ARE UTILIZED, CARRIER SHALL NOT APPLY EXTRA LABOR CHARGES FOR RE-SECURING OR RE-PACKING PBO CARTONS. IF RE-PACKING AND RE-TAPING IS REQUIRED, CARRIER SHALL LIST T HE NUMBER OF MEN USED, TIME SPENT, AND NUMBER OF CARTONS RE-TAPED OR RE-PACKED. NO CHARGE TO CUSTOMER. - THE DRIVER MUST PROVIDE AN EXPLANATION FOR ANY OF THE FOLLOWING SERVICES: S HUTTLE, LONG CARRY, AND FLIGHTS. SHIPPER MUST SIGN FOR THESESERVICES.-SHUTTLE MUST BE TRUCK TO TRUCK, IF TAKEN TO WHSE DOCK ACCOUNT WILL NOT PAY. - DRIVER MUST FILL OUT THE PACK REPORT WITH ALL UNITS PACKED AT TIME OF LOADING - ONE EXTRAPICKUP AND EXTRA DELIVERY IS AUTHORIZED WITHIN 60 MILE RADI US BETWEEN PICKUP AND DELIVERY POINTS AT NO ADDITIONAL COST.- AUTHORIZATION MUST BE OBTAINED ON EXTRAS PRIOR TO SERVIC E BEING PERFORMED. - SHIPMENTS MOVING ON THE SAME TRUCK WILL BE CONSOLIDATED SHIPMENTS. - ALL CHARGES MUST BEINVOICED WITHIN 90 DAYS OF DELIVERY OR INVOICE WILL NOT BE PAID. - THIRD PARTY - CRATING AND UNCRATING: IF CARRIER UTILIZES A THIRD PARTY TO PERFORM CRATING/UNCRATING SERVICES,THE TOTAL THIRD PARTY CHARGES SHALL NOT EXCEED THE (NON-DIS COUNTED) RATES PUBLISHED IN THE CURRENT HGB 400-N TARIFF. -BOOKING AGENT MUST NOTE ON EVERY SHIPMENT REGISTRATION THA T ACCOUNT REQUIRES ORIGINAL DOCUMENTS. SCANNED DOCUMENTS WILL NOT BE ACCEPTED BY CUSTOMER. BOOKING AGENT SHOULD MAKE EVERY EFFORT TO COMMUNICATE THIS TO THE OA, DRIVER, STORAGE AGENT, DESTINATION AGENT, ETC. BOOKING AGENT SHOULD MAKE EVERYEFFORT TO SELF-HAUL ALL SHIPMENTS IN ORDER TO CONTROL DOCU MENT ISSUE.</MSS:NoteMemo>

        </MSS:Memo>

        <MSS:Memo AllowUpdate="1" MatchByCreateDate="1">

           <MSS:CreateDate>2015-03-07 10:49:09</MSS:CreateDate>

           <MSS:VanLineCode>158</MSS:VanLineCode>

           <MSS:NoteSubject>Order Related (002)</MSS:NoteSubject>

           <MSS:NoteMemo>AGENTS SENT: ORIGIN AGENT PRE-ASSIGNMENT NOTIFICATION 2189</MSS:NoteMemo>

        </MSS:Memo>

        <MSS:Memo AllowUpdate="1" MatchByCreateDate="1">

           <MSS:CreateDate>2015-03-28 11:35:18</MSS:CreateDate>

           <MSS:VanLineCode>158</MSS:VanLineCode>

           <MSS:NoteSubject>Order Related (014)</MSS:NoteSubject>

           <MSS:NoteMemo>** TOUCH POINTS ** -CRYSTAL</MSS:NoteMemo>

        </MSS:Memo>

        <MSS:Memo AllowUpdate="1" MatchByCreateDate="1">

           <MSS:CreateDate>2015-04-25 12:06:57</MSS:CreateDate>

           <MSS:VanLineCode>158</MSS:VanLineCode>

           <MSS:NoteSubject>Order Related (025)</MSS:NoteSubject>

           <MSS:NoteMemo>GOOD MORNING ANN WE HAVE REVIEWED THE ESTIMATE. ALL IS APPROVED RATES/SERVICES ARE SUBJECT TO FINAL AUDIT/REVIEW THANKS FELICIA</MSS:NoteMemo>

        </MSS:Memo>

        <MSS:Memo AllowUpdate="1" MatchByCreateDate="1">

           <MSS:CreateDate>2015-06-01 14:43:55</MSS:CreateDate>

           <MSS:VanLineCode>158</MSS:VanLineCode>

           <MSS:NoteSubject>Order Related (027)</MSS:NoteSubject>

           <MSS:NoteMemo>SEE IF PLZ BILL AT WM DUGGAN 2189 WILL HANDLE THIS ALL THE WAY. LET US KNOW,.</MSS:NoteMemo>

        </MSS:Memo>

    </MSS:Memos>

    <MSS:ExtraStops>

        <MSS:Pickup>

           <MSS:ExtraStopNumber>1</MSS:ExtraStopNumber>

           <MSS:Address>MINI STORAGE</MSS:Address>

           <MSS:City>CHESTNUT HILL</MSS:City>

           <MSS:State>MA</MSS:State>

           <MSS:County>MIDDLESEX</MSS:County>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>02467-4444</MSS:ZipCode>

           <MSS:Contact>EX PICKUP CONTACT 1</MSS:Contact>

           <MSS:Company>EXTRA PICKUP CONTACT</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>212</MSS:AreaCode>

                   <MSS:LocalNumber>555-6666</MSS:LocalNumber>

                   <MSS:Extension>345</MSS:Extension>

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>414</MSS:AreaCode>

                   <MSS:LocalNumber>555-8888</MSS:LocalNumber>

                   <MSS:Extension>456</MSS:Extension>

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Pickup>

        <MSS:Pickup>

           <MSS:ExtraStopNumber>2</MSS:ExtraStopNumber>

           <MSS:Address>125 CENTER ST</MSS:Address>

           <MSS:City>BOSTON</MSS:City>

           <MSS:State>MA</MSS:State>

           <MSS:County>MIDDLESEX</MSS:County>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>76543</MSS:ZipCode>

           <MSS:Contact>EX PICKUP CONTACT 2</MSS:Contact>

           <MSS:Company>EXTRA PICKUP CONTACT 2</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>313</MSS:AreaCode>

                   <MSS:LocalNumber>555-7777</MSS:LocalNumber>

                   <MSS:Extension>678</MSS:Extension>

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>515</MSS:AreaCode>

                   <MSS:LocalNumber>555-9999</MSS:LocalNumber>

                   <MSS:Extension>567</MSS:Extension>

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Pickup>

        <MSS:Pickup>

           <MSS:ExtraStopNumber>3</MSS:ExtraStopNumber>

           <MSS:Address>7050 MINOLA DRIVE</MSS:Address>

           <MSS:City>LITHOWANNIA</MSS:City>

           <MSS:State>FL</MSS:State>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>30039</MSS:ZipCode>

           <MSS:Contact>GARY EAST</MSS:Contact>

           <MSS:Company>THE WOOD IMAGE</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>880</MSS:AreaCode>

                   <MSS:LocalNumber>482-6670</MSS:LocalNumber>

                   <MSS:Extension>789</MSS:Extension>

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>999</MSS:AreaCode>

                   <MSS:LocalNumber>555-1212</MSS:LocalNumber>

                   <MSS:Extension>678</MSS:Extension>

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Pickup>

        <MSS:Delivery>

           <MSS:ExtraStopNumber>1</MSS:ExtraStopNumber>

           <MSS:Address>67 MAIN ST</MSS:Address>

           <MSS:City>NEW YORK</MSS:City>

           <MSS:State>NY</MSS:State>

           <MSS:County>MIDDLESEX</MSS:County>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>10101-5555</MSS:ZipCode>

           <MSS:Contact>EX DELIVERY CONTACT 1</MSS:Contact>

           <MSS:Company>EXTRA DELIVERY CONTACT</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>612</MSS:AreaCode>

                   <MSS:LocalNumber>444-6666</MSS:LocalNumber>

                   <MSS:Extension>123</MSS:Extension>

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>324</MSS:AreaCode>

                   <MSS:LocalNumber>444-8888</MSS:LocalNumber>

                   <MSS:Extension>234</MSS:Extension>

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Delivery>

        <MSS:Delivery>

           <MSS:ExtraStopNumber>2</MSS:ExtraStopNumber>

           <MSS:Address>1567 TOWNE CENTER DR</MSS:Address>

           <MSS:City>NEWPORT</MSS:City>

           <MSS:State>RI</MSS:State>

           <MSS:County>MIDDLESEX</MSS:County>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>01010</MSS:ZipCode>

           <MSS:Contact>EX DELIVERY CONTACT 2</MSS:Contact>

           <MSS:Company>EXTRA DELIVERY CONTACT 2</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>713</MSS:AreaCode>

                   <MSS:LocalNumber>444-7777</MSS:LocalNumber>

                   <MSS:Extension>456</MSS:Extension>

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>425</MSS:AreaCode>

                   <MSS:LocalNumber>444-9999</MSS:LocalNumber>

                   <MSS:Extension>345</MSS:Extension>

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Delivery>

        <MSS:Delivery>

           <MSS:ExtraStopNumber>3</MSS:ExtraStopNumber>

           <MSS:Address>9999 NANCY RIDGE DR STE C</MSS:Address>

           <MSS:City>SAN DIEGOa</MSS:City>

           <MSS:State>AZ</MSS:State>

           <MSS:Country>USA</MSS:Country>

           <MSS:ZipCode>89121-2345</MSS:ZipCode>

           <MSS:Contact>PAIDMAN</MSS:Contact>

           <MSS:Company>BAXTER/SYNOVIS BURGICA</MSS:Company>

           <MSS:PhoneNumbers>

               <MSS:PhoneNumber>

                   <MSS:AreaCode>648</MSS:AreaCode>

                   <MSS:LocalNumber>555-7555</MSS:LocalNumber>

                   <MSS:Extension xsi:nil="1" />

                   <MSS:Type>Home</MSS:Type>

               </MSS:PhoneNumber>

               <MSS:PhoneNumber>

                   <MSS:AreaCode xsi:nil="1" />

                   <MSS:LocalNumber xsi:nil="1" />

                   <MSS:Extension xsi:nil="1" />

                   <MSS:Type>Work</MSS:Type>

               </MSS:PhoneNumber>

           </MSS:PhoneNumbers>

        </MSS:Delivery>

    </MSS:ExtraStops>

    <MSS:MilitaryInformation>

        <MSS:GBLNumber>BGNC0021</MSS:GBLNumber>

        <MSS:OriginBaseCode>BGNC</MSS:OriginBaseCode>

        <MSS:DestinationBaseCode>HAFC</MSS:DestinationBaseCode>

    </MSS:MilitaryInformation>

    <MSS:ExternalApplication>

        <MSS:Interface>

 

Note

Set the ExternalSource to the Name corresponding to the type of data being sent as specified within the XML System Data Type Map section of XML System Setup. For example, if you are downloading “Order Information” then enter the Name corresponding to that type.

Figure 2: XML System Data Type Map dialog

 

 

           <MSS:ExternalSource>YOUR EXTERNAL DATA TYPE MAP NAME</MSS:ExternalSource>

        </MSS:Interface>

    </MSS:ExternalApplication>

    <MSS:SITInformations>

        <MSS:SITInformation>

           <MSS:Agent>

               <MSS:AgentID>0207</MSS:AgentID>

           </MSS:Agent>

           <MSS:SITType>Destination</MSS:SITType>

           <MSS:Authorization>PEND</MSS:Authorization>

           <MSS:Days>60</MSS:Days>

        </MSS:SITInformation>

    </MSS:SITInformations>

    <MSS:ContractInformation>

        <MSS:Contract>SU8524</MSS:Contract>

    </MSS:ContractInformation>

    <MSS:DriverDispatchInformation>

        <MSS:AssignedDate>2015-06-05</MSS:AssignedDate>

        <MSS:AssignedTime>16:17:00</MSS:AssignedTime>

        <MSS:ETADate>2015-06-06</MSS:ETADate>

        <MSS:ETATime>12:34:00</MSS:ETATime>

    </MSS:DriverDispatchInformation>

</MSS:Order>