Getting a country/region split using Go-map > Forums > Bi4ce Open Source DotNetNuke Skins: DNN Modules: DNN Consulting

Forums

Forums > Bi4ce.Modules > GoMap (free module)

Subject: Getting a country/region split using Go-map

You are not authorized to post a reply.

Page 1 of 2

Author

Messages

Daniel W

Posts:18

05/17/2007 11:12 AM	Alert
Hi I've just downloaded and installed 2this module, firstly...wow looks great and has endless uses, thanks guys! I'm running DNN 4.51 and have Go-map 2.81 however I have run through the standard wizard and selected a both Table/View options (vwCountriesOnline and vwPeopleOnline)however all though both show users based in the UK, there is no regional split of users, ie all of them are shown grouped in one place. I have both country and region flagged for membership. Is it something simple I'm missing? I'm also confussed by the Latitude/Longitude settings- when do I use these, can I use them being based in the UK? Thanks for your time in advance! Dan

ewalker

Posts:219

05/17/2007 11:24 AM	Alert
Hi Dan, The points in GoMap are plotted on a best effort basis by comparing city, region, and country for a user profile to those in the GeoLookup table that GoMap creates. We have only pre-populated GoMap with regional information for the US, but if you need more detailed point plotting, you can add more rows to the GeoLookup table. If you would prefer to depart from the sample views (vwCountriesOnline and vwPeopleOnline), GoMap can can accept any data with these columns (the portalID column is optional). If you have a better way of calculating the Lat and Long coordinates, GoMap can plot those values. Finally, the Latitude/Longitude setting on the final Wizard step are there to indicate the inititial center point of the Map. Best of luck!

Eric Walker - R2integrated

Daniel W

Posts:18

05/17/2007 11:35 AM	Alert
Hi Eric Thanks for the quick answers. Any plans to load regional data for any other countries? Please could you explainhow I would add rows to the GeoLookup table? Where would I generate the data, and how would I access the table. (Not done anything like this before!)... Cheers Dan

ewalker

Posts:219

05/17/2007 12:17 PM	Alert
The easiest way I've found to add points is to add to the GeoLookup table is to create a new GoMap module instance on a page and configure it to use a new table. Then, I search for each point I want to add to the GeoLookup table by Address (On the advanced settings tab, click on the Data Points button). Once, in that second, click on the "Find Address" link at the bottom of the page. For non-US addresses, you'll want to type the City and state into the second address line. Your points will be added to the database that that you created at the beginning of the wizard. You can then use SQL to copy the Latitude and Longitude point from your table into the GeoLookup table.

Eric Walker - R2integrated

Daniel W

Posts:18

05/17/2007 2:24 PM	Alert
Ok, when I click on 'Data Points' it says fetching data, but seems to take ages, I've left it for 10 mins and nothing... The other options like map info and icons change stright away, is this a bug/issues? Cheers Dan

Daniel W

Posts:18

05/17/2007 5:37 PM	Alert
Hi, I've taken a look and seen some other people posting the same problem with this, but no solutions.... Anyone have any ideas?!...

ewalker

Posts:219

05/17/2007 5:42 PM	Alert
Hi Dan, We're looking to this right now. Thanks

Eric Walker - R2integrated

Daniel W

Posts:18

05/17/2007 5:54 PM	Alert
Ok, It works on Firefox, but not on IE 7.0573. So it must be a setting issue around IE... Dan

ewalker

Posts:219

05/17/2007 7:17 PM	Alert
Hi Dan, We should be releasing a new version of GoMap tonight or tomorrow that should fix this issue. Please download the new version and let us know if this resolves your issue. Thanks

Eric Walker - R2integrated

Daniel W

Posts:18

05/18/2007 5:42 AM	Alert
Hi Ok thanks for that, will wait for the update for IE, So in the meantime I've been using Firefox. I'm looking in my tables, but all I can see is a table called 'dbo.geolookup' not any of the tables I created to record point data, Where/how do I find these tables? Cheers Dan

ewalker

Posts:219

05/18/2007 8:59 AM	Alert
Hi Dan, You can now download a new version of GoMap (2.8.2) from our site now. Your table should be in the database. Your data should be in the table that you created in the third step of the wizard. You can find all views and tables that GoMap can read from by running this query: [quote] SELECT * FROM GoMap_Sources [/quote]

Eric Walker - R2integrated

Daniel W

Posts:18

05/18/2007 9:25 AM	Alert
Hi Ok, got the download and that resolves the IE problem with points. I have followed the steps above, but can't find the table I have created. Also when I go back into the wizard afterwards, and try and select an existing table it only shows the 2 defaults. Surely I should expect to see the table here I've created as well? Maybe thats why I can't see it in Express Manager?... Thanks Dan

ewalker

Posts:219

05/18/2007 9:27 AM	Alert
Hi Dan, Your table it not being created. I have not been able to reproduce this problem. Do you have any unusual settings for your DNN install?

Eric Walker - R2integrated

Daniel W

Posts:18

05/18/2007 9:43 AM	Alert
Hi NOt that I'm aware off, its a shared server with SeekDotNet. Just to clarify steps needed. Start Wizard. Select usersonline config file. Select Table/View option. Select New Table, and name it. Enter Google API key. Then on advanced settings, select 'Data Points' and 'find address' in City I enter Oxford, in State I enter 'Oxfordshire'. Click find address, and say yes to adding points. I then click next, and complete the wizard. Is this correct, do you need me to ask my hosts any questions? Thanks Again. Dan

Daniel W

Posts:18

05/18/2007 10:16 AM	Alert
Another thing I have noticed, is when I use the default settings it won't let me add any more than one point to the map. So I can have 1 point in the uk that I plot, but when I try and add anothers, using all the plotting methods it does not appear to add them....

ewalker

Posts:219

05/18/2007 10:31 AM	Alert
If I understand your correctly, you are referring to the vwPeopleOnline or the vwCountriesOnline. This is because these data sources are views which cannot be updates. You can only add data to XML data sources or table data sources.

Eric Walker - R2integrated

ewalker

Posts:219

05/18/2007 10:32 AM	Alert
I have tried reproducing your problem by running DNN from SQL Express, but I could not reproduce any problem with creating a table in GoMap.

Eric Walker - R2integrated

Daniel W

Posts:18

05/18/2007 11:04 AM	Alert
Righ noted. But even when I don't use these and try and use my own the data is not saved or written... It seems like the module is not being able to write to the db or something. Any other ideas? What should I ask my hosting company to check? Thanks Dan

Daniel W

Posts:18

05/18/2007 11:56 AM	Alert
Another update on this, when I use the XML option it saves the data! So not sure if this is a module, or access to my database problem? Can I use a XML file in the same way as we talked about above?

ewalker

Posts:219

05/18/2007 3:27 PM	Alert
Using an XML file, you will be able to record the Latitude and Longitude, but you will not be able to easily use a single SQL statement to transfer the points into the GeoLookup table. Alternately, you can go into your database and create a table by running this SQL statement: CREATE TABLE MyGoMapPoints (ID int identity(1,1), Zoom int, Latitude float, Longitude float, IconIndex int, Timer int, Timerinfo varchar(100), Description varchar(2000)) Afterwards, this table should show up in your GoMap Wizard.

Eric Walker - R2integrated

You are not authorized to post a reply.

Page 1 of 2

Forums > Bi4ce.Modules > GoMap (free module) > Getting a country/region split using Go-map

ActiveForums 3.6