Posted by (JavaScript must be enabled to view this email address) on Wed 14 Oct 2009

This week we’ve launched the Brantas Customer Access Portal, if you are a customer with a registered support agreement you will be able to easily view and maintain your active cases. 

How have we done this?  We’ve integrated our support management system (Dynamics CRM) with the eService Accelerator for CRM from codeplex, mix that with Brantas’ knowledge of web technologies (including ASP.Net, CSS and xHTML) and the result is a fully branded, customised portal for our customers.

We’re also currently working on a SharePoint Designer Activity tutorial to go on the site later this week.

Posted by (JavaScript must be enabled to view this email address) on Thu 06 Aug 2009

We were trying to configure Email Enabled Document Libraries in MOSS 2007 and all was going really well until actually configuring a document library to accept emails. 

Every time I ran the Incoming Email Settings page and clicked OK I was presented with an ACCESS DENIED error from the web service.  Great! Windows 2008 was at it again.  It might be a lot more secure but its not kind to those who have to administer it on a daily basis.

Eventually I tracked down a post which showed I had to use a command CACLS to set permissions on the IIS Metabase - Application Pool accounts have no administrative access over this and the CACLS command is a way to allow the required level of access.

CACLS is deprecated in Windows 2008, instead you should use

ICACLS “%SystemDrive%\Windows\System32\inetsrv\config\applicationHost.config” /grant <domain>\<UserAccount>:(D,WDAC)

Posted by (JavaScript must be enabled to view this email address) on Tue 28 Jul 2009

The first thing to do is get the current month:

SET @CurrentDate = GetDate()SET @CurrentMonth = Month(@CurrentDate)

Then its just a case of setting the start and end of the fiscal year according to whether the month falls in the last quarter (Jan, Feb, Mar) or the first three quarters (April thru to Dec):

IF @CurrentMonth >= 4
BEGIN	
SET @FiscalYearStart = DATEADD(mm, 3, DATEADD(yyyy, DATEDIFF(yyyy, 0, @CurrentDate), 0))	
SET @FiscalYearFinish = DATEADD(mm, -1, DATEADD(yyyy, 1, @FiscalYearStart))
END
ELSE
BEGIN	
SET @FiscalYearStart = DATEADD(mm, -9, DATEADD(yyyy, DATEDIFF(yyyy, 0, @CurrentDate), 0))	
SET @FiscalYearFinish = DATEADD(mm, -1, DATEADD(yyyy, 1, @FiscalYearStart))
END

Hope this helps you in your report building duties full code below:

Declare @CurrentDate AS DateTime
Declare @CurrentMonth AS int
Declare @FiscalYearStart AS DateTime
Declare @FiscalYearFinish AS DateTime
SET @CurrentDate = GetDate()
SET @CurrentMonth = Month(@CurrentDate)
IF @CurrentMonth >= 4
BEGIN	
SET @FiscalYearStart = DATEADD(mm, 3, DATEADD(yyyy, DATEDIFF(yyyy, 0, @CurrentDate), 0))	
SET @FiscalYearFinish = DATEADD(mm, -1, DATEADD(yyyy, 1, @FiscalYearStart))
END
ELSE
BEGIN	
SET @FiscalYearStart = DATEADD(mm, -9, DATEADD(yyyy, DATEDIFF(yyyy, 0, @CurrentDate), 0))	
SET @FiscalYearFinish = DATEADD(mm, -1, DATEADD(yyyy, 1, @FiscalYearStart))
END
SELECT @FiscalYearStart, @FiscalYearFinish