OfficePoint

OneNote Table Of Contents Add-in

2011-04-29T08:16:00.001-04:00

http://blogs.msdn.com/b/johnguin/archive/2011/04/28/updated-the-onenote-table-of-contents-and-sorter-powertoy.aspx

Sitecore Firebug Javascript Error

2011-03-14T09:29:00.002-04:00

Using IE8 with Sitecore there is sometimes a javascript error that has to do with a firebug lite item that Sitecore has embedded into the designer. To get rid of firebug lite and thus the error, do the following.

Open the Core database, navigate to /sitecore/layout/Devices/Internet Explorer and delete the Firebug Lite item.

This information originally comes from a Sitecore developer.

http://stackoverflow.com/questions/2513586/is-firebug-lite-javascript-must-need-in-sitecore-shell

SharePoint 2010 Site Templates Document Library Workflow + OneNote

2010-12-23T12:30:00.003-05:00

I ran across a strange problem today. Here's my situation. Saving a site as a site template (wsp solution), the site had a document library that had a default template of a OneNote file and it also had workflow associated with it (created with SPD). Using the site template to recreate the file works but the document library's "New Document" button was disabled and there was no template associated with it in the new site.

I wrote a bit of code that resets the document library to use the OneNote document as its template but the question remains, why did that button get greyed out when a workflow was associated with that document library and saved in the template.

I tested saving the template without the workflow associated with the document library and the OneNote template stayed associated with the document library, it was only when I associated a workflow with the document library that the "New Document" button got greyed out.

Bug!

OneNote Publish to PDF

2010-12-06T12:45:00.001-05:00

Microsoft.Office.Interop.OneNote Publish. To publish the entire notebook, use the code below, where Personal is the name and folder of my notebook. The Publish action will find all the .one files and combine them into one pdf file. Whammooo!!

var onenoteApp = new Microsoft.Office.Interop.OneNote.Application();

string bstrHierarchyID = string.Empty;

onenoteApp.OpenHierarchy(@"C:\Users\brad.test\Documents\OneNote Notebooks\Personal\",

System.String.Empty, out bstrHierarchyID, Microsoft.Office.Interop.OneNote.CreateFileType.cftNone);

string bstrTargetFilePath = "C:\\Temp\\Personal1.pdf";

onenoteApp.Publish(bstrHierarchyID, bstrTargetFilePath, OneNote.PublishFormat.pfPDF);

SharePoint EditControlBlock RegistrationId types

2010-11-15T11:59:00.001-05:00

public enum SPListTemplateType
{
InvalidType = -1,
GenericList = 100,
DocumentLibrary = 101,
Survey = 102,
Links = 103,
Announcements = 104,
Contacts = 105,
Events = 106,
Tasks = 107,
DiscussionBoard = 108,
PictureLibrary = 109,
DataSources = 110,
WebTemplateCatalog = 111,
UserInformation = 112,
WebPartCatalog = 113,
ListTemplateCatalog = 114,
XMLForm = 115,
MasterPageCatalog = 116,
NoCodeWorkflows = 117,
WorkflowProcess = 118,
WebPageLibrary = 119,
CustomGrid = 120,
DataConnectionLibrary = 130,
WorkflowHistory = 140,
GanttTasks = 150,
Meetings = 200,
Agenda = 201,
MeetingUser = 202,
Decision = 204,
MeetingObjective = 207,
TextBox = 210,
ThingsToBring = 211,
HomePageLibrary = 212,
Posts = 301,
Comments = 302,
Categories = 303,
IssueTracking = 1100,
AdminTasks = 1200,
}

SharePoint 2010 Backward Compatible Document Library Events

2010-11-11T09:47:00.003-05:00

They still work. Hooray!!

When I go to the SharePoint 2010 document library settings I can see:

Specify the assembly name, class name and properties for the document library's event handler. WSS_LONG_NAME will call this event handler when items in the document library are inserted, updated, or deleted.

Not sure what "WSS_LONG_NAME" is but apparently it will call my SharePoint 2010 document library event handler.

To enable this to show, I went to Central Admin of my SharePoint 2010 farm, Manage Web Applications, select the web application and then click on Resource Throttling. There will be a radio button to turn this (backward compatible document library events) on or off.

SharePoint 2010 Common Navigation Across Site Collections

2010-11-09T10:51:00.012-05:00

So Microsoft best practice dictates content dbs should be less than 100GB or so, at least that's what I think. Either way, you're here because you have multiple site collections and want to know how to have the same top navigation bar across all the site collections. It took me a few hours to find but here's the solution.

In web.config file, add the following provider


<siteMap defaultProvider="CurrentNavigation" enabled="true">

      <providers>

        <add name="CustomTopNavProvider" siteMapFile="/_layouts/1033/CustomTopNavMenu.sitemap" type="System.Web.XmlSiteMapProvider,System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

Add the CustomTopNavMenu.sitemap to the 1033 directory. If you don't know how to create or use a sitemap file just google it.

Open up the master page for each site collection, for 2010 it's v4, probably best to create a copy and all that stuff before editing it.

Find this part of the file. (around line 343)


<SharePoint:AspMenu

   ID="TopNavigationMenuV4"

   Runat="server"

   EnableViewState="false"

   DataSourceID="topSiteMap"

   AccessKey="<%$Resources:wss,navigation_accesskey%>"

   UseSimpleRendering="true"

   UseSeparateCss="false"

   Orientation="Horizontal"

   StaticDisplayLevels="2"

   MaximumDynamicDisplayLevels="1"

   SkipLinkText=""

   CssClass="s4-tn"/>

 <SharePoint:DelegateControl runat="server" ControlId="TopNavigationDataSource" Id="topNavigationDelegate">

  <Template_Controls>

   <asp:SiteMapDataSource

     ShowStartingNode="False"

     SiteMapProvider="SPNavigationProvider"

     id="topSiteMap"

     runat="server"

     StartingNodeUrl="sid:1002"/>

  </Template_Controls>

 </SharePoint:DelegateControl>

and change it to the following:


<SharePoint:AspMenu

   ID="TopNavigationMenuV4"

   Runat="server"

   EnableViewState="false"

   DataSourceID="topSiteMap"

   AccessKey="<%$Resources:wss,navigation_accesskey%>"

   UseSimpleRendering="true"

   UseSeparateCss="false"

   Orientation="Horizontal"

   StaticDisplayLevels="1"

   MaximumDynamicDisplayLevels="4"

   SkipLinkText=""

   CssClass="s4-tn"/>

 <SharePoint:DelegateControl runat="server" ControlId="TopNavigationDataSource">

  <Template_Controls>

   <asp:SiteMapDataSource

     ShowStartingNode="False"

     SiteMapProvider="CustomTopNavProvider"

     id="topSiteMap"

     runat="server"

/>

  </Template_Controls>

 </SharePoint:DelegateControl>

basically we are setting the SiteMapProvider to the provider we added in the web.config that reads our custom site map file. We don't show the starting node, we remove an ID of the DelegateControl (may or may not be necessary) and then set the StaticDisplayLevels of the ASPMenu to 1 and the MaximumDynamicDisplayLevels to 4. S

Save masterpage, reload page and whamooo, it should work. If not, leave a comment and I'll try to help.

Expanding on this, if you created a web part that could read and update the sitemap file, then users would not necessarily need access to the 1033 folder to update navigation.

UPDATE: after some research, it doesn't seem possible to dynamically update the .sitemap file using a web part. I suggest putting a custom folder in the 1033 folder for navigation and share it out to those who need to be able to update it. It will need to be update on all front end web servers.

SQL Reporting Keep Header Rows Visible Repeat on New Page

2010-03-22T10:17:00.002-04:00

This shouldn't be that difficult to figure out. But it is, so here is how to do it.

Select the first static member of the Tablix and set the property of RepeateOnNewPage to True and the KeepWithGroup property to After.

That's it.

How to set focus on textbox within ModalPopUp Extender Panel

2009-09-01T10:38:00.001-04:00

Taken from: http://forums.asp.net/t/1218079.aspx

javascript
function pageLoad(){
$find("ModalPopupExtender's BehavoirID").add_shown(onModalPopupShown);
}
function onModalPopupShown(){
//set focus here.
}

javascript end

SharePoint Service Pack 2 Expiration Date Hot Fix Available

2009-06-25T10:45:00.003-04:00

http://support.microsoft.com/default.aspx?scid=kb;EN-US;971620

SQL Reporting Services Split Expression

2009-06-22T13:22:00.000-04:00

=(Replace(Fields!WebUrl.Value, Parameters!ParentUrl.Value, "")).Split("/")(0)

SharePoint disallowed special characters

2009-06-09T10:49:00.001-04:00

http://support.microsoft.com/default.aspx?scid=kb;en-us;905231

SharePoint 2007 SP2 will expire your site in 180 days

2009-05-22T07:40:00.002-04:00

Oops, somebody should be fired for this mistake. Apparently after you install SP2, start the count down because in 180 days your site is going to die. All the data will be intact but users won't be able to access it.

http://blogs.msdn.com/sharepoint/archive/2009/05/21/attention-important-information-on-service-pack-2.aspx

Wait for the hotfix before you install the service pack.

I Love Xobni

2009-05-20T16:10:00.002-04:00

I love Xonbi (inbox spelled backwards), I can't tell you how much time this add-in has saved me.

http://www.xobni.com/

April CU Update is available

2009-05-15T09:31:00.001-04:00

Install WSS first then MOSS then run the SharePoint Configuration wizard.

WSS - KB968850

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968850

MOSS - KB968851

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968851

Business Contact Manager 2007 Service Pack 2 (BCM 2007 SP2)

2009-04-30T12:38:00.003-04:00

In case you haven't heard by now, Office 2007 Service Pack 2 has been released by Microsoft. You can download them from the links in this post by the Office Sustained Engineering Team

One item that isn't included on that page is the link to download Business Contact Manager 2007 Service Pack 2 or BCM 2007 SP2. I strongly suggest you install the Office 2007 SP2 update before updating Business Contact Manager 2007 Service Pack 2 or BCM 2007 SP2. You can find the installation package for Business Contact Manager 2007 Service Pack 2 or BCM 2007 SP2 by going to the following link.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=405aa7e9-e63b-447b-a49b-d4cbd8eea30d

Hopefully it resolves some common BCM problems.

SharePoint Site Themes

2009-04-17T08:13:00.002-04:00

Microsoft has released Ten Themes for SharePoint but in order to use them you need to compile them into their solution files. Waste of time.

Ten Themes for SharePoint in VSeWSS Projects

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0a87658f-20b8-4dcc-ad7a-09ad22641f3a

So I did it for you. Here are the ten SharePoint Themes as solution files. SharePoint Themes

You need to deploy them as solutions and then each has a feature that needs to be activated to apply the theme to the site. They are Site Features. Enjoy!

SharePoint February Cumulative Update Available

2009-03-09T09:56:00.002-04:00

Install WSS first then MOSS then run the SharePoint Configuration wizard.

WSS - KB961755

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=961755&kbln=en-us

MOSS - KB96156

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=961756&kbln=en-us

This SharePoint February cumulative update addresses many issues including the Email Enabled Lists problem in my previous post.

SharePoint Email Enabled Lists Unknown Alias

2009-02-27T13:48:00.003-05:00

Try installing the hotfix or wait for the February Cumulative Update that includes this hotfix. Once it comes out I'm going to install it and will let everyone know whether the problem reoccurs after the update.

The entries for e-mail-enabled lists are being deleted from the EmailEnabledLists table in the configuration database. When this issue occurs, incoming e-mail messages for these lists are not delivered. Therefore, the e-mail messages are deleted, and errors are logged for "Unkown alias."

http://support.microsoft.com/kb/961750

Programmatically start SharePoint search crawl

2009-02-27T10:23:00.001-05:00

Simple code sample on how to programmatically start a SharePoint search crawl through code. I haven't had a use for this yet but it's good to know that search crawls can be started easily.

http://weblogs.asp.net/vikram/archive/2009/02/27/starting-an-incremental-crawl-in-share-point-programmatically.aspx

Test Website with mulitple browsers without installing them

2009-02-25T13:47:00.001-05:00

Check this site out for all your vitual browser needs. It does require that you download an executable but the exe isn't an install of the browser. It's just used to mimic the browser without installation.

http://www.xenocode.com/browsers/

SharePoint Email Enabled Lists

2009-02-23T08:21:00.002-05:00

The query below when run against the SharePoint content database(s) will display the email alias and the name of the associated list. Hopefully, from the list name you should know where it resides or you can at least search your SharePoint site for it.

SELECT tp_EmailAlias as EmailAlias,

tp_Title as ListTitle

FROM AllLists

INNER JOIN Webs ON AllLists.tp_WebId = Webs.Id

WHERE tp_EmailAlias <> ''

Download Stimulus Plan

2009-02-13T12:17:00.002-05:00

How can we expect our congressmen and Senators to pass this? What happened to capitalism and free markets, is the US economy in that bad of shape we need to become socialist. Download the House Stimulus Plan and see for yourself.

http://www.rules.house.gov/111/LegText/111_hr1_text.pdf

And if you are not a congressmen or Senator, you might have trouble figuring out what the hell this document is referring to half the time. It's very complicated and confusing. Here's a tidbit from it.

$1,200,000,000 for grants to the States for

19 youth activities, including summer jobs for youth

$1.2 Billion for youth activities and summer jobs. How about No! Youths can find their own summer jobs without having the government give them 1.2 Billion Dollars to do it. Nice work Obama. How about you give me a billion dollars for living in one of the worst states in the Nation in terms of unemployments. That would help me get a job, or wait I would just take the money and continue to not work.

SharePoint Jobs

2009-02-11T14:55:00.001-05:00

I ran across this site http://www.partnerpoint.com/ and thought it was interesting. It has a ton of .NET and SharePoint jobs listed in various US states.

My SharePoint advice to a friend

2009-02-06T13:25:00.001-05:00

I don't have any certifications in SharePoint or any other technology. I don't care to get any certifications. My policy is if I've worked 4-5 years with SharePoint and the company I interview with needs a certification on my resume then I don't want to work for them. My experience should be enough. Needless to say I don't like companies asking for certifications and in general don't care for them.

Done with my rant...

I was a consultant with Sagestone Consulting(MS Partner) and was right out of college doing an internship for the help desk dept. During that internship one of my colleagues told me that SharePoint was going to be the next big thing and I should spend time learning it. He suggested I read the SharePoint Administrator's Guide which is huge. I installed SharePoint on a VPC, downloaded the guide and just started studying. My focus was on administration and installation particularly topology, taxonomy, server farm installation and search. So after uninstalling, reinstalling and configuring SharePoint about a dozen times I became familiar with it. With the new version MOSS 2007, MS added about a dozen more complicated features with a more advanced search engine, the ability to host public sites with it, master pages and page layouts. I am not very familiar with the details of how all those work but because I had the experience from SharePoint 2003 I knew the core of the product. I guess a good starting point would be to start with just Windows SharePoint Services since that is the core of MOSS 2007 along with a slew of other MS products including project server, identity life management server along with others. So knowledge of WSS would go a long way to knowing how the sites of these other products work. Plus WSS has most of the features of MOSS but is a bit simpler to learn starting out. A lot of companies are just running WSS because they don't have to pay the big bucks. There is a WSS Admin Guide, so download that or find it on TechNet and start studying and installing. There is a SharePoint user group in GR that meets one Tuesday of every month. https://www.wmspug.org/Home/default.aspx That would be a good resource too, a lot of local businesses have people that attend that, good networking night.

My advice would be the same, try to get your hands on a VPC or VM that you can install SharePoint on and download and start studying the Admin Guide. SharePoint is only going to expand and continue to grow with Microsoft.

Another thing, if you manage to get your hands on a beta version of the next version of Office (Office 14), definitely work on learning how to migrate from the current version of SharePoint to the next. There are going to be lots of companies that have a need for this migration and there aren't a lot of consulting firms in town with SharePoint experts that will know how to do this. The demand will be great but the resources small. It's a good opportunity for employment.

Hope this all helps, let me know if you have any questions. I'm always glad to help.

SQL Server 2005 versions

2009-02-04T13:20:00.001-05:00

SQL Server 2005 SP2 - 9.0.3042

SQL Server 2005 SP2 with critical update - 9.0.3050

http://www.microsoft.com/downloads/details.aspx?familyid=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

SQL Server 2005 SP3 - 9.0.4035

http://support.microsoft.com/kb/321185

SharePoint Open a closed Web Part

2009-01-30T14:13:00.001-05:00

When a web part is closed using the X, the web part is still loaded on the page, it is just not displayed. Resources are allocated that are never used, so she was right in asking the question.

Here are the steps to put a web part back on a page:

Site Actions -> Edit Page
Click Add a Web Part
Click Advanced Web Part gallery and options
Click Closed Web Parts
Drag closed web part onto the page

http://www.endusersharepoint.com/?p=49

Configure RTE in Sitecore 6

2009-01-16T16:22:00.000-05:00

Switch to the Master Database.

Find the common template you use for your pages inside of the Template Manager. I use one just called "Page" that inherits from the General\BaseTemplate template. The BaseTemplate template has a field called Body which is a RTE field. Find that field of the BaseTemplate and then paste one of the following lines into the source field.

I used the rich text full because I want my editors to have the full RTE Toolbar and all the buttons available to them. But you could also use any of the following.

/sitecore/system/settings/html editor profiles/rich text default

/sitecore/system/settings/html editor profiles/rich text full

/sitecore/system/settings/html editor profiles/rich text ide

/sitecore/system/settings/html editor profiles/rich text medium

Let me know if you have questions, it took me awhile to figure this out, so I may be able to help you if you can't get it working.

InfoPath Adding Image to Button ImageButton

2008-12-16T09:04:00.001-05:00

This KB article describes, in effect, how to create an ImageButton in InfoPath.

http://support.microsoft.com/kb/832511

Sort StringCollection ArrayList

2008-12-15T09:27:00.001-05:00

This is the call you need to make to sort a StringCollection.

ArrayList.Adapter(myStringList).Sort();

Internship Available

2008-12-12T14:36:00.002-05:00

I stumbled across this internship opportunity at Van Andel Institute for a .NET Developer. It sounds like they want a sophomore student at one of Grand Rapid's colleges or university to work on a bunch of .NET apps. Heavy on SQL Server apparently and some reporting. Maybe they are doing SQL Server Reporting Services in house. Anyway, if you are student and looking for an internship next semester you should apply.

http://www.vai.org/Employment/Opportunities/1013.aspx

Coding4Fun Book Code Downloads

2008-12-11T16:00:00.002-05:00

http://www.c4fbook.com/default.aspx

All the downloads and source code that you've seen and heard about at TechEd 2008 and PDC 2008 are now available for the coding4fun series and the book.

http://www.c4fbook.com/media/

I am going to enjoy InnerTube. Get the downloads while you can.

SharePoint Picture Library Item Url

2008-12-11T15:13:00.002-05:00

Very nice article and code snippet on how to get the url of the full image and of the thumbnail.

http://blogs.threewill.com/implementingsharepoint/archive/2007/09/13/sharepoint-picture-library-urls.aspx

Programmatically set border width of Excel cell

2008-12-08T09:35:00.003-05:00

This MSDN article briefly explains how to do this: http://msdn.microsoft.com/en-us/library/bb209714.aspx

and here is an example that I am using in my code. It just sets the left border weight to thick for the cell located at 1,2.

range = (Microsoft.Office.Interop.Excel.Range)wsheet.Cells[1, 2];

range.Borders[Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeLeft].Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThick;

NHibernate Tutorial Videos

2008-11-21T09:28:00.002-05:00

I'm just starting to learn NHibernate and needed to get up to speed quickly. The Summer of NHibernate allowed me to do this. Granted the videos are long but the information presented is all crucial and makes it easy to get up to speed on NHibernate.

Obama Birth Certificate (is faked?)

2008-11-13T11:15:00.001-05:00

Here is Obama's Birth Certificate.

http://i305.photobucket.com/albums/nn227/Polarik/BO_Birth_Certificate.jpg

Updated: This is apparently a fake birth certificate, this begs the question as to why the Obama campaign hasn't released the real one. This is all my politics for today.

Custom SSRS Web Parts for SharePoint

2008-11-05T11:00:00.002-05:00

No code but sounds like it can be done. This is in regards to developing custom SQL Reporting Services SharePoint Web Parts.

http://blogs.msdn.com/sharepoint/archive/2008/11/03/how-we-did-it-allowing-connections-to-multiple-ssrs-servers-with-report-viewer-and-explorer-web-parts.aspx

SPRelinkDocuments released on CodePlex

2008-11-04T12:54:00.002-05:00

I have created a project on CodePlex to host this simple Windows application I wrote to assist SharePoint administrators with relinking form templates that are no longer connected to their form templates. The site is http://www.codeplex.com/SPRelinkDocuments

I will manage discussions and issues on CodePlex. I've released the source code and an executable so feel free to take it and run with it. I will add you as a contributor if you'd like to update the code in CodePlex.

Grand Rapids SharePoint User Group Meeting Nov 6th

2008-10-30T08:31:00.001-04:00

Here is the info:

On November 6, Harold Gravatt of Realign LLC, a MCSE with over 18 years of demonstrated expertise delivering Microsoft based network solutions, will cover implementing the External Collaboration Toolkit for SharePoint using ADAM and FBA. Find out how your company can provide authenticated team site access to clients and partners without adding them to your Active Directory.

David Tappan, a MCSE and Senior MOSS Architect at C/D/H, will also lead a ‘How Do I’ presentation on how to configure Kerberos authentication in a multi-server SharePoint farm.

New Horizons

5315 28^th St Ct. SE Suite B

Grand Rapids, MI 49546

November 6, 2008

6:00pm-8:00pm

SharePoint The EXECUTE permission was denied on the object 'proc_LogChange', database 'SharePoint_AdminContent_, schema dbo

2008-10-24T08:38:00.003-04:00

You may receive an error similar to the one below when upgrading or installing a hotfix on SharePoint. I received this and SharePoint didn't tell me anything more than this error message.

The EXECUTE permission was denied on the object 'proc_LogChange', database SharePoint_AdminContent, schema dbo

To resolve this I logged into the SharePoint web server as the Application Pool account that SharePoint was running under and also granted this user dbo rights on the SharePoint_AdminContent database. I then ran the SharePoint ConfigurationWizard again and the upgrade completed successfully.

Gmail Web Slice for Internet Explorer 8

2008-10-22T13:43:00.001-04:00

<input type="button" value="Add GMAIL Web Slice" class="addButton"

onclick='window.external.AddToFavoritesBar(

"https://mail.google.com/mail/feed/atom",

"GMAIL", "slice");' />

Creating an IE 8 Web Slice to display your Google Mail Gmail Inbox

2008-10-22T13:35:00.007-04:00

This is another very simple example of how to add an authenticated Web Slice that displays the contents of your Gmail inbox in the IE 8 web slice.

Creating a simple Internet Explorer 8 web slice to display RSS Feed

2008-10-22T13:21:00.003-04:00

Creating a simple Internet Explorer 8 web slice is pretty easy to do. This example shows how to add a button to your page that will add a web slice to display any valid RSS feed. Again this web slice will display an RSS feed. In this case the web slice displays the RSS feed from this blog.

<input type="button" value="Add Web Slice" class="addButton"

onclick='window.external.AddToFavoritesBar(

"http://feeds.feedburner.com/Officepoint?format=xml",

"OfficePoint RSS Feed", "slice");' />

IE 8 Accelerator Sample Example

2008-10-22T08:52:00.002-04:00

This is an example of an IE 8 Accelerator. It doesn't tell you how to create one but it is itself a definition for an accelerator. This is a very simple one that adds an Accelerator that will just redirect the user to OfficePoint when clicked.

<?xml version="1.0" encoding="UTF-8" ?>

<os:openServiceDescription xmlns:os="http://www.microsoft.com/schemas/openservicedescription/1.0">

<os:homepageUrl>http://officepoint.blogspot.com</os:homepageUrl>

<os:display>

<os:name>Visit OfficePoint</os:name>

<os:icon>http://blogitems.googlepages.com/office.ico</os:icon>

<os:description>Visit my site</os:description>

</os:display>

<os:activity category="Visit">

<os:activityAction context="document">

<os:execute action="http://officepoint.blogspot.com" method="get" />

</os:activityAction>

</os:activity>

</os:openServiceDescription>

In order to add an Accelerator you'll need add a button that adds the service.

<html>

<head>

<title>Untitled Page</title>

</head>

<body>

<div>

Add OfficePoint Accelerator

</button>

</div>

</form>

</body>

</html>

Generate machineKey web.config

2008-10-21T15:15:00.001-04:00

Here is a site that will generate the machineKey for your web.config for you. Useful for the Sitecore AD Module configuration explained below or for any ASP.NET site that needs the machineKey in the web.config.

http://aspnetresources.com/tools/keycreator.aspx

Unofficial Sitecore 6 Active Directory Module Administrator’s Guide

2008-10-21T15:12:00.002-04:00

Sitecore has released an Active Directory Module for Sitecore 6 which I believe to be the equivalent of the LDAP Module that was available for version 5.3 and below. This guide will explain how to configure the AD Module in your environment with one AD domain.

Install the AD Module package (you should know how to do this already)
To verify that it was installed correctly check to see that the following files exist:

/bin/LightLDAP.dll
/bin/LightLDAPClient.dll
/App_Config/Include/ldap.config
/sitecore/admin/LDAPLogin.aspx
/sitecore/admin/ProviderStatus.aspx

Open /App_Config/ConnectionStrings.config and add a connection string similar to the one below.
<add name="LDAPConnection" connectionString="LDAP://{DomainController}/OU={LowestOUName},OU={OUNameAboveLowestOne},DC={DomainName},DC={com or org}"/>

DomainController should be the name of one of your company's domain controller server's
LowestOUName is the OU you want to get users from
OUNameAboveLowestOne is the OU Name above the OU you want to get user's from, you may not have this entry or you may have multiples of this, check out MSDN for LDAP Query specifics.
DomainName is the name of your domain
Com or org is the .com or .org or .net domain extension

Open the web.config file and find the <membership provider="sitecore"> tag and add a provider by cutting and pasting from below and filling in your values for the values in brackets.

{NameOfYourDomain} is your domain name
{Sitecore LDAP User} is the user that Sitecore will use to connect to your AD
{Sitecore LDAP User Password} is the password of the above user/>

Still within the <membership provider="sitecore"> tag, find the provider:

<add name="sitecore" type="Sitecore.Security.SitecoreMembershipProvider, Sitecore.Kernel" realProviderName="sql" providerWildcard="%" raiseEvents="true" />

and change the realProviderName to switcher so the line now reads

<add name="sitecore" type="Sitecore.Security.SitecoreMembershipProvider, Sitecore.Kernel" realProviderName="switcher" providerWildcard="%" raiseEvents="true" />
Now find the <roleManager defaultProvider="sitecore" enabled="true"> tag and add a provider by cutting and pasting from below and filling in your values for the values in brackets.

{NameOfYourDomain} is your domain name
{Sitecore LDAP User} is the user that Sitecore will use to connect to your AD
{Sitecore LDAP User Password} is the password of the above user/>

Still within the <roleManager defaultProvider="sitecore" enabled="true"> tag, find the provider:

<add name="sitecore" type="Sitecore.Security.SitecoreRoleProvider, Sitecore.Kernel" realProviderName="sql" raiseEvents="true" />

and change the realProviderName to switcher so the line now reads

<add name="sitecore" type="Sitecore.Security.SitecoreRoleProvider, Sitecore.Kernel" realProviderName="switcher" raiseEvents="true" />
Add a machineKey to the <system.web> section. It will look like

<machineKey validationKey="" decryptionKey="" validation="SHA1" /> you can go here http://aspnetresources.com/tools/keycreator.aspx to have one created for you, just generate one using the default values on that page. Example:

<machineKey validationKey="F0893ED36F497B12D0374825033C51F92E85A028C05E65474FB39D41240A6F11F06B531FFC07C3A53239CE8B789C624A7486556E44D8F7165A249605E86375E7"

decryptionKey="7509A38E7B68F1A610D6463B977805F2008D9EDAF2C55E79" validation="SHA1" />

Find a section in the web.config similar to <switchingProviders> and add the sections in bold.

<provider providerName="{NameOfYourDomain}" storeFullNames="false" wildcard="*" domains="{NameOfYourDomain}" />

</membership>

<provider providerName="{NameOfYourDomain}" storeFullNames="false" wildcard="*" domains="{NameOfYourDomain}" />

</roleManager>

</profile>

</switchingProviders>

Open up /App_Config/Security/Domains.config.xml and add a domain.

If you've done everything correctly you should now be able to open up User Manager in Sitecore and see users from your AD OU listed.

Improving Sitecore 6 Active Directory Module Performance

2008-10-21T14:37:00.002-04:00

There is a new module for Sitecore 6 called Active Directory Module which seems to replace the LDAP Module that was available in Sitecore v5.3 and below. This new module uses the ASP.NET Membership provider available with ASP.NET 2.0. The Official Administrator's guide to this new module explains how to configure it for your Sitecore environment. I will release my unofficial guide in the next day or so but in the meantime you should be aware there are significant performance issues with it that were not present in the old LDAP Module. At least for me and one other person there has been. These steps will explain how to work around these performance issues but aren't supported by Sitecore so be sure to backup all the files I tell you to edit. I haven't seen any problems with this workaround but if you do let me know and I'll investigate, as far as I know these changes do not cause any additional issues. So let's get to it.

When trying to use the User Manager and page through the many users from your AD domain you may notice that it is too slow to use. To improve this you'll want to do a few things:

Open up the web.config file and find the following line which defines the number of rows returned when paging through the grid which is a Component Art Web UI Grid.

Change the value to 24.

Now open up C:\Inetpub\wwwroot\{websitename}\WebSite\sitecore\shell\Applications\Security\UserManager\UserManager.aspx

Change the PageSize="20" property of the grid to PageSize="24"

Within the columns definitions of the grid comment out the columns for the Domain, Profile.Email, Profile.Comment, Profile.ClientLanguage and Profile.State. This is the change that really improves the performance. You probably don't care about all those fields anyway, and if you do, then just uncomment the one you want to see and it will appear in the grid.

As a side note, the Grid has a property called RunningMode which is set to CallBack, if you set it to Server instead it will cause the Grid to do a post back when paging which I have found did not significantly increase the performance of the paging but if commenting out the lines above doesn't help you may want to try that.

Also within your LDAP query in the AD Module try to get it down to one OU or a few OU's with few people in them, the more data it needs to bring back the worse performance will probably be.

With the changes above, open the User Manager and now instead taking a few minutes to get to the next page or not paging at all, it should only take < 1 min to page to the next set of users. Not great but better than what it was before we started.

The other pain point is managing roles with the Role Manager and managing user roles inside the Role Manager. Comment out the same lines as above in the following files and your performance using Role Manager should also increase.

All files in C:\Inetpub\wwwroot\{websitename}\WebSite\sitecore\shell\Applications\Security\RoleManager include similar Grids except for NewRole.xaml.xml.

And C:\Inetpub\wwwroot\SitecoreSix\WebSite\sitecore\shell\Applications\Security\SelectAccount\SelectAccount.xaml.xml contains a similar grid that you can comment out the Email and Profile.Comment columns.

West Michigan SharePoint User Group Meeting November

2008-10-17T08:57:00.001-04:00

We invite you to attend the West Michigan SharePoint User’s Group Meeting on Thursday, November 6, 2008-seating is limited so please Register Today!

On November 6, Harold Gravatt, a MCSE with over 18 years of demonstrated expertise delivering Microsoft based network solutions, will cover implementing the External Collaboration Toolkit for SharePoint using ADAM and FBA.

David Tappan, a MCSE and Senior MOSS Architect at C/D/H, will also lead a ‘How Do I’ presentation on how to configure Kerberos authentication in a multi-server SharePoint farm.

New Horizons

5315 28^th St Ct. SE Suite B

Grand Rapids, MI 49546

November 6, 2008

6:00pm-8:00pm

Please join us and share your ideas and best practices while networking with your peers. Food and drink will be served.

Unofficial Sitecore Migration Guide Upgrading from Sitecore 5.3 rev 071114 to Sitecore 6

2008-10-14T14:51:00.003-04:00

I've posted the guide as a post but the images didn't show up, so here is the downloadable copy of the guide. Just follow it exactly and you should be able to get your Sitecore 6 site running and upgraded from Sitecore 5.3. The upgrade of Sitecore 5.3 was relatively easy and I like how the Sitecore 6 update packages include all previous updates, it makes it a lot easier to get to the current version.

Upgrading from Sitecore 5.3 rev 071114 to Sitecore 6

Download Unofficial Upgrade Guide

Unofficial Sitecore Migration Guide Upgrading from Sitecore 5.3 rev 071114 to Sitecore 6

2008-10-14T14:45:00.002-04:00

Unofficial Sitecore Migration Guide

Upgrading from Sitecore 5.3 rev 071114 to Sitecore 6

Step One: Install Sitecore 6

Screen shots of installation below.

Must be SQL 2005 or 2005 Express Database

Attempt to launch http://sitecore6/sitecore if you receive the error below then do the following: remove and then add the sitecore sql user to the Sitecore 6 databases as dbowner.

Databases:

{web site name}Sitecore_Core

{web site name}Sitecore_Master

{web site name}Sitecore_Web

Switch to the Advanced view, select Desktop, click the Hide Warning button. The username is Admin and the password is b.

Attempt to launch http://sitecore6, if you've done everything right you will see the screen below.

Ok if you've made it this far you now have a clean installation of Sitecore v6.

Step Two: Grant Access

Grant "Network Service" and "Internet Guest Account" Full Control rights to the Sitecore 6 web root within C:\inetpub\wwwroot if that's where you choose to install Sitecore 6.

Step Three: Make a backup copy of the original Sitecore 6 root folder

Just in case you need to revert back to an original file, make a copy of the Sitecore 6 web site root folder.

Step Four: Install updates to Sitecore 6

Download Sitecore 6.0.0 Update rev. 080912.zip which fixes Sitecore's problem with .NET 3.0 SP1. (Or download the lastest update which contains the fixes for all previous updates)

Install the update package and overwrite all when prompted.

To verify that is was install successfully check the version of Sitecore.Client.dll in the bin directory of the web site. It should say 6.0.0 rev. 080912 if it doesn't then the update wasn't installed.

Step Five: Install upgrade prerequisite packages

Download the Database Conversion tool and extract the contents which should give you two zip files: Sitecore Update Installation Wizard-2.0.0 rev. 080730.zip and V6DBConversionTool-1.0.0rev080923.zip

Install Sitecore Update Installation Wizard-2.0.0 rev. 080730.zip first and overwrite all when prompted. To verify that this update was successful verify that a Sitecore.Update.dll file exists in the bin directory of the web site.

Now install V6DBConversionTool-1.0.0rev080923.zip and overwrite all when prompted. To verify that this update was successful look in the sitecore/admin/ folder within the website root there should be a folder called upgrade with three folders in it and then additional files within those folders.

Step Six: Copy security template files

Copy the "security templates.xml" in the old Sitecore installation from /sitecore/shell and copy it to the new Sitecore 6 installation into /sitecore/shell.

Step Seven: Modify connectionstrings.config file

Open up App_Config/ConnectionStrings.config and rename the master connection string to v6_master. Then add connection strings to the Sitecore 5.3 databases except for the web database. Oh and the core database string for the 5.3 connections should be named v53_core. Example of a fully modified file is below.

Step Eight: Copy some include files

Copy the .include files in /sitecore/admin/upgrade/IncludeFiles to /App_Config/Include and rename the name.config.disabled files to name.config. Each include with the .config extension will be upgraded those with the .disabled extension will not be upgraded. So only rename those databases that you want to upgrade. To verify that Sitecore picked up all the databases, log into Sitecore and click on the database button in the lower right hand corner of the console, you should see all of them you add appear.

Step Nine: Pray that the conversion wizard works

First you'll need to go into IIS and grant anonymous access rights to the /sitecore/admin folder/

Then browse to http://{sitecoreurl}/sitecore/admin/upgrade/main.aspx. Go through the wizard and choose to automatically do the conversion process. And eventually you'll hit the "Start Conversion" button. If you were successful, depending on the size of your databases (my core and master were around 4GB), 1 hour later you will see:

If you were unsuccessful you may see the error below. This was a fairly easy fix for me. I was trying to convert a SQL 2000 database but since sys.objects doesn't exist in SQL 2000 I had to upgrade them to SQL 2005 and then run the conversion again. After doing that it was successful.

2652 14:15:52 ERROR Failed to upgrade the database

Exception: System.Data.SqlClient.SqlException

Message: Invalid object name 'sys.objects'.

Source: .Net SqlClient Data Provider

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at Sitecore.V6DBConversion.SqlServerDatabaseConverter.ExecuteScalar(String cs, String sql)

at Sitecore.V6DBConversion.SqlServerDatabaseConverter.Convert(SqlServerDataProvider provider, IOutput output)

Great, you've made it this far, now only a few more hours of waiting.

Step Ten: Rebuild some Sitecore databases

First let's clean up the databases by rebuilding the link database for the Core and Master databases. Then rebuild the search indexes on the Core and Quick Search options.

Step Eleven: Republish entire site

Go to the Home section and then the Publish option and Publish site. This is where you wait for a few hours while Sitecore copies data out of the master database to the new Web database. Don't screw with anything else just let it run and depending on the size a few hours later it will say successful. If not, start it again and do an incremental publish so you don't have to republish everything.

Step Twelve: Remove some old upgrade files

Remove and I do mean remove all the .config files within the /App_Config/Include folder. If you just copy them to another folder within that folder you'll get errors, so just get rid of them completely.

In the /App_Config/ConnectionString.config file get rid of all entries except the Core, Web and Master strings.

Delete the /sitecore/admin/upgrade folder

If a /sitecore/admin/packages/tool folder exists, delete that too, I didn't have one so I didn't need to delete it.

Delete the following files if you have them

/sitecore/admin/upgrade.aspx, mine was named update.aspx
/sitecore/admin/web.config
/bin/sitecore.diffinstaller.dll, I didn't have this file
/bin/DiffLib.dll, I didn't have this one either
/bin/Sitecore.Upgrade.dll, mine was named Sitecore.Update.dll
/bin/Sitecore.V6DBConversion.dll

Take offline and a few weeks later get rid of the security, extranet, archive and recyclebin and possibly the v6 master database from SQL.

Step Thirteen: Restore the clean web.config

You should have a copy of the clean v6 web.config file, copy that file to the new v6 web site root and replace the one that's already in there.

Step Fourteen: Copy custom files to the new v6 root

Copy your custom files from the v5.3 root to the v6 root

Layouts
Images
Xsl
Media
Css
Any other folders that are in your site that don't exist in the v6 site that are needed

Compile your solution against the new Sitecore dlls and copy the dll to the bin folder of the v6 site

Merge any web.config customizations from the v5.3 config file to the v6 config file, possibly app settings or ajax stuff.

Step Fifteen: Test, Test and Test

Test the site.

SharePoint Date Picker Control

2008-10-10T14:29:00.003-04:00

This explains how to use the date picker control that SharePoint provides. This example uses it in a web part.

RenderContents...

DateTimeControl dtcBegin;

DateTimeControl dtcEnd;

dtcBegin = new DateTimeControl();

dtcEnd = new DateTimeControl();

this.Controls.Add(dtcBegin);

this.Controls.Add(dtcEnd);

And to reference the selected date do this:

System.DateTime start = dtcBegin.SelectedDate;

System.DateTime end = dtcEnd.SelectedDate;

Decode SharePoint List ID found in Url

2008-10-09T13:07:00.001-04:00

Basically get rid of %7B and %7D and change %2D to a dash

from

http://nickgrattan.wordpress.com/2008/04/29/finding-the-id-guid-for-a-sharepoint-list/

FBHW Free Beer and Hot Wings Podcast Url Information removed and added

2008-10-08T10:39:00.002-04:00

I'm removing the direct links to their podcast from this blog. I will no longer post their url.

With that said, the podcast is still freely available on mediafly, signup and search for "the freebeer and hotwings morning show" on their site. It's now mediafly's problem.

Current configuration settings prohibit embedding username and password in the database connection string SharePoint InfoPath

2008-10-03T09:38:00.002-04:00

You may get this error using an InfoPath form within SharePoint

Current configuration settings prohibit embedding username and password in the database connection string.)

SharePoint Central Admin -> Application Management -> Configure InfoPath Forms Services.

Check the box next to Allow embedded SQL authentication and click the OK button.

Grand Rapids Tech Lunch #5

2008-10-02T09:36:00.002-04:00

Date -- October 6th, 2008

Time -- 12:00 to 1:30 PM

Place -- Grand Rapids Brewing Co. @ NE corner of 28th Street and East Beltline by Centerpointe Mall

Great bunch of guys and gals getting together to discuss technical stuff once a month. Check out http://grtechlunch.com/grafitti/meetings/5-grtechlunch-event-october-6th-2008-grand-rapids-brewing-company/ for more information.

Two InfoPath Contact Selector Controls On One Form

2008-10-02T08:44:00.003-04:00

This information comes from the comments section of the InfoPath Team Blog.

Say you want to add two InfoPath Contact Selector controls to one InfoPath form. This sounds simple enough, create your group and then add the Person repeating node with the DisplayName, AccountName and AccountId fields like you normally would to the Person group. Trying to duplicate this same group again for the second contact selector control will throw an error because you can't have fields or groups with the same names. But knowing that the names have to be exact to have the contact selector control work, the question arises how do we duplicate the data source for the InfoPath contact selector control.

Well assuming you have a group named grpPersonSelector bound to the first InfoPath contact selector control. Create another group named really anything we'll use grpPersonSelectorTwo. Now right click on the Person repeating group under grpPersonSelector and click Reference and choose grpPersonSelectorTwo.

That's it, now the grpPersonSelectorTwo group can be bound to your second InfoPath contact selector control. Thanks Scott for this information.

WSS MOSS SharePoint version numbers

2008-09-29T08:42:00.002-04:00

This is a very nice article describing how to find out which version of SharePoint you are running.

http://www.mindsharpblogs.com/penny/articles/481.aspx

Another great post regarding SharePoint versions from MindSharp.

Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists

2008-09-26T16:15:00.002-04:00

This is a nice add-in to Excel that lets it do a two way sync with a SharePoint list.

http://www.microsoft.com/downloads/details.aspx?FamilyID=25836e52-1892-4e17-ac08-5df13cfc5295&DisplayLang=en

And this explains how to use it. Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

http://msdn.microsoft.com/en-us/library/bb462636(office.11).aspx

Outlook BCM running on SQL Server 2008

2008-09-17T12:55:00.002-04:00

Will BCM 2007 using a shared database work on SQL Server 2008? The answer is not clear. Technically there is no reason why it shouldn't. However, it has not been tested with SQL 2008 and the increased security in SQL 2008 may cause issues.

Should you move to SQL 2008 if you are using a BCM 2007 shared database? Probably not.

Can you? Yes, but you're pretty much on your own to troubleshoot any issues that arise to make it work correctly.

If you have done this, shoot me a note and let me know the steps you took or issues you ran into, I'm sure others would love to get feedback on how it went.

Improve Outlook BCM Business Contact Manager Performance - Three Outlook BCM Performance Tips

2008-09-17T12:39:00.006-04:00

Many complaints about BCM is that it is a performance hog, it's slow, unresponsive, it freezes Outlook... blah blah blah. Well let's try to improve it a bit shall we.

First, if you aren't using the email linking feature then shut it off. I believe it's off by default but if you still go into Business Contact Manager -> Manage E-Mail Auto Linking, there are two tabs one for Emails and one for Folders. Click the "Clear All" button on both tabs and click ok.

Second, if you are in a shared database environment, each machine with BCM installed is hitting your SQL server every second. This creates a lot of traffice and a lot of performance problems. You most likely don't need to get your BCM data updated every second. This update is called a Polling Interval. This Polling Interval was supposedly set higher if you installed the service pack for BCM, however this probably isn't the case. So you need to manually set it higher. To do this open up Registry Editor on each client machine. The path to the key is HKCU -> Software -> Microsoft -> Business Solutions eCRM. Create a DWORD key in that folder called PollingInterval. Modify it's value and set the Decimal value to 180000 which is 180000ms or 3 minutes. Each minute is 60000ms so the Decimal value for one minute would be 60000. This way the client machine will only hit the SQL server every 3 minutes way down from every second.

Third, set the SQL memory for the client machines. By default each client machine will have SQL Server 2005 Express installed on it, this installs with Outlook BCM. By default the maximum amount of memory that SQL Server 2005 Express can use is 2147483647MB, that's huge and unnecessary for BCM. Download and install the SQL Management tools (http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en) on each client machine. Connect to the local SQL Express server and right click on the server within the management studio and choose Properties. Within the pane that comes up, click the Memory link and set the Max Amount of memory to 256MB. That's plenty for BCM. Click OK and it's done.

These 3 performance tips will help with the BCM performance.

Send me a comment if you need additional help.

Record iTunes streaming radio music

2008-09-09T13:46:00.002-04:00

Download UrlHelper and follow the instructions on the page below. It actually works.

http://www.streamingstar.com/How-to-record-iTunes-radio.htm

Don't know how legal it is since ripping music seems to be off limits nowadays but what the hell, go for it.

Convert ArrayList to string[] array

2008-09-08T15:25:00.002-04:00

So simple, yet I didn't know it.

VB: stringArray as string[] = arrayList.ToArray(typeof(string)) as string[];

C#: string[] stringArray = (string[])arrayList.ToArray(typeof(string));

form template cannot be opened in Microsoft Office InfoPath because it contains code that requires a version of the Microsoft Common language runtime

2008-09-05T10:24:00.002-04:00

I received this error while trying to open an InfoPath form.

the form template cannot be opened in Microsoft Office InfoPath because it contains code that requires a version of the Microsoft Common language runtime that is not currently installed

I searched Google and MSDN but no solutions or even mention of this problem. After watching some tv last night and installing XP SP3 on my home computer it came to me that the CLR library needs to somehow get updated or fixed. But Windows had already been repaired and Office 2007 reinstalled, that should have fixed it but nope.

Hmmm.... I got it, let's try to install .NET Framework 3.5 SP1 and see what happens. There have been improvements made to the CLR in 3.5 SP1 and should maybe update the missing dlls. Sure enough after installing 3.5 SP1 and trying to open the form again it opened without problems.

So installing the latest version of the .NET framework fixed the issue.

Create a digital collage

2008-09-04T13:51:00.002-04:00

This very cool tool from Microsoft Research creates a digital collage for you.

http://research.microsoft.com/AutoCollage/

IE 8 Download

2008-08-28T07:44:00.002-04:00

The Internet Explorer 8 beta 2 is now available download IE 8 from http://www.microsoft.com/windows/internet-explorer/beta/default.aspx

OneNote Web Exporter - Display OneNote on SharePoint

2008-08-27T09:45:00.003-04:00

This free add-on to OneNote gives the user the ability to export a web page view of a OneNote document. You can even export it to SharePoint and use a page view web part to host the webview.html page within a SharePoint site.

http://www.codeplex.com/ONWebber

This add-on sure beats my Word2OneNote.

Even better idea, create a Shared Notebook that is stored on SharePoint, export this Notebook to the same SharePoint library. Now multiple users can open and edit the Notebook and export it back to update the web page.

Hmmm.... wonder how concurrent updates are dealt with?

Sitecore 5.3 Archive Item

2008-08-27T08:46:00.001-04:00

Here is the documentation on how to archive a Sitecore 5.3 Item.

http://sdn5.sitecore.net/SDN5/End%20User/Site%20Administration/Item%20Management/Archiving%20Items.aspx

Sitecore Restore Archive Item

2008-08-27T08:06:00.004-04:00

Once again Sitecore lets me down as there is no way to easily restore an archived item from the Archive database within Sitecore 5.3. Note that there is no Archive database in Sitecore 6. But for those of us that are still on Sitecore 5.3 until they release some sort of migration tool we still have the Archive database.

Anyway, this guy has a nice post on how to add the missing Restore option for Archived items. http://usoniandream.blogspot.com/2007/07/tutorial-restore-from-archive.html

One thing to note about Archiving items, just because you archive them doesn't mean they still aren't published. To truly archive an item, you should first make it as not publishable, then publish it (this will ensure the page is removed from the web database, then Archive the page, then save it. If you refresh the parent node of that page you'll notice that the page is now gone and now exists within the Archive database.

Job Justifications, Systems you manage... my experience is not good

2008-08-22T10:38:00.001-04:00

At my previous employer my manager came to me one day asking me to detail what I work on i.e. what systems do I manage and to provide a weekly percentage of this work in an Excel spreadsheet. I thought ok, he just wants to know what I do everyday. Not quite, 2 months later the company announces they are being acquired by another. People get cut, my manager did, somehow I remained.

What I learned: When a manager asks for this type of information it might indicate the company is about to be acquired.

Current Day: My manager asks all of us to provide information about the systems we support and what we work on weekly. This scares me a little as it sounds a lot like my previous employer.

My list is going to be 10 pages long this time.

Anyway, for those of you out there that encounter this type of situation, either come up with a huge list or pack your bags. In my case, I was young and had a lot of potential, I think that's why I was kept, plus I was making dirt for pay.

SQL 2008 Open Table is gone

2008-08-22T08:09:00.003-04:00

Another change that wasn't obvious at first is that the Open Table option is gone when a table is right clicked. I'm sure that was probably ambiguous so MS had to take it out.

The Open Table command has now been replaced with Edit Top 200 Rows.

Well what if there is a row at 201 that I want to edit. Is there no easy way to right click and just open all the rows.

SQL 2008 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

2008-08-22T08:03:00.002-04:00

I've just started using SQL 2008 and have encountered a very annoying problem. Whenever I change a table I get an error:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

WTF? I was able to change tables whenever I wanted to in SQL 2000 and 2005 and now I'm not allowed to in SQL 2008. Oh wait, I need to disable some stupid option that shouldn't have been enabled in the first place. To do this follow these instructions:

Within SQL Management Studio click on the Tools menu. Then Options, then the Designer node and uncheck the box that says: Prevent saving changes that require the table to be re-created.

Now we can actually work with tables like we were able to do in SQL 2005. Nice extra step MS, next time make it more difficult to do what we need to do.

Vista SP1 Prompts When Opening Documents From SharePoint

2008-08-20T14:02:00.003-04:00

You are prompted to enter your credentials when opening a document stored in SharePoint when using Vista. SharePoint and Vista don't play well together by default unless you install Vista SP1 and then hack that registry.

http://support.microsoft.com/?id=943280

Oh and don't forget to restart the WebClient service as well as IE after you hack that registry. SharePoint documents will prompt for credentials when running Vista if you don't configure Vista correctly.

TechEd 2008 DVD Set Arrives

2008-08-18T16:08:00.002-04:00

Today I received the completed DVD set of the sessions, keynotes and presentations given at this year's (2008) TechEd down in Orlando, FL.

Again I'll have to reiterate that I wasn't blown away by TechEd. It seemed a little elementary and I was expecting more deep dives into the technologies. Maybe that's what the PDC is for. Either way, I won't be going to next years in L.A., maybe the year after when it's in New Orleans.

Missing WebTrends Hit and Visit Filters after 8.5 upgrade

2008-08-18T09:58:00.001-04:00

After upgrading to WebTrends 8.5 I noticed that all my hit and visit filters disappeared. I didn't bother to write down all the configuration of these filters before the upgrade because really who would. I called support and they were easily able to get my filters back with a minimal amount of work.

First stop a couple of WebTrends services. First stop the User Interface and then the Scheduler Agent.

Next browse to your WebTrends directory most likely C:\Program Files\WebTrends\storage\config\wtm_wtx\datfiles\filters. You should see a bunch of .bak files. Take the most recent .bak file it may be named something similar to hits_webtrendsdatetime.bak. Make a backup copy of hits.ini and call it hits.ini.old. Now take the hits_webtrendsdatetime.bak file and rename it to hits.ini.

Now start up the WebTrends service in the opposite order, so start the Scheduler Agent and then the User Interface. Log into the WebTrends console and you should now see your hit filters back. This same process will work for visit filters as well just use the visits.ini file and the visits_webtrendsdatetime.bak files instead.

Also notice that when you stop the WebTrends User Interface service that the WebTrends Tomcat service stops as well, and when you start the User Interface service the Tomcat service will start.

Hope this helps someone.

Sitecore and .NET Framework 3.5 SP1 Service Pack 1

2008-08-13T10:25:00.001-04:00

Do not install .NET 3.5 SP1 on your Sitecore server, doing so may result in long hours and a broken site. Here is the information directly from Sitecore that I recently received in an email.

Dear Sitecore Enthusiast,

You are receiving this message because you are subscribed to the Sitecore Product Issues and Patches mailing list.

On Monday, August 4th, Microsoft released the following service packs: Visual Studio 2008 SP1 and .NET 3.5 SP1.

Sitecore has discovered that these service packs introduce a bug in the LosFormatter class (System.Web.UI.LosFormatter in System.Web.dll, used to serialize and deserialize an ASP.NET ViewState). This bug causes stability issues in Sitecore products. Sitecore has raised this as an urgent priority issue with Microsoft (case number : SRQ080813600454) and is working to help resolve this issue.

In the meantime, PLEASE DO NOT INSTALL .NET 3.5 SP1 and Visual Studio 2008 SP1 on any server running a Sitecore product (including Sitecore WCMS, Intranet Portal, and Foundry) until further notice!

Symptoms associated with installing either of these service packs:
Memory consumption increases dramatically and single core CPU usage goes up to 100% when opening the Access Viewer or Media Library applications.
OutOfMemoryExceptions thrown in the Desktop and Content Editor.
The browser becomes unresponsive when accessing Sitecore.

Please be aware that Microsoft may include this Service Pack as part of the monthly ‘Patch Tuesday’. Please take steps to avoid the automatic installation of these service packs.

Please be aware that the final version of SQL Server 2008 will require .NET 3.5 SP1.
If you have any questions about this issue, please contact Sitecore support.

Best Regards, Sitecore Support Team.

Blogger favicon.ico

2008-08-12T12:24:00.002-04:00

Wondering how I got the cool favicon by the url within your web browser. I followed the instructions found http://tips-for-new-bloggers.blogspot.com/2007/02/adding-favicon-icon-to-blogger-url.html to add it.

I think Blogger should make it easier to put a favicon within the url but since they don't you can just follow the instructions in the link above to add the favicon to Blogger.

SharePoint Limited Access permissions

2008-08-12T12:18:00.003-04:00

What exactly does Limited Access mean when you see it applied to an individual or a group within SharePoint? What access do they have and why do they have it? It's not obvious to tell within the SharePoint user interface what Limited Access means. Now we have a tool to tell us what SharePoint Limited Access really means. Check out http://www.codeplex.com/SPLimitedAccessDisco

It has 47 downloads since it's release in late July 2008. I think if more people knew about this Limited Access tool that there would be more. Hopefully people will see this post and download it.

Visual Studio 2008 SP1 Download

2008-08-11T13:29:00.001-04:00

Here is the download link. It installs Visual Studio 2008 SP1 (Service Pack 1) and .NET Framework 3.1 SP1.

http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

DateTime.ToString Formats

2008-08-08T13:45:00.002-04:00

I always use the following reference page to find a DateTime ToString format. It's a very good reference page for Date Time String Formats. I suggest you bookmark it yourself.

http://authors.aspalliance.com/aspxtreme/sys/demos/datetimeformats.aspx

Creating a custom Visual Studio Theme

2008-08-08T13:42:00.001-04:00

Forget trying to create a Visual Studio theme by yourself, by using the frickin sweet tool below, you can create a Visual Studio theme within seconds and import it into Visual Studio and start using it.

http://frickinsweet.com/tools/Theme.mvc.aspx

Visual Studio themes are frickin sweet man!!

Adding a SharePoint Site Picker to a SharePoint layouts page

2008-08-07T07:56:00.003-04:00

Very nice article detailing how to add a SharePoint site picker to a custom page within the layouts directory.

http://chrissyblanco.blogspot.com/2008/07/adding-sharepoint-site-picker-to_03.html

Upgrading WebTrends from 8.1 to 8.5

2008-08-07T07:53:00.001-04:00

The upgrade from WebTrends version 8.1 to 8.5 did not go smoothly. The big difference between the 8.1 versions and 8.5 is that instead of using mysql databases 8.5 now uses SQL databases specifically running on SQL Server 2005 Express Edition. During the upgrade 8.5 installed SQL 2005 Express and converted the mysql databases to SQL databases. This all seemed to go fine except when the WebTrends site came up it still pointed to the old mysql databases even though the SQL databases were created and converted successfully.

Support had me first uninstall 8.5 and then reinstall 8.5, after this we tried restoring the converted databases over the empty 8.5 databases. This did not succeed as when the site was browsed a SQL error was displayed. So support had me uninstall 8.5 and reinstall 8.1 specifically 8.1.0.5164. After we had a blank 8.1 installation running I stopped the WebTrends services and made copies of the storage, wt_sched and wtmaster folders that exist within the WebTrends folder within Program Files. I then copied in my backup folders of these (I made backups of these before doing any upgrade, apparently all the data is stored in these folders). I then restarted the WebTrends services and browsed to the WebTrends site. Success, the site came up, I was able to login and all my analysis data was there.

After we verified some of the data in the 8.1 version, we upgraded to 8.1a which I believe is 8.1.0.2048. After the upgrade we again logged into the WebTrends site and verified the data. Just a note here, one of the many technicians I spoke to told me that the upgrade would only be successful from 8.1a to 8.5. This explains why my 8.1 to 8.5 upgrade didn’t go well. The data was correct so we then upgraded to 8.5, we logged into the WebTrends site again and finally the data was all there.

You can verify version and database platform by logging into the WebTrends site, going into the Administration area and then into Install Components. On that page is a link to About WebTrends which displays the version number and database platform.

Lessons learned: Upgrade to 8.1a before attempting to upgrade to 8.5.

Grand Rapids has been Google Street View

2008-08-05T14:39:00.003-04:00

Check out Google Street View of Grand Rapids, MI.

http://maps.google.com/help/maps/streetview/

I didn't see the car go by but it must have been pretty recent because it has the construction in downtown filmed.

West Michigan SharePoint User Group September 2 Meeting

2008-08-04T13:02:00.000-04:00

New Horizons
5315 28th St Ct. SE Suite B
Grand Rapids, MI 49546

September 2, 2008
6:00pm-8:00pm

On September 2nd, David Tappan of C/D/H and Clay Osborn of Blue Sphere Solutions will do a deep dive on using data view/data form web parts to surface and present content from multiple sources. They will show how the data view web part is the “swiss army knife” of web parts. The presentation will include tips and tricks on setting up data connections and little known settings in SharePoint Designer, as well as how to do some amazing customizations of both functionality and look and feel using XSLT.

John von Rosen, a Software Consultant for Blue Sphere Solutions, will be giving a presentation on using the Business Data Catalog in SharePoint to provide insight into corporate data in an enterprise dashboard.

The presentation will provide information for business users by demonstrating the potential for access to business data in a dashboard. We will also cover the technical aspects, such as understanding the BDC metadata definition file.
Please join us and share your ideas and best practices while networking with your peers. Food and drink will be served.

IE 8 Beta Program

2008-08-01T07:56:00.003-04:00

Speaking of beta programs, I have been invited to participate in the Windows Internet Explorer 8 beta tester program.

I look forward to getting prereleases of the software and providing direct feedback to MS about any bugs I find.

If you would like to apply see this post View article...

Office 14 Estimated Release Date

2008-08-01T07:52:00.002-04:00

Office 14 appears to be scheduled to be released in Q4 of 2009 or Q1 of 2010. Given that timeline the Office 14 beta program will probaby not start until late this year or early next year. I remember participating in the Office 2007 beta program and I believe that started the same year that that Office system was released.

I also saw a rumor that Windows 7 could be released around that same timeframe, wonder if MS will do another Office - Windows launch.

"This document outlines the future direction of Microsoft Dynamics CRM through to the next major release, Microsoft Dynamics CRM “V.Next”, which will be aligned with the Office 14 wave of product releases due in late 2009/early 2010." from http://blogs.msdn.com/dynamicscrmonline/archive/2008/07/23/microsoft-dynamics-crm-statement-of-direction.aspx

Of course non of this is confirmed except for the information provided in the post by MS above about the estimated Office 14 release date.

SharePoint Mobile Enabled Lists Document Libraries

2008-07-31T10:13:00.001-04:00

I was under the impression that by default all lists and libraries within SharePoint were mobile enabled by default. However this is not the case.

To mobile enable a list, Modify the view you would like to make mobile, scross down to the Mobile section and check the box.

Convert InfoPath form to PDF Document

2008-07-29T08:05:00.002-04:00

I wanted to know how to do this for a long time now but never really spent the time to figure it out. And sometimes that's a good thing because people do it for you. As in this sample about how to convert the InfoPath form to a PDF.

http://aspalliance.com/1466_Printing_InfoPath_2007_WebBased_Forms_to_PDF.6

The solution uses an open source project for the PDF generation called iTextSharp. I haven't tried it yet but I also don't know of a lot of free pdf libraries.

Programmatically remove InfoPath digital signature

2008-07-28T16:01:00.002-04:00

This code will need to be placed within the backed InfoPath code, although just like before I'm going to try doing this with a web part. Speaking of which, I was able to remove the Excel digital signatures using a web part however it prompted for each signature that was to be removed and there is no way to get rid of that prompt so that sucked.

Anyway, here is how to do it in InfoPath. Basically get the signature node, go to the signature child of that node and delete it.

XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();

if(this.Signed) //then unsign it
{
XPathNavigator xSignedSection = xnDoc.SelectSingleNode("my:myFields/my:signatures1/my:signatures2", this.NamespaceManager);

if (xSignedSection.HasChildren)
{
xSignedSection.MoveToChild(XPathNodeType.Element); xSignedSection.DeleteSelf();
}

}

Microsoft .NET RegEx Syntax Regular Expressions

2008-07-28T14:51:00.002-04:00

I found a very nice cheat sheet for regular expression syntax. I have to admit I sucked at this in college and still hate it. Pages like these were built for people like me.

http://regexlib.com/CheatSheet.aspx

Programmatically Post to ASP page and read results

2008-07-28T10:01:00.003-04:00

I want to be able to POST some values to an external web site's ASP page and then programmatically read the results. The external page has no query string paramaters so I can't just create the url and read the page instead I need to create some web requests and deal with that object. This is how I did it, basically a mash up of what I found on the web but I believe more concise and clear.

//set our data
ASCIIEncoding encoding = new ASCIIEncoding();
string postData = "firstname=" + fname.Text;
postData += ("&lastname=" + lname.Text);

//compose the submission
HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://somepage.asp");
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = postData.Length;

// Post to the form.
StreamWriter swRequestWriter = new StreamWriter(request.GetRequestStream());
swRequestWriter.Write(postData);
swRequestWriter.Close();

//get the response
HttpWebResponse hwrWebResponse = (HttpWebResponse)request.GetResponse();

// Read the response
StreamReader srResponseReader = new
StreamReader(hwrWebResponse.GetResponseStream());
string strResponseData = srResponseReader.ReadToEnd();
srResponseReader.Close();

// Display the response on my page
Response.Write(strResponseData);

Now what I plan to do is screen scrape the result page and get the data I need. Ah regular expressions, I hate those. Stay tuned for that post in the next couple of days...

Creating a SharePoint stsadm command prompt on the dektop

2008-07-24T16:07:00.002-04:00

Create a quick shortcut to the stsadm command prompt for your SharePoint server.

http://blogs.msdn.com/scicoria/archive/2008/07/24/creating-a-wss-moss-command-prompt-on-the-desktop.aspx

Finding the SQL behind a Crystal Report

2008-07-24T15:16:00.002-04:00

I need to find the SQL that generated a Crystal Report. All I had was the report definition file and Visual Studio 2008.

After creating a new DSN (Windows XP users click here for instructions) I opened up the report in VS and clicked the Crystal Reports menu at the top. Then Database -> Show SQL Query. A wizard will popup, click the Back button, choose the newly created DSN for your database and then click Next. Login with your credentials and click Finish. Whalla (spelling??) I now see the previously hidden SQL.

InfoPath Percentage Symbol Field

2008-07-24T08:54:00.001-04:00

This applies to InfoPath 2007 as well.

That's just wrong:

Note Microsoft Office InfoPath 2003 does not add percent symbols to numbers that are formatted as percentages. To add a percent symbol to a control's label, click where you want the percent symbol to appear, and then type %.

http://office.microsoft.com/en-us/infopath/HP010938331033.aspx

Programmatically remove digital signatures from Excel document

2008-07-23T14:11:00.002-04:00

Here is some sample code to remove all digital signatures from an Excel workbook. This can be run from a Windows app or Console app. I'm going to try to make it work within a SharePoint document library event handler. That should be interesting. Basically the idea is to have a document library that has a bunch of documents that are digitally signed and then every month get reset by removing all the digital signatures. Hope this runs in the event handler.

Microsoft.Office.Interop.Excel.Application eApp = null; Microsoft.Office.Interop.Excel.Workbook wb = null;

//gets our workbook
eApp = new Microsoft.Office.Interop.Excel.Application();
wb = eApp.Workbooks.Open(textBox1.Text, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

//makes it visible and activates the workbook

//eApp.Visible = true;
//wb.Activate();

//get signatures

Microsoft.Office.Core.SignatureSet sigs = wb.Signatures;

//remove all the signatures

foreach (Microsoft.Office.Core.Signature sig in sigs)
{ sig.Delete(); }

//save and close the form

wb.Save();
wb.Close(Type.Missing, Type.Missing, Type.Missing);
wb = null;
eApp = null;

Sample valid credit card numbers

2008-07-22T15:07:00.004-04:00

I often need to test my forms with credit card information, so here are some valid numbers for each type of card, although I doubt they will work in reality but they pass the Luhn Algorithm for my testing.

Visa
4111 1111 1111 1111

MasterCard
5500 0000 0000 0004

American Express
3400 0000 0000 009

Discover
6011 0000 0000 0004

EmailSubmitConnection :How to add custom email to an InfoPath email data connection EmailSubmitConnection

2008-07-22T14:58:00.004-04:00

EmailSubmitConnection : Often times I need to add some more information to an email that is sent from InfoPath besides just a view of the form. Sometimes I want to add fields and such to the body of the email but just end up adding the fields to the subject line since there is no way without writing code to include fields in the introduction field of the email. I hope with Office 14 they make this possible without writing code, but for right now let's see how to do it.

First, you need to create a data connection (EmailSubmitConnection) that sends an email to someone within the InfoPath data connections. This data connection needs to be created so we can reference it in our code.

Second get into the code behind of the form, I'm using C# for InfoPath 2007 so those with InfoPath 2003 may have to figure this out for themselves but hopefully this gives them some clues.

Within, probably a button click event, I get a reference to the email data connection. The "email connection" is the name of the data connection I created in the first step.

EmailSubmitConnection emailDataConnection = (EmailSubmitConnection)this.DataConnections["email connection"];

//add your custom message to the introduction, say hello to yourself
XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();
XPathNavigator fullName = xnDoc.SelectSingleNode("my:myFields/my:txtFullName", this.NamespaceManager);
emailDataConnection .Introduction = "My custom introduction with some fields. Hello " + fullName.Value;

//submit the data connection which sends the email
emailDataConnection .Execute();

As you can see, just get a reference to the data connection (EmailSubmitConnection), set the Introduction property and execute. This can also be accomplished for the FileSubmitConnection and WebServiceConnection objects, so you can write code to execute these connections and set some custom properties before making the submit. Hope this helps someone.

Funny video for developers

2008-07-21T14:26:00.003-04:00

Stupid sales people should learn how to use the software they are selling. I can't tell you how many times I had to help people learn about the MS software that they had no idea how to use but were trying to sell it to our clients.

http://www.thewebsiteisdown.com/

InfoPath Rules vs Code

2008-07-21T11:10:00.000-04:00

When writing custom code behind for an InfoPath form you should keep in mind that when used on a button with other rules that the rules will run before the code. This means that if one of your rules "Closes the form" that your code will have to do this instead, otherwise the rule will close the form and your code will never run.

There is no way to switch the OoE or Order of Execution within InfoPath. Here is a sample to close the form in code in a js script code behind. There is also no need to sign the form unless the code interacts with the SharePoint OM.

Application.XDocuments.Close(0); //will close form but keep InfoPath open

Application.Quit(bool) //will exit InfoPath and if true force an exit, if false will prompt user if they want to save the form

I used true because in a rule I submit the form so the code can go ahead and quit InfoPath.

Installation Instructions for Sitecore CMS 6

2008-07-15T14:10:00.002-04:00

Sitecore has not provided a migration path from v5.3 to v6 and therefore a lot of Sitecore users cannot upgrade to the latest and greatest. I think this is unacceptable.

Here are screenshots of the Sitecore 6 installation process in case you ever get there.

Sitecore 6 Installation Screenshots