Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 Online French names displayed wrongly with � char RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a Canadian organization online, just with English language.  All French names are displayed wrongly , as in "H�pital" instead of "Hôpital" .

    Test environment had the same settings and Frnch Chars were displayed properly. Any suggestion whatis the problem?

    Thnak you in advance

    Nicoleta

    Nicolette
    Monday, May 2, 2011 7:01 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    The way which works for me is to use a unicode-compliant tab delimited txt file (it is another option on the Save As... list for Excel). You will need to adjust the delimiting settings in the Wizard but it will work without a problem. I have used this to import data in Chinese, Japanese and Korean into CRM without problems.

     

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Friday, May 6, 2011 11:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I found this article which explains how to save the file in Unicode:

    The trick to getting around this problem is to save the CSV file in Unicode (32-bit, Universal character set) format before you import it with CRM’s Import Data Wizard.

    • From Excel, choose Save As then save the file as CSV.
    • Open the CSV file in notepad then do a “Save As”
    • In the Save As dialogue, you will see a picklist labelled “Encoding” that defaults to ANSI (8-bit)
    • Change the Encoding to Unicode, change Save as type to “All Files” then click Save

    http://thecrmarchitect.com/2010/02/23/crm_import_data_language/

    many thanks Leon!

     

    Nicolette
    Tuesday, May 3, 2011 6:27 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Did you install the language pack (MUI) for CRM?

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=db44c564-2338-407e-980a-c9c83ad37729

     

    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Monday, May 2, 2011 8:39 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    No, I didn't install it. I don't plan to use the French language, just some of the names have those chars.

    And, as I mentioned, test env had the same settings (only English), but imported records displayed properly. Do I still need to install it, and why? Thank you

    Nicolette
    Monday, May 2, 2011 9:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    So does the dev system have the problem system have the correct fonts installed?
    Jamie Miley
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!
    Monday, May 2, 2011 9:39 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jamie,

    Thank you for helping. Did I mention this is 2011 Online? All languages are already available for me to enable. Test env was Online as well.  all records were imported via Import Wizard in both cases.

    My only solution so far is to copy the right char and paste it for each record with problems. thank you

    Nicolette
    Monday, May 2, 2011 9:52 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    If you can paste in the correct character and it works, it does not sound like a display issue but rather a data import issue. Did you use CSV files to transfer the data from test to production as these are not unicode compliant and would potentially cause problems for accented charaters.

    Leon Tribe

    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 Tuesday, May 3, 2011 7:07 AM
    Tuesday, May 3, 2011 7:07 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    That's righ Leon, I used CSV files to import data. I had an Excel file which I converted to CSV. Thsi is the only way I know of importing data into Online. What  would you recommend ?

    Thank you

    Nicolette
    Tuesday, May 3, 2011 6:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I found this article which explains how to save the file in Unicode:

    The trick to getting around this problem is to save the CSV file in Unicode (32-bit, Universal character set) format before you import it with CRM’s Import Data Wizard.

    • From Excel, choose Save As then save the file as CSV.
    • Open the CSV file in notepad then do a “Save As”
    • In the Save As dialogue, you will see a picklist labelled “Encoding” that defaults to ANSI (8-bit)
    • Change the Encoding to Unicode, change Save as type to “All Files” then click Save

    http://thecrmarchitect.com/2010/02/23/crm_import_data_language/

    many thanks Leon!

     

    Nicolette
    Tuesday, May 3, 2011 6:27 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    The way which works for me is to use a unicode-compliant tab delimited txt file (it is another option on the Save As... list for Excel). You will need to adjust the delimiting settings in the Wizard but it will work without a problem. I have used this to import data in Chinese, Japanese and Korean into CRM without problems.

     

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Friday, May 6, 2011 11:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you for your replies, Leon. I will try it next time.
    Nicolette
    Saturday, May 7, 2011 12:41 PM