☰
You are here:
Home » forums » Magic Parser
 » Help with XML file.


Help with XML file.

Submitted by baggagepin on Sat, 2010-10-30 14:50 in

Hi,

Could you please provide some help with a file we are trying to pass through Magic Parser.
The format is as follows:

<Result>
<Flight FlightHistoryId="207727318" AirlineCode="BMR" LastUpdated="6:53" Flight="BMR 676" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
<Flight FlightHistoryId="207727318" AirlineCode="VS" LastUpdated="6:53" Flight="VS 4676" Codeshare="T" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
<Flight FlightHistoryId="207727318" AirlineCode="US" LastUpdated="6:53" Flight="US 5483" Codeshare="T" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
<Flight FlightHistoryId="207727318" AirlineCode="UA" LastUpdated="6:53" Flight="UA 4862" Codeshare="T" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
<Flight FlightHistoryId="207727318" AirlineCode="SK" LastUpdated="6:53" Flight="SK 9752" Codeshare="T" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
<Flight FlightHistoryId="207727318" AirlineCode="SA" LastUpdated="6:53" Flight="SA 7642" Codeshare="T" StatusCode="S" OriginCity="London" OriginAirportCode="LHR" DestinationCity="Aberdeen" DestinationAirportCode="ABZ" City="Aberdeen" AirportCode="ABZ" ScheduledGateTime="15:00" CurrentGateTime="15:00" RemarksWithTime="On Time" Terminal="1" />
</Result>

When we do pass the file through not all the elements are captured. Can you see any reason why this would be.

Again, many thanks for your help.

Best regards,
Dereck

‹ Parse data within xml value How to deal with "serial control characters" ›
login or register to post comments
Hi Dereck, Make sure that
Submitted by support on Sat, 2010-10-30 16:54

Hi Dereck,

Make sure that you're using the Format String as follows:

xml|RESULT/FLIGHT/

That should reveal all attributes of each flight as each record, as per the demo using your data here...

Hope this helps,
Cheers,
David.

login or register to post comments