 |
 |
|
|
|
|
 |
|
|
GoMap (free module)
Review and discuss the new FREE GoMaps module, Google Maps and DotNetNuke Integration.
| You are not authorized to post a reply. |
|
| |
|
dschaening
Posts:18
 |
| 05/09/2007 2:56 PM |
 Alert
|
| When trying to install I get this SQL error
StartJob Start Sql execution: 02.08.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --* TRIGGER UPDATE ON THE UserGeoLookup TABLE, USING THE GeoLookup TABLE UPDATE dbo.GeoLookup SET Country = 'Undefined' WHERE GeoLookup = -1 UPDATE p SET PropertyValue = PropertyValue FROM userProfile as p inner join profilePropertyDefinition as pd on p.propertyDefinitionID = pd.propertyDefinitionID and pd.PropertyName in ('City', 'Region', 'Country') --* ADD THE COUNTRY ONLINE VIEW SET QUOTED_IDENTIFIER ON
EndJob End Sql execution: 02.08.00.SqlDataProvider file
|
|
|
|
ewalker
Posts:219
|
| 05/09/2007 4:56 PM |
Alert
|
Is this an upgrade from an earlier version of GoMap, or are you installing GoMap on your DNN instance? Also, is a fresh DNN 4.5.1 install or is this a new DNN install?
Thanks |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/10/2007 7:04 AM |
Alert
|
| Fresh GoMap install and Upgraded 4.5.1 from 4.35>4.41>4.50>4.5.1 |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 10:39 AM |
Alert
|
Hi dschaening,
We have just released 2.8.1. Can you try installing this update and let us know if it resolves your issue?
|
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 10:53 AM |
Alert
|
| Should I uninstall first?
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_UserGeoLookup'. Cannot insert duplicate key in object 'UserGeoLookup'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --* TRIGGER UPDATE ON THE UserGeoLookup TABLE, USING THE GeoLookup TABLE UPDATE dbo.GeoLookup SET Country = NULL WHERE GeoLookup IS NULL --* ADD THE COUNTRY ONLINE VIEW SET QUOTED_IDENTIFIER ON |
|
|
|
dschaening
Posts:18
|
| 05/11/2007 11:15 AM |
Alert
|
ok I uninstalled the last version and installed this version and we have a working copy! Thanks
What I would like to do with this module is probably typical. Use the user base and be able to enter an address and display users within a radius of the address input. Can you point me in the right direction to accomplish that feat? |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 11:23 AM |
Alert
|
| Hi dschaening, the default search options when GoMap is set to Directory mode has an Address search box. Take a look at the settings in the Wizard as starting point. |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 11:47 AM |
Alert
|
| I have that working, but it will not display the directory items...I used the defaults and copied the css file to the Module root from the sample. What am I missing? There are no instructions on this part. |
|
|
|
dschaening
Posts:18
|
| 05/11/2007 12:08 PM |
Alert
|
| When I try to plot points to be added to a new table created by gomap, the 'fetching data' runs and never gives me any options, maybe that is the issue? |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 2:28 PM |
Alert
|
| That may be the issue. Have you gotten either of the default views to work? |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 2:31 PM |
Alert
|
Yes I have the vwPersonOnline working for plotting and such. Two issue remain though.
The directory does not display, but the search does, and works. (using default templates)
The plotted locations are way off. Went into the table and checked the lat/long which are correct, but they are rendered off on the map, maybe 150 miles or so.
Anyway to get this to look like your demo on this site? That is exactly what I am looking for? |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 3:05 PM |
Alert
|
GoMap needs a text area on the page (a div) defined somewhere on the page to insert its results.
Try adding this HTML to the page:
You need one DIV with the id myResults, and a second with id myPager to display a pager in case multiple results are returned.
|
|
Eric Walker - R2integrated |
|
ewalker
Posts:219
|
| 05/11/2007 3:08 PM |
Alert
|
Here is that HTML again:
<div id="myResults" style="width: 100%; font-family: arial; font-size: 11px;"></div>
<br>
<div id="myPager" style="width: 100%; font-family: arial; font-size: 11px;"></div> |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 3:16 PM |
Alert
|
| I thought it rendered and this was an override value, so it lists everything, but the points are still off |
|
|
|
dschaening
Posts:18
|
| 05/11/2007 4:09 PM |
Alert
|
| oh, and it is rendering multples per point and there are no addresses like in your demo. |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 4:32 PM |
Alert
|
| Can you post a link to your example? There may be an issue with the logic in calculating the search radius. |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 4:38 PM |
Alert
|
I still need to clean up some formatiing but here you go.,
http://intranet.mymcteam.com/Home/EMPMap/tabid/384/Default.aspx
Seems as if only the Country and State are plotted, but I am using the Persons View? Do I need to create this procedure myself, because the lat/long are correct. |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 4:44 PM |
Alert
|
| If you look at the views that ship with GoMap plot an address, they lookup the country, region, and city from the GeoLookup table on a best effort basis. GoMap populates this table with countries and states, but it does not contain any data for cities. If you need more accuracy, you will need to add more records to the GeoLookup table , or lookup the latitude and longitude for your points using a different method. |
|
Eric Walker - R2integrated |
|
dschaening
Posts:18
|
| 05/11/2007 4:46 PM |
Alert
|
| I was just looking at that. If I add those columns, is the logic already there to lookup those items, or do I need to rewrite some code? |
|
|
|
ewalker
Posts:219
|
| 05/11/2007 4:47 PM |
Alert
|
| vwPeopleOnline and vwCountriesOnline will automatically pick the most detailed match in this order: city, state, country, so yes, if you add city data, it will automatically work. |
|
Eric Walker - R2integrated |
|
|
| You are not authorized to post a reply. |
|
|
|
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:
- DNN Version
- Module Version
- Admin Log Viewer Information
- 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
|
 |
|
|
|
 |
|