Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Thursday, November 20, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
The ever-powerful ListX module forum. Post your questions, new configuration ideas and reviews.
Forums > Bi4ce.Modules.ListX > General
Subject: Using List-X with XML

You are not authorized to post a reply.   
Author Messages
Encoder
Welterweight
Posts:37
06/06/2008 7:54 PM Alert 
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.
-John
MCAD.Net, MCP, MCSD
jliptak
Heavyweight
Posts:162
06/07/2008 4:57 AM Alert 
------------------------------
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.

Attachment: XmlSample.zip
robert_chumley
Please Wait...
Posts:595
06/09/2008 9:23 AM Alert 
Hello jliptak,
Thank you for the example here, do you mind if we put this into the ListX/OWS hall of fame?
Thanks,
Robert Chumley
r2integrated (formally bi4ce)
jliptak
Heavyweight
Posts:162
06/10/2008 5:10 AM Alert 
Sure, happy to help out.
Encoder
Welterweight
Posts:37
06/16/2008 3:08 PM Alert 
<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.
-John
MCAD.Net, MCP, MCSD
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > General > Using List-X with XML


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation