FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Importing Google MyMaps RSS Feed (need to store coordinates View next topic
View previous topic
Post new topicReply to topic
Author Message
brendanc



Joined: 20 Sep 2010
Posts: 1
Location: ie

PostPosted: Mon Sep 20, 2010 9:56 am Reply with quoteBack to top

Hello,
I am using RSS2SQL to store data from a Google MyMap.
My aim is to be able to store the coordinate information in the FeedItems table using RSS2SQL.
A sample item of the RSS for a Google Map is as follows:

Code:
<item>
    <guid isPermaLink="false">00048ceb4891ed4334048</guid>
    <pubDate>Tue, 03 Aug 2010 13:41:14 +0000</pubDate>
    <title>Track 2</title>
    <description><![CDATA[]]></description>
    <author>Brendanc</author>
    <gml:LineString>
      <gml:posList>
        52.652737 -7.248225
        52.652447 -7.248814
        52.652458 -7.249173
        52.652294 -7.249490
        52.652081 -7.250069
       </gml:posList>
    </gml:LineString>
  </item>


The attributes I need to get out are "gml:posList" and "gml:LineString". Is it possible for the RSS2SQL script to look at additional XML/RSS attributes and to update these into a database?

thanks,

Brendan
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Tue Jan 18, 2011 4:09 pm Reply with quoteBack to top

What database error are you receiving?

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme