Results 1 to 4 of 4

Thread: Farsi Data import issue in SugarCRM

  1. #1
    mryekhande@gmail.com Guest

    Default Farsi Data import issue in SugarCRM

    Hi,

    Whenever i import excel or csv containg farsi data into sugarcrm.then it imports but database saved data as '??????' chars.I have to avoid this chars.I check data on browsers by echo then it print as '?????'.


    Code: $this->_currentRow[$key] = str_replace(array("\r\n", "\n", "\r"),PHP_EOL,$value);

    echo $value;prints as '?????'

    How i stored farsi data into Mysql DB.

    Please help me,IT'S URGENT FOR ME....

    Thanks,
    Manish

  2. #2
    ibryas26 Guest

    Default Re: Farsi Data import issue in SugarCRM

    Hi,
    please try this :

    1. Do what ever cleaning in Excel 2010 and save to 2003/2007 .xls format.
    2. Open with OpenOffice or LibreOffice
    3. Save as .csv - Tick "Change filter" in the Saving program dialog and choose there charset and so on.
    4. In Notepad++ : "Convert to UTF-8 without BOM" + in file menu - Convert end of line (EOL) to UNIX format (no matter your system is)
    5. Set import options to UTF-8 in Sugar and in your own user settings.
    6. Import

    regards,

    Savage75

  3. #3
    casinobonus66 Guest

    Default Re: Farsi Data import issue in SugarCRM

    who r any post for this.....................

  4. #4
    mryekhande is offline Sugar Community Member
    Join Date
    Dec 2010
    Location
    Pune
    Posts
    12

    Default Re: Farsi Data import issue in SugarCRM

    Thanks,

    It works....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Farsi Data import issue in SugarCRM
    By mryekhande@gmail.com in forum Sugar Developer Website
    Replies: 1
    Last Post: 2013-03-22, 03:04 PM
  2. Import data from listhub to sugarcrm
    By PunctuationMark in forum Help
    Replies: 0
    Last Post: 2012-09-20, 07:18 AM
  3. SugarCRM 6.4 import parsing issue
    By Tostino in forum Help
    Replies: 1
    Last Post: 2012-02-22, 08:21 PM
  4. Replies: 0
    Last Post: 2012-02-22, 03:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •