SharePoint EditControlBlock RegistrationId types

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 Service Pack 2 Expiration Date Hot Fix Available

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

SharePoint 2007 SP2 will expire your site in 180 days

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.

April CU Update is available

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

SharePoint Site Themes

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

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

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

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

SharePoint Email Enabled Lists

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 <> ''

SharePoint Jobs

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

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.

SharePoint Open a closed Web Part

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:

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

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

SharePoint Picture Library Item Url

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

Custom SSRS Web Parts for SharePoint

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

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

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

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.

West Michigan SharePoint User Group Meeting November

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.

SharePoint Date Picker Control

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

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/