locked
Culture format problem while importing RRS feed

  • Question

  • Hi all,
    I'm importing records using excel into CRM which contains CRM Money CRM Decimal , CRm number fields.
    When I import it using en-US format of CRM it imports successfully,
    but when Chnage the CRM format to da-DK its gives the exception, due to (,) and (.) in number fields.

    Any Solution how to do it?
    Dare to promise
    Monday, August 10, 2009 12:12 PM

Answers

  • Sorry I thought you were using the import wizard.

    Regardless, it is probably the commas causing grief. You may need to put quotes around the fields to prevent confusion or even convert the currency fields prior to import.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    http://leontribe.blogspot.com/
    or hear me tweet @leontribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Sunday, August 16, 2009 8:17 PM

All replies

  • I'm guessing its the commas confusing the CSV format. Try saving the source file as a tab-seperated text file instead of a CSV.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    http://leontribe.blogspot.com/
    or hear me tweet @leontribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Monday, August 10, 2009 9:16 PM
    Monday, August 10, 2009 9:15 PM
  • HI leon
    My Requirement is csv file only. I cant change it.
    is there any way in code?

    Dare to promise
    Tuesday, August 11, 2009 5:19 AM
  • Any manipulations on files can be done easily with this great library: http://www.filehelpers.com/ 
    Tuesday, August 11, 2009 7:15 AM
  • Sorry I thought you were using the import wizard.

    Regardless, it is probably the commas causing grief. You may need to put quotes around the fields to prevent confusion or even convert the currency fields prior to import.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    http://leontribe.blogspot.com/
    or hear me tweet @leontribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Sunday, August 16, 2009 8:17 PM