If you are getting the error:

‘An error occurred processing the data view. The XslText property is empty’

You have probably inserted an extra dataview on your page, check your page & remove the extra data view you accidentally inserted & your error will go away.

More From pstilgoe

• Error: Cannot retrieve the information for application credential key
• Error: There is no file with URL ‘http://test-url’ in this Web.
• How to make the filter choices display by default in the DVWP

If you are getting this error its because you are trying to edit a publishing page. To edit a publishing page you will need to first detach it from its ‘Master Page Layout’, now you can edit it as you wish but any changes to the master layout obviously will no longer apply to this page.

More From pstilgoe

• Sharepoint Calculated Column – Tasks Due This Week
• How to embed a powerpoint presentation into a Sharepoint page
• View PDF documents in a webpart

Excellent step by step instructions here:

http://techtrainingnotes.blogspot.com/2008/11/sharepoint-group-by-on-more-than-2.html

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• How to embed a powerpoint presentation into a Sharepoint page
• How to activate InfoPath Form Services on a standalone MOSS2007 deployment

If you have downloaded & installed the Contact Management template from Microsoft you will have noticed for some reason it by default returns all names beginnning with ‘R’

You’l be pleased to know this is easily fixed by editing: http://MYSERVER/contacts/Results.aspx in Sharepoint Designer.

The list of contacts is provided by a Data View web part which contains the following line:

Remove the letter ‘r’ and refresh your page, now no contacts will show up by default.

More From pstilgoe

• How to make the filter choices display by default in the DVWP
• Change default.aspx to a different page with different name
• MOSS search results all return with the IE document icon and not their correct icon

You’re using a custom list as a form to collect data which is made simple in Sharepoint / MOSS as it automatically creates the form for you as you add the required fields / columns to your lists. This is OK but quite alot of the time you find yourself needing more flexibilty with your forms ie. adding notes in between fields, adding navigation & links etc. You’l be pleased to know if you have a copy of Sharepoint Designer this is relatively straightforward to achieve:

1) Open your site in SharePoint Designer.

2) Browse to your newly created list and open the NewForm.aspx web form.

3) Make a copy of this form by going File –> Save As and giving it a new name ie. ‘NewForm-test.aspx’

4) Highlight the ‘default List Form’ Web Part on the page & hit delete.

5) Click Insert > SharePoint Controls > Custom List Form.

6) In the List or Document Library Form box, select the appropriate list, content type and type of form.

7) Click OK and a new Data Form Web Part is added with the controls representing all the fields from the list.

Apply the customisations you require ie. adding in text boxes, adding links etc etc.

9) Now save the form & when you’re happy with it update your links to point to the new form.

More From pstilgoe

• Import data from CSV and SQL to a SharePoint list
• Converting a Sharepoint List into XML
• Exporting a Sharepoint List into XML

Thanks to Dink at Sharepointu.com for this solution:

You can actually achieve this through a simple workflow in SharePoint Designer using a custom list in your SharePoint site.

In your site, create a custom list called “Emails” and add in two columns:

First column called “Body” – type “Multiple lines of text” (this will contain the actually “body” of the email).

Second column called “Date” – type “Date and Time” (this will be used to hold the next date/time the email will be sent).

Additionally, enable versions on the list – choose “Create a version each time you edit an item in this list” (this will be used for tracking how many times the email is sent and serves as a “confirmation” that the workflow did run).

*Additionally, if it doesn’t already exist, create a new group in the site that you will add in all the users who need to receive the monthly email (permissions for this is not important so you can use an existing site group if it already has the users you need).

In SPD, connect to your site and create a new Workflow “File > New > Workflow” called “Email Users” and attach it to the “Emails” list:
Set it to both:
“Automatically start this workflow when a new item is created” and
“Automatically start this workflow whenever an item is changed”.

At first glance, you may be thinking that setting it this way will cause an infinate loop, and you’d be correct – this is intentional.

Click next to create the Workflow steps.

We only need one step so name it “Send Message”.

**In any of the following steps, if you do not see the specified Action listed when you click the “Actions” button, select the “More Actions” option from the bottom of the list to bring up a complete list of all the actions available where you can now find the Action specified.**

Click “Actions” and choose “Pause Until Date”.
Click “this time”, click the “fx” button, then choose “Current Item” and “Date” for the “Source” and “Field” dropdowns, then click “OK”.

Click “Actions” and choose “Send an Email”.
Click “this message”.
Click the address book icon in the “To” field then scroll through the list of site groups to find the *group that your users belong to (this will be the list of users that need to receive the email), select the group then click “Add>>” then “OK”.
Click the “fx” button in the “Subject” field and choose “Current Item” and “Title” in the “Source” and “Field” dropdowns, then click “OK”.
Click the “Add Lookup to Body” button and choose “Current Item” and “Body” for the “Source” and “Field” dropdowns, then click “OK”.
Optionally, you can now add any additional text to the body of the email message by placing your cursor before or after the “[%Emails:Body%]” lookup and type in whatever you want.
Once completed, click “OK”.

Click “Actions” and choose “Add Time to Date”.
Click on “0″ and change it to “1″.
Click on “minutes” and change it to “months”.
Click on”date”, click the “fx” button, then choose “Current Item” and “Date” from the “Source” and “Field” dropdowns, then click “OK”.
Leave the “(Output to “Variable: date)” part as is.

Click “Actions” and choose “Update List Item”.
Click “this list”.
Choose “Current Item” in the “List” dropdown.
Click “Add” and choose “Date” from the “Set this field” dropdown, then click the “fx” button.
Choose “Workflow Data” and “Variable: date” for the “Source” and “Field” dropdowns, then click “OK”.
Click “OK” again, then one more time to close the “Update List Item” screen.

Your workflow should now appear as:

Pause until Emails:Date
then email [Your Group Name Here]
then Add 1 months to Emails:Date (Output to Variable: date)
then Update item in Emails

Click the “Check Workflow” button to verify there are no errors in the Workflow (confirmation box will open – click “OK” to close it), then click the “Finish” button to build the workflow and associate (attach) it to the “Emails” list.

Back on your site, go to the “Emails” list and create a new item.
Give it the “Reminder to Submit Expense Forms” title (or whatever you require) and add to the body the message you want then to read. Choose the next “11th” as the date (obviously the current month if its before the 11th, or the following month if its currently after the 11th), then click “OK” to add the item.

What’s going to happen is that as soon as the item is added to the list, the workflow will start. If the date listed (in the item) is in the future, it will pause until that date, then when the date is reached, it will send out an email to each member of the group with the details of the item as the email (title will be email title – body will be email body). Once it has emailed the message out, the workflow will then add 1 month (not 30 days, but one calendar month) then update the “date” field in the item on the list to reflect this new date. Since we’ve now “modified” the list item, this will again fire off the workflow which has the first step of pausing until the date listed in the item – which is now one month in the future (and will always be on the 11th).

You can now also look through the version history of the item to see an etry of each time the email had been sent (indicated by a new version being listed for each time).

More From pstilgoe

• Creating filtered views in Sharepoint
• Sharepoint Search – How features work part 1
• Using Sharepoint meeting workspaces with Outlook 2003 / 2007