Remove IP Address Tracking in Webform Submissions

The client wanted the ability to create web forms and receive submissions in their Drupal 6 website, but they aren't allowed to collect information about users. The Webform module is a great solution, but by default they collect the user's IP Address.

Excel Web Access Web Part Errors in Sharepoint 2010

After migrating content from one Sharepoint installation to another, content meant to display in an Excel Web Access Web Part was throwing errors. The first required going into Central Administration and adding the entire website to the Trusted File Location for the Excel Service Application.

This was done by going to Manage Service Applications, Excel Services Application, Trusted File Locations, and adding the root URL to the list.

The second error displayed to the user as:

The workbook cannot be opened.

I searched for that phrase on Google and came across a blog post that suggested checking the Event Viewer for more details. In Event Viewer, the details included:

'Unable to open workbook due to unexpected exception: Microsoft.Office.Excel.Server.Host.HostFileException ---> System.Data.SqlClient.SqlException: Cannot open database "SP_Content" requested by the login. The login failed.
Login failed for user 'DOMAIN\spservices'.

The blog post referenced another very useful blog post: http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx

I opened PowerShell and ran the following two lines of code:

$w = Get-SPWebApplication "http://domain.com"

$webApp.GrantAccessToProcessIdentity("DOMAIN\spservices")

Now, the Excel Web Access Web Part seems to be working as it did in the old site.

No Left Navigation on New Web Part Pages

I found it a bit frustrating to manually add the left navigation to every new web parts page created in Sharepoint 2010. The manual process includes commenting out two chunks of code in each web parts page created which I figured out with the help of this site: http://blogs.technet.com/b/seanearp/archive/2011/03/09/how-to-create-a-sharepoint-2010-web-part-page-that-inherits-the-site-s-left-navigation.aspx. I knew there had to be a way to do it once for all new web parts pages.

Access Denied for All Users

I recently encountered a problem logging in. I could log in as the admin or any other user, but it would show the "Access Denied" message instead of the admin controls. The site worked fine for anonymous users, but no one could log in to make changes.

Extracting Month and Year from a Date and Time Field

I created a series of of document libraries in Sharepoint 2010 to archive minutes from meetings. I wanted to create a view that grouped the minutes by year and month, but I only wanted users to enter the date of the meeting. I figured out how to extract the month and year from the date column and display those as separate columns.

Redirection that works

Content administrators needed a way to control the URL to their external web application and be able to edit/show a maintenance message when the application was down for updates.

I created a new content type with a CCK link field for the URL and a single on/off check box for the administrator to turn the maintenance message on or off. The maintenance message lived in the default title and body.

MySQL crashed and nodes display "n/a"

MySQL crashed due to a lack of hard drive space. More hard drive space was allocated and MySQL was restarted. For a moment, the site appeared to be fine. A minute later, everywhere a node was suppose to display, "n/a" appeared instead.