Import data to CRM 3.0

kenl
kenl Member Posts: 182
edited 2006-11-05 in Dynamics CRM
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...)

:-k

Thanks.

Comments

  • Shenpen
    Shenpen Member Posts: 386
    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).
    Do It Yourself is they key. Standard code might work - your code surely works.
  • Tzapp
    Tzapp Member Posts: 1
    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?
  • borsicsj
    borsicsj Member Posts: 32
    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.

    Tzapp wrote:
    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?
    Brg,

    --
    János Borsics
  • kondi
    kondi Member Posts: 1
    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

Categories