CRM 4: Data migration tool: importing contacts with two addresses RRS feed

  • Question

  • I have tried to import contacts from csv files to CRM with data migration tool. It works without errors and address 2 of every contact goes to the CRM's database (customeraddressbase) but it does not show when I go to CRM and try to look at the contact and its "more addresses" information. Why the address is not there? Is there some special attribute that has to have some special value to get those second addresses to be shown in CRM?

    - Pauli
    Turku Polytechnic
    Friday, October 16, 2009 9:52 AM


All replies

  • Hi,
    The address2 is also in the contactbase not in more addresses. It's a little confusing with more addresses in CRM4.
    Please read this document https://community.dynamics.com/blogs/crmmattwittemann/comments/26160.aspx

    Dynamics CRM Blog: http://bovoweb.blogspot.com
    Friday, October 16, 2009 10:19 AM
  • Thanks! We don't have those address2-fields visible in contact's information so of course, I don't see those allthough they are in the DB. :) So the only solution seems to be to import those addresses on another import with data migration manager. Hopefully that works.

    - Pauli
    Turku Polytechnic
    Friday, October 16, 2009 10:33 AM
  • Now I have tried several times to import addresses from a different csv file. Information in csv includes full name, street 1, street 2, zip code and city. Full name (family name + first name) is mapped to "parent =>contact => Full name". Everything seems to work fine and conversion errors are okay (some persons are not in CRM because of earlier import problems) but after that the import itself gives upload errors like this:

    #,"File Name","Line No.","Description","Column Heading","Column Value","More Information"
    1,"Osoitteet_ajoon.csv","2","An error has occurred. Please see the log file for more information.","","","An unexpected error occurred."

    I understand that something has gone wrong in upload (don't know what) but I cannot find the error log anywhere. I have tried to find it under the DMM installation directory, all hard drives with search, event log, anywhere from CRM server etc. but I haven't found any log files anywhere.
    So, where should the log file be?
    Is the full name mapped to "parent => contact => full name" the right way to import more addresses?
    Should I use some extra attributes to get the import work?

    - Pauli
    Turku Polytechnic
    Monday, October 19, 2009 7:41 AM
  • Hi Pauli,
    I am unsure about the log file but I would strongly suggest you use unique numeric values to link your two records. Fullname would be a bad idea as you might have different contacts with the same name.

    Kind Regards,

    Monday, October 19, 2009 10:16 PM
  • Yes I know that but it is the only way because we don't have any individualized numbers (f.ex. social security numbers) in our source systems. Of course we could generate numbers to contacts before importing them to CRM but the number of contacts that have two or more addresses is quite small and also the number of contacts as a whole is not so big so it does not matter if we have to put some addresses manually.

    - Pauli
    Turku University of Applied Sciences
    Tuesday, October 20, 2009 4:52 AM
  • Look at row #2 in your file.  Something is wrong with that row.  There could be bad characters, extra comma, carriage return or something like that.  Look for a data anomolie. in that row of data.  Look under Settings, Data Management, Imports and find the Import Job.  Open the Import job and select failures from the left navigation menu to obtain more information about the error.
    Best Regards, Donna
    Wednesday, October 28, 2009 7:30 PM