Google Analytics data in a SharePoint list

Jacob Reimers has written an C# API for accessing Google Analytics data.When I saw his post, I thought it would be great to fetch the latest data every day, and write it to a SharePoint list. Then you can use the data, without querying Google for every request. You could then use the ChartPart for SharePoint to generate nice charts from your Google Analytics data. E.g. one for the visits for the last month.

Anwendungsentwicklung mit SharePoint 2010

Fabian hat es auf seinem Blog schon geschrieben. Deshalb werde ich auch über unser Projekt bloggen. Zusammen schreiben wir ein Buch zum Thema Anwendungsentwicklung mit SharePoint 2010. Das Buch richtet sich an Entwickler, Anwender und Administratoren und hat das Ziel, Wege aufzuzeigen, mit denen Unternehmenslösungen mit SharePoint 2010 realisiert werden können.

SPFarm.Local is null?

It took me some time to find the solution to a problem, where a WPF application could not connect to a local SharePoint farm via SPFarm.Local. It always returned null. Windows 7 was not the problem. I copied my application to a Windows Server 2008 VM to test. In case somebody has the same problem, here is the solution: Make sure you have set the Platform to “Any CPU” and not x86 if you are using x64 assemblies.

SPDispose or not to SPDispose

Roger Lamb has posted an article about SharePoint objects, which must not be disposed. He also wrote about changes to SP 2010 regarding disposing objects. SPContext.Current.Site SPContext.Current.Web SPContext.Site SPContext.Web SPControl.GetContextWeb(..) SPControl.GetContextSite(..) SPFeatureReceiverProperties.Feature.Parent SPItemEventProperties.ListItem.Web SPList.BreakRoleInheritance() Do not call list.ParentWeb.Dispose() SPListEventProperties.Web SPListEventProperties.List.Web SPSite.RootWeb Problems may occur when SPContext.Web has equality to the SPContext.Web.. make sure you dispose of SPSite and it will cleanup sub webs automatically SPSite.

Getting started with Silverlight development

Tim Heuer has written 7 posts about Silverlight development. So if you haven’t started with Silverlight but plan to, have a look at his post series. Part 1: Really getting started – the tools you need and getting your first Hello World Part 2: Defining UI Layout – understanding layout and using Blend to help Part 3: Accessing data – how to get data from where Part 4: Binding the data – once you get the data, how can you use it?

CodePlex project

Today I’ve created a CodePlex project for some of my SharePoint developments. Interesting to see what I’ve done so far 🙂 The link is Webparts [Access Fileserver Data via SharePoint][3] [Display all my alerts][4] [Webpart to show Sitecollections/Subwebs][5] [TagCloud Webpart][6] [Display a single ListItem][7] Custom Fields [Upload Files and Images][8] Features [.NET 3.5 and Silverlight][9] Control Adapter [Navigation for Wikis][10] Event Handler

Develop your own Windows Service

Writing a Windows Service is very easy. Deploying it with a Setup is an easy task as well. But be careful what option you set for the failure behavior! In my case I installed the service with “Windows Installer XML (WiX) toolset”. Do not use critical as ErrorControl value. It will force a reboot of the server, if the services fails to start. Fortunately booting with “Last known good configuration” worked for me and I could uninstall the service…

Get Central Administration Webapplication

With this code you can get the central administration webapplication.1: private static SPWebApplication GetCentralAdministrationWebApplication() <span class=lnum 2: </span{3: SPWebService cS = SPWebService.ContentService; <span class=lnum 4: </span var service = cS.Farm.Services.GetValue<SPWebService>(<span class=str"WSS_Administration"</span);5: SPWebApplicationCollection webApplications = service.WebApplications; <span class=lnum 6: </span <span class=kwrdforeach</span (SPWebApplication webApplication <span class=kwrdin</span webApplications)7: { <span class=lnum 8: </span <span class=kwrdreturn</span webApplication;9: } <span class=lnum 10: </span <span class=kwrdreturn</span <span class=kwrdnull</span;11: } If you have a better way, let me know 🙂

Control.ClientID has wrong value

An ASP.NET Controls has a ClientID property. SharePoint Controls inherit from the ASP.NET Controls. The property will give you the ID, the rendered control will have in the HTML source. There is one thing to remember: The ClientID is valid only, if the control has been added to the Controls of the Page!ID **before** adding the control ID **after** adding the control FilterButton **ctl00\_m\_Webpart1_**FilterButton So if you need the ClientID e.

New WSPBuilder version

Carsten Keutmann has released a new version of his great WSPBuilder. Here are the new features: A Reference folder under GAC and 80/Bin is now supported for large dlls that do not need reflection for SafeControls and Permissions. New menu function “Recycle the Windows SharePoint Services Timer” implemented on WSPBuilder Extensions. Refactoring of “Copy to GAC” in order to improve the functionality. Bug fixed! “Unable to get solution id from manifest: Unable to extract manifest.

Multi Level Navigation

The out-of-the-box WSS navigation offers one level of navigation. The navigation elements can be configured in the site settings. There is a way to make it have multi level navigation, as MOSS does, by changing the DataSource. But this “hack” is not flexible, as you can not reorder the item within the navigation menu. While I was reading the post How to create your own Cascading Navigation using the ASPMenu control, the decision was made to build a custom navigation which supports multiple navigation levels.

Using SharePoint Controls

Back from vacation. 1 week with an offline version of feeds is hard. So I read the postings I got closely 🙂 One post I do want to bring your attention to, is about SharePoint Controls. My post about using the SharePoint Controls shows how to use the controls you see in forms (TextField, NumberField, LookupField…). There are plenty of SharePoint controls, which you can use. Robin Meure has written a post “re-using SharePoint controls”.

.NET 3.5 and Silverlight

Using AJAX or Silverlight from within SharePoint in Webparts requires you to modify the web.config to support the technology. I don’t mention that you have to install the .NET Framework 3.5 SP1 and Silverlight to be able to use it… Instead of changing the web.config manually (.NET Framework 3.5 AJAX und Silverlight in SharePoint registrieren von Fabian Moritz), you can use my features. They do all the necessary changes for you.