Archive
Why can’t I access the column in my SharePoint list programatically?
The answer might be simple. The first time a column is created and you title it “Column1″ the database records that. If you (or someone else) later changes the column title to “Column2″ your application will break. Why? Because behind the scenes that column is still “Column1″
Hiding and showing fields using jQuery in SharePoint Designer 2010
Building forms using SharePoint Designer can be a bit tricky at times. What if you wanted to a text box to show only if a certain radio button value is selected? This video will show you how I acheived this using jQuery.
This post might also help:
Validating a SharePoint form field in SharePoint Designer 2010
Using jQuery to hide form elements based on drop-down value
Using jQuery to hide form elements based on drop-down value.
Populating a drop-down with list values using C# for SharePoint 2010
- 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#
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
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
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
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
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).
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.
|
|
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: http://suguk.org/)
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
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:
- From within PowerPoint, right click on any slide to display the context men.
- Click on the Publish Slides option
Publish slides
- 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
-
Use the Browse button to locate the slide library:
- Clicking on the Browse button will open the “Select a slide library” dialogue box
Browse to locate the slide library
- Enter the address of the slide library in the address bar. Alternatively enter a top level address such as http://cps.co.uk and then navigate to the required slide library
- Click the Select button
- Clicking on the Browse button will open the “Select a slide library” dialogue box
- Once the required slide library has been selected, click on the Publish button
- 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:
- Open the slide library that contains the required slides.
- Use the check boxes to the left of the slide thumbnails to select the required slides
- Click on the link to copy the required slides to a presentation
Select files and Copy slides to presentation
- 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
- 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.
- 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.
- 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!
   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 carlsprake.wordpress.com/ (original article) |
