I would like to plot all properties onto a google map using Property Agent Latest.  I thought I had seen this done already some place but I have been searching for an hour now.  I only have 9 properties and I want to show them all on a single Google Map (or other map). 

Does naybody have an example they could share?

Mike

I apologise for advertise my module, but perhaps not so know still and do precisely what you need!

http://www.snowcovered.com/Snowcovered2/Default.aspx?tabid=242&PackageID=11170

Can I just plot the properties on the map or do I need to have the Search fields?  I want to put a map of the Rideau waterway in Ontario and plot the 9-marinas that are participating in this site.  For each plot on the map, I want the baloon to show some custom fields and some Agent fields and have a link to the property listing.  If you module will do that than I am happy to buy.

This looks like a great way to go, but there is no [LONGDITUDE] and [LATITUDE] tokens for RSS layour files.  Are you suggesting I make [CUSTOM:Lat]?  Maybe Scott can add [LATITUDE] and [LONGDITUDE] to the RSS.

I tried to do this but somehow it did not work for me.

It would be nice if you can share your RSS templates with us...

Thanks

I agree, this module is great with PA: http://www.snowcovered.com/Snowcovered2/Default.aspx?tabid=242&PackageID=11170

It's also well supported.

I will share the RSS if I get mine working.  I tried the Map module suggested but it did not seem to suit me, maybe the next version will.

I got my RSS feed to plot all the locations onto a map but now I have DotnetNuke snag.  In order for my map to run, i need to run an onload event in my body tag.  But I cannot do that because I do not have access to my boxy tag for and individual page.  This must be a common problem, does anyone have a recommendation?  It s

Here is the code that runs the map... works in Firefox but not IE when added to a Text/HTML module.

<mce:script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAA70IckGHuJtFN_MNDlZfcuxQ3PJBcGu5t8yV97bkCuB6GtAIF7hTZ6B04EFPKhP3OVH-rPG3kQbKRiQ " mce_src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAA70IckGHuJtFN_MNDlZfcuxQ3PJBcGu5t8yV97bkCuB6GtAIF7hTZ6B04EFPKhP3OVH-rPG3kQbKRiQ "></mce:script> <mce:script type="text/javascript"><!-- var map; var geoXml; var toggleState = 1; function initialize() { if (GBrowserIsCompatible()) { geoXml = new GGeoXml("http://rideau.omoa.com/Home/tabid/562/agentType/rss/Default.aspx?title=Latest+Transient+Slips"); map = new GMap2(document.getElementById("map_canvas")); map.setCenter(new GLatLng(44.85,-76.00891), 9); map.addControl(new GLargeMapControl()); map.addControl(new GLargeMapControl()); map.addOverlay(geoXml); } } // --></mce:script> [script removed] <div id="map_canvas" style="width: 450px; height: 650px; float:left; border: 1px solid black;"></div>

Here is the coe I used to make my RSS feed:

<?xml version="1.0" encoding="utf-8"?> <feed xmlns="http://www.w3.org/2005/Atom" xmlns:georss="http://www.georss.org/georss"> <title>Marinas on the Rideau</title> <subtitle>Marinas that have Transient Slips</subtitle> <link href="http://rideau.omoa.com/" mce_href="http://rideau.omoa.com/"/> <updated>[NOW]</updated> <id>urn:uuid:60a76c80-d399-11d9-b93C-0003939e0af6</id> [ITEMS] </feed>

<entry> <title>[DISPLAYNAME]</title> <link href="[LINK]" mce_href="[LINK]"/> <id>urn:uuid:1225c695-cfb8-4ebb-aaaa-80da344efa6a</id> <updated>[DATEMODIFIED]</updated> <summary>Slips available for: <em>[CUSTOM:Date-1]</em>: [CUSTOM:Slips-1]<br /> <em>[CUSTOM:Date-2]</em>: [CUSTOM:Slips-2]<br /> <em>[CUSTOM:Date-3]</em>: [CUSTOM:Slips-3]<br /> <em>[CUSTOM:Date-4]</em>: [CUSTOM:Slips-4]<br /> <em>[CUSTOM:Date-5]</em>: [CUSTOM:Slips-5] </summary> <georss:point>[CUSTOM:Lat] [CUSTOM:Long]</georss:point> </entry>

I took some advice that I found and I put the onload event into a single-pixel image tag and it seems to work in IE and FF now... have not tested it more and I have a lot of design work to do on this site now.

It is turning into a pretty useful application. (still need to skin it and decorate it)

http://rideau.omoa.com/

There are 9 marinas involved and the purpose of the site is to see who has transient slips available (vacant dock). Each marina is a DNN user and I have custom profiles for them.  The marinas are supposed to keep their own data up-to-date.  When they log in to the site, they can edit their own Listing but cannot touch others.

All marinas are plotted on a map

All marinas have a listing that has contact from and tell your friend.

Marinas can add their own photos to their listing to attract attention.

RSS feed will allow users to subscribe to the feed on their smartphones

One map has all marinas to assist in navigating

All marinas have a map that links to directions.... too bad google does not provide nautical charts.

Is there anything that can't be done with Property Agent and imagination?

Thanks for sharing Mike...

I have a lot of listing that does not have map coordinates. Is there any way to eliminate those listings from RSS so that map is always plotting some listings?

I would have to look at the template guide for Property Agent, but I do think it is possible using expression tags.  For this to work, I had to create a custom field for Longitude and one for Latitude even though PA has [LONGITUDE] and [LATITUDE], those tokens are available in the RSS layout file.

Perhaps we could lobby Scott to add these tokens into RSS layout templates but he would also need to make conditional tokens for them too.  So Scott, if your watching this thread:

we need the following tokens to work in RSS

[LONGITUDE]

[LATITUDE]

[HASCOORDINATES] [/HASCOORDINATES]

I did a retool of my map plotting that I thought I would share.  I bought a map module on Snowcovered called Netsim Map Extreme.  It is templateable using HTML and tokens just like Ventrian modules are and it supports custom SQL from a variety of sources.  It also can accept arguements from the querystring for the WHERE clause.

I had to write a complicated (for me) SQL statement to pull data from Property Agent tables, and from DNN User and User Profile tables to plot my points on the map.  I was able to put dynamic data into the map point baloons. I actually copied a lot of the SQL from Property Agent Stored Procedures.

My end result is a list of properties beside a map with points on it.  If I hover over a name in the list, the point is highlighted on the map with an info baloon and if I hover over the point on the map, the name in the list is highlighted.

Here is what I ended up with: http://www.rideauslips.com. 

I did a trial of Propery Map and was very impressed with that module as well, but it did not quite do for me what I wanted.  My new solution is not perfect, but it is cool and thought you would like it.  If you want me to share any code, I am happy to oblige.

Mike

As I mentioned, Netsim Map Extreme is required from Snowcoverd for $40 or $80 for a host license. http://www.snowcovered.com/Snowcovered2/Default.aspx?tabid=242&PackageID=12567

Here is the sql I wrote for plotting all properties.  I am not great at writing SQL so there may be a better way to accomplish this but I went into the PA tables to find out the ID of each custom field.SELECT p.[ModuleID], p.[PropertyID] as LocationID, p.[PropertyID] as SortOrder, p.[IsFeatured] as IsActive, '/MarinasontheRideau/tabid/611/agentType/View/PropertyID/' + rtrim(convert(char,p.[PropertyID])) + '/Default.aspx' as link, 8 as zoom, p.[DateCreated] as CreatedDate, p.[Latitude], p.[Longitude], u.[UserName], u.[DisplayName] as Title, u.[FirstName] + ' ' + u.[LastName] as 'FullName', u.[Email], (SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 65) as 'MarinaNote', '<p class="Normal">Slips Available for:<br/><em>'+rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 51)))+'</em>: ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 52)))+'<br />' + '<em>'+rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 54)))+'</em>: ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 55)))+'<br />' + '<em>'+rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 57)))+'</em>: ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 58)))+'<br />' + '<em>'+rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 60)))+'</em>: ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 61)))+'<br />' + '<em>'+rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 63)))+'</em>: ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 64)))+'<br /></p>' + '<p class="Normal"><em>Telephone: </em>'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Telephone') AND UserID= u.UserID) +' <br /><a href="mailto:'+u.[Email]+'" mce_href="mailto:'+u.[Email]+'">Email</a> | <a href="'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Website') AND UserID= u.UserID)+'" mce_href="'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Website') AND UserID= u.UserID)+'">Website</a></p>' as Description, '<a href="mailto:'+u.[Email]+'" mce_href="mailto:'+u.[Email]+'">Email</a> | <a href="'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Website') AND UserID= u.UserID)+'" mce_href="'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Website') AND UserID= u.UserID)+'">Website</a>' as webemail, '<em>Telephone: </em>'+(SELECT PropertyValue FROM UserProfile WHERE PropertyDefinitionID = dbo.GetProfilePropertyDefinitionID(24, 'Telephone') AND UserID= u.UserID) as ThePhone FROM dbo.ventrian_propertyagent_property p LEFT JOIN dbo.Users u ON p.AuthorID = u.UserID WHERE p.[ModuleID] = 1351 ORDER BY CreatedDate DESC

The Custom Templates for Netsim is a similar concept as Ventrian so you should find it easy.

Here is the list item:

<tr valign="top"> <td width="50%"><div class="Normal"><a href="#" mce_href="#" {popup-show} {popup-hide}><img src="{icon-idle}" mce_src="{icon-idle}" border="0" /></a> <a href="{link}" mce_href="{link}" {popup-show} {popup-hide} style="font-weight:bold;" mce_style="font-weight:bold;">{title}</a> <br>{MarinaNote}<br><a href="{link}" mce_href="{link}" style="font-weight:bold;" mce_style="font-weight:bold;">Read More...</a><br><br> {zoom-satellite} | {zoom-street} | {zoom-city} | {zoom-region} </div></td> <td>{description}</td> </tr>

Here is the Popup

<a href="{link}" mce_href="{link}" style="font-weight:bold;" mce_style="font-weight:bold;">{title}</a><hr/>{description}

I used this same module to do the same thing on this site: http://tilt.creativeis.ca/Maps.aspx

It is still a work in progress, but I put a PA photo in the popup which is cool.

Here is the SQL

SELECT p.[ModuleID], p.[PropertyID] as LocationID, p.[PropertyID] as SortOrder, p.[IsFeatured] as IsActive, '/ConservingLand/ConservedLand/tabid/490/agentType/View/PropertyID/' + rtrim(convert(char,p.[PropertyID])) + '/Default.aspx' as link, 8 as zoom, p.[DateCreated] as CreatedDate, p.[Latitude], p.[Longitude], '/DesktopModules/PropertyAgent/ImageHandler.ashx?width=188&height=141&HomeDirectory=%2fPortals%2f12%2f%2fPropertyAgent%2f1150%2fImages&fileName=' + rtrim(convert(char,(select top 1 [PhotoID] from dbo.Ventrian_PropertyAgent_Photo photo where p.PropertyID = photo.PropertyID order by SortOrder))) + '.jpg&portalid=12&i=' + rtrim(convert(char,(select top 1 [PhotoID] from dbo.Ventrian_PropertyAgent_Photo photo where p.PropertyID = photo.PropertyID order by SortOrder))) +'&Q=False' as PhotoURL, '<p class="Normal"> ' + rtrim(convert(char,(SELECT CustomValue FROM dbo.Ventrian_PropertyAgent_PropertyValue where PropertyID = p.PropertyID AND CustomFieldID = 44)))+'</p>' as Title, 'Photo' as Description FROM dbo.ventrian_propertyagent_property p LEFT JOIN dbo.Users u ON p.AuthorID = u.UserID WHERE p.[ModuleID] = 1150 ORDER BY CreatedDate DESC

Here is the popup code:

<a href="{link}" mce_href="{link}" style="font-weight:bold;" mce_style="font-weight:bold;">{title}</a><hr/><img src="{PhotoURL}" mce_src="{PhotoURL}" border="0" alt="" />