i want to explode this xml file in php and i dont know how to get the value on each node
<?xml version=“1.0”?>
<HotelSearchRS>
<Response>
<item>
<id>124786</id>
<bestPrice AllocationKey=“20140602-034842” currency=“INR” amount=“0”>
<availableRoom ourAmount=“8934.44” ourCurrency=“INR” BookingKey=“124786-1”/>
</bestPrice>
<availableRooms>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“8934.44” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-1” totalRooms=“1” totalRoomTypes=“1” roomName=“Superior Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“12507.1” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-2” totalRooms=“1” totalRoomTypes=“1” roomName=“Deluxe Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“12763.43” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-3” totalRooms=“1” totalRoomTypes=“1” roomName=“Superior Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“17016.91” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-4” totalRooms=“1” totalRoomTypes=“1” roomName=“Superior Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“17867.7” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-5” totalRooms=“1” totalRoomTypes=“1” roomName=“Deluxe Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“22688.8” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-6” totalRooms=“1” totalRoomTypes=“1” roomName=“Deluxe Room” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“31269.08” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-7” totalRooms=“1” totalRoomTypes=“1” roomName=“Suite” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“44669.85” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-8” totalRooms=“1” totalRoomTypes=“1” roomName=“Suite” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
<availableRoom AllocationKey=“20140602-034842” hotelID=“124786” ourAmount=“52469.1” ourCurrency=“INR” hotelCategory=“5” isRecommended=“” hotelName=“Le Meridien Dahab Resort” location=“Near Dahab Bay” meals=“Full Breakfast” BookingKey=“124786-9” totalRooms=“1” totalRoomTypes=“1” roomName=“Suite” availablity=“AVAILABLE” offers=“” essentialInformation=“” rooms=“SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0”/>
</availableRooms>
</item>
</Response>
</HotelSearchRS>
like AllocationKey, hotel id, hotel name etc…
dear i can not till now export this huge xml file… any help please
Are you really saying “I don’t know PHP and want someone to write the code for me”?
for sure no… all that i need is to have a tutorial to explode unlimited nested xml file in php…
i am not in need from anyone to write code for me…
What about any of the many XML tutorials in my previous link?
If your server is running PHP5+ then you should have SimpleXML support installed.
i tried to explode the xml string by putting it in a php array then explodng the array… and i found that this way is not right…
i am trying again to make it by SimpleXML… but till now i did not reach my goal
i need to get the id, the best price allocationkey,currency,amount…
<availableroom ouramount=“8942.57” ourcurrency=“INR” bookingkey=“124786-1”/>
</bestprice>
thanks for your reply
Finally i made it but i need a small help
$xml=simplexml_load_string($xml);
//print_r($xml);
echo $xml->response->item->id.'<br>';
echo $xml->response->item->bestprice['allocationkey'] .'<br>';
echo $xml->response->item->bestprice['currency'] .'<br>';
echo $xml->response->item->bestprice['amount'] .'<br>';
echo $xml->response->item->bestprice->availableroom['ouramount'] .'<br>';
echo $xml->response->item->bestprice->availableroom['ourcurrency'] .'<br>';
echo $xml->response->item->bestprice->availableroom['bookingkey'] .'<br>';
$counter=0;
foreach($xml->response->item->availablerooms->availableroom as $data)
{
echo $counter.'-)'.$xml->response->item->availablerooms->availableroom[$counter]['allocationkey'] .'<br>';
$counter++;
}
i made it by this code but i can not make it when i have multiple <item> tag
$xml='<?xml version="1.0"?>
<hotelsearchrs>
<response>
<item>
<id>124786</id>
<bestprice allocationkey="20140603-112230" currency="INR" amount="0">
<availableroom ouramount="8942.57" ourcurrency="INR" bookingkey="124786-1"/>
</bestprice>
<availablerooms>
<availableroom allocationkey="20140603-1122301" hotelid="124786" ouramount="8942.57" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-1" totalrooms="1" totalroomtypes="1" roomname="Superior Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122302" hotelid="124786" ouramount="12518.49" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-2" totalrooms="1" totalroomtypes="1" roomname="Deluxe Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122303" hotelid="124786" ouramount="12775.04" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-3" totalrooms="1" totalroomtypes="1" roomname="Superior Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122304" hotelid="124786" ouramount="17032.39" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-4" totalrooms="1" totalroomtypes="1" roomname="Superior Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122305" hotelid="124786" ouramount="17883.97" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-5" totalrooms="1" totalroomtypes="1" roomname="Deluxe Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122306" hotelid="124786" ouramount="22709.46" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-6" totalrooms="1" totalroomtypes="1" roomname="Deluxe Room" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122307" hotelid="124786" ouramount="31297.55" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-7" totalrooms="1" totalroomtypes="1" roomname="Suite" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122308" hotelid="124786" ouramount="44710.52" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-8" totalrooms="1" totalroomtypes="1" roomname="Suite" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableroom allocationkey="20140603-1122309" hotelid="124786" ouramount="52516.86" ourcurrency="INR" hotelcategory="5" isrecommended="" hotelname="Le Meridien Dahab Resort" location="Near Dahab Bay" meals="Full Breakfast" bookingkey="124786-9" totalrooms="1" totalroomtypes="1" roomname="Suite" availablity="AVAILABLE" offers="" essentialinformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
</availablerooms>
</item>
<item>
<id>604080</id>
<bestPrice AllocationKey="20140602-040404" currency="INR" amount="0">
<availableRoom ourAmount="9020.05" ourCurrency="INR" BookingKey="604080-1"/>
</bestPrice>
<availableRooms>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="9020.05" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Breakfast Buffet" BookingKey="604080-1" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - Standard Sea View Room Bed and Breakfast" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="9020.05" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Breakfast Buffet" BookingKey="604080-2" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View Room Bed and Breakfast" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="12445.37" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Half Board" BookingKey="604080-3" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - standard Sea View room Half Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="14728.93" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Half Board" BookingKey="604080-4" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View room Half Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="15185.65" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Full Board" BookingKey="604080-5" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - Standard Sea View room Full Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="17469.2" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Full Board" BookingKey="604080-6" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View room Full Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
</availableRooms>
</item>
<item>
<id>12122832498</id>
<bestPrice AllocationKey="20140602-12244" currency="INR" amount="0">
<availableRoom ourAmount="9020.05" ourCurrency="INR" BookingKey="604080-1"/>
</bestPrice>
<availableRooms>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="9020.05" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Breakfast Buffet" BookingKey="604080-1" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - Standard Sea View Room Bed and Breakfast" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="9020.05" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Breakfast Buffet" BookingKey="604080-2" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View Room Bed and Breakfast" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="12445.37" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Half Board" BookingKey="604080-3" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - standard Sea View room Half Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="14728.93" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Half Board" BookingKey="604080-4" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View room Half Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="15185.65" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Full Board" BookingKey="604080-5" totalRooms="1" totalRoomTypes="1" roomName="Standard Room, Sea View - Standard Sea View room Full Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
<availableRoom AllocationKey="20140602-040404" hotelID="604080" ourAmount="17469.2" ourCurrency="INR" hotelCategory="5" isRecommended="" hotelName="Hurghada Marriott Beach Resort" location="In Hurghada (Sakkala)" meals="Full Board" BookingKey="604080-6" totalRooms="1" totalRoomTypes="1" roomName="Deluxe Room - Deluxe Sea View room Full Board" availablity="AVAILABLE" offers="" essentialInformation="" rooms="SB:0-SBWC:0-SBW2C:0-DB:0-DBWC:1-DBW2C:0-TR:0-TRWC:0-TRW2C:0-QB:0-QBWC:0-QBW2C:0"/>
</availableRooms>
</item>
</response>
</hotelsearchrs>
';
$xml=simplexml_load_string($xml);
//print_r($xml);
$counter_1=0;
foreach($xml->response->item as $data_1)
{
echo '<strong>ID : </strong>'.$xml->response->item[$counter_1]->id.'<br>';
echo '<strong>Allocation Key:</strong>'.$xml->response->item[$counter_1]->bestprice['allocationkey'] .'<br>';
$counter_1++;
}
i get the id’s normally but i can not get the allocation keys in best price…
really i appreciate your help
That’s because Item is now an array. Save the XML as test.xml and try this code …
<?php
$xml=simplexml_load_file("test.xml");
echo '<pre>';
print_r($xml);
echo '</pre>';
?>
Call it up in a browser and look at the SimpleXML structure.
siteguru:
That’s because Item is now an array. Save the XML as test.xml and try this code …
<?php
$xml=simplexml_load_file("test.xml");
echo '<pre>';
print_r($xml);
echo '</pre>';
?>
Call it up in a browser and look at the SimpleXML structure.
Dear i made it using xml string and it’s working fine only one problem left… the nodes returned from xml are not in same case, sometimes it’s capsulized and other times it is in lowercase
e.g: <response> , sometimes <Response> and sometime <RESPONSE>
and it is a web service out of my control…
how i can make all nodes in the xml string in lower case?? notice that i can not use strtolower($xml) because the values inside the nodes are case sensitive and i have to send it as it is without changing it to lower
Are there any formal recommendations on element casing in XML?
I know XHTML uses lowercase element names (as opposed to HTML which canonically uses uppercase but is case-insensitive.)
But I’m talking about XML for generic content.
lowercase:
<customer>
<accountnumber>619</accountnumber>
<name>Shelby Lake</name>
</customer>
camelCase:
<customer>
<accountNumber>619</accountNumber>
<name>Shelby Lake</name>
</customer>
PascalCase:
<Customer>
<AccountNumber>619</AccountNumber>
<Name>Shelby Lake</Name>
</Customer>
UPPERCASE:
<CUSTOMER>
<ACCOUNTNUMBER>619</ACCOUNTNUMBER>
<NAME>Shelby Lake</NAME>
</CUSTOMER>