Thursday 19 July 2012

Data Import


While importing data, I was getting an SQL Internal Error when trying to import error,
There are few plugin registered on records created, and when I debuged them while importing data, the code executed fine.

The reason for the error was the length of the identifier/name of the record was defined 100 character, and the concatenation was exceeding the length of identifier/name.

Wednesday 18 July 2012

MSCRMKeyGenerator problem

Error: when trying to browse the crm page.
object reference not set to an instance of an object.

when looked at the event viewer. following is the detail message

Current key (KeyType : CrmWRPCTokenKey) is expired.  This can indicate that a key is not being regenerated correctly.  Current Key : CrmKey(Id:xxxxx-xxxx-xxxx-a602-00155d8283bf, ScaleGroupId:00000000-0000-0000-0000-000000000000, KeyType:CrmWRPCTokenKey, Expired:True, ValidOn:06/15/2012 09:59:04, ExpiresOn:07/18/2012 09:59:04, CreatedOn:06/15/2012 09:59:04, CreatedBy:NT AUTHORITY\NETWORK SERVICE.

Solution: Restart Async servcie and do a IIS Reset

Tuesday 10 July 2012

Formating Excel Sheet

To format a list of values in a column if they are not present in the list of values mentioned into another sheet column,


Select the range of cells you want to apply formatting to
Click on the Conditional Formatting
Click on the new rule

Specify formula
=countif(sheet1!b2$:c3$,d2)
select format and click apply

d2 is the first record of the selection where we are applying the formatting to.

=countif(dictionarylist,d2)
dictionarylist is the name of the cells values from where we like the values to compare to. to create a named list, select list of values, and on the left of formula where it show column name change it to some list name e.g. dicitionarylist

if you want to format a cell where values does not exits in the list than

= countif(dictionarylist,d2)=0

=if(isblank(m9),false,COUNTIF(lifecyclelist,M9)=0)

http://www.contextures.com/xlCondFormat03.html
http://www.contextures.com/xlCondFormat01.html