Appending an XML file

dcjones

Hi all,

I have an XML file which I need to append to other XML file.

example file1:

<?xml version="1.0" encoding="UTF-8"?>
<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlrepository/AOS/Controlled/AFDS/Schemas/AFDSFlightData_2.xsd">
    <Header>
        <MessageSentDateTime>2009-07-02T11:25:06Z</MessageSentDateTime>
        <MessageSequenceNumber>739497</MessageSequenceNumber>
        <MessageType>AFDSFlightData</MessageType>
        <SourceSystemID>IDAHO</SourceSystemID>
        <DestinationSystemID>FIDS</DestinationSystemID>
    </Header>
    <Body>
        <AFDSFlightData>
            <SubscriptionID>134784</SubscriptionID>
            <Identification>
                <AODBUniqueID>4545964</AODBUniqueID>
                <FlightReference>
                    <CarrierCode>EZY</CarrierCode>
                    <FlightNumber>8609</FlightNumber>
                    <ArrivalOrDeparture>D</ArrivalOrDeparture>
                    <ScheduledDateTime>2009-07-02T12:00:00Z</ScheduledDateTime>
                </FlightReference>
          </AFDSFlightData>
    </Body>
</Envelope>

example file2:

<?xml version="1.0" encoding="UTF-8"?>
<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlrepository/AOS/Controlled/AFDS/Schemas/AFDSFlightData_2.xsd">
    <Header>
        <MessageSentDateTime>2009-07-02T11:27:06Z</MessageSentDateTime>
        <MessageSequenceNumber>739498</MessageSequenceNumber>
        <MessageType>AFDSFlightData</MessageType>
        <SourceSystemID>IDAHO</SourceSystemID>
        <DestinationSystemID>FIDS</DestinationSystemID>
    </Header>
    <Body>
        <AFDSFlightData>
            <SubscriptionID>134785</SubscriptionID>
            <Identification>
                <AODBUniqueID>4545965</AODBUniqueID>
                <FlightReference>
                    <CarrierCode>BA</CarrierCode>
                    <FlightNumber>123</FlightNumber>
                    <ArrivalOrDeparture>A</ArrivalOrDeparture>
                    <ScheduledDateTime>2009-07-02T13:00:00Z</ScheduledDateTime>
                </FlightReference>
          </AFDSFlightData>
    </Body>
</Envelope>

and then end up with a file like:

<?xml version="1.0" encoding="UTF-8"?>
<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlrepository/AOS/Controlled/AFDS/Schemas/AFDSFlightData_2.xsd">
    <Header>
        <MessageSentDateTime>2009-07-02T11:25:06Z</MessageSentDateTime>
        <MessageSequenceNumber>739497</MessageSequenceNumber>
        <MessageType>AFDSFlightData</MessageType>
        <SourceSystemID>IDAHO</SourceSystemID>
        <DestinationSystemID>FIDS</DestinationSystemID>
    </Header>
    <Body>
        <AFDSFlightData>
            <SubscriptionID>134784</SubscriptionID>
            <Identification>
                <AODBUniqueID>4545964</AODBUniqueID>
                <FlightReference>
                    <CarrierCode>EZY</CarrierCode>
                    <FlightNumber>8609</FlightNumber>
                    <ArrivalOrDeparture>D</ArrivalOrDeparture>
                    <ScheduledDateTime>2009-07-02T12:00:00Z</ScheduledDateTime>
                </FlightReference>
          </AFDSFlightData>
    </Body>
</Envelope>

<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlrepository/AOS/Controlled/AFDS/Schemas/AFDSFlightData_2.xsd">
    <Header>
        <MessageSentDateTime>2009-07-02T11:27:06Z</MessageSentDateTime>
        <MessageSequenceNumber>739498</MessageSequenceNumber>
        <MessageType>AFDSFlightData</MessageType>
        <SourceSystemID>IDAHO</SourceSystemID>
        <DestinationSystemID>FIDS</DestinationSystemID>
    </Header>
    <Body>
        <AFDSFlightData>
            <SubscriptionID>134785</SubscriptionID>
            <Identification>
                <AODBUniqueID>4545965</AODBUniqueID>
                <FlightReference>
                    <CarrierCode>BA</CarrierCode>
                    <FlightNumber>123</FlightNumber>
                    <ArrivalOrDeparture>A</ArrivalOrDeparture>
                    <ScheduledDateTime>2009-07-02T13:00:00Z</ScheduledDateTime>
                </FlightReference>
          </AFDSFlightData>
    </Body>
</Envelope>

Can this be done, if so could anyone provide some direction.

Weedpacket

It could, but you'd need a new pair of tags enclosing the whole thing or the XML won't be well-formed.

You'd also need to drop the <?xml declarations first; and put a new one back on at the top after you've put the two parts together.

johanafm

Weedpacket;10939919 wrote:
It could, but you'd need a new pair of tags enclosing the whole thing or the XML won't be well-formed.

It allready isn't. Identification is never closed, and this needs to be fixed as well.

Personally, I'd probably just create a new DOMDocument, append an Envelopes node as root node, then import the Envelope from each of the other documents.

dcjones

Hi both, and thank you for your replies.

Like others in the past this is truly my first time in the world of DOMDocument creation.

I have spent the morning reading about the subject and must confess I am at a loss as to where to start. I have also spent a considerable amount of time reading tutorials I have found on Google and most of it does not make much sense to me.

Is there any way you could give me a hand in starting to get to grips with this script.

I would like to show you what I have written so far but trust me when I say; it’s not fit for human consumption.

I fully understand if you do not have the time. Manny thanks again.