We announced news of our Latest Module for Dot Net Nuke. The Microsoft Pivot based module that brings pivot browser technology to DNN. See more about the DNN Pivot Module.

Some quick info for the file system on the iOS.

Documents – persists data and is backed up when you connect itunes.

tmp – used for your temp app stuff. Not to persist data and you should clean up that directory whenever possible by your app.

Library/Caches – persists app specific data between launches of the app. Not backed up.

Library/Preferences – app specific preference settings data (but use CFPreferences API), Gets backed up.

More info at apple’s site here.

Quickly get the path to your Documents directory here:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documentsDirectory = [paths objectAtIndex:0];

// get a file called foo.xml

NSString *filePath = [documentsDirectory stringByAppendingPathComponent:@”foo.xml”];

Getting the tmp directory is a bit easier:

NSString *tmpDir = NSTemporaryDirectory();

When hosting wordpress on iis 7, the ability to upload images from blog post tools like Live Writer and the ability to automatically update plugins is controlled by the permissions set both within IIS and within the directory structure that IIS accesses. The account that holds the key to the success is the “Users” account, unlike other versions of IIS.

Thanks to http://www.engadget.com for a rocking cast of WWDC 2010

"Pricing — there’s two colors. White and black. Pricing — $199 for 16GB, $299 for 32GB."

On sale 24th July 2010

"So what’s our lineup look like? 3GS is now $99. These go on sale June 24th."

"Pre-orders start a week from tomorrow. And we’re shipping in 5 countries. In July we’re shipping in 18 more."

Thanks to http://www.engadget.com

"So in 2007 when we launched the iPhone, it was my privilege to make a call to Jony Ive… and I’m going to do the same thing now." Boom, video call.

Now the iPhone 4G running on the iOS4 has built in video call

“You know I grew up with the Jetsons… and video calls… and now it’s real. What about you?" Jony: "I grew up with the same thing, and it’s real now!" Steve: "It is real… especially when people turn off their WiFi." Jony: "We’ve had to wait an awful long time for this to become reality." Steve: "Okay, let’s have lunch soon."

It’s called FaceTime. WiFi only. iPhone 4 to iPhone 4. No setup.

11:38AM Wow — very cool. Two people speaking in sign language on the phone. We’re getting a little choked up! That’s a pretty cool use.

11:38AM Wow. You can flip the image to the rear camera. This commercial is pretty intense.

We have updated a range of our dotnetnuke modules on our website. You can find all the latest updates and news on our site. We have under the support tab, a DNN module news area, that links to all the module news and latest features and updates.

While installing MS CRM Rollup 8 or MS CRM rollup 9, we received an error that looked like this:

—————————
Microsoft Dynamics CRM 4.0 Update Rollup 9
—————————
Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

Invalid length parameter passed to the LEFT or SUBSTRING function.

Cannot insert the value NULL into column ‘InvoiceNumber’, table ‘sdia_MSCRM.dbo.InvoiceBase’; column does not allow nulls. UPDATE fails.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

—————————
Retry   Cancel  
—————————

It turns out this error is caused by an invoice having an invalid invoice number. By default, MS CRM gives invoices numbers that look something like this: INV-06881-39HRRD

In our CRM project, we had some invoice number formats being inserted manually by a remote Events Booking system we have written for the web (cool application actually). This used slightly different format invoice numbers intentionally. The solution to the problem was to either remove or renumber in the same format the invoice records. Once your invoice numbers are all as CRM expects them, then you can install either or both updates.

This is a SQL script that may help:

Execute this SQL script to generate correct invoice number, specifying

correct length for your invoice number format

(verify in your CRM parameters Automatic Numbering for invoice):

@InvoiceNumberPref = 'INV'

@invoicePART1Len = 5

@invoicePART2Len = 6

In this case : INV-02365-6Y5TRE

-- Start Script ---------------------------------------- 

DECLARE @InvoiceNumberPref nvarchar(5)

SET @InvoiceNumberPref = 'INV'

DECLARE @invoicePART1Len int

SET @invoicePART1Len = 5

DECLARE @invoicePART2Len int

SET @invoicePART2Len = 6

DECLARE @i int

DECLARE @j int

DECLARE @n int

DECLARE @strnum nvarchar(10)

DECLARE @RandomChars nvarchar(10)

DECLARE @RandomInvoiceNumber nvarchar(20)

SET @j = 1

DECLARE @invoiceid nvarchar(50)

DECLARE @invoicenumber nvarchar(20)

DECLARE cursor_invoices CURSOR FOR

SELECT CONVERT(NVARCHAR(50),invoiceid), invoicenumber FROM dbo.invoice

order by createdon

OPEN cursor_invoices

FETCH cursor_invoices INTO @invoiceid, @invoicenumber

WHILE @@FETCH_STATUS = 0

BEGIN

SET @strnum = CONVERT(nvarchar(10), @j)

SET @j = @j + 1

SET @strnum = REPLICATE('0', @invoicePART1Len-LEN(@strnum)) + @strnum

SET @RandomChars = ''

SET @i = 0

WHILE @i < @invoicePART2Len

BEGIN

SET @n = ASCII(0)+CEILING(RAND()*(ASCII('Z')-ASCII(0)))

--exclude value range 58-64 

IF @n>ASCII(9) AND @n<ASCII('A') SET

@n=ASCII(0)+CEILING(RAND()*(ASCII(9)-ASCII(0)))

SET @i = @i + 1

SET @RandomChars = @RandomChars + NCHAR(@n)

END

SET @RandomInvoiceNumber = @InvoiceNumberPref + '-'+@strnum+'-'+@RandomChars

PRINT @invoiceid + ' ' + @invoicenumber + ' ' + @RandomInvoiceNumber

UPDATE invoicebase

SET invoicenumber = @RandomInvoiceNumber

WHERE invoiceid = @invoiceid

FETCH cursor_invoices INTO @invoiceid, @invoicenumber

END

CLOSE cursor_invoices

DEALLOCATE cursor_invoices

Check out our website for more CRM integration into DotNetNuke.