[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

BCM to CRM 4.0 - how do I migrate the "old" data

Posted on 2008-06-15
9
Medium Priority
?
1,987 Views
Last Modified: 2013-11-24
Hi Gurus,

I installed a new CRM 4.0 Server and that part went really fine (when I got all the red exclamation marks from CRM-Installation away :))
Then I wanted to import the "old" BCM data in the new server. I started an export - I was happy to find a full export with history in BCM - I got a nice BCM file as result of the export.
The real problems started when I tried to reimport the BCM data in CRM 4.0 with the Data Migration Wizard:
1.) The wizard does not accept BCM files where all the infos are in.
2.) I lose the connection between account and contact when I use the csv files I can export from BCM

So I used the BCM file and made an .xml out of it (just renaming) - I imported the XML in MS Access to get the structure of the old data. Then I used the GUIDs from the XML and brought them back in the csv exported files from BCM (because in the XML file all emailadress were in a different table without GUIDs)
Finally I had a 2 nice files - one for accounts and one for contact in csv format. The import worked and I got almost all data in.

But how do I get the history and everything else in??? Emails, photos and all links to files are missing. How can MS make a big brother of BCM and forget the tools to let the little brother grow????

I hope someone can give me a solution!

Thanks in advance

0
Comment
Question by:Plastikboot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 9

Expert Comment

by:Biffster007
ID: 21789812
Hi,

There are a number of ways you can import data into CRM.

1) Using the import wzard which you've already done.
2) Use a third party product like Scribe Migrate or a tool from C360.
3) Write your own import assembly.  This is what I walways do and find it's definitely the most flexible way of doing it.

Cheers,
MH
0
 

Author Comment

by:Plastikboot
ID: 21789972
But how do I split the BCM and most important how do I import the compressed rich text?
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21789993
Hi,

You're going to have to extract the BCM data into a database of some description, SQL Server would be good, and run imports into CRM from there.  There is a 'Text' datatype in CRM which will hold your compressed rich text.

MH
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:Plastikboot
ID: 21793783
I really wanted to use the migration wizard but even when I use the text-field option I still get the compressed data in crm - so nothing is decompressed. Is there a way to use the import wizard??
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21797519
The import wizard is quite limited unfortunately, hence the reason I opt for writing my own assemblies.

By 'compressed' what do you actually mean??  Can you not extract into a CSV file and import from there??

MH
0
 

Author Comment

by:Plastikboot
ID: 21797613
Unfortunately not - it shows "Compressed Rich Text" as label and contains just hexadezimal data without spaces. I didn´t manage to get the contains decompressed yet - I tried Word, Excel and MS Access but no solution.
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 21797639
Hmmmm....

There must be a tool out there that allows you to decompress into fields of some kind??

Can you re-export the data and save into another format??

MH
0
 

Author Comment

by:Plastikboot
ID: 21797685
Nope - I will try to access the SQL database of BCM and reformat the data there. So no solution yet.
0
 
LVL 9

Accepted Solution

by:
Biffster007 earned 1500 total points
ID: 21797757
That's the best plan...Reformat the BCM data, then export into another format compatible with the import wzard, then import into CRM.

MH
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question