MOSS 2007 – Error enabling Office SharePoint Server Publishing Infrastructure

Upon trying to enable the feature for publishing in MOSS, I ran across this security error. Access denied. at Microsoft.SharePoint.Administration.SPPersistedObject.Update().

Under site settings logged in as site collection admin, go to Site Collection Administration -> Site Collection Features.

Office SharePoint Server Publishing Infrastructure
Provides centralized libraries, content types, master pages and page layouts and enables page scheduling and other publishing functionality for a site collection.

Click the Activate and this is where the error is happening.

Upon some wide searches I found this great post that provided a great work around. Here are the basic steps and link.
1. Open IIS Admin.
2. Location the Web Site for your WSS web application.
3. Goto to the properties and select the ‘Home Directory’ tab.
4. Change the AppPool to be the same as Central Administration.
5. IISRESET
6. Activate the Publishing Infrastructure feature on your site.
7. Change to AppPool back to the original.
8. IISRESET.

Activating Office SharePoint Server Publishing Infrastructure – Access Denied

Format telephone field in CRM 4.0 using javascript onChange event

Here is a simple javascript to format telephone numbers in CRM. This is to be used in the onChange event at the field level. Throw this in there to format telephone numbers using (XXX) XXX-XXXX. Pretty simple code that I found and slightly modified to meet our clients need.

var oField = event.srcElement;
if (typeof(oField) != “undefined” && oField != null)
{
var sTmp = oField.DataValue.replace(/[^0-9]/g, “”);
switch (sTmp.length)
{
case 10:
oField.DataValue = “(” + sTmp.substr(0, 3) + “) ” + sTmp.substr(3, 3) + “-” + sTmp.substr(6, 4);
break;

default:
alert(‘Phone must contain 10 numbers.’);
break;
}
}

I found this code while searching google. It is from Mitch Milam’s blog and the entry is for CRM 3.0 SDK: Phone number format example bug fix. Thanks Mitch!

Customizing Marketing List View in Microsoft CRM 4.0

Upon trying to customize the view of the “Marketing List Members” in the Marketing List entity, I hit a road block (typical in CRM 4.0 I have come to realize..). My first instinct was to go under the Contact entity, look for the associated view and modify the view from there. Much to my surpirse, the view didn’t match what I was seeing in the Marketing List. Hmm….

After a short while on Google, I found that the Marketing List Members does not use a view that is available from the Contact entity. Of course it doesn’t! It uses a built in view call “All Members”. In order to modify this, you must use the Advance Find feature, pull up the “All Members” view and modify it there. See the details at Customizing Marketing List from the Microsoft CRM Team Blog site.

Good Luck!!

Deletion Service in Microsoft CRM 4.0

When performing a bulk load using the Data Migration tool in CRM 4.0, I ran across a huge issue on how the data is backed out. I am working on a large ACT! to CRM 4.0 migration which include 73 mapping for the Contact entity and of course, it is a trial and error process. Using the Data Migration tool is perfect since you can back out the successful records until you get a clean upload. The only problem is that the deletion process sets a flag on the entity level (DeletionStatusCode = 2) rather than actually deleting the records from the database. Then the Sync service will pick up the records for deletion and physically delete them. Now the limitation to this process is that the service will only run once a day and can not be run on demand…. until yesterday afternoon.

Welcome ScaleGroup Job Editor! Simply install on the CRM 4.0 server and now you can actually set when the delete service runs!!

Thank you to the East Region Microsoft CRM blog. I recommend checking this blog weekly for other very useful updates to all things CRM 4.0.