Finding the value of the state and status codes

Posted on September 25th, 2009 mitch  Print No comments

If you’ve ever wondered how to find the values for the statecode and statuscode, you can use the following SQL script to find those values:

select 

    AttributeName, 

    AttributeValue,

    Value

from dbo.StringMap 

where

(dbo.StringMap.AttributeName = 'statuscode' 

or

dbo.StringMap.AttributeName = 'statecode')

and 

dbo.StringMap.ObjectTypeCode = 1

Will display the following values for the Account Entity ( ObjectTypeCode = 1 ):

Customization, Dynamics CRM

(1 votes, average: 3.00 out of 5)

 Loading ...

481 views

Off-Topic: Can you .NET Till Your Eyes Bleed?

Posted on September 16th, 2009 mitch  Print 6 comments

Hi Everyone,

This past month has been a whirlwind for me with both customer and personal projects in the works.

I alternate my days between .NET (C#) and JavaScript, with much of late being .NET.

I am almost exhausted.  I found myself refactoring C# in my sleep.

Am I alone?  Does anyone else have this condition?

Later, Mitch

Development

(1 votes, average: 5.00 out of 5)

 Loading ...

1,270 views

Thought of the day. 9/16/2009

Posted on September 16th, 2009 mitch  Print No comments

You’re happy to see the sun come up. 

I’m happy that I can see the sun come up.

Meanderings

(No Ratings Yet)

 Loading ...

202 views

New article on CRM Team Blog. 9/16/2009

Posted on September 16th, 2009 mitch  Print 1 comment

I have a short article on the CRM Team Blog discussing the Properties feature for a CRM record.

Dynamics CRM

(No Ratings Yet)

 Loading ...

3,132 views

Using .NET to Develop for the iPhone

Posted on September 14th, 2009 mitch  Print No comments

Today, Novell officially released MonoTouch, a development environment that allows you to write C# .NET code that can be deployed on the iPhone and iTouch.

I find the whole concept fascinating. So much so that I actually bought a Mac Mini so I could write iPhone apps. ( Due to the iPhone SDK, a Mac is required as a development platform. )

It will be a change of pace from writing CRM-integrated apps all day. :)

Development, iPhone

(2 votes, average: 5.00 out of 5)

 Loading ...

525 views

Looking for Beta Testers

Posted on September 11th, 2009 mitch  Print 2 comments

Hi Everyone,

I have a new CRM add-on that is just entering the testing phase and I am looking for people to spend a little time testing and providing feedback.

If you are interested please send an email to:

mitch at crmaccelerators dot net

Thanks, Mitch

CRM Data Validation

The add-on is a data validation tool that includes the following functionality:

User interface validation

This feature allows you to view the attributes for a particular entity and examine their usage within the system.

You can choose to display:

• All Attributes
• Only default attributes
• Only custom attributes

The attribute list can be further refined by:

• Show all attributes
• Show only attributes found on forms
• Show only attributes NOT found on forms

You can compare the data found within an individual attribute by setting thresholds. This feature allows you to compare the total number of records found in the entity to the number of instances where a particular field contains data.

• The Positive threshold is a percentage that reports records containing data more than X percent of the time
• The Negative threshold is a percentage that reports records containing data less than Y percent of the time.

This data can be utilized to determine if your data entry form is properly balanced with the important attributes being on the first tab and lesser-used attributes being on the subsequent tabs.

Data may also be collected showing attributes which contain data but are not being utilized on the form. This could indicate an architectural change in the system and the possibility that those fields can be removed.

Duplicate email checking ( across entities )

The duplicate email function will check for duplicate emails that may exist in the Lead, Account, Contact, or System User entities.

You have the option of editing the email directly within the user interface or opening the record within CRM for editing there.

Locate System User emails within the Lead, Contact, or Account entities

Since the existence of System User emails inside other entities, such as Contact, can cause tracking issues, this feature allows you to locate and remove those addresses.

Verifying email address formats

The CRM user interface requires that a valid email be entered when completing any email fields. The same cannot be said for data that has been imported or migrated from another system. This feature scans and reports any invalid email addresses found within the CRM system.

Dynamics CRM

(No Ratings Yet)

 Loading ...

763 views

Outlook 2007 and Plain Text Email Line Wrapping

Posted on September 2nd, 2009 mitch  Print No comments

This is a bit off-topic for me, but since I ran into it, I blog about it.

So I’m testing one of my CRM add-ons which involves sending an email to an email-enabled CRM queue.

I’m sending an email with an XML packet in the email body.  Unfortunately, Outlook keeps hard-wrapping the text by inserting carriage-returns which end up breaking the XML into fragments.

Fortunately, Slipstick Systems came to my rescue, as always ( anything Outlook/Exchange-related ).

Anyway, I found a reference to a KB article that mentions how to make Outlook “not wrap” plain text emails going out over the Internet.

Perfect!

Other than having to change the Registry Key mentioned in the KB article to:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0

instead of Office\11.0 ( for Outlook 2003 ), everything worked and I can get back to testing.

Development, Email

(No Ratings Yet)

 Loading ...

741 views