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 ):
| AttributeName | AttributeValue | Value |
|
statecode |
0 |
Active |
|
statecode |
1 |
Inactive |
|
statuscode |
1 |
Active |
|
statuscode |
2 |
Inactive |
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
You’re happy to see the sun come up.
I’m happy that I can see the sun come up.
I have a short article on the CRM Team Blog discussing the Properties feature for a CRM record.
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. :)
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.
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.
Loading ...
