mibuso.com

I am new to CRM.

I need to import data to CRM 3.0
But the Import function only allow us to import account, contact, lead, and campaign. Can we import other table? (Like product, Competitor, Order, Invoice...)



Thanks.

Sure. Check out the Data Migration Framework and the Common Data Format database by searching on Microsoft. Beware that data migration is one-way - you cannot later modify the data. Better to do a test migration to a test database and then move data with Redeployment Tool (also on Microsoft).

Hello!
I have some problems with CRM 3.0 Data Migration Framework. I've created CDF database and import my data (from Access) to it.
I'm trying to migrate only one entity - Account.
In cdf_Account table(about 1000 entries), I've filled that fields: AccountId(integer 1,2...), Name, Telephone1, OwningUserName (in the format domain\logonname). After that i used CDF Data Mapping Wizard, that filled OwnerUser field. And then I start CDF Migration Wizard, check Account entity. But it doesn't process any records.

Log:
19.05.2006 - 14:18:31 -- CDF Entity Migration Order: Account
19.05.2006 - 14:18:31 -- The CDF Migration Wizard is initializing. This may take several minutes.

19.05.2006 - 14:18:38 -- Processing entity: Account
19.05.2006 - 14:18:38 -- Starting migration phase
19.05.2006 - 14:18:38 -- Test Batch Count = 0
19.05.2006 - 14:18:39 -- Migration phase completed
19.05.2006 - 14:18:39 -- Processing entity: Account
19.05.2006 - 14:18:39 -- Starting update phase
19.05.2006 - 14:18:39 -- Update phase completed

Anybody can tell, why CDF Migration Wizard doesn't work properly?

Hello!

If you used DTS package to load data into the cdf_Account table you should turn off the Use fast load option on the Options page. This is the typical problem of the DMF.

Hello,

I have tried to look for some answers to a problem which makes our lives really ugly when trying to import data in CRM 3.0

We succeeded to create a CDF database and to populate it with the data we have in the .xls files. The major problem is when we try to migrate the
data from the cdf database into the actual crm database using CDF
migration wizard.
You can see bellow the log generated by the wizard and i also have a screen shot with the actual results, if you want me to send it over.

I would apprreciate your input regarding this matter considering that we
are stucked with this implemantation.
thank you very much ,
best regards

CDF Entity Migration Order: Product
The CDF Migration Wizard is initializing. This may take several minutes.
Processing entity: Product
Starting migration phase
Test Batch Count = 10
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>105000.0000</price><productnumber>Adl/01/009/0016</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>55</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>99000.0000</price><productnumber>Adl/01/009/0015</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>158</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>105000.0000</price><productnumber>Adl/01/009/0014</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>55</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>95000.0000</price><productnumber>Adl/01/009/0013</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>105</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>105000.0000</price><productnumber>Adl/01/009/0012</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>55</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>95000.0000</price><productnumber>Adl/01/009/0011</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>105</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>105000.0000</price><productnumber>Adl/01/009/0010</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>55</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>95000.0000</price><productnumber>Adl/01/009/0009</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>105</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>105000.0000</price><productnumber>Adl/01/009/0008</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>55</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Creating object
Failed to migrate object:
<product><iskit>0</iskit><price>95000.0000</price><productnumber>Adl/01/009/0007</productnumber><quantitydecimal>2</quantitydecimal><new_arealand>105</new_arealand><new_buildingtype>1</new_buildingtype></product>
Recording migration status
Migration phase completed
Processing entity: Product
Starting update phase
Update phase completed