Where does BCM store User-Defined fields in the database?

  • Thread starter Thread starter Jim
  • Start date Start date
Status
Not open for further replies.
J

Jim

I'm working on a migration from BCM to Dynamics CRM 4.0. The client has

user-defined fields on the Opportunity form. Where are these fields stored

in the MSSmallBusiness database? I have looked all over and have not yet

found them. Any assistance is appreciated.
 
The mapping involved with user defined fields is quite complex but the short

answer is they are stored in a table called ContactUserFields. It maps to

ContactMainTable on CustomerServiceID field. The ContactUserFields table has

columns UserField1 through UserField40, thus the inherent limit on 40 user

defined fields. The data is stored in binary format so you will have to cast

to the appropriate data type when querying. You can map the columns index to

the exact user defined fields in a table called EntityUserFields. The data

in UserFieldIndex maps to the UserField## column in ContactUserFields. If

you need help with the datatype check out the tables UserFieldDefinitions and

UserFieldDataTypes.

The quickest way to pull all the data is to use the preconstructed views.

The view with IMAPI in the name will pull user defined fields. If you wanted

to export all the Account info query from AccountIMAPIView. If you want the

Contact info query ContactIMAPIView.

This should get you pointed in the right direction.

"Jim" wrote:


> I'm working on a migration from BCM to Dynamics CRM 4.0. The client has
> user-defined fields on the Opportunity form. Where are these fields stored
> in the MSSmallBusiness database? I have looked all over and have not yet
> found them. Any assistance is appreciated.
 
The mapping involved with user defined fields is quite complex but the short

answer is they are stored in a table called ContactUserFields. It maps to

ContactMainTable on CustomerServiceID field. The ContactUserFields table has

columns UserField1 through UserField40, thus the inherent limit on 40 user

defined fields. The data is stored in binary format so you will have to cast

to the appropriate data type when querying. You can map the columns index to

the exact user defined fields in a table called EntityUserFields. The data

in UserFieldIndex maps to the UserField## column in ContactUserFields. If

you need help with the datatype check out the tables UserFieldDefinitions and

UserFieldDataTypes.

The quickest way to pull all the data is to use the preconstructed views.

The view with IMAPI in the name will pull user defined fields. If you wanted

to export all the Account info query from AccountIMAPIView. If you want the

Contact info query ContactIMAPIView.

This should get you pointed in the right direction.

"Jim" wrote:


> I'm working on a migration from BCM to Dynamics CRM 4.0. The client has
> user-defined fields on the Opportunity form. Where are these fields stored
> in the MSSmallBusiness database? I have looked all over and have not yet
> found them. Any assistance is appreciated.
 
The mapping involved with user defined fields is quite complex but the short

answer is they are stored in a table called ContactUserFields. It maps to

ContactMainTable on CustomerServiceID field. The ContactUserFields table has

columns UserField1 through UserField40, thus the inherent limit on 40 user

defined fields. The data is stored in binary format so you will have to cast

to the appropriate data type when querying. You can map the columns index to

the exact user defined fields in a table called EntityUserFields. The data

in UserFieldIndex maps to the UserField## column in ContactUserFields. If

you need help with the datatype check out the tables UserFieldDefinitions and

UserFieldDataTypes.

The quickest way to pull all the data is to use the preconstructed views.

The view with IMAPI in the name will pull user defined fields. If you wanted

to export all the Account info query from AccountIMAPIView. If you want the

Contact info query ContactIMAPIView.

This should get you pointed in the right direction.

"Jim" wrote:


> I'm working on a migration from BCM to Dynamics CRM 4.0. The client has
> user-defined fields on the Opportunity form. Where are these fields stored
> in the MSSmallBusiness database? I have looked all over and have not yet
> found them. Any assistance is appreciated.
 
Status
Not open for further replies.
< User Defined Fields | Adding a new database to BCM >
Similar threads
Thread starter Title Forum Replies Date
D Where does Outlook store signatures? Outlook VBA and Custom Forms 9
H Where does Outlook 2007 save the default reminder settings? Outlook VBA and Custom Forms 1
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
G Outlook Contact Item.Restrict where FullName is NULL Outlook VBA and Custom Forms 3
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
e_a_g_l_e_p_i Changing where data .pst is saved to Using Outlook 3
D Anyone tell me where custom view settings are stored? Outlook VBA and Custom Forms 9
P Sending email from outlook IMAP to GMAIL where embedded images are added as attachment Using Outlook 1
J Outlook 2016 After a search in all mailboxes, where is each message that was found? Using Outlook 6
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
J OUTLOOK 2016 FILE STORAGE WHERE COMMAND Using Outlook 12
C Long List Of Outlook 2016/Outlook.com Bugs // Where To Report? Using Outlook 10
S Views ans Where Settings AreSavd Using Outlook 4
F Move mails from Deleted Items folder back to its original folder where the mails got deleted Using Outlook 0
Horsepower Where did Evenote come from? Using Outlook 6
tswatek Issue with where Outlook saves new contacts Using Outlook 3
snissen Where is "Edit Message" in Outlook 2016? Using Outlook 2
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Mark Foley Where are Outlook categories save for IMAP? Using Outlook 12
T Where did my categorized emails go? Using Outlook 1
H Where to post code in Outlook Outlook VBA and Custom Forms 1
R click to toggle quick click category reasigns to where ? Using Outlook 2
P Where are the cached emails stored? Using Outlook.com accounts in Outlook 2
D VBA Script (Ask to where to save send mail) Outlook VBA and Custom Forms 1
R Outlook 2013 People Pane - Where is the "Add" button for social networks? Using Outlook 4
J Lost contacts.pst afer sync with iCloud: where has contact.pst disapperaed to? Using Outlook 3
O Outlook 2013 contacts - Where to find "Display as"-field Using Outlook 2
J Linking Contacts to a Message Where the Contact isn't an Addressee Using Outlook 1
L How do i choose where i file my sent messages? Using Outlook 1
C Outlook 2007 Contact Card opens in margin of screen where I can't see it Using Outlook 3
P Where the heck is the data? Using Outlook 10
G Modify Subject line of incoming mail where I am in Cc line Using Outlook 1
B Can't locate in Outlook custom form where is message from Using Outlook 4
B help: where are outlook2000 email accounts stored Using Outlook 14
Rupert Dragwater Where to find folders in Outlook 2010 Using Outlook 4
S Where is the BCM SDK?? BCM (Business Contact Manager) 1
B Where are my emails that I already? Using Outlook 1
G Where are Saved Reports physically stored? BCM (Business Contact Manager) 0
O Where is Launcher, the custom action for Exchange server? Exchange Server Administration 1
J Where is Final Release BCM 2010, Microsoft? Why is Dev Team silent BCM (Business Contact Manager) 2
B Where is RTM version of BCM 2010? BCM (Business Contact Manager) 2
N Where have all the helpful people gone in this forum? BCM (Business Contact Manager) 3
S Custom Fields - Deleting And Where Are They Saved Outlook VBA and Custom Forms 8
M WHERE without using CASE Outlook VBA and Custom Forms 3
S Where to publish my custom form ? Outlook VBA and Custom Forms 4
P Where are User-defined fields stored in BCM 2010 database? BCM (Business Contact Manager) 2
E Where is Business Contact Manager?? BCM (Business Contact Manager) 2
T Where is "administrative groups" Exchange Server Administration 9
K Get folder path where an account stores messages Outlook VBA and Custom Forms 5
A COM add-in causes Outlook 2007 to periodically crash where it did not in Outlook 2003 Outlook VBA and Custom Forms 3

Similar threads

Back
Top