woensdag 23 december 2009

Sub-folders vs Metadata – a Story About Resistance and Changing Jobs

There is always resistance by end users to go the metadata route instead of using sub-folders in their document libraries. Their arguments for staying with sub-folders have some validity when it comes to resistance to change though. People don’t like to change. Changing from sub-folders to metadata is like changing jobs.

More ........

Linked in iscussion

Using Business Connectivity Services in SharePoint 2010

Kirk Evans
One of my kids’ favorite books is called If You Give a Mouse a Cookie by Laura Numeroff─a children’s book based on the slippery-slope notion that if you give a mouse a cookie, he will ask for milk, realizing he is thirsty. When he drinks the milk, he will ask for a mirror, then some scissors, then a broom, then some crayons, and on and on, asking for a new item once he realizes the utility of the item he currently has.

This is how I see many users progressing along the adoption timeline with SharePoint: they begin slowly, uploading a few documents, and then progress to using workflows and forms and ultimately wanting to surface external data on their site. It isn’t until you see how easy one task was to accomplish that you decide to go for the next challenge.

It’s a common scenario: I have a portal, I have some external data, and I want to integrate that data into my portal in a meaningful way. Microsoft Office SharePoint Server 2007 (MOSS 2007) introduced the Business Data Catalog (BDC) to facilitate this exact scenario: make it easy to surface external data inside a portal experience. For example, you can create an XML definition file that defines the mapping between SharePoint and your external data so it can be rendered in a Web Part, used as a column within a list and even integrated into search.

When I show companies how they can use BDC to map to existing line-of-business applications, the light bulb usually turns on after I show search results that include people, documents, list data and data from their existing LOB system─all within the same set of results.

Even though the BDC in MOSS 2007 enabled connectivity to external systems, it was difficult to create solutions because of the lack of a designer. Furthermore, though BDC made it relatively easy to create read-only solutions that display data in the Business Data List Web Part, it was not so simple to create a solution that enabled users to make changes and write that data back to the external store.

Business Connectivity Services (BCS) in SharePoint 2010 is all about connecting to external data. BCS enhances the SharePoint platform’s capabilities with out-of-box features, services and tools that streamline development of solutions with deep integration of external data and services. BCS builds upon its BDC predecessor in the key areas of presentation, connectivity, tooling and lifecycle management. For example, in SharePoint 2010 it’s easy to create an external content type with SharePoint Designer, create an external list in SharePoint’s Web user interface and take the list offline into Outlook as a set of contacts. Also, you can make updates to contacts in Outlook that will cause the data in the external system to update as well.

More ......

zaterdag 12 december 2009

Sharepoint 2010 Beta - Records Management

SharePoint 2010 introduces new capabilities regarding Records Management. The most interesting feature, I think, is In-Place Records management (info at the end of this post) which makes it possible to declare documents as records without moving them to a Records Center. Records and documents live side by side in the site they were created in, and SharePoint 2010 makes it possible to apply different policies (i.e. retention schedules) depending if the item is a record or a document.

The Record Center site template is still available. It utilizes some new functionality like the Content Organizer to route incoming documents to the libraries of your preference. A new “dashboard” gives a record manager faster access to common tasks and to-do actions.

Holds (with discovery), audit and file-plan reports are also new or improved functionality to better control your records.

Other items than documents can also be declared as records in SharePoint 2010; wiki pages, blog posts, article pages among others.

This post gives an overview of two capabilities; Records Center and In-place Record Management. Functionality like Holds, File-plan and other Records management features will be covered in later posts.

The functionality described in this blog post may be changed substantially prior to final commercial release of SharePoint 2010.


Create a Records Center site
Simply create a Records Center by selecting the correct site template:

When creating a Records Center in SharePoint 2010, the following features are enabled:

Content Organizer

E-mail Integration with Content Organizer

Hold and eDiscovery

Metadata Navigation and Filtering

Offline Synchronization for External Lists

SharePoint Server Enterprise Site features

SharePoint Server Standard Site features

Team Collaboration Lists


The new look of the SharePoint 2010 Records Center:



The “Submit a Record” button let users upload (and add metadata to) documents. The documents will be added to the “Drop Off Library” and then moved to the correct library/folder according to the rules added by the records manager.

Note: Activate the “In Place Records Management” feature on the Site Collection level to fully take advantage of the Records Center. The feature has to be activated to mark incoming documents as records:



Create / enable Content Types
The Content Organizer uses Content Types (and related metadata) as criteria for where to move incoming documents. Content Types must therefore be created (or enabled) before routing functionality are enabled.

Create libraries for storing Records
I created a document library; “Contracts 2009” and added a rule “Contract” to the Content Organizer. When documents are submitted, the Content Organizer will move any documents related to the Content Type “Document” into the “Contracts 2009” library. You can create as many libraries/folders and content organizer rules you need to best control your records.

In my “Contracts 2009” document library, I went to Library Settings and enabled “Automatically Declaration”. Now, all documents added to the library are automatically flagged as records.:



Create Content Organizer rules
I added rules by selecting: Site Settings / Site Settings / Site Administration / Content Organizer Rules:



What happens if my target library doesn’t have the necessary Content Type enabled? I tried to create a rule which is using the Content Type “Dublin Core” as a criteria. I wanted all documents related to “Dublin Core” to be moved to the “Contracts 2009” library. As you can see from the message below, all target libraries also need necessary Content Types enabled for the Content Organizer to be able to move documents into the library.



Retention Schedule
Retention Schedule is, per default, enforced on the Content Types, but it is possible to define retention schedules on library/folder level too.

Retention schedule using Content Types
I went to Site Action / Site Settings / Galleries / Site content types (on Site Collection level), then I clicked on the content type “Document”.



Then i clicked on “Information management policy settings”, checked the “Enable Retention” and was given the choice of running different retention schedules on Non-Records and Records:



I chose to use a different retention schedule, and clicked “Add a retention stage for records…”. I was given the choice of setting different actions when the event fires.



It’s possible to add multiple actions, and each stage will occur one after the other in the order they appear on the page:



Retention schedule using Library/folder
Retention schedules are possible to configure directly on a document library. I went to my “Contracts 2009” library and selected “Document Library Settings. Under “Permission and Management” I clicked “Information management policy settings”. Here, I changed the source of retention by clicking on the “Change source”.

When choosing a different source a message will pop up, that basically says that you’re overriding the retention schedule at the Content Type level:



Then a form was presented, where I added my retention events and actions.

In-Place Records Management
A new capability in SharePoint 2010 is In-Place Records management. Instead of moving a document to a specific Records Center, you declare the document as a record and it will be handled as a record in the site it was created in. After the the document is declared as a record, it can have policies and restrictions different than when it was a document. The policies are added to either the Content Types or directly on the document libraries (see the Retention Schedule paragraph above).

Documents can be declared as records either manually or automatically.

Manual record declaration can be configures on Site Collection level and overridden in each document library. In Site Collection settings you have the following options on how declarations of records should be done:



When Record Declaration Availability is set to “Available in all location by default”, a new icon appears on the Ribbon:



A document will get a padlock added to its icon when declared as a record:



Again, you can override the record declaration availability on the document library level:



Automatically declarations of records is possible by checking the “Automatic Declaration” option in the document library settings.

Sharepoint 2010 Beta - Content Organizers

How many times have you gone into a company that needs enterprise document management for day to day activities? Typically you have grandiose plans to organize documents using content types. Best practice right?! No folders, hooray!? Users should love it right?! Only to discover that the people in the trenches see the added work of physically going to the appropriate document library as another "step" followed with "I don't have time for that".

SharePoint 2010 attempts to ease the pain of filing documents with a new concept called 'Content Organizers'. Basically sp2010 looks at rules of incoming documents and tosses them into a specified document library.

Let's enable this feature and set up some rules to see what Content Organizers can (and can't) do inside SharePoint 2010!

Assuming you are running as administrator on your website, go to Site Settings and click 'Manage Site Features' under 'Site Actions'.



Towards the top of the screen, Content Organizer should be sitting there with an Activate button.



(if you get a message indicating that you need another feature to be enabled, go to site collection features and enable either Office SharePoint Server Enterprise Site Collection features or Office SharePoint Server Standard Site Collections features)

Click on Activate, then click on 'View All Site Content' under the Site Actions menu or in the left hand navigation menu.

SharePoint 2010 creates a document library called 'Drop Off Library'. This is going to be the starting point for your future visitors. Save this address and move back to Site Settings.

In the 'Site Administration' section, Content Organizer Settings and Content Organizers Rules are now selectable options.



Click on Content Organizer Rules so that we can see what options are available. From here we can specify some fairly important configuration settings.

It is possible to force users into uploading documents to the Drop Off Folder. (no direct access to document libraries)
Email admins if documents do not satisfy any 'move' rules.
Versioning and preserve document context.

Lastly, in the submission points section, sp2010 presents a Web service URL. Save that URL in your notes, that actually gets important and will be discussed in a future blog post regarding workflows.

Going back to site settings, click on Content Organizer Rules.

Hopefully by now the ribbon control looks familiar. With the ribbon control on 'Items', click New Item.

If your site has existing Content Types, they will be available to be selected in the dropdown menu. Under 'Submission's Content Type' section, there is a conditions section that will allow you to enter more detail. This is not a required field, meaning it is possible to tell sp2010 to just move all items that are documents to a specified location. Here I like to specify my content types with a value.

At the time of writing (9/15/1009), 2010 allows the specification of six conditions.

In the 'Target Location' section, click on browse. Notice that all the document libraries listed exist in the current site.



So is it possible to move documents to another site? Is it possible to move documents to another site collection?

In the Target Location section, select the radio button 'Another content organizer in a different site'. The dropdownlist will display all of the options that you currently have to route this document elsewhere.



If you don't have any options here, it is because you haven't associated any content organizers to any send to connections. (The next post will discuss this process. )

At this point, you should be have a basic understanding of what a Content Organizer is, how to enable the feature and how to create rules. You also have witness to the difficulty of moving documents across sites or site collections.

Fortunately for us, Microsoft gave us a few workarounds for moving documents across site collections. It is fairly easy process. One option is out of the box, the other option involves SharePoint Designer 2010.

So, save that Web Service URL from the Submission Point section and come back to the next post when you are ready.