locked
Importing Notes field with New Line chars using DMM 4.0 RRS feed

  • Question

  • Dear All,
                   
    The Source CSV file has Notes field with New Line characters and Commas in the data.Thus, when we import the data from the CSV file, the field delimiters get misplaced and the data loses its format.A sample record of my data looks like shown below. When we try to import. The data migration manager throws error. I am using CRM 4.0 and DMM 4.0. I appreciate any help on this issue.

    Regarding                                                   Is Document     Description                                                 Title
    CA543E5F-7555-6D11-874E-001641D83D08    yes                  10/20/2008, agree 9/12/2008 hide!                  Test Notes
                                                                                               In development 8/14/2008 "approved" by
                                                                                               Jim'neil to contact Andrew 6/12/2008 Nexcom:

    in developing stage, John to make intro

    Regards
    Sudhakar
    Wednesday, December 31, 2008 5:51 PM

All replies

  • You have to clean up the source file.  You can replace commas with spaces but you also need to remove carriage returns.

     

    Wednesday, December 31, 2008 6:50 PM
  • Hi Guys

     

    I had this same issue a few weeks back with a data migration for a customer and i found that excel has a substitute function.

     

    The following site gives step by step on how to remove all ASCII characters that you do not wish to have and it works very well.

     

    http://www.techonthenet.com/excel/questions/remove_chars.php

     

    Hope that helps

     

    Allan

     

    http://allanvirtualitbiz.blogspot.com/

     

    Monday, January 5, 2009 1:48 PM
  • Hi Donna Edwards,

                                Thankx and sorry for delayed reply. But, when i replace all the spaces, commas and carriage returns, the text loses its whole format. I am looking for a way to import the Notes with the same format as i have displayed in my sample as thats the requirement. And as i have the field delimiter as commas in the source file, when i replace the commas, the data gets collapsed. My exact requirement is to upload data to the Opportunity Entity Notes field with multiple lines.

     

    Regards

    Sudhakar.

                 

    Tuesday, January 6, 2009 5:32 PM
  • Hi Allan Connolly,

                            Thankx and sorry for delayed reply.I have tried already with removing all the commas, New Line chars and white spaces. But even when there is no new line chars in a cell, when we try to import a notes field with some 1500 chars of data, the Data Migration Manager(DMM) preview shows a single cell data in the next line and it throws error. And as i am using the field delimiter as commas in the source CSV file, when we remove commas, the data loses its format.

     

    Thanks & Regards

    Sudhakar

    Tuesday, January 6, 2009 5:52 PM
  • Hi Sudhakar

     

    Im sorry that it did not work for you... however what is the exact error message that the DMM is throwing up?

     

    cheers

     

    Allan

     

    http://allanvirtualitbiz.blogspot.com

     

    Wednesday, January 7, 2009 10:13 AM
  • Hi Sudhakar,

    I had a the same problem as  you.
     
    See if this helps  http://jamie-rorrison.blogspot.com/2008/08/dynamic-crm-40-data-migration-manager.html




    Wednesday, January 7, 2009 12:00 PM
  • If you are not able to get the source data in the format needed then you may want to look at a tool called Scribe.  It is fairly inexpensive and will most likely be able to get the job done.  Check out www.scribesoft.com and look at their integration tool for Dynamics CRM.  Another option is to review the SDK and see if you can create a Web service to move the data into CRM.  Here is a link to the SDK  http://www.microsoft.com/downloads/details.aspx?FamilyID=82E632A7-FAF9-41E0-8EC1-A2662AAE9DFB&displaylang=en

     

     

    I think these tools may prove to be a good fit for your situation.

    Wednesday, January 7, 2009 1:14 PM