Ben There, Done That

If you’re like us, chances are you have users accessing SharePoint from several different browsers.  SharePoint 2007 can bring about many challenges for users not wanting to Internet Explorer, one of which is replying to threads in a SharePoint Discussion board.

To be perfectly honest I’ve never been a huge fan of the discussion board in SharePoint, so I haven’t often paid much attention to it.  However, since switching jobs, I have found the users here love the discussion board.  The first thing I did to make it even better for users, was to download the Quest Discussion board web part, to give users a much nicer interface for viewing posts.

Recently, more and more of our users have been accessing discussion boards from a browser other than IE.  When replying to a discussion, this brings up and ugly mess of HTML for the end users if they are replying from FireFox, Safari or Chrome.

We had three options for solving this:

1. Training – Make sure all users know that when replying to a discussion, they are not to touch the HTML, but simply add their response above it.  Feasible…but definitely not the best idea.

2. Require all users to use IE – hahaha…yeah right! Parts of our environment are accessible to our users from home as well as a subset of our users having the ability to choose if they want a MAC or a PC.  This just won’t happen.

3. Find a way for users to edit rich test (eliminating the HTML) when responding to or posting a new item in a discussion board.

Thanks to Telerik, we were able to take approach #3.  The Telerik RadEditor Lite (bottom of the page) provides two features.  One feature to use the RadEditor for Rich Text fields when using a browser other than IE and the second feature to use the RAdEditor for IE as well.  After adding and deploying the solution to the SharePoint farm and activating the feature on your SharePoint site, when you edit a Rich Text field from a browser other than IE, instead of the ugly html you are given a nice, easy to use Rich Text field from Telerik.

This is starting to get dangerous…I’m blogging about SharePoint development twice in a row.  Again, this may be something very basic to most SharePoint developers, but as I learn, I enjoy blogging about issues I’ve discovered and things I’ve learned as I continue to develop more.

My next venture into SharePoint development is to create some custom .ASPX forms for use within our SharePoint environment.  For our situation, InfoPath Forms Services would make much more sense, unfortunately, we only have SharePoint 2007 Standard with no plans to go to Enterprise.

So, I created a very basic .ASPX file with an equally as simple .cs (code behind file), packaged it all up as solution and deployed it.  However, when I went to access the site, I encounter a “Could Not Load Type…” error.  After a quick search on Google, I found – http://blogs.catapultsystems.com/matthew/archive/2007/12/07/could-not-load-type-error.aspx between that post and the post by Andrew Connell that was referenced there I was able to solve my problem.

When I had created my .aspx file I had failed to use the “5 part name” to reference the assembly file.  I had put Inherits=”NewForm.NewForm” rather than Inherits=”NewForm.NewForm, NewForm, Version=1.0.0.0, Culture=neutral, PublicKeyToken=*********”

As soon as I changed my .aspx file to use the 5 part name and redeployed my solution everything worked perfectly!

Read the RTM announcement from the Microsoft SharePoint Team Blog – http://blogs.msdn.com/sharepoint/archive/2010/04/16/sharepoint-2010-reaches-rtm.aspx

Great job guys!  Can’t wait to get my hands on it

As discovered by Todd Carter there is a memory leak in SharePoint 2007.  He has outlined the details as well as a work around to the fix the memory leak.

I decided to do some testing with it, however, when I compiled the dll, placed it into the GAC, and changed my global.asax file, I started getting this error: “Could not load file or assembly ‘[Assembly Name]’ or one of its dependencies.  The system cannot find the file specified.”

After digging into this error for a while I discovered my problem.  This may be fairly obvious to developers out there , but coming at this from more of a SharePoint administrator type roll, I missed this one step that isn’t outlined in the steps provided by Todd.

After deploying your dll to the GAC, you need to open up your web.config and place

<add assembly="[Assembly Name], Version=[Version Number], Culture=neutral, PublicKeyToken=[Public Key Token]" />

in the web.config file of the web application you wish to apply your fix to.  This line should be added between <assemblies> and </assemblies> in the web.config file.

All of the information: Assembly Name, Version Number and the Public Key Token can be found by right clicking on your dll in the GAC and viewing the properties of the dll.

Once I added the assembly to my web.config for the web applications I was trying to apply the fix to, everything worked as expected.

I was working with SharePoint surveys the other day and discovered an old issue working with surveys and Microsoft Office that appears to have resurfaced.

We were trying to see what other reports we could generate from a SharePoint survey.  Naturally with the option to export to Excel, we figured why not just export all the survey data into Excel and play with it there.  To test it out I tried to get a variety of questions in the survey, one of these questions being the rating (matrix) survey question.

I created a few responses to the survey and attempted to export the list data to Excel (I’m running 2010 Beta).  Everything came over well with the exception of the matrix type questions.  I did some searching and this was also an issue with Excel 2003.  However, people said it was resolved with Excel 2007.  I installed Excel 2007 and sure enough the matrix questions imported into Excel 2007 just fine.  I tried Excel 2010 once more and the values still failed to come over.

So, it appears that the problem with importing matrix type of questions from SharePoint 2007 to Excel 2003 has returned in Excel 2010.  Granted, this is the beta, so maybe it will be fixed by the release.

I also want to do some testing with SharePoint 2010 surveys, Excel 2010 and possibly PowerPivot.  I’ve been reading some great things about PowerPivot but haven’t had much of a chance to play with it for myself.  Once I get a chance to do some testing with these tools I’ll write a new post.  Hopefully there will be some good news about doing more in depth analysis of SharePoint Survey results using these new tools.

SharePoint is designed to security trim your search results based on your user ID, a great feature to have in SharePoint as you don’t want search to return results of pages and content a user doesn’t have access too.  However, this requires one extra “step” at times when moving a site from development to testing or even to production.

I’m sure this topic has been blogged about before as this isn’t the first time I’ve run into it, but I figured I would write a short post about it for anyone that encounters what would appear to be an issue with their Search in SharePoint.

The scenario: You have been building out a SharePoint site and you are ready to release it to the rest of your users. You have tested everything using your own credentials.  You add a new user to the site with credentials equivalent to your end users and start testing with those credentials before going live.  Everything is working as expected…until

The problem: Your perform a search…You go to your search page, search for some well known content that you know should be returned, but you get no results in SharePoint search.  Your navigate to the page and you have access to it and can view the content you are searching for.  To further test, you run a few more searches, but everything comes back with no search results.

The resolution: When SharePoint performs a crawl (incremental or full) it looks at all your content AS WELL AS who has permission to access the content.  If you add users to your site, and immediately try a search before running a search crawl, the search index still has that the newly added user doesn’t have access to the content.  So, if you are going to add new users to the site that need access to search, or you are going to be testing search, immediately after adding those new users, run an incremental crawl so your SharePoint search index can pick up that these new users actually have access to the content you are searching for.

Unfortunately, I was unable to attend the SharePoint conference this year. However, I have been trying to follow it all day via twitter and the #SPC2009 hash tag. There have been a ton of tweets and with the tweets and the amount of people a lot of duplicates. As tweets have been going out all day I’ve tried to capture new blog posts about the 2010 stack and am attempting to put together a good list of blog posts that I’ve have noticed today (and continue to notice throughout the week). Feel free to send me any blog posts I have missed or you would like me to add to my site. So, here they are:

SharePoint

SharePoint Overview from the Microsoft SharePoint Team – http://blogs.msdn.com/sharepoint/archive/2009/10/19/sharepoint-2010.aspx

SharePoint 2010 Home Page - http://sharepoint2010.microsoft.com/Pages/default.aspx

SharePoint Conference 2010 Home Page (Keynote video soon) – http://www.mssharepointconference.com/Pages/default.aspx

SharePoint Conference Video Highlights – http://www.mssharepointconference.com/Pages/videohighlights.aspx

SharePoint 2010 MSDN Site – http://msdn.microsoft.com/en-us/library/dd776256.aspx

SharePoint 2010 TechNet Site – http://technet.microsoft.com/en-us/sharepoint/default.aspx

Pre-Register for SharePoint 2010 Beta – http://sharepoint2010.microsoft.com/try-it/Pages/Trial.aspx

Arpan Shah, Welcome to SharePoint 2010 – http://blogs.msdn.com/arpans/archive/2009/10/19/welcome-to-sharepoint-2010.aspx

Andrew Connell’s Blog (Several SharePoint 2010 posts already) – http://www.andrewconnell.com/blog/

SharePoint Sharpener, Rundown of New Features – http://sharepointsharpener.wordpress.com/2009/10/19/spc09-sharepoint-2010-unveiled-rundown-of-new-features/

SharePoint 2010 Installation (not in English, but has screen shots of the install) – http://sharepointsisters.de/2009/10/installation-sharepoint-server-2010/

SharePoint 2010 Preview by Knowledge Management Associates – http://blogs.kma-llc.net/microknowledge/2009/10/sharepooint-2010-preview.html

A listing of SharePoint 2010 Documentation and Posters published by Microsoft – http://bink.nu/news/sharepoint-2010-documentation.aspx

Document Management in SharePoint 2010 – http://dotneteers.net/blogs/aghy/archive/2009/10/19/document-management-in-sharepoint-2010.aspx

ZDNet SharePoint 2010 Announcement – http://blogs.zdnet.com/microsoft/?p=4278

Corey’s SharePoint 2010 Observations – http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2009/10/19/corey-s-big-post-of-sharepoint-2010-observations.aspx

Ballmer, SharePoint and the Economy – http://www.infoworld.com/d/developer-world/microsofts-ballmer-shows-sharepoint-and-cites-its-link-economic-prosperity-587

Another index of some SharePoint 2010 postings online – http://webpartner.com/PNPT#7fc51a6079d86e3841db

Mike Gotta Notes from SPC09 Day 1 – http://mikeg.typepad.com/perceptions/2009/10/sharepoint-2009-conference-morning-keynotes.html

SharePoint 2010 Public Beta to be released next month – http://news.cnet.com/8301-13860_3-10377483-56.html

StoragePoint for SharePoint 2010 – http://www.reuters.com/article/pressRelease/idUS164545+19-Oct-2009+PRN20091019

SharePoint 2010 Central Admin – http://planetmoss.blogspot.com/2009/10/central-administration-in-sharepoint.html

Eli Robillard, Sandbox Solutions and Security in WSS 4.0 (SharePoint Foundation) – http://weblogs.asp.net/erobillard/

SharePoint Conference 2009, Morning Keynote from The Burton Group – http://ccsblog.burtongroup.com/collaboration_and_content/2009/10/sharepoint-2009-conference-morning-keynotes.html

SharePoint 2010 Links from S.S. Ahmed, SharePoint MVP – http://vspug.com/ssa/2009/10/19/sharepoint-2010-links/

Lookup Columns in SharePoint 2010 – http://weblogs.asp.net/bsimser/archive/2009/10/19/sp2010-what-s-new-lookup-columns-spc09.aspx

Overview of SharePoint Conference 2009, Day 1 – http://weblogs.asp.net/bsimser/archive/2009/10/19/the-kimono-is-open-the-veil-is-lifted-the-gags-are-removed-spc09.aspx

BI

BI in SharePoint 2010 – http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99-f288-47c2-916b-2f32864f7b82&ID=268

Office 2010

PivotPoint for Excel 2010 – http://www.powerpivot.com/

Office 2010 Public Beta to be released next month – http://news.cnet.com/8301-13860_3-10377483-56.html

Visual Studio 2010

Announcing Visual Studio 2010 – http://blogs.msdn.com/somasegar/archive/2009/10/19/announcing-visual-studio-2010-and-net-fx-4-beta-2.aspx

Again, this is just a list of what I could capture while keeping an eye on twitter all day.  Feel free to email me addition blog posts or add them as a comment as I will try to continue updating this list throughout the week.

After four days at Baptist Health, the team launched the new Wolfson Children’s Hospital site today on SharePoint.  Being there for the short time I have, I didn’t have a lot to contribute to the site, nonetheless it is still very exciting for the whole team.  Feel free to head over to the site, check it out and let us know what you think!

Tags: SharePoint, Baptist Health, Wolfson Children’s Hospital, Health Care

Powered by Qumana

That’s right, it is time for me to move on to a new job.  Today was my last day with EPC Group.  It has been a wonderful year and a half with them, consulting with companies I never imagined I would be working with.  I have learned and grown a lot in my SharePoint knowledge while working with them as well as made some great friends that hopefully I will continue to stay in touch with.

About 7 weeks ago I was contacted by a friend of our Pastor about a job, working locally to Jacksonville, FL performing SharePoint Design and Administration for Baptist Health.  After a couple of interviews, a job offer, and discussing it with my wife, we decided the best option for me and our family going forward was to accept the position with Baptist Health.  So, it is with excitement, that I will be starting in my new position with them on Monday.

I hope to continue this blog and updating it regularly with my experiences, tricks and tips about SharePoint.  We’ll have to see which direction this blog takes.  But with my new position being in the health care field, hopefully I can write some post about SharePoint and how it relates to and can be utilized within the Health Care Industry.

Tags: SharePoint, Health Care, Jobs, EPC Group, Baptist Health

Powered by Qumana

The other day I was assisting a client changing the URL to their SharePoint environment.  They are also running PWA under this site.  The name change went very smoothly and I thought everything was running great.  I had removed the old URL from the AAM and set the old site to redirect in IIS so anyone typing in the old URL would be taken to the new one.

My joy at the success was short lived.  Shortly after completing I got an email that user were getting errors when trying to upload files, view/edit file properties, pretty much anything with a file in a document library.  They were getting the error "File not Found".  I tested it out myself on the root site and it worked fine, I asked for examples and they were only have the problems on the PWA Project Workspaces.  I dug into the SharePoint log files and apparently something in PWA was still referencing the old URL.  I thought to myself, great, do I need to leave the old site running to?  Doing some searching, I found this post that solved the problem.

Apparently PWA puts an absolute URL in the content databases.  If this doesn’t exists you get the error.  The good news, you don’t need to modify the content database (something you should never do anyways).  Even better, the site doesn’t even need to be running, just add the URL back into AAM (even if the site doesn’t exists in IIS..or in my case is redirecting) and everything goes back to working as expected.

Tags: SharePoint, PWA

Powered by Qumana