Hello All,

I am trying to use a list-x module to sync up some XML GPS Data, with an existing database. The XML is in the following format:

<?xml version="1.0" ?>
- <ATDataLatest>
- <Unit ID="5648435671" Nick="BJO">
- <Record Cached="N" TowerLocation="N">
<Time Elapsed="17 days 1 hour 28 minutes">2008-05-18 15:07:42</Time>
<Status BatteryLevel="2" GPSLevel="0" TowerLevel="3" />
<GPS Lat="41.00314" Lon="-74.05692" Alt="98" Speed="0" Heading="0" Direction="-" />
</Record>
</Unit>
- <Unit ID="1371827338" Nick="DFJ">
- <Record Cached="N" TowerLocation="N">
<Time Elapsed="27 days 7 hours 35 minutes">2008-05-08 09:00:39</Time>
<Status BatteryLevel="0" GPSLevel="3" TowerLevel="2" />
<GPS Lat="35.38571" Lon="-94.40095" Alt="314" Speed="0" Heading="0" Direction="-" />
</Record>
</Unit>
- <Unit ID="2613909209" Nick="RJS">
- <Record Cached="N" TowerLocation="N">
<Time Elapsed="19 days 8 hours 9 minutes">2008-05-16 08:26:33</Time>
<Status BatteryLevel="3" GPSLevel="3" TowerLevel="3" />
<GPS Lat="40.55015" Lon="-74.40904" Alt="108" Speed="0" Heading="63" Direction="-" />
</Record>
</Unit>
- <Unit ID="6179189235" Nick="SMO">
- <Record Cached="N" TowerLocation="N">
<Time Elapsed="3 minutes">2008-06-04 16:33:05</Time>
<Status BatteryLevel="0" GPSLevel="0" TowerLevel="2" />
<GPS Lat="35.27386" Lon="-94.39154" Alt="469" Speed="0" Heading="282" Direction="-" />
</Record>
</Unit>
</ATDataLatest>

I need to be able to retrieve that xml data from accutracking.com (I have the URL). I need to be able to do the following:
1. Read the data from the URL
2. strip out the UnitID, Lat, Long, ALT and Nick attributes.
3. write the arrtibute values into a db without using a save action.
4. loop to the next data record in the xml stream and do it all over again.

Is this something that can be achieved in list-x?

All help is appreciated.

------------------------------
A Note from the Bi4ce Support:
------------------------------
This is a fantastic demonstration of using ListX to bind to an XML feed and then parse that result with SQL. Great work on this!
------------------------------
Original Message:
------------------------------
Try the attached listx config.

Hello jliptak,
Thank you for the example here, do you mind if we put this into the ListX/OWS hall of fame?
Thanks,

Sure, happy to help out.

<div class='NTForums_Quote'>Posted By robert_chumley on 06/09/2008 9:23 AM

Hello jliptak,<br>Thank you for the example here, do you mind if we put this into the ListX/OWS hall of fame?<br>Thanks,</div>


This sample was fantastic, thanks so much for all the help.