Posts Tagged ‘SharePoint 2010’

Populating a drop-down with list values using C# for SharePoint 2010

October 12, 2012 Leave a comment

  • Finds the list “My Tasks”
  • Gets all items from the “Title” column in the “My Task” lists
  • Uses a foreach loop to add all of the “Title” columns values to a drop-down.

Watch the video to see how it works.


Moving repeating table values to another list using a Visual Web Part in C#

October 12, 2012 Leave a comment

InfoPath 2010 repeating tables are useful and sometimes even essential to the project requirements. However, they carry with them some problems. For one thing when multiple values are entered into an InfoPath 2010 form all of the values become crammed into one SharePoint 2010 column. This will cause all kinds of problem down the road if you ever need to access that Info and/or filter it etc. So the following example shows how to move the repeating table values to a separate list where the values can be more efficiently managed.

  • I’ve created a Visual Studio 2010 visual web part that fires the code on page load
  • You must have a delimiter to separate the values. In this case I have used a ;
  • Do NOT add a ; to the last repeating table entry. If you do you will have and extra record in the new list.

How does it work? View the Video below:

Chart Web Part SharePoint 2010

October 12, 2012 Leave a comment

The SharePoint 2010 Chart Web Part is a very useful tool. It has lots of capablity out-of-the box. You can extract data from and Excel sheet and display that data via graphs on a SharePoint 2010 page. This videos shows you how.

Note: the Excel file must be uploaded to a SharePoint document library.

Publishing an Administrator-approved form template

October 12, 2012 Leave a comment

If you add custom code to InfoPath 2010 form template you will need to publish the form as an “administrator-approved” form template. Publishing an administrator-approved template is not an intuitive process (in my humble opinion). So, I create a video that will give a step-by-step of how this is done.

How to upload a .wsp solution in SharePoint 2010

October 9, 2012 2 comments

Have you ever gotten a .SharePoint 2010 wsp file and thought “Now what?”. Well there are two ways to do this. You can upload the .wsp to the solution gallary within the site collection and the create a sub-site based on the .wsp. The videos below shows this technique.


You can also create an entire site collection based on the .wsp. The video below shows this technique.

Combined Knowledge, DEV Boot Camps and the 70-573

October 8, 2012 1 comment

It has been a few weeks since I attended, which has given me some time to reflect on the SharePoint 2010 development boot camp that myself and various others at CPS have attended over the last couple of months.


Now in my role as a SharePoint Consultant / Solution Architect, I primarily get involved in solution design, estimation of work and the leading of project teams during implementation.

In my experience however, clients rarely want to pay purely for oversight of implementation alone.  As a result, my skill set extends to SharePoint configuration, client-side development (JavaScript, jQuery, XSLT, CSS, HTML etc.) SQL / reporting and very very occasionally I get involved in the .NET side of things also.

So to round out my knowledge, aid work estimation and my ideas for future 2013 concepts, I joined our developers on the Combined Knowledge – Development Boot Camp and I thought I would share my experiences (please note this is a personal thought piece and is not sponsored in anyway).


Combined Knowledge

Setting the scene

We contacted Combined Knowledge and it would appear that these development boot camps are popular, so book early.

As a company, it is important for us to have our employees Microsoft certified to ensure quality solutions and our Gold Partner status in Project Server and SharePoint capabilities.  As a result, we took the Boot Camp and 70-573 certification options for all staff members attending the course.

Cost of the training covers:

  • Hotel for the week (board and all meals)
  • Combined Knowledge training materials
  • Microsoft official training manual for the course (used for night time reading and exam preparation)
    To kick off the Development Boot Camp piece, the trainer (Gary Yeoman in this case) sends study material suggestions for the night before the training, setting the tone for the week.

Gary Yeoman


                        click for course overview


The Training

So now that we have set the scene, the training course side was the usual affair:

  • Start time 9:30
  • Finish time: 17:00 ish
  • Virtual machine environment with SharePoint Server 2010, SQL Server, Visual Studio 2010 and various other tools as required
  • Various refreshments throughout
  • Click on the course overview for full course details.
  • Full, detailed course notes of slides used and plenty of examples for anything you can think of for SharePoint development.

However, the development boot camp piece top and tails this with study in the evening based on MSDN documentation, course material and code examples to work through.

On each day at 8:30, Gary is in place ready to go through the study material and code samples for the evening before.

Certification and Community

If the moons align, you may also get the chance to join in with the SharePoint User Group community.  Steven Smith supports the SUGUK for the Midlands and we were lucky enough to catch the meeting discussing SharePoint 2013.  (Further details available here:


And finally at the end of the course, the option to take the 70-573 – SharePoint 2010, Application Development exam is available at the Combined Knowledge offices, 10 minutes from the training location.

Thankfully, I managed to pass due to the excellent development course material and week full of studying.



And that concludes my review of the Combined Knowledge Dev Boot Camp experience, probably the best training experience I have had with knowledge that will serve me well now and for the future with SharePoint 2013. 

If you have any questions, leave them in the comments below and I’ll come back to you.

#SharePoint Slide Libraries #SP2010

July 22, 2012 1 comment

At a recent meeting of all the consultants, we were talking about the various tools that we use and how we use them. These can include various PowerPoint presentations. One of the more senior people in the room asked; “Wouldn’t it be great if we could have one central repository of all the PowerPoint slides that might want to use? It would be even better if we were told automatically when these slides are updated and we can be sure that we are using the most up to date slides in our presentation.”

I thought about this for a brief moment and then said “That sounds like SharePoint slide library to me. I’m pretty sure you can do all those things from a slide library”.

And, as it turns out, you can.

Adding slides to the library

To add one more slides from a presentation to the slide library:

  1. From within PowerPoint, right click on any slide to display the context men.
  2. Click on the Publish Slides option

    Publish slides

    Publish slides

  3. This will open the Publish Slides dialogue box. The slide that was right clicked on in the previous step will already be selected. Use the checkboxes to the left of the thumbnails to select other slides. Alternatively use the Select All button to select all the slides.

    Select files to publish

    Select files to publish

  4. Use the Browse button to locate the slide library:

    1. Clicking on the Browse button will open the “Select a slide library” dialogue box

      Browse to locate the slide library

      Browse to locate the slide library

    2. Enter the address of the slide library in the address bar. Alternatively enter a top level address such as and then navigate to the required slide library
    3. Click the Select button
  5. Once the required slide library has been selected, click on the Publish button
  6. The required slides will be added to the slide library

Using slides from a slide library in a presentation

To add slides from a slide library to a presentation:

  1. Open the slide library that contains the required slides.
  2. Use the check boxes to the left of the slide thumbnails to select the required slides
  3. Click on the link to copy the required slides to a presentation

    Select files and add to presentation

    Select files and Copy slides to presentation

  4. If PowerPoint is not already open then it will be opened a dialogue box will prompt you to add the selected slides to a new presentation

    Copy slides to PowerPoint

  5. Copy slides to PowerPoint

  6. If there is already a presentation open then there will be the option to add the selected slides to a new presentation or the existing one.
  7. In either case the second check box should be selected. The next time the presentation is opened a dialogue box will appear, prompting the user to check for changes. 
  8. Clicking on the Check button will compare slides in the current presentation to slides in the slide library. If PowerPoint detects that the latter have been changed then a dialogue box will appear giving the user the chance to updates slides in the presentation.

Et Voila! One central repository for slides and notification of changes!

Carl Sprake
After beginning my career in pharmaceutical sales I moved into IT training, initially in the pharmaceutical sector but then moved across to the NHS to teach basic computer skills and the ECDL. I then changed companies and moved into a primarily Microsoft Office training and support role. I joined CPS in 2008 as a training consultant and now provide configuration as well as training services.

This article has been cross posted from (original article)

Retrieving the Project GUID with JavaScript CSOM #PS2013 #PS2010 #MSProject #Office365 #in

July 20, 2012 5 comments

So the Microsoft Office preview is out and unfortunately my colleagues and I are still consulting on current and previous versions, so only limited time around client work allows for play.  Luckily we have had access to earlier versions for several months now so as a company Corporate Project Solutions is prepared for 2013 and we are even running knowledge sessions and upgrade validation checks.

Moving on… whilst in the hotel, we started playing with Napa and the possibilities around what can and can’t be done.

Although this example is not relevant to Napa (due to the environment the apps run in), we did manage to product some code that would be useful for Sandbox Solutions or Composite solutions using the Content Editor Web Part in Project Online, Project Server 2013 and potentially Project Server 2010.

In this example, we use the SharePoint Client Side Object Model to view the property bag within a Project Site to retrieve the following:

  • Internal Project UID
  • Project Wep App URL
  • Project Web App Site UID.

NB: The Project UID is for the plan associated within to the site in Project Server.

The Result


SharePoint CSOM code running within a Project Site in Project Online (Office 365 Preview)



Closer look at the output


So you may be wondering, why we need this information.  Well with the introduction of Project Online / Project Server 2013, the client side object model can interact with the PSI to return Project and Resource data.

In many cases you will need the Project UID as a starting point!

Here are the details of getting things up and running in the IE Development Toolbar Smile and trust me, there is much more CSOM goodness to come.


Final Code Example:

function getWebProperty() {
    var ctx = new SP.ClientContext.get_current();
    this.web = ctx.get_web();
    this.props =  this.web.get_allProperties();

       Function.createDelegate(this, gotProperty), 
       Function.createDelegate(this, failedGettingProperty)

function gotProperty() {
    alert("Project UID: " + this.props.get_fieldValues()["MSPWAPROJUID"]
     + "\nPWA URL: " + this.props.get_fieldValues()["PWAURL"]
     + "\nPWA Site UID: " + this.props.get_fieldValues()["MSPWASITEUID"]

function failedGettingProperty() {


Debug Code Example:

To get this detail out, me and my colleague had to do some digging in the object model using debug code to alert out to the console values at the Web and Property object areas:

function getWebProperty() {
    var ctx = new SP.ClientContext.get_current();
            for(var p in ctx)
                        console.log("T: " + p);
    this.web = ctx.get_web();
    this.props =  this.web.get_allProperties();

       Function.createDelegate(this, gotProperty), 
       Function.createDelegate(this, failedGettingProperty)

function gotProperty() {
            for(var itm in this.web){
            for(var prop in props){
            for(var fv in this.props.get_fieldValues())

function failedGettingProperty() {



Example References

Just in case you need to add sources for JavaScript frameworks.  Here are some references below:

<script type="text/ecmascript" src="/_layouts/SP.Core.js" />

<script type="text/ecmascript" src="/_layouts/SP.Debug.js" />

<script type="text/ecmascript" src="/_layouts/SP.Runtime.Debug.js" />

<script type="text/javascript" 
     src="" />


Passed my MOS #SharePoint #PowerPoint 2010 exams #SP2010 #PS2010 #ProjectServer #MSProject

A quick post to say that I have started my journey to becoming a Microsoft Office Master and I am now officially a Microsoft Office Specialist in SharePoint and PowerPoint 2010.


Now you may be wondering why I would be taking the Microsoft Office Specialist exams when I have SharePoint and Project Server server certifications and I work as a consultant.  Surely I know this stuff and how does it help my career?

Well I’m glad you asked!  There are several reasons why I am interested in the MOS Specialist and Master exams:

  • When you become too deep into the technical, you sometimes need a refresher on how out of the box items work.  This is my way of keeping my hand in.
  • For users we train at Corporate Project Solutions, I wanted to know how well our courses prepared them for the exam (very well it would appear!).
  • For our trainee’s within CPS, would it help them to becoming a well rounded SharePoint / Office professional in the marketplace (yes, it definitely would).
  • Lastly (and possibly the most important), SharePoint solutions are not just about SharePoint.  It is about the integration with the Microsoft ecosystem (Office, Project Server, Team Foundation Server, SQL Server).  By understanding the surrounding technologies, solutions I design and implement will be more supportable and upgradeable in future.

For revision material, I used the following book and of course practiced on the applications themselves:

MOS10StudyGuide mos2010studyguide
Click on the images to view the book at amazon

I will be working on the Word and Excel Expert exams next (a fair bit more prep to do first) and then I may take the Office 365 exam when it is released also, just to see how it compares to the SharePoint 2010 exam.

The Office 365 Study Guide is due out soon and I expect receive my copy in the next week or two from my pre-order.


As an interesting thing to note, during my research I found it difficult to find an examination centre that would allow me to just take the exam.  However, one place in London was very good, professional and I would recommend:SandGTraining


  • Good facilities
  • Helpful staff
  • Flexible time scales
  • Central location (near Holborn)
  • There is a coffee shop outside for last minute revision before you go in
  • What more could you want!

Full details about the all the exams can be found here:


Exam number

MOS: Microsoft Office Word 2010

MOS: Microsoft Office Word 2010 Expert

MOS: Microsoft Office Excel 2010

MOS: Microsoft Office Excel 2010 Expert

MOS: Microsoft Office PowerPoint 2010

MOS: Microsoft Office Outlook 2010

MOS: Microsoft Office Access 2010

MOS: Microsoft SharePoint 2010

MOS: Microsoft Office OneNote 2010

Exam 77-853

MOS: Microsoft Office 365

Exam 77-891*


To learn more about the MOS Master certification, details are here:


And lastly as a shameless plug for the company I work for… If you would like to learn more about the training Corporate Project Solutions provides, click on the image below:


If anybody has any questions about the details above, get in contact

Presenting and staffing at TechEd Europe 2012 next week #TEE12

Just a quick blog post to say that I will be presenting at TechEd Europe 2012 next week with my slide deck:

Integrating Project Server & SharePoint 2010
 Deployment Approaches, Integration Options
& making the most of the SharePoint Enterprise Features

TechEd Europe 2012

Code: OSP02-LNC

  • Level: 300
  • Category: Office, Office 365 & SharePoint
  • Presenter: Giles Hamson
  • Date: Wednesday, June 27th 2012
  • Time: 13:30 to 14:15 (45 mins)
  • Location: Hall 2

The key focus of this session is to understand three popular approaches to implementing SharePoint and Project Server together and the key benefits to each method.

In addition you will also learn:

  • Understanding how SharePoint and Project Server work together
  • Using the enterprise features of SharePoint to leverage Project Server data
  • How SharePoint and Project Server techniques differ and can cause issues with implementation

I will also be staffing the Microsoft stand to discuss Project Server, Project, SharePoint & Office with anyone who stops by.  So if you have any questions about the product set or you just want to say hello, come along.

My Schedule:

  • Tuesday: Booth 13:30 till 15:30
  • Wednesday: Presentation 13:30 till 14:15 (link)
  • Flight out Wednesday night – Airport for 7pm ish.

Look forward to seeing you there!

%d bloggers like this: