Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)



  • 1. Business Contacts vs Contacts
    Why can't I "Create New Contact From Same Company" in Business Contacts but I can in "Contacts"? that doesn't make any sense! Jack
  • 2. right management?
    Hi, Is it possible, to set rights to different users working with BCM? In this case user A only would have access to his address-pool, user B would have exclusively access to a different pool, and so on. Thanks for your feedback. regards Patrick
  • 3. BCM - problems reinstalling
    Clean install and update BCMUPD2 leads to BCM Folder showing but nothing in the toolbars. When Outlook is booted error message : Your .oft file for message class IPM.Contact.BCM Account has a wrong version. Requested version 2.00.351600 .oft for version 1.00.1616.00 I've Googled it and searched Microsoft Knowledge Base - nothing helpful.
  • 4. Business Contact View
    Hello everyone: When looking at an individual business contact (General View) I would like to see the "Comments" (the one with the time stamp located in the Details View). Ideally, I would like to be able to see the last comment entry in the Business Contacts List so I could do my follow up calls one after the other without having to go into the full view. Any help on how to accomplish this would be great! Thanks Jack

Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)

Postby picander77 » Tue, 11 Jul 2006 22:05:34 GMT

Hello there!

I need to migrate a custom CRM Application to BCM (over 10000

The easy Import way would be to export first all documents as Excel /
CSV, but then I found some difficulties importing and linking the
"Accounts" with the "Business Contacts". It seems it cannot be
performed using the featured BCM Import Tool.

I think the best way to migrate all the data would be to write all the
Documents directly into a *.BCM File, which are in fact XML Files. The
custom CRM Application can export all documents into well structured
XML and provides an XML Schema to facilitate the integration with other
databases or components.

Therefore, I would like to create an *.XLST (XML Transformation) in
order to transform the exported XML into a newly created *.BCM File.
Creating such a transformation requires a good know-how of the XML
Schema of the *.BCM Files

Does anybody have already performed such a migration via *.BCM Files?
Does anybody have a *.XSD File that I may use?

Any other suggestions?

Thanks in advance.


Re: Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)

Postby Luther » Wed, 12 Jul 2006 04:25:48 GMT

I've done some work in this area. In my experience, BCM XML does not
support XSD.

Your best bet to understand BCM XML is to create a new BCM database.
Create an Account, a child Business Contact, and an Opportunity, set
data for every field on the forms, then add one Activity of each
supported type, setting data in every field, and create one Product.
Then export to a BCM file. That should give you an XML file with every
possible element, which you can then use as a reference.

Similar Threads:

1.XML case: automated XML export of dynamic schema

Hi all, not sure this is right newsgroup for my questions.

I'd like to provide my users with Excel documents (simple lists with column 
Then, I'd like to upload this excel document into SQL Server, in a 
normalized model
The excel has a not-predictable layout, except that column headers will be 
within a predefined set of possibilities and there will always be a field 

--> upload into data model

My idea is to use XML:
- export excel to XML: this will be denormalized (lots of troubles with this)
- normalize this XML with XSLT to CODE, FIELD, VALUE elements (I have 
covered this)
- upload to SQL Server with OPEN XML (I have covered this)

My main problem is to automate the process of exporting to XML from an Excel 
Different parts of the problem, as far as I got:
1. I need to be able to generically create an XML map for exporting purposes
2. this must run stand-alone: the Excel-sheets (no macros in the sheet) will 
be dropped in a directory and then the process must start.

Maybe, I could make a long XSD with all possible fields, but then I must map 
the columns with the corresponding XML elements. 
The column order in the Excel sheet might be different than the element 
order in the XML map.

Anyone did something comparably, or can point me towards some reference that 
would help me?

Thanks in advance.

2.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!


3.BCM-V2 (Outlook 2003 BCM SP3) TO BCM-V3 (Outlook 2007) Migration

I've got a two backups from my BCM-V2 SP3 installation :
A) Completed Export to BCM (From Outlook 2003)
B) Database Backup From MSSQL 2003 (Express Ed, or Whatever)

I Did a clean install (on Another WorkStation) of Office 2007, then install 
Outlook BCM-V3 (Witch install MSSQL Express Ed 2005, and creates an empty 

I've follow two differents steps to try to make the migration :
A) Import BCM File (From my previous exported BCM (Outlook 2003)).
ERROR : Something like "Outlook can't make the last action", and nothing 
append, another thing is that, I must kill outlook process to get rid of that 
pop-up (Cancel and BACK buttons doesn't work)
B) Restore Database into MSSQL Express 2005:
It seams that this last step is the right one, but, when the process is in 
the middle of the migration, it stops, and shows a pop-up with something like 
"You're not allowed to restore database, plese contact the owner (my self) of 
the database, before restore" (This is not the exactly msg, but the meaning 
is the same)

My last chance, is to backup database, with password, and try to restore 
again, and see what append. No other clue for me, any help ??


(Excuse my bad english))

4.How in outlook BCM 2007 & C# import Opportunity product list XML insert a opportunity

5.Outlook 2007 BCM and XML

Could someone please give me some examples on retrievine, creating and 
updating the XML files used for Opportunity Products & Services? I need to 
create new Opportunities with Products programatically.  


6. How in outlook BCM 2007 & C# import Opportunity product list XML insert a opportunity

7. Extract XML Schema from a word document!

8. Extract XML Schema from a Word Document!



Who is online

Users browsing this forum: No registered users and 16 guest