Mobile View Doesn’t Work on SharePoint ( WSS 3.0) List

I recently ran into a situation where I couldn’t get the ‘Mobile View’ in WSS 3.0 to work on a list that I had created. I went into the view of the list and selected the Mobile checkboxes (‘Make this a mobile view ‘ and ‘Make this the default mobile view‘), but it still was not showing up on my SharePoint site’s mobile homepage. My first thought was “What makes this list different than the other lists that have mobile views that are working?”

The answer was easy: I had created the list by selecting Custom List in Datasheet View from the ‘Create’ page. There are no mobile view choices for datasheet views, so I had created a new ‘standard’ view for the list. Even though I could check the ‘ Make this a mobile view ‘ checkbox, it was not showing up on the mobile homepage.

I basically had to recreate the list using the Custom List option, instead of Custom List in Datasheet View option. This is likely a bug; I haven’t been able to come up with a reasonable explanation as to why it would act this way (and the fact that the Mobile options showed up reinforce my bug theory).

How to Enable Incoming Email within SharePoint 2007



SharePoint 2007 allows for emails to be accepted into discussions, document libraries and lists. To enable this functionality, a few steps will need to be followed. One thing to note: integrating SharePoint with Exchange is NOT needed for this functionality, but if you do choose Exchange, you will get some added benefits.


-SMTP Service

You will need to install the SMTP Server Service on the SharePoint server. This is done via add/remove programs, and within the IIS component listing.


-Enable Incoming Email

Now, enable Incoming Email from the Central Administration website. It is found by following: Central Administration > Operations > Incoming Email Settings


-SMTP Connector

You will finally need to configure an SMTP connector within your email server so it knows where to send emails you designate for SharePoint.

SharePoint Database Performance – Moving the SharePoint SQL Database to New Location on the Same Server

I run an instance of WSS 3.0 on a machine at home for testing. I don't use it much because it is so slow unless you are on the LAN. I always knew it was because of SQL, but I didn't really have time to look into fixing it. See, I don't have the option of having two separate drives in the machine. NOTE: You should never run SQL databases on the same HD spindle where the OS is located due to exactly what I was experiencing: slow response.

Then I woke-up to the year 2007 and apparently there are external HDDs you can buy…okay, I knew about them; I just didn't put too much thought into it. This evening, I moved my SharePoint databases to the new external HDD and the responsiveness of SharePoint increased tremendously.

I did a search on how to move the dbs without causing problems, and honestly, I was unable to find any websites/postings that matched my scenario exactly. The postings talked about: 1) moving from the Microsoft SQL Embedded Edition (MSEE) version to full SQL or 2) Moving to a different server

So, here are my pretty simple steps to move my SQL database to a new HDD:
1) Made sure I had backups of the database and of the SharePoint sites!
2) Make note of the dbo for all SharePoint databases
3) Stopped all SharePoint services
4) Detached the existing databases
5) Copied all SharePoint database files and db logs to the new location
6) Individually attached all the SharePoint databases with the new location
NOTE: Pay special attention to the db owner selection when attaching the databases. You should have made note of the correct dbo in step 2.
7) Started all services
8) Load the SharePoint website.

Simple enough and it worked, which is even better.

Exclude Managed Path

In the SharePoint version 2.0 products, to exclude a directory from SharePoint “control”, you add an Explicit Exclusion to the Managed Paths for the site using the Central Administration Website. You also add Explicit Inclusions and Wildcard Inclusions at the same location.

However, in SharePoint version 3.0 products, it is a bit different. You still create Explicit Inclusions and Wildcard Inclusions on the administration page for the site. However, to create an Explicit Exclusion, you just have to create a new Virtual Directory in IIS underneath the appropriate IIS Virtual Server. This is because ASP.NET knows that when you create a new virtual directory, it should not touch it. Pretty nifty, eh?

When I set my excluded directories up, I did run into a minor issue. It was so minor that all I had to do was give the Network Service account read permissions on the physical directory.

Differences between Windows SharePoint Services and Portal Server 2003 ( WSS vs. SPS )

The question comes up pretty often: "Which product is right for me?"
Honestly, there are many factors that come into play to answer that question:
The white paper does an okay job at describing the differences and I think everyone should take a look at it before deciding which SharePoint product to deploy.

My take on the Microsoft SharePoint Products and Technologies Resource Kit

I think it is always good to remember the Microsoft SharePoint Products and Technologies Resource Kit has chapters online that are free to access. But, most people don’t know how this book can help them. So, here is the chapters listing along with some of my thoughts on the chapter. Remember, my advice is to read the whole book BEFORE you deploy SharePoint into production! You will thank me later!
Chapter 5 – SharePoint Portal Server Architecture
This is a good chapter to read up on how SharePoint Portal 2003 and WSS are different

Chapter 6 – Security Architecture for SharePoint Products and Technologies
This is a good chapter to read to get a grasp on the authentication in SharePoint and how users are implemented.

Chapter 7 – Architecting SharePoint Products and Technologies for Operating System Topologies
This chapter will help in understanding how SharePoint lives in your domain.

Chapter 8 – Planning Your Information Structure Using Microsoft Office SharePoint Portal Server 2003
You will need this chapter to help you get SharePoint to be the Center of your organization’s information.

Chapter 12 – Deploying Medium and Large Server Farms
You want a step-by-step deploying guide? Well, here is the chapter for you! It describes deployment using multiple servers.

Chapter 17 – Configuring SharePoint Portal Server 2003
This chapter will help you get your Portal server running lean and mean.

Chapter 18 – Managing SharePoint Portal Server 2003
You will need this chapter after you have installed and you realize that managing Portal can be a full-time job if it isn’t done correctly!

Chapter 22 – Managing External Content in Microsoft Office SharePoint Portal Server 2003
This chapter is all about getting external content from websites outside the Portal available to your users through you new portal.

Chapter 23 – Personalization Services in SharePoint Products and Technologies
Everyone wants their users to be notified when something is updated. They also want to be able to deliver content to specific users. Well, this is your chapter to get that info!

Chapter 24 – Information Security Policies for SharePoint Products and Technologies
You absolutely need to read this chapter! Your security team (and your future self) 🙂 will love you for it!

Chapter 26 – Single Sign-On in SharePoint Portal Server 2003
Who wants to input their username/password in 10 different times to get to different resources? Nobody does and this chapter will help you setup SSO to help get rid of that logon prompt!

Chapter 28 – Disaster Recovery in SharePoint Products and Technologies
To be honest, this is probably the most read chapter in the book. If you haven’t had to recover your SharePoint infrastructure yet (due to problems), good. Read this chapter to make sure when you do, it will go over smoothly.

Chapter 29 – Usage Analysis Tools in SharePoint Products and Technologies
When your manager asks “do people actually use that SharePoint environment?”, you will be able to answer them after reading this chapter

Chapter 32 – Using Microsoft Office FrontPage 2003 to Customize SharePoint Products and Technologies Sites
What to know how to move the search box to the left side of the page, or customize the look of your website? This is the chapter for you.

Chapter 34 – The SharePoint Portal Server Object Model
This chapter holds some real gems in dealing with administrating SharePoint. Take a look for code samples!

Chapter 40 – Microsoft Outlook 2003 Integration with SharePoint Products and Technologies
What to have your schedule and SharePoint interact? Well, read this chapter!

Chapter 41 – Integrating Exchange Server 2003 with SharePoint Products and Technologies
Learn about e-mail-enabled public folders and Exchange public folders in this chapter.

List Item Limits

I was just reminded today about the limits on how many items you can have on a list.
The limits are divided by the type of fields as dictated by the Microsoft article titled “Column Limit Exceeded” Message When You Add a New Column to a SharePoint Services List .
Part of the article:
With Windows SharePoint Services, you can create the following numbers of each column type for each list or library:
64 Single line of text and Choice (drop-down menu or radio buttons)
31 Multiple lines of text and Choice (check boxes (allow multiple sections))
32 Number and currency
32 Hyperlink
16 Date and time
16 Lookup
16 Yes/No
8 Calculated