Hello there! I need to migrate a custom CRM Application to BCM (over 10000 documents): 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. Picander
Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)
2 posts
• Page 1 of 1
- Exchange 2000
- Microsoft Project
- WINDOWS SERVER
- ISA
- device driver
- WINDOWS SERVER
- ace
- windows media center
- VB.NET
- Network Protocols
Jump to:
- 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
Next
Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)
by picander77 » Tue, 11 Jul 2006 22:05:34 GMT
Re: Migration Via *.bcm / XML Files: BCM XML Schema required (*.xsd)
by 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 headers). 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 CODE. CODE LONG_DESC SHORT_DESC DUNS ... 1 LONGa SHORTa DUNSa 2 LONGb SHORTb DUNSb 3 LONGc SHORTc DUNSc --> upload into data model CODE FIELD (e.g. LONG_DESC,SHORT_DESC, DUNS...) VALUE (e.g. LONGa, SHORTa, DUNSa, LONGb, SHORTb, DUNSb, LONGc, SHORTc, DUNSc...) 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 file. 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. Bert
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 nightmare! 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! Nick
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 database) 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 ?? Thxs, (Excuse my bad english))
4.How in outlook BCM 2007 & C# import Opportunity product list XML insert a opportunity
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. Thanks!!
6. How in outlook BCM 2007 & C# import Opportunity product list XML insert a opportunity
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 16 guest