The SharePoint Hive

The “Site Content and Structure” reports are a great way of finding files which are pending approval or checked out but I just realised you can create your own reports.

If you have never seen these reports before:

Go to site settings –> Site Administration –> Content and structure

But you can create you own reports by going to “View all site content”

Under lists –> Content and Structure Reports

Here you can see all the reports available from C & S as well as the CAML that makes these reports.

Read More

Need InfoPath training? We’ve got just what you’re looking for!

SharePoint Solutions offers quality hands-on classroom-based InfoPath training.

Learn the ins and outs of creating digital forms that your users won’t mind using.

Four days is all it takes to master digital form creation in InfoPath 2010, and to learn the basics of routing those forms through common business processes using SharePoint 2010 workflow, through our new course, InfoPath 2010 and SharePoint Server 2010 No-Code Workflow Deep Dive (Intermediate).

In this instructor-led 4-day “deep dive” course, you’ll learn:

• To understand forms as a primary driver of business processes
• To design digital forms that work – asking the right questions the right way
• To understand the varied audiences for your forms and the data they need
• A framework for determining what questions your form needs
• Form layout and design best practices
• What controls are available for InfoPath forms and how they work
• How to create data connections to receive data from external sources

and much, much more.

In addition, you’ll learn to use SharePoint Designer 2010 to create powerful SharePoint workflows to automate the routing of those InfoPath forms through common business processes. You’ll discover:

• The different types of workflows you can create and when to use them
• Item events which trigger workflow
• Steps, actions and conditions: the building blocks of workflow design
• Else-if conditional branching and (MS) Boolean logic
• How to test and debug your workflows

and so much more.

Familiarity with the basics of SharePoint 2010 is required, but no previous experience with InfoPath 2010 or SharePoint Designer 2010 is necessary.

Packed with information and hands-on experience!
Classes are filling up fast, so prompt registration is highly recommended.

Check scheduled dates and locations of upcoming classes.

Read More

I had this error today creating an External Content Type for Business Connectivity Services (BCS) in Visual Studio 2010. I had to get help resolving it so I wanted to share the resolution.

Error occurred in deployment step ‘Add Solution’: The default web application could not be determined. Set the SiteUrl property in feature BdcModelProject2_Feature1 to the URL of the desired site and retry activation.

Parameter name: properties

You can resolve this by editing the Feature1.feature file in Visual Studio 2010. Open the template and add a line to tell them what your web application is. Mine is called http://intranet.contoso.com

Add this line:     <Property Key=”SiteUrl” Value=”http://intranet.contoso.com/” />

So the full template now looks like this:

<?xml version=”1.0″ encoding=”utf-8″ ?>
<Feature xmlns=”http://schemas.microsoft.com/sharepoint/“>
  <Properties>
    <Property Key=”GloballyAvailable” Value=”true” />
    <Property Key=”SiteUrl” Value=”http://intranet.contoso.com/” />
  </Properties>
</Feature>

Read More

We completed and published the SharePoint VSeWSS Import tool. This tool is an add-in to Visual Studio 2010 and it adds a new SharePoint project template for importing a VSeWSS project.

VSeWSS or the Visual Studio 2008 extensions for Windows SharePoint Services are the Microsoft tools for creating SharePoint 2007 projects on Visual Studio 2008. In Visual Studio 2010 we have built in tools for creating SharePoint 2010 projects. This import tool takes a VSeWSS project that is targetted at SharePoint 2007 and migrates it to Visual Studio 2010 where it is targetted at SharePoint 2010.

The import tool is distributed as source code so you will need to compile it before using it. There’s a batch file provided for this and you just need Visual Studio 2010 installed and to run the batch file.

The import tool works at the project level, not the solution level. So if you have a solution with multiple projects you will need to import them one by one and get them all going.

Read More

I have some external references to a Sharepoint list. There are certain sheets that have these connections that must be refreshed on the press of a button.

How can I only refresh certain sheets?! Please help
Can I refresh the sheets one at a time in the command…?

Something like ActiveWorkbook.Refresh.Sheets(“SheetA”) ???

I’m creating a button to refresh specific worksheets and their connections. So it could be multiple lines of code to refresh one worksheet. Please help!

Chosen Answer:

Given that the only available commands are either

activeworkbook.refreshall

or

workbooks(index).refreshall

it seems you can’t directly.

Reading around it looks like you can’t refresh when sheets are protected.

It may be a lot of hassle, but I suppose you could have each sheet linked to a separate workbook and you only refresh those you want to refresh.
by: flyingtiggeruk
on: 5th August 11

Author: Tobias Zimmergren http://www.zimmergren.net | http://www.tozit.com | @zimmergren
Introduction
In this article I will talk about how you can get started with creating custom PowerShell commands for SharePoint 2010 that you can use.
You will see how easy it actually is to build a custom c … (More)
Read More

Step-by-step, Creating a Reusable Learning Objects Strategy shows how to create and implement a reusable learning objects (RLO) strategy that is flexible enough to accommodate your individual needs or use across a global organization. Creating a Reusable Learning Objects Strategy outlines the benefits and challenges of RLO and shows how to compare your current development process with one based on reusable learning objects. The book also helps evaluate the level of changes you will need to account for during the transition to RLO.

List Price: $ 70.00
Price: $ 58.41

List Price: $ 17.95
Price:

Implementing Enterprise 2.0 provides detailed practical insights into how to create substantial business value with web technologies, supported by numerous case studies of successful implementation and lessons learned. Implementing Enterprise 2.0 can be used to gain a clear understanding of Enterprise 2.0 and Web 2.0 in organizations, identify opportunities for value creation, provide a structured view of benefits and risks, establish governance initiatives, create and communicate a clear Enterprise 2.0 strategy for your organization, and design and implement successful projects.

List Price: $ 195.00
Price: $ 177.63

A friend/client of mine just recorded a video of me demonstrating the creation of a simple dashboard using Excel Services. This is aimed towards savvy business users. Here you go,

Read full article ….

Read More