The GeoCoder is available from http://www.fatgeorge.co.uk/Store.aspx

A little later than intentioned but for all those who wish to incoporate mapping and proximity searches into their AS sites then here you go.

I will start to populate the product page with articles and how-to's on how to perform proximity search listings etc.

If you have any queries or suggestions on Geo related stuff drop me a line.

Tony,

Once you modify a profile in DNN 05.06.00 your geocoder update function does not work.
It still maps the user to the old address.

We think the problem maybe a function in fatgeorge.GeoCoder.dll that retrieves all modified users. A sql query is built (code below) that should retrieve modified users but there is a flaw in it. On the second line below there is a join done to the UserProfile table. I believe this should actually read {databaseOwner}{objectQualifer}UserProfile otherwise I’m pretty sure an exception would be thrown, although I can’t find this exception being thrown anywhere. Nor can I find the log file that the dll is attempting to log to (fg_GeoCoder.log)


builder.Append("SELECT DISTINCT p.userid from {databaseOwner}{objectQualifier}UserPortals p ")
builder.Append("JOIN UserProfile up ON p.UserId = up.UserID")
builder.Append(" where PortalId = ")
builder.Append(PortalId.ToString)
builder.Append(" AND up.LastUpdatedDate >= '")
builder.Append(lastRunDate)
builder.Append("'")
If ASOnly Then builder.Append(" AND EXISTS (select 1 FROM activesocial_User asu WHERE asu.PortalId = ") builder.Append(PortalId.ToString) builder.Append(" AND asu.UserId = up.UserId)")
End If

Can you please help?

Hi John,
Thanks for pointing this out.
I am working on a new version to fix this now.
I will post here when it is available.

OK, a new version is available to download from http://www.fatgeorge.co.uk/Store.aspx for logged in GeoCoder customers.

Thanks, that sorted it.

Tony,

Is it possible to use your geocoder to create lats. and longs. from any datasource that contains an address field?
If so how is this achieved?

Posted By John Condon on 16 Dec 2010 10:58 AM
Tony,

Is it possible to use your geocoder to create lats. and longs. from any datasource that contains an address field?
If so how is this achieved?

Currently it only supports DNN Profiles, AS Users and AS Groups.
On the roadmap is support for XMod data and SQL tables.

I am wondering if the simplest way for the generic sql tables would be to define sql view format that would specify the required fields that the GeoCoder works with.

This would make the solution very flexible but would require some sql knowledge or getting someone else to create that view.

In the geocoder manager you would simply specify the name of the sql view to query.

Let me have your thoughts.

Tony,

I have already created the sql views with relative info and lat, longs.

How do I access the geocoder manager?

Posted By John Condon on 17 Dec 2010 08:00 AM
Tony,

I have already created the sql views with relative info and lat, longs.

How do I access the geocoder manager?

The geocoder manager is just a sql table which hold the configuration data at the moment.
The geocoder will not process the sql view in the current version.

I am just looking at implementing this functionality in a new version.

Would you care to send me your sql view definition so I can check it?

if so send to support AT fatgeorge.co.uk

Tony,

from looking at your fatgeorge_GeoCoder_Manager table you've got the structure in place that would allow for adding custom data from a SQL table / view. I think the addition of a SQL Source column where you can set the name of a table / view to select data from would allow you to implement this pretty quickly. You already have the columns in place to allow for the definintion of expected column names to make it generic.

From the XMod point of view I'm a bit of a newbie to it so couldn't really say how I'd implement this.