Archive for Uncategorized

Australia Sharepoint Conference

// January 25th, 2010 // No Comments » // Uncategorized

I just saw that the Australia Sharepoint Conference is being organised by fellow Sydney Sharepointers Kathy Hughes, Debbie Ireland, Brendan Law, James Milne and Mark Orange for Sydney in June. Wooah! What good news.

Hopefully ill be invited to talk!

Office 2010 and Sharepoint 2007 – The list cannot be displayed in Datasheet view…

// December 17th, 2009 // 6 Comments » // Uncategorized

Cant edit a Sharepoint List in datasheet view? using office 2010?

Here’s the answer

Installing Sharepoint 2010 in Single Server Mode on Windows 7

// December 14th, 2009 // 1 Comment » // Uncategorized

So i finally got this up and running…

I used the following resource:

Setting Up the Development Environment for SharePoint Server

Follow it step for step. However there are a couple of prerequisites you MUST install which are listed in the above document:

All the ones listed in Step 2, Number 7 of the MSDN document above PLUS
WCF Hotfix

there a few things you should know that i never found on other blogs:

1) Do the install within your company network, otherwise you’ll get errors in the configuration which will fail on Step 2 with “Exception: Microsoft.SharePoint.SPException: User cannot be found.” You have online access to the domain controller .

2)The following error:
Failed to create the configuration database.
An exception of type System.Security.Cryptography.CryptographicException was thrown. Additional exception information: The data is invalid.

Can be solved by:

Give Full control to NETWORK SERVICE on the folder c:\program files\common files\Microsoft Shared\Web Server Extensions\14

3) The following error:
Failed to create sample data. Exception of type Microsoft.Office.Server.userProfiles.userProfileException was thrown. The request channel timed out while waiting for a reply… Increase the SendTimeout value on the binding.

Can be solved by:

Install WCF FIX: A hotfix that provides a method to support the token authentication without transport security or message encryption in WCF is available for the .NET Framework 3.5 SP1 (Windows Server 2008, Windows Server 2008 R2) . Please note the 2008 fix also applies to Vista, while the 2008 R2 fix also applies to Windows 7.

Remove Code from your Infopath Form

// November 20th, 2009 // No Comments » // Uncategorized

Thanks to Paul Galvin, i managed to find out how to do this: check it out here

Dynamic Sharepoint Workflows: How to

// November 18th, 2009 // 7 Comments » // Uncategorized

Ive been itching to write this blog post for a while. See ive been holed up a major car company for a little while now who had a basic requirement. They have MOSS 2007 and were wanting a basic Infopath form and multi-step approval workflow behind it, which just did the basics like sent emails and reminders such as “please approve/reject this form” or “please review this form”. In 95% of Sharepoint Workflow articles (the State machine workflows) ive found that Sharepoint Experts create multiple tasks, with multiple correlation tokens etc etc and it all seemed just a little too confusing and long winded. Now im sure its best practice to create workflows in this manner, but is it easiest? Better yet, is it DYNAMIC? How do i redeploy this workflow for another client and update it without any code changes?

Far too often ive spent time sitting at clients creating each one a custom workflow for their needs, then deploying and moving on, only to find a similar requirement next week at another client. I can write Visual Studio State Machine and Sequential Workflows all day, but surely there is a way to reuse what ive done, better yet, deploy one workflow, and tweak it outside of Visual Studio (without code manipulation) Was there essentially a way for a Business User to update their own workflows?

Well immediately Products such as Blackpoint, Agilepoint or Nintex came running through my mind. They all give the user the ability to create their own workflows, just a little training on those, and id never have to write another workflow. However, most of my clients cannot afford these wonderful products. So they were a no go. Still i was convinced there was a way to create the dynamic workflow!

Well heres my answer:

Essentially every workflow is state based really, it moves from state to state, whether it be sequential or not. A simple example would be a travel request:

State 1: User fills in form -> State 2: send to manager -> State 3: Manager reviews -> State 4: Form approved/rejected.

Within a state machine workflow, the workflow may respond to an event such as OnWorkflowItemChanged and move from state to state depending. The state is normally dictated by the a field in the form, in my example above is the status of the request:

1. Pending
2. Approved
3. Rejected

From this i worked out that i need my form to manage the state of the whole process and my workflow to respond to these changes. Based on what state the form was manaipulated to when a user changed values within the form, execute the relevant workflow step which is associated with that form state. So how might this work in a diagram?

basic workflow step

Based on the above diagram i have created 2 videos which run you through both the Form and the workflow itself, explaining how i enabled the form to save the latest state within the form, and how my workflow reacts to these changes:

Form Video

Workflow Video

If you do have any questions, please post comments below, i will try to help out.

Sharepoint Solution Exporter

// November 17th, 2009 // No Comments » // Uncategorized

Im loving Mark’s work here. He has made it easy to export your solution into a WSP. I used it for my infopath form which worked like a treat. coupled with the Solution Installer, its perfect!

Finishing the Blackmore’s Marathon

// September 24th, 2009 // 1 Comment » // Uncategorized

After 2-odd hours, dealing with my girlfriend’s emotional breakdown at 14km, i finally finished (without her, hehe, she asked me to go ahead!!)

Thats me in the red!

My Latest Project: PA Interactive

// June 26th, 2009 // No Comments » // Uncategorized

My latest project below… I included a new jQuery Content Slider which i have created as a webpart now which links to my Community Kit for Sharepoint Blogs.

Ill be uploading a video soon for this awesome webpart…

Displaying the First ‘x’ Words of a Rich Text Column in a Dataview

// June 22nd, 2009 // No Comments » // Uncategorized

Working with datviews and Sharepoint designer often, i come across the need to show the first few words of a rich text column often, especially the “body” tag say of a blog.

It would be pretty easy using the ddwrt:limit function or the substring() for any other column, but in this case the body tag is actually in html format. The “Limit” function then brings us back ugly part html which is no good to display.

Luckily there is a way. There are essentially two steps here:

1. strip the html
2. return the first ‘x’ words

I used a simple template to strip the html, here it is:

 xhtml |  copy code |? 
01
02
  
03
    
04
    
05
     
06
      
07
        
08
      
09
     
10
     
11
      
12
     
13
    
14
 
15

Then we need to return the first ‘x’ words:

 xhtml |  copy code |? 
01
  
02
      
03
      
04
      
05
      
06
        07
                ">  
08
              
09
              
10
                  
11
                  
12
                  
13
              
14
          
15
        16
                    string-length(substring-before($TextData, '  ')) > 0)">  
17
              
18
          
19
          
20
              
21
          
22
      
23

24

Then just under your

 xhtml |  copy code |? 
1
line:

 xhtml |  copy code |? 
1
2
				  
3
      
4
        
5
      
6
   
7

Credit given: Thanks to Mark’s post for the help.

The data source control failed to execute the update command – Finally a solution

// April 30th, 2009 // 2 Comments » // Uncategorized

I have literally google the h*ll out of this one. As someone that plays with a lot of dataviews and custom list forms, i come across it this one and im hoping this blog post helps a lot of people!

Essentially the history around it is that it is a Date related problem. So on your Form, if you have Date related fields and you hit the save button, you will get the error which is specified. Apparently the hotfix for kb 949749 works, although some say it doesnt. From readking it may have something to do with the date format and using MM/DD/YYYY and DD/MM/YYYY. Either way, i havent been able to find any quick fixes for it…. until yesterday!

And its really quite simple, although probably not the best solution, it still works.

1. Open up Sharepoint designer, and fire up the problem page.
2. In the design view, find all the date fields. Click the > button as shown below

3. Change the dropdown from List Form Field to Date Picker Field.