locked
Export / Import Data using the UNID. RRS feed

  • Question

  • Hi

    We are trying to import our contacts and assign to the relevant Accounts using the UNID, however when I export this column from CRM it is with {}.  Is there a way this can be removed before we export?  as we are only able to successfully import without the brackets.
    many thanks
    Wednesday, August 19, 2009 2:27 PM

Answers

  • Hi,

    sorry, there is no was in the standard dynamic excel-export to export the guid without the {} signs.
    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    Wednesday, August 19, 2009 4:45 PM
  • Michael is correct, you can not export without the brackets.  A workaround is to use the Replace feature in Excel to replac the { and } with a delete.  This should be fairly quick.  The other option is to exctract the data from SQL using a SQL query and then copy it into Excel and save it as a csv file for importing.  If you use SQL, ensure your column headings match exactly to the Display label of the CRM field.
    Best Regards, Donna
    Thursday, August 20, 2009 3:41 PM

All replies

  • Hi,

    sorry, there is no was in the standard dynamic excel-export to export the guid without the {} signs.
    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    Wednesday, August 19, 2009 4:45 PM
  • Michael is correct, you can not export without the brackets.  A workaround is to use the Replace feature in Excel to replac the { and } with a delete.  This should be fairly quick.  The other option is to exctract the data from SQL using a SQL query and then copy it into Excel and save it as a csv file for importing.  If you use SQL, ensure your column headings match exactly to the Display label of the CRM field.
    Best Regards, Donna
    Thursday, August 20, 2009 3:41 PM
  • Thank you for your replies however if you have to export with the brackets why is it that you cannot then import with brackets?

    many thanks
    Monday, August 24, 2009 10:06 AM