Sharepoint Services

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

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

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.

Jquery and Sharepoint for Totals and Averages for List Views

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

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

The joys of Sharepoint and JQuery! Ive been blown away by JQuery recently and been using it a lot in my personal websites. I needed to see whether i could use it within Sharepoint. That’s when i came across http://www.endusersharepoint.com/. I would like to thank and give credits to Paul Grenier for the following Totals value for a column on a view.

I needed a way to the total per group in a view which contained groups and be able to find their average too! The column that needed totaling is a “Calculated column” which normally presents Sharepoint a problem. Luckily i came across this this post to help me.

I’ve extended it slightly to allow the AVG to be found too!

Please note, your totals column has to be the last column shown in your view
Here’s how:

1) On your view page add in a content editor webpart

2) In the content editor webpart, click the Source Editor…

3) Add the following code:

 xhtml | 
 copy code |
?
 
01
 
02

60

Sharepoint Consulting at a Coffee Company in Sydney

// April 7th, 2009 // No Comments » // Uncategorized

Well, there isnt much anything much more satisfying than working at a coffee company and implementing their WSS 3.0 portal. I get to drink some of the finest coffee around whilst doing something i love. Nothing too tricky about this one, some backend workflow to send out some Email Newsletters periodically to all their “Partners”, so the different outlets and the usuals, news and the like.

Here it is so far:

WSS Error: “the control is not available because you do not have the correct permissions”

// March 31st, 2009 // 9 Comments » // Uncategorized

So i came across an interesting error today! I was using a people picker which was filtered to only use a particular sharepoint group! If I, as site collection administrator, accessed it, it worked fine and i was able to select a person. However for anyone else this did not work!

Solution:

Well, it worked out that all the users needed to be added to this list in order to get it working. I even tried to set the permission of the lists in the User permission List itself, gave them full control but still nothing.

So i eventually created another group from which i would use the people picker on, and added “domain/domain users” to it. I reconfigured the people column to use this list and hey presto, it worked!

Questions

Why would it do this, surely there shouldnt be any security around a specific column of a list (there are 3rd party features for this), i realise that yes, the user permission list has permission properties, but still, if i create a list with a people picker column, then surely i will control access to the list itself?

Sharepoint Contractor: A positive job

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

It really amazes me that in this downturn that i still receive mails and offers for contracts, some at really lucrative prices. Whilst those around me in everything from Finance to Marketing, even Hardware, infrastructure or Microsoft Dynamics and AX seem to suffer slightly, the Sharepoint, be it WSS or MOSS jobs keep rolling in. It amazes me that document management, collaboration, business intelligence and forms and workflow might be top of the minds of those who might find themselves wondering about their next income.

It got me thinking, a product such Microsoft Office Server 2007 really stimulates positive work ethic, positive collaboration of staff, and positive employees, a means which every enterprise needs at the moment. Could it be that the likes of this wonderful technology are being associated with creative, stimulated action to make their businesses succeed in this global crisis?

I used to play in a rock band: Thus Far

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

so whilst we’re on the subject of music, thought id publish our video, kinda weird that it goes in a post above coldplay but hey… it happens!

I Went to see Coldplay in Sydney, 15 March 2009

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

And now im in a huge state of depression. Depressed because i know that as long as i dont see them again, i will never experience a truly breathtaking extravaganza of sheer musical brilliance and choreography of the finest quality. I felt like i came down from a huge high once it was done. Well done to Coldplay, you are just a cut above anything i have ever seen. Your show takes the art of giving concerts to a new level, one that im sure i wont see for a long while. Nothing more i can say, only to leave you with a few photos and videos of my experience!

I really want the new Surface Technology SDK

// March 3rd, 2009 // No Comments » // Uncategorized

Isnt this just the freakin greatest?