Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help with OPENXML Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 8:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 11:04 AM
Points: 1, Visits: 5
Hi all

I am a bit of a newbie with openxml and need a little guidance from any kind OpenXML pro's out there !, I have an XML file to import into a set of tables on a regular basis and just need a little help in getting going .. a sample of my xml is

If any kind person could point in the right direction of say importing the booking agent area I am sure I can figure the rest out

thanking you all greatly in advance :o)

john

<?xml version="1.0" encoding="UTF-8" ?
><my:Handoff xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:my="http://www.evolvi.biz"
xsi:schemaLocation="http://www.evolvi.biz EVO_Handoff.xsd"
SequenceNumber="0000007358"
Created="2013-06-21T13:51:14.390"
SchemaVersion="4.0"
OrderRef="24436720"
FulfilmentMethodType="Conventional"
DeliveryMethod="Standard">
<Agency Ref="9873" ExternalRef="Wayte"/>
<ImmediateDetail OrderItemRef="25388514" TransactionType="Issue"

TransactionDate="2013-06-21T13:50:00" MachineType="30" MachineNumber="0791" CurrencyCode="GBP" PersonalCCUsed="false" FulfilmentType="Other">
<Account Ref="28422" ExternalRef="0003" Type="Conventional" Period="FourWeekly" Immediate="true" EvolviInvoice="false" EvolviPayment="false" EvolviFinancial="false"/>

<BookingAgent
Ref="60703" ExternalRef="HG" BranchExternalRef="01" Unit="Stoke">
<Person FirstName="HAZEL" LastName="GARNER" Title="MRS"/>
<Email Address="hazel@waytetravel.co.uk"/>
</BookingAgent>

<TicketingAgent Ref="60703" ExternalRef="HG" BranchExternalRef="01" Unit="Wayte Travel Management"/>

<PassengerGroup LeadRef="59392156">
<Passenger Ref="59392156" AdultChild="Adult">
<Person FirstName="T" LastName="POVEY" Title="MR"/>
<CustomField Code="1" Label="Purchase Order" Value="4501221551"/>
<CustomField Code="2" Label="Cost Centre" Value="128050"/>
<CustomField Code="3" Label="File Number" Value="50809"/>
</Passenger>
</PassengerGroup>
Post #1467185
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse