@info – The practical side of SharePoint

Posts Tagged ‘Tips and Tricks’

10 SharePoint 2007 Admin shortcuts

Posted by sharepoinTony on November 18, 2009

Shortcuts that can help you get to pages you need when working on your SharePoint 2007 sites.

Add these to end of url for site or page to get to the page you need:
  1. Save Site as Template: _layouts/savetmpl.aspx
  2. Jump to Settings page: _layouts/settings.aspx
  3. Site Template Gallery : _catalogs/wt/Forms/Common.aspx
  4. List Template Gallery: _catalogs/lt/Forms/AllItems.aspx
  5. Web Part Gallery: _catalogs/wp/Forms/AllItems.aspx
  6. Master Page Gallery: _catalogs/masterpage/Forms/AllItems.aspx
  7. Add web parts to any page: ?PageView=Shared&ToolPaneView=2
  8. Manage your Alerts (2003 & 2007): _layouts/1033/MySubs.aspx (2003) and _layouts/SubEdit.aspx (2007)
  9. Web Part Page Maintenance: ?contents=1
  10. IISReset can get annoying, every time you deploy new functionality you hit IISReset, and you wait.

A much quicker way is to recycle only the application pool instead of issuing an IISReset. In order to recycle just the application pool, you can use the following command:

cscript c:\windows\system32\iisapp.vbs /a “[App_Pool_Name]” /r

Added bonus:

Application Pool Recycle Utility
This makes the pages load quickly after recycling the pool or doing an IISReset.

Posted in SharePoint 2007 | Tagged: , , | Comments Off on 10 SharePoint 2007 Admin shortcuts

Document Library Read Access

Posted by sharepoinTony on September 12, 2009

A user reports that they cannot see any files in a document library.  They have Read access, what is going on?  Yep, there are files in the library.  Here is the nitty gritty:

No ERROR will display, however a user with Read access to a document library (or folder or specific files depending on how permissions are enabled and if inheritance is broken) may not be able to see files in the library/folder.
If a Library has Versioning turned on, then by default files that are uploaded are marked as Draft’s.  Also by default people with Read access cannot see Draft documents.

Resolution options:

  1. Turn Versioning off if it is not really needed for that library.
  2. Change the versioning settings to allow draft’s to be seen by Readers.
  3. Approve the draft document.

Additional Info about versions in SharePoint Document Libraries:

Versioning On – If approvals are setup, then a draft can be Approved and become visible to people with Read access – even if the versioning setting to view drafts is not set for readers.

When in the Versioning Settings screen for a Document Library, follow the link “Learn about specifying who can view and edit drafts” in the Draft Item Security section to learn more about these settings and how the permissions are impacted.

When content approval is required:

  • You can specify whether files that are pending approval can be viewed by people with permission to read, people with permission to edit, or only the author and people with permission to approve items.
  • If both major and minor versions are being tracked, the author must publish a major version before the file can be submitted for approval.
  • When content approval is required, people who have permission to read content but do not have permission to see draft items will see the last approved or major version of the file.

Posted in Document Library, SharePoint 2007 | Tagged: , , | Comments Off on Document Library Read Access

Can’t browser enable form

Posted by sharepoinTony on September 12, 2009

You need to do at least 1, 2 and 4 (3 may have been done already is doesn’t need to be repeated)


stsadm -o activatefeature -filename IPFSSiteFeatures\feature.xml -force -url http://URLToYourSite


stsadm -o activatefeature -filename IPFSWebFeatures\feature.xml –force -url http://URLToYourSite

3. You need to activate the ‘Office SharePoint Server Enterprise Site Collection features’ feature on Site Collection level.

4. iisreset

Posted in SharePoint 2007 | Tagged: , , | Comments Off on Can’t browser enable form

Workflow tidbits

Posted by sharepoinTony on September 12, 2009

I meant to post these awhile back, and I may add to this post over time as I collect or recall  the handy little learning’s that I have stored up in the nooks and cranny’s of my brain.

Starting a Workflow Manually

In order to manually start a workflow created in SPD (SharePoint Designer) the user must have Manage Lists permissions on that list.   The workflow can start “on new” or “on change” with just standard contribute permissions…but, starting it manually is considered “managing” the list.

EMail link to list item in a Workflow

If you want to go directly to the details of a particular list item (basically reconstructing the URL used by SharePoint) use the SPD workflow properties below to build your link:

“<a href=” & workflowProperties.SiteUrl & workflowProperties.ListUrl & “/DispForm.aspx?ID=” & workflowProperties.ItemId&”>”

Posted in SharePoint 2007, Workflow | Tagged: , | Comments Off on Workflow tidbits

List View Filtering

Posted by sharepoinTony on September 10, 2009

Here is something that I had to figure out that may help others…

Looking for NULL’s:
In your view, for the filter choose:

“Show items only when the following is true:”
then “Show the items when column”
Select from the dropdown [name of your column that can be blank]”
choose “is equal to”
then leave the text box blank.

  See my example using a blank Due Date:

 Filter within a List View

Filter within a List View





Going back to your list, if you now use this view, it’ll only return results where the column is empty.


Filtering a View for a SharePoint List

Posted in Lists, SharePoint 2007, Views | Tagged: , , | Comments Off on List View Filtering

Naming Custom Themes

Posted by sharepoinTony on September 8, 2009

Creating a custom theme in SharePoint isn’t very painful, especially if you are able to use most of an existing theme. I do this frequently enough that it isn’t a dreaded task. However, I was working on a custom theme today and l learned a new painful lesson.

It appears that your custom theme name cannot contain underscores ("_") or hyphens ("-").

Each time I attempted to implement a theme with either of those characters I ran into problems. Most common was a message that the theme "custom_theme 1011" already exists on the server, or is invalid. Sometimes it mentions the folder name or file. Regardless of the error message, the real culprit is your naming scheme if you are using the special characters mentioned above. I don’t have time to test now, but I suspect that most or all special characters will cause problems for custom theme names.

Renaming the ‘problem’ theme by removing the special characters (and modifying the associated XML and INF files) made the problem disappear. Previously, I had read blog posts saying that there was a character limit of 8 or 9 for the theme name. I have found this to be untrue. I have custom themes with 14 character names which work fine…as long as they don’t use special characters.

Posted in SharePoint 2007 | Tagged: , | Comments Off on Naming Custom Themes

SharePoint Blog Category Pagination

Posted by sharepoinTony on August 29, 2009

Quick and easy.  That is what it sounded like.

It’s Friday about 3pm, a department manager wants ‘something’ added in his department site.  They want to post information for another group to view.  They want to categorize the content so the users can easily sort through the various postings.  They wanted a blog.  For the sake of brevity I won’t go into more details on what, why, etc. related to the choices, just the interesting tidbits.

I quickly created a SharePoint Blog site under their SP 2007 department site, did the few obligatory things to make it nicer and fit the theme and the department and let it go.    The department manager was happy, the end.

4-ish pm – he is back. Gee, we notice that when we select a Category from the QuickLaunch and the posts display, there is this little “1-10 >” thing down on the very bottom…and we don’t like it.  We want to see everything posted in that Category on one page, we don’t care how long it is or if we have to scroll down for days.

OK, I will take a look…there must be a setting in the Blog settings somewhere.  Nope, can’t find it anywhere.

I look at the page, it is … Lists/Categories/Category.aspx, so I decide to open it up in SharePoint Designer (SPD).  If I try to modify the view in ‘design’ mode it hangs SPD.  Nice touch. Did I mention it was late Friday afternoon?  After much searching around in Code mode, I find what I am looking for – that is the tidbit controlling pagination.  I knew it had to be a page or item view limit somewhere in there. 

Here is what you do to adjust pagination:

Go and find the <ListViewXML> tag (in the Category.aspx or other page where pagination control is desired), search there for the section of code that looks something like this:

/Query&gt;&lt;RowLimit Paged=&quot;TRUE&quot;&gt;10&lt;/RowLimit&gt;&lt;

Notice that “Paged” is equal to TRUE and has a value of “10″.  You can set the value to whatever number of blog posts you want to display.  I suspect that you could just set “Paged” to “FALSE” if you want to display every post from any chosen Category.  I plan to try that out very soon…but the critical knowledge has been gained and shared.

Enjoy your SharePoint Blogs!

UPDATE: I tested out setting Paged to “False”, which works fine, as long as you remove the number from the RowLimit (example above displays “10”).  If you leave a number in there, SharePoint will display that number of posts without pagination at the bottom to get to the additional posts.  Your code should look something like this:

/Query&gt;&lt;RowLimit Paged=&quot;FALSE&quot;&gt;&lt;/RowLimit&gt;&lt;

Posted in SharePoint 2007 | Tagged: , , , | 3 Comments »

2007 Alert Me management

Posted by sharepoinTony on June 17, 2009

Users can go to _layouts/MySubs.aspx on the site where they have an Alert setup to delete the alert.
Seems lots of people don’t know how to get there and remove an alert.

Posted in Alerts, SharePoint 2007 | Tagged: , | Comments Off on 2007 Alert Me management