Querying BCM data



  • 1. Office 2K small business tools
    I installed Office 2K and the small business tools part of the program does not seem to have installed (neither did Publisher 2k for that matter). Tech support did not have the info on that program..the small business tools which has a small business customer manager, and other things. Anyone have any ideas how to see if it's there, how to activate it (the book doesn't say much either), etc?? Thanks Mike
  • 2. How do you set up business contact manager for limited user accco.
    I only have one administrator account and several limted users accounts. How do you set up that the limited users can use Business Contact Manager+
  • 3. Reading messages on server and contact manager with mail appli
    Just curious, why would they include it in the 2K pacakage if it won't work until a product that is 3 years away? Does the ability to flag emails with the purpose of making notes about them, adding a todo or appt for call back etc exist. I.E can Outlook be used as the mail program and be directly linked to the contact manager as described? "Luther" wrote: > BCM only works with Office/Outlook 2003 and not with 2K > >
  • 4. Business Contact History field displays all contents of inbox
    Business Contact History field displays all the detailed contents of your Inbox instead of displaying only the history items that are related to the Account History or Business Contact History field.
  • 5. Scheduling calls
    I am trying to schedule calls and call back time from within Outlook Business Contact manager. I don't see a date and time field under eithe the General or Details field. Using the Flag button, I have scheduled a call at a certain time and date however the time and date do not show up under the callback field. Does anyone know where I can find instructions or a manual which will allow us to use this product in a productive way? Thanks. -- HSolomon

Querying BCM data

Postby a2F5ZXNz » Mon, 15 Mar 2010 01:21:01 GMT

Hi there -- 

I'm trying to build a simple report: show me all CONTACTS where (various 
criteria are true) AND the payment status for the ACCOUNT they're associated 
with equals PAID. 

I have a feeling the reporting functions built into BCM are not robust 
enough for what I'm after, but if someone could help me figure out how to 
connect with BCM data through Access or SQL, I'd be fine. 

Any insight? I'd be grateful. 


Re: Querying BCM data

Postby Leonid S. Knyshov // SBS Expert » Wed, 17 Mar 2010 06:48:42 GMT

Which BCM?

Leonid S. Knyshov
Crashproof Solutions
Twitter: @wiseleo
Microsoft Small Business Specialist
Try Exchange Online  http://www.**--****.com/ 
Please vote "helpful" if I helped you :)

Similar Threads:

1.outlook 2007 with BCM - BCM query

In the BCM am trying to change the opportunities current view. I have added 
my own fields successfully but when I add one of the default fields 
"contacts" it allows me the add this to the view but nothing shows in the 
field? This happens with several default fields? Why?

Thank you - David

2.Outlook 2007 with BCM - BCM query?

In the BCM am trying to change the opportunities current view. I have added 
my own fields successfully but when I add one of the default fields 
"contacts" it allows me the add this to the view but nothing shows in the 
field? This happens with several default fields? Why?

3.BCM 2007 - How to create a document and include BCM data

I'm not trying to mail merge to 200 recepients in my contact list.
I want to automaticly create a document, where it includes contact 
informatio from the contact that is actualy open.
This used to be possible before, but I can't seem to find it in 2007 and in 
I want the document to automaticly be registered under communications - just 
like e-mails, calender events and so on.

Can anyone help me?

Best regards,
Henrik Notlev

4.BCM to CRM 3.0 Migration Q - Data Migration Wizard for Outlook BCM

Hi All,

This weekend I will be migrating from BCM to CRM 3.0 (on SBS 2003) and was 
hoping to get a heads up on the following:

1) clarify a "Known Issues with the Data Migration Wizard for Microsoft 
Outlook with Business Contact Manager" point that sticks out in the 
documentation and in my long hours of reading online namely: 

"The link between activities and parent accounts and contacts is not 
preserved during migration. 
If you have accounts or contacts in Microsoft Outlook with Business Contact 
Manager that have activities, such as tasks or appointments, associated with 
them, when you migrate the data to Microsoft CRM, the activities are not 
associated with the accounts or contacts. These activities will be migrated, 
but the Regarding field will be blank. "

surely this is a fundamental flaw here that anyone that has used BCM will 
have history attached to each - we don't have a large amount of accounts - 
several hundred - but they each have 40-100+ items of history so to go 
through and manually manipulate these unassociated items/contacts will be a 

how does one get around this using the migration tool (given I am just a 
small operation so can't afford an expensive 3rd party tool)? 

2) also in addition to the above any other gotchyas to be aware of using the 
"Data Migration Wizard for Office Outlook with BCM" tool?

thanks in advance!


5.Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool

I created a BCM database in my local machine and I would like to move it to 
the server so other machines on the network can have access to it as well. I 
used osql -E -S command to stop the BCM database from my machine and moved it 
to the server, and I re-attached BCM database from the server. 

EXEC sp_attach_db @dbname = N'STS_Config', @filename1 = 
N'C:\new_database_location\STS_Config.mdf', @filename2 = 

Can I have other machine attach to the Database in the server the same way? 
Since I am the owner, I still have to give permission to user to access it. 
But I would rather perfer to have Admin on the server have the total control 
of DB. It seems MS2007 BCM Data Admin Tool is the way to go, but does it work 
on the database created by BCM V2 on MS2003? 

I installed the BCM Data Admin Tool + SQL 2005 Express, when I launch the 
Admin Tool it did not find the BCM Instance, is there a special way to 
configure that?

Any help will be greatly appreciated.

6. Import Data from 2003 BCM to 2007 BCM (on Windows 7)

7. Need to migrate BCM 2003 data into BCM 2007

8. Migrate BCM 2003 data to BCM 2007



Who is online

Users browsing this forum: No registered users and 72 guest