Showing posts from 2011

MOS 2010 Study Guide for Microsoft Office SharePoint

I was invited to take the Beta version of the user exam for SharePoint, officially called Microsoft Office Specialist, SharePoint 2010. This was the first time that I have taken a Microsoft Office Specialist exam, though I have taken around 50 Microsoft Certified Professional Exams. But they are quite different, basically it is a simulation of SharePoint and one is assigned many different tasks to perform. Great fun. After getting the certification I am teaching the SharePoint user interface to two students who would also like to write the exam. Since I had received it as part of a review program, I decided to use Geoff Evelyn’s MOS 2010 Study Guide for Microsoft® Office SharePoint® from O’Reilly. The books is a good match to the exam objectives, I did not spot an exam objective that is not covered here. The intended audience would be someone who has been working with SharePoint for a while, and wants to write the exam. The book does not work as well outside the intended audience, for…

Commerce Server Inventory System Part 5

Building the Inventory Catalog Creating the Inventory Catalog The process of creating the inventory catalog is straightforward and relies on the same tools used to create product catalogs. Before you create the inventory catalog, however, take the time to determine if your inventory needs require any changes to the inventory schema. Is there additional information that you’d like to store along with your inventory data that the default schema doesn’t support? For instance, would you like to store information about the inventory’s location in the warehouse? Maybe, in addition to naming your inventory catalogs, you want to store the unique identifiers used by your partners to help identify the catalogs. There are many difference scenarios that may justify changing the inventory and adding additional metadata to the inventory schema. Make sure to take the time to think these scenarios through before you begin to extend the inventory schema, although it is possible to add a…

Book Review: Pro SharePoint 2010 Search

Just read the book Pro SharePoint 2010 Search yesterday, looking for gaps in my understand of search. It is a good coverage of SharePoint Search, it does not cover FAST Search. That the authors had real life experience was obvious from the coverage also of third party, I found this part especially interesting. Also enjoyed the brief discussion of the search algorithm. The discussion on changing the ranking model was good, and some of the issues with changing the user's language settings were clearly explained. I would recommend this book. I received it as part of a review program.

Commerce Server Inventory System Part 4

Inventory Site Resources In addition to metadata stored about the Inventory System, Commerce Server also has inventory settings stored as site resources. Site resources are entities that provide functionality to a specific Commerce Server site. These settings can be viewed and modified through the Commerce Server Manager (see Figure 4-3). Inventory site resources override properties defined within the Inventory System metadata. The inventory site resources include the following: ·Display Backordered Items. This resource is used to indicate whether or not backordered SKUs are displayed on the Web site. If the value is -1 (True), then backordered SKUs are displayed on the Web site, whereas a value of 0 (False) indicates that backordered SKUs are not displayed on the Web site. ·Display Out of Stock Items. This resource is used to indicate whether or not out-of-stock SKUs are displayed on the Web site. If the value is -1 (True), then out-of-stock SKUs are displayed on the Web site, …

Using Today in a SharePoint calculated column

Sometimes one can be too tricky for ones own good. Was recently talking about the workaround to name a column Today, then create a calculated column using Today, and then to delete the placeholder column. Works like a treat, but of course the Calculated column does not automatically update the calculated column unless the item changes. Now we know why they hid this feature. Of course one could make a timer job....With thanks to Vaidotas.

Developer Dashboard


Links for dialog

Recipe: IIS 7.0 Compression for SharePoint 2010

%Windir%\system32\inetsrv\config\applicationHost.config around line 445

<httpCompression directory="%SystemDrive%\inetpub\temp\IIS Temporary Compressed Files">
<scheme name="gzip" dll="%Windir%\system32\inetsrv\gzip.dll" dynamicCompressionLevel="9"/>

cd \windows\system32\inetsrv

APPCMD.EXE set config –section:httpCompression /dynamicCompressionDisableCpuUsage:75

APPCMD.EXE set config –section:httpCompression /dynamicCompressionEnableCpuUsage:20
APPCMD.EXE set config –section:urlCompression /dynamicCompressionBeforeCache:true

XML rendered in blog with help of

Image you there! I will be presenting one SharePoint Deep Dive for ITPros and one for Developers.

Writing programmatically to the web.config file

SharePoint 2010 has a change that requires the following PowerShell:$cs = [Microsoft.SharePoint.Administration.SPWebService]::ContentService$cs.RemoteAdministratorAccessDenied = $false$cs.Update()

OnTaskCreated not firing in loop

Errata MOC 10175 SharePoint Dev

1. Lab 13 is gets message office not activated. Workaround to copy theme file from C:\Program Files (x86)\Microsoft Office\Document Themes 14 or run ospprearm from Office 2010 directory
2. Page 4-46 Lab 4, should delete the where clause.
3. Careful with timing in lab 2 page 2-53, allow the timer job time to run at each step, otherwise you will get errors.
4.Page 5-39 Lab 5, unfortunately has access denied problems changing the web config file, Lab works as stated, as long as the students do not look in the web config file to see if it really changed! Fix is this Powershell:

$cs = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$cs.RemoteAdministratorAccessDenied = $false
5. Page 5-41 needs to add the references as well as just the using statements, but the students should be able to work that out.
6. Page 10-34 needs also a test for .jpeg files to make it harmonize with the page 10-32 test.
7. Page 10-34 needs to add to create a new page called training.
8. Page …

Commerce Server Inventory System Part 3

The Inventory Schema Just as the Catalog System has a schema used as a template to define the product catalog, so too does the Inventory System have a schema used to define an inventory catalog. There are two types of inventory metadata: Inventory Catalog Metadata, and Inventory Stock-Keeping Unit (SKU) Metadata. * Inventory Catalog Metadata: This metadata is similar to catalog metadata, except that it pertains to the Inventory System. This metadata includes the catalog name, date created, description, and the last modified date. * Inventory Stock-Keeping Unit (SKU) Metadata: The SKU is the unique identifier for a product, and allows a product to be tracked for inventory purposes. See Table 4-1 for detailed SKU metadata properties. Inventory Stock-Keeping Unit (SKU) Metadata Property Name Property Description Backorder Availability date The backorder availability date property is the earliest date when the back-ordered SKU is available for shipping. Backorder Limit …

InfoPath FormService MemoryCacheSize default

Technet says 250 MB. MSDN says 300 MB.I suspect the first figure is correct. The 300 MB is the threshold as explained here.

Kerberos for SharePoint 2010

Just reading this excellent white paper want to be sure that I have the main points clearly in mind. My previous blog on Kerberos is here.
1. Service Apps only use C2WTS if incoming auth is classic or Windows claims. 2. Reporting Services is not claims aware, needs classic Kerberos as does RSS viewer with authenticated feed. 3. When C2WTS with Kerberos, must use constrained delegation. eg. Excel, PerfomancePoint, InfoPath, Visio services. All require C2WTS with Kerberos. Cannot cross domain boundaries. 4. Basic delegation: BDC, Access, Reporting, Project. Can cross domain boundaries, no protocol transition. 5. According to the documentation PowerPivot is claims aware and does not need delegation. It uses C2WTS to get Windows Identity to connect to AS Vertipaq. On refresh Vertipaq/PP service uses SSS and NTLM to connect to data source, there would onl…

SharePoint Myths

Myth 1. It takes 3 synchs for a profile deletion to work. See the mythbuster here.Myth 2. You cannot use SharePoint for good looking internet sites. See some of the sites here.
Do you have a SharePoint myth you would like to see busted? Please send an email to the address here.

SharePoint 2010 Mirroring and Log Shipping

All databases can be mirrored for high availability except:
User Profile Service Application_SyncDB_
User Profile Service Application_SocialDB_
Reporting Services databases.The only databases that can be logged shipped or use async mirroring:
WSS_UsageApplication (not recommended)
All ProjectServer DBs if all db logs are synched
DefaultPowerPivotServiceApplicationDB (SQL server only)This is according to this TechNet article updated July 29, 2010.Another TechNet article also updated July 29, 2010 indicates that the following databases can also be log shipped:Application_Registry_server_DB_
Managed Metadata Service_
PerformancePoint Service Application_
User Profile Service Application_SocialDB_Technically, I would concur with extending this list to include these.With thanks to C. Liu

CQWP (Content Query Web Part) and Dynamic Filtering

Basically you can use the token PageFieldValue to use a value on the current page layout. This works if it is a Managed MetaData field. Similarly you can use the PageQueryString to add a value to use in the query. A good example of using these values is here.

CQWP (Content Query Web Part) and Common View Fields

SharePoint 2010 exposes the Common View fields on the web part tool pane. Hence it is no longer necessary to export the web part, edit these fields and reimport. The documentation should be updated to reflect this.

SharePoint 2010 Enterprise Search

Although you can have the query component and the query processor on two separate machines, the "Did you mean?" functionality will not work since it only uses the local query component.

List of sites using Commerce Server 2007 or 2009

Sample credit card numbers for testing Commerce Server 2009

• American Express: 3400-0000-0000-009
• Visa: 4111-1111-1111-1111
• MasterCard: 5111-1111-1111-1118
• Discover: 6011-0000-0000-0004

Commerce Server Inventory System Part 2

Inventory Systems Features The Inventory System in Commerce Server comes with many important features that aid in the real-time management of inventory for items in your catalog. These features allow you to do the following: * Display real-time inventory conditions of your products and product variants, including in stock, out-of-stock, back-ordered, or pre-orderable. * Filter products and product variants listings to show only those products that are currently available in stock. * Decrement inventory levels when orders are processed. * Receive notifications when inventory levels reach an out-of-stock threshold. * Integrate inventory levels with LOB applications. * Gain insight into how well products and product variants are selling. As the Inventory System deals with physical items that can be sold, it is common to refer to items as a stock-keeping unit (SKU) rather than a product or product variant. A SKU is a unique identifier that enabl…