Steven JW Kennedy

My Blog

Archive for the ‘SharePoint’ Category

Microsoft SharePoint, MOSS, WSS, SharePoint server etc.

Plotting SharePoint List Data on a Google Map – Part 2

Posted by Steven Kennedy on April 11, 2011


First off I’d like to acknowledge Kyle Schaeffer’s posting Plotting Your SharePoint 2010 List Data on a Google Map which I used as the starting point for my little project. I was also just going to make this a single post, as I implied in my initial post on this topic Plotting SharePoint List Data on a Google Map – Part 1, but as I started to write this post it got longer and longer, so I’ve broken it up in to multiple posts that I’ve listed below. You can either jump to the specific post of interest, or you can go through from Step One. Each post has a link to both the previous post and the next post in the series. The SP & GM used in the post titles indicate ‘SharePoint & Google Maps’, making it a little bit easier to identify the posts as part of the same series.

Scenario

What I wanted to do was take a set of address information and plot it on a Google Map, with the markers being clickable and showing various salient information about the location. In my case I mocked up some location information to emulate a company with sites across the USA, along with the number of employees at each site. You could also use something similar to indicate what type and or the size of the sites network connections. Does it have direct Internet access etc. For my example I’m keeping it simple, Location and number of employees. Also, instead of using Google’s geocoder function, to resolve an address to a Lat/Long, I’m going to provide the Lat/Long as part of the SharePoint List data. This means some additional up front work, and ongoing as new locations are added but this is off-set by the issues created in trying to use the geocoder functionality for something like 200 locations and the various limitations imposed by using the free capability that Google provides.

Requirements to use these posts to do the something similar;

  • SharePoint 2010, and appropriate access to be able to create;
    • a SharePoint 2010 List
    • a web part web page
    • use SharePoint Designer 2010 to edit the web part web page (some companies may have restricted this capability. In which case you’re out of luck and you wont be able to follow these instructions.)
  • A set of data, including location information, that you wish to plot using Google Maps

Note! This example makes use of the Google Maps V2 API (which has been deprecated already, but still works) along with jQuery.

Additional posts in this series

If you follow the steps outlined above you should be able to end up with a Google Maps displayed on a SharePoint page that looks something like;

image_thumb[10][1]

Posted in Google, SharePoint 2010 | Tagged: , | 4 Comments »

Plotting SharePoint List Data on a Google Map – Part 1

Posted by Steven Kennedy on April 11, 2011


At the beginning of March I attended a Google Technology User Group meeting where the presentation was about the use of Google Maps and Fusion Tables. I have a short post Fusion Tables and Google Maps about the meeting and a quick example that I cobbled together.

The use of Fusion Tables got me thinking about something that I’d played with a year or so ago. Using a SharePoint List to provide data to a Google Map. I did some work at the time to see if I could make this happen, borrowing greatly from the Internet as I’m not a JavaScript developer. I had some limited success but then as they say ‘stuff happened’ and I wasn’t able to pursue it. The meeting on Fusion Tables got be thinking about it again so off I went to the Internet to see what’s out their. This time for SharePoint 2010.

I came across a good posting called Plotting Your SharePoint 2010 List Data on a Google Map by Kyle Schaeffer. This posting gives pretty good instructions on who to use the Google Maps v2 API and jQuery to generate markers on a Google Map based on SharePoint List data.

However, I did run in to a number of issues in trying to follow Kyle’s instructions, based mainly I believe on the fact that he’s writing for experienced developers, which I’m not.

So, a few of the things that I ran in to;

  • SharePoint List Data – In Kyle’s example the address data is held in a multi-line field. In mine it wasn’t. Kyle explains how to reference the data from his example but not for a general case. I had to work that out. He also talks about how to change the class name but again doesn’t say how. I still haven’t figured this bit out.
  • Google Map in relation to the SharePoint List data. I found out the hard way, a couple of hours of it not working, that you need to ensure that you’re SharePoint List appears on the page ABOVE the Google Map
  • GeoCoder – this is the function of taking an address and getting the corresponding Latitude/Longitude that can be used by Google Maps. What isn’t mentioned in Kyle’s post is that there are limits to the number of Geocodes you can do per day, and the speed at which it’ll respond. There’s also no error checking. I found this out the hard way when I tried to plot just under 200 points. Not all of them where being displayed. It turned out to be a combination of inaccurate addresses and the speed at which I was calling the geocode function. I did try putting in a time delay but that didn’t seem to help.

So what did I take away from Kyle’s post. Well the two most important elements to making it work, that of making the SharePoint List available and most importantly how to cycle through each entry in the list in order to obtain the relevant data to put a marker on the map.

In Plotting SharePoint List Data on a Google Map – Part 2 I’ll start to detail how I took Kyle’s instructions as a basis for producing a Google Map with clickable custom markers based on data from a SharePoint List.

The picture below depicts what I ended up with in Plotting SharePoint List Data on a Google Map – A series of company sites with custom icons used to indicate the number of employees on site. The icons are clickable and display the address information, number of employees at the site as well as a link to step zoom to the location. The location depicted below is an old address of mine when I lived in Los Angeles many years ago.

image

Posted in Google, SharePoint 2010 | Tagged: , | 1 Comment »

Error when listing or trying to change Server Roles or Features on Server 2008 R2

Posted by Steven Kennedy on December 31, 2010


I recently ran in to an issue when I was working with my SharePoint 2010 server. I was trying to set it up to be able to send an receive emails. In order to do so I went to enable the SMTP feature on the the server, only to get an error when I tried to access it via Server Manager.

I stopped and restarted Server Manager but to no avail so I re-booted the server. I still got the same problem. As I was somewhat impatient I decided to try to enable the SMTP Feature via PowerShell. However, when I tried that I got an error there as well, unfortunately I didn’t take a screen shot or note the wording.

I then started to look in the various Windows logs to see if there was anything there. I did see the same error popping up a number of times, in the System Log and the Application log. I’ve included both screen shots and the text, of both the errors I saw, below.

——————————————————————-

The Windows Modules Installer service terminated unexpectedly.  It has done this 5 time(s).

Windows Modules Installer - System Event Log Entry

——————————————————————-

Faulting application name: TrustedInstaller.exe, version: 6.1.7600.16385, time stamp: 0x4a5bc4b0
Faulting module name: ntdll.dll, version: 6.1.7600.16559, time stamp: 0x4ba9b802
Exception code: 0xc00000fd
Fault offset: 0x0000000000052880
Faulting process id: 0xa04
Faulting application start time: 0x01cba90ddb32e4d5
Faulting application path: C:\Windows\servicing\TrustedInstaller.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 2f761c45-1501-11e0-9d8d-00155d01051c

Trusted Installer - Application Event Log

I did some searching on the Internet to see what came up associated with these two errors but nothing much came up except to change what action should be carried out when the service failed.

After some more searching I cam across an entry on a site called Fix my IT system that pointed me to a Microsoft Hotfix that you can find here

I applied the hot fix, for Server 2008 R2, no re-boot required, and that fixed my problem. I was then able to run Server Manager and add the SMTP service Feature.

Posted in Operating Systems, Server 2008, SharePoint 2010 | Tagged: | Leave a Comment »

Missing Server Side Dependencies – 8d6034c4-a416-e535-281a-6b714894e1aa

Posted by Steven Kennedy on December 15, 2010


(First posted on my web.me.com/stevenjkennedy blog on 9th October 2010)

Information configuration issue;

[MissingWebPart][WebPart class [8d6034c4-a416-e535-281a-6b714894e1aa] is referenced [6] times in the database, but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database, but are not installed on the current farm. Please install any feature or solution which contains these web parts.] 

There is a blog entry here, that talks about how to ‘fix’ this problem. I tried it and it worked for me. The information given, visit the two web pages SearchAdministration.aspx and SearchFarmDashboard.aspx worked only there where no directions on how to get to the two pages. I had to go searching (pun intended) for them, checking the URL address until I found them.

Having visited each page I then went back to the SharePoint Centralized Administration and re-checked to see if the issue was still showing up. It wasn’t.

So where where these pages? Well SearchFarmDashboard.aspx is accessed via Central Administration.General Application Settings.Farm Search Administration, as shown in the pictures.

image_2_36F31C30

image_4_36F31C30

The page SearchAdministration.aspx can be accessed by clicking on Search Service Application. The resulting page is shown below.

image_6_36F31C30

Posted in SharePoint 2010 | Tagged: | Leave a Comment »

Google Analytics connector of SharePoint 2010–Traffic received

Posted by Steven Kennedy on December 14, 2010


So, now I have traffic to look at. Well, it’s only my own traffic but as I’m doing this just as a proof of concept, and to see what information Google Analytics collects, that’s okay.

The screen shot below shows the traffic for the one day that Google Analytics has been gathering information. I’ve switched the display to show page titles, rather than the URL for the page, Google collects them both.

I could see where either the URL or the page title might give some cause for concern, from an IT Security perspective but I’ll explore these possibilities in a later posting, once I have some more data.

Content by Title

Now I get to visit various pages on my SharePoint 2010 My Site to see what turns up in Google Analytics.

I guess one other approach would be to look at the JavaScript used by Google Analytics to decipher what information it’s collecting – what a novel approach! The bad news is I don’t do JavaScript, well not development. I’ve cobbled together some from examples I’ve obtained from the ‘net so perhaps I’ll look in to this.

Posted in Google Analytics, SharePoint 2010 | Tagged: , | Leave a Comment »