External User Not Recieving Sharepoint Alerts

By peter.stilgoe





I had a problem where external users, in this case hotmail addresses werent recieving Sharepoint Notifications. I was scratching my head but the solution was a simple one, as they normally are….

If you are going to let users outside of your domain receive outgoing email from SharePoint, you may need to enter their domains as valid in SMTP. To do this go to your SMTP server under IIS and right click on Domains. Choose New Domain, and Remote. Add the domain of your users’ email address. If it is going to be a mixed bag, you may need to add several remote domains such as *.com, *.net, *.org, *.co.uk etc etc

  • Share/Bookmark

Allowed anonymous access on a Sharepoint list and still get prompted for a login

By peter.stilgoe





If you have enabled anonymous access on your Sharepoint farm and you still get prompted for a login when trying to access a list, it is most likely that your list exists in a ‘Publishing Site’.

This is because by default all publishing sites have a feature called ‘ViewFormPagesLockdown’ activated. This basically provides extra security for internet facing Sharepoint sites by stopping anonymous users viewing pages like AllItems.aspx etc.

If you want anonymous users to be able to view such pages you need to disable ‘ViewFormPagesLockdown’

1 Remove all anonymous access from the site.
2 Deactivate the ViewFormPagesLockdown Feature
3 Make sure that the list inherits its permissions from its parent.
4 Do an IISreset and close all browsers.
5 Wait 60 seconds or so for everything to start backup
6 Turn anonymous access on at the site level
7 Close the browser.
8 Browse to the website as anonymous user.
9 Click on a navigation link to browse to the list in question
10 You should now be able to browse list items as an anonymous user.

Activate Feature:

stsadm -o activatefeature -url -filename ViewFormPagesLockDown\feature.xml

De-Activate Feature:

stsadm -o deactivatefeature -url -filename ViewFormPagesLockDown\feature.xml

  • Share/Bookmark

Exporting a Sharepoint List into XML

By peter.stilgoe





This easiest way is to use the URL below & insert your list GUID

http://servername/site/_vti_bin/owssvr.dll?Cmd=Display&List=*YOURUNIQUELISTID*&XMLDATA=TRUE

To get the GUID of the list you need to go into the list & click ‘Settings’ -> ‘List Settings’. Now if you look at your URL you will see something like:

/_layouts/listedit.aspx?List=%7B7B476F98%2D1075%2D4A6D%2D8F63%2D4C754B3F41FC%7D

The URL is encoded so you will need to replace “%7B” with “{” and “%7D” with “}” and “%2D” with “-” so the end result would look something like: {7B476F98-1075-4A6D-8F63-4C754B3F41FC}

  • Share/Bookmark

One of the better ways of implementing Jquery in your Sharepoint environment

By peter.stilgoe

1. Open up SharePoint Portal and click on Site Actions -> Site Settings -> All Site Settings option

2. Under “Site Administration“group option, Click on “Content and Structure” link

3. From top menu Click “New” List option to create a list of type “Document Library”.

4. Let’s Configure document library further…. Let’s name it as “JavaLib”
[ Note: The name of the document library could be any name you like, I like the name JavaLib as we will use this library to organize all JavaScript’s related resources]

5. (Best Practices) Now, We can configure the JavaLib with additional columns, Versioning and Security so that it can return us a favors like versioning and auto advancing to new versions (if needed).

5.1. Add a column “Script Version” as Single Line of Text to JavaLib

Having “Script version” column becomes very informative when one has lots of developers.

5.2. Configure versioning with 10 Major & 10 Minor Versions

Versioning will allow you to rollback to previous version if there is a bug/known defects without having all other pages needing a modification.

5.3. Set Library security as Read Only to Everyone and Contribute to DevGroup

Limiting who can upload new items (scripts) will help establish controlled processes and release changes using major versions.

6. Let’s download most current JQuery version 1.3.2 from http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js to the desktop

7. Now, Let’s upload jquery.1.3.2.min.js file from our desktop to our JavaLib library.

Note: After uploading the file, Please make sure you change the Name from Jquery-1.3.2.min.js to Jquery and Title as Jquery-1.3.2.min.js and Script version as 1.3.2. This will help us in future if other revisions are available then you do not have to update all webparts with new framework urls.

8. Now we have JQuery available in our environment, with correct control security & versioning in place.

Thanks to Hemendra Patel over @ http://hemsoft.blogspot.com/2009/06/first-look-at-jquery-sharepoint.html

  • Share/Bookmark

Import data from CSV and SQL to a SharePoint list

By peter.stilgoe

This SharePoint feature allows you to quickly import data from a CSV file or a SQL stored procedure to any custom SharePoint list.

Once you have added the solution to your farm and activated it on your site collection an additional menu option will be available on the Action menu of each custom list that will take you to the import CSV or SQL page.

Simply select which option you want – either import from a CSV file or import from a SQL stored procedure. Next, browse to the CSV file or enter the SQL connection and name of the stored procedure and hit the Import button.

There is a check box option to delete all items from the list before doing the import which is not selected by default.

Click Here

  • Share/Bookmark

NHS Guidance: Microsoft Office SharePoint Server 2007 Information Architecture

By peter.stilgoe

This guidance helps healthcare organisations apply a chosen information architecture or taxonomy within a 2007 Office system environment. Microsoft Office SharePoint 2007 Information Architecture describes how to plan and design an information architecture and provides step-by-step instructions showing how to configure Microsoft® Office SharePoint® Server 2007 with these settings.

This guidance is suitable for use by healthcare organisations that currently:

- Have content stored in local drives and file shares
- Archive records manually
- Have a basic Web server with Web master-controlled publishing
- Have not yet deployed Office SharePoint Server 2007, or have recently deployed Office SharePoint Server 2007 and wish to plan a portal structure and information architecture

Solution Accelerator – Scorecards

This solution accelerator acts as a template for configuring a management dashboard to track organisational metrics. It contains four example dashboards ranging from a primary care practice to a healthcare organisation’s CEO dashboard with metrics based on the healthcare targets for 2008. The solution accelerator also includes online guidance explaining how to customise a dashboard for a healthcare organisation’s needs.

This solution accelerator is suitable for use by healthcare organisations that currently use :

- Static paper-based documents to track performance with manually-entered performance metrics

- Static, decentralized, and highly-IT dependent reports

- Standalone spreadsheet-based analysis

  • Share/Bookmark

Suppress Microsoft Office Document Authentication Prompt In SharePoint

By peter.stilgoe

Havnt tried it but apparently works:

http://mysharepointblog.com/post/2007/02/Suppress-Microsoft-Office-Document-Authentication-Prompt-In-SharePoint-WSS-30.aspx

  • Share/Bookmark

Need to edit a sharepoint page but there is no edit option

By peter.stilgoe

You need to edit a page in Sharepoint but the ‘Edit’ option is greyed out for example on a survey page.

Simply append NewForm.aspx with ?ToolPaneView=2 so it looks like

/NewForm.aspx?ToolPaneView=2

You now have your page in edit mode so you can add webparts etc

  • Share/Bookmark

How to create a good Sharepoint Survey

By peter.stilgoe

■Do the respondents feel comfortable answering the questions?
■Is the wording of the survey clear?
■Is the time reference clear to the respondents?
■Are the answer choices compatible with the respondents experience in the matter?
■Do any of the items require the respondent to think too long or hard before responding? Which ones?
■Which items produce irritation, embarrassment, or confusion?
■Do any of the questions generate response bias? Which ones?
■Do the answers collected reflect what you want in regards to the purpose of the survey?
■Is there enough diversity in the answers received?
■Is the survey too long?
■According to your test audience, have any other important issues been overlooked?

  • Share/Bookmark

categoriaSharepoint Surveys commentoNo Comments dataSeptember 22nd, 2009
Read All

Charting Data From Sharepoint Lists

By peter.stilgoe

If you’re frustrated by the lack of charting ability in Sharepoint / MOSS take a look at Visifire

Using Silverlight, The Dataview Webpart & Visifire you can start charting your list data within minutes with some very smart charts!

  • Share/Bookmark

Enterprise Content Management can lead to big savings for the NHS

By peter.stilgoe

A recent study conducted by ioko for a typical NHS Trust indicated that over half the respondents found it difficult to find information and could not be sure they were using the latest version of the document. 32% indicated that they spent between 2 to 5 hours or more per week searching for information.

You do the maths !!

  • Share/Bookmark

About Me

Sharepoint / MOSS / K2 /Nintex / IA / BI / InfoPath Consultant