Where can I get a database layout for the BCM database? Ed - ejohm[ at ]hotmail.com 5/18/2007 3:32:00 PM Is Business Contact Manager documented? I would like to find a “database layout” so I know which fields are already there and what causes them to be updated on a field by field basis. Obviously some fields are updated by user input, but others are triggered by some other event. Heck, I don’t even know what fields exist at this point. Maybe we don't need that kind of information. Your thought? Ed

Re: Where can I get a database layout for the BCM database? "Alex" <blindmails[ at ]gmail.com> 5/18/2007 7:24:01 PM Ed, i am looking for the same information. I am working in a way to identify the ID of projects, because i have to show it and BCM do not show in forms. You can create a Database Diagram using this tool on SQL Server Management Studio. You will get a snapshot of all tables and fields and relations about that. You said about updating fields... well.. the BCM database is very strange... many data are updated by a sequence of triggers.. and some critical data, such as name of projects, for example, are encoded. You cannot read this fields directly in SQL Server. Maybe we can exchange informations about BCM database. I really need to find a way to show, in Project Forms, the ID of the projects. I already discovered many fields and the relations about them. Alex "Ed - ejohm[ at ]hotmail.com" <Ed - ejohm[ at ]hotmail.com[ at ]discussions.microsoft.com> wrote in message news:146FF857-426C-4140-AA65-DD12196AA012[ at ]microsoft.com... [Quoted Text] > Is Business Contact Manager documented? I would like to find a "database > layout" so I know which fields are already there and what causes them to > be > updated on a field by field basis. Obviously some fields are updated by > user input, but others are triggered by some other event. Heck, I don't > even > know what fields exist at this point. > > Maybe we don't need that kind of information. Your thought? > > Ed

Re: Where can I get a database layout for the BCM database? cschneid4[ at ]gmail.com 6/5/2007 8:53:13 PM On May 18, 10:32 am, Ed - e...[ at ]hotmail.com <Ed - e...[ at ]hotmail.com[ at ]discussions.microsoft.com> wrote: [Quoted Text] > Is Business Contact Manager documented? I would like to find a "database > layout" so I know which fields are already there and what causes them to be > updated on a field by field basis. Obviously some fields are updated by > user input, but others are triggered by some other event. Heck, I don't even > know what fields exist at this point. > > Maybe we don't need that kind of information. Your thought? > > Ed Ed, Did you ever find any Business Contact Manager documentation? I'm looking to build a couple custom reports but haven't had any luck figuring out the database scheme. Thanks... Craig

Re: Where can I get a database layout for the BCM database? Luther <enowning[ at ]gmail.com> 6/6/2007 3:23:59 PM On Jun 5, 1:53 pm, cschne...[ at ]gmail.com wrote: [Quoted Text] > On May 18, 10:32 am, Ed - e...[ at ]hotmail.com <Ed - > > e...[ at ]hotmail.com[ at ]discussions.microsoft.com> wrote: > > Is Business Contact Manager documented? I would like to find a "database > > layout" so I know which fields are already there and what causes them to be > > updated on a field by field basis. Obviously some fields are updated by > > user input, but others are triggered by some other event. Heck, I don't even > > know what fields exist at this point. > > > Maybe we don't need that kind of information. Your thought? > > > Ed > > Ed, > Did you ever find any Business Contact Manager documentation? I'm > looking to build a couple custom reports but haven't had any luck > figuring out the database scheme. Thanks... > > Craig The BCM database is intentionally undocumented. The only available documentation is for the Public Accounts and Contacts Views. Those are there for other apps to have access to some of the contact fields. However, there's been a fair amount of discussion of the database tables here over the years. I've been told there a bcm developer's newsgroup but I haven't been able to find it publically--i.e. on Google Groups. Most of the encoded binary fields contain Outlook data that BCM is required to store by Outlook, but BCM doesn't use it apart from saving those fields when Outlook asks it to and returning the data when Outlook requests it.