Results 1 to 2 of 2

Thread: Impossible to import contacts - pb on 'salutation'

  1. #1
    TestSugar1 is offline Senior Member
    Join Date
    Mar 2009
    Posts
    31

    Question Impossible to import contacts - pb on 'salutation'

    Hello,

    I have a problem when I try to import my contacts (6500) in SugarCRM. I'm using the French version.

    I import a file in which the salutations are M., Mme, Melle, or where the field is empty. These values correspond to the values allowed in Sugar.

    Problem: when I import these data, only the 28 contacts in which the salutation is empty are created, and the remaining ones are rejected...
    In the error file at the end of the import (error_1.csv), I have almost 6500 lignes of that kind:
    Clé absente dans la liste. Les valeurs possibles sont: ,M.,Mlle,Mme,Dr.,Prof.,"LBL_SALUTATION (salutation)",M.,1

    (which means)
    Key absent from the list. The possible values are ,M.,Mlle,Mme,Dr.,Prof.,"LBL_SALUTATION (salutation)",M.,1

    It seems to be a bug in Sugar translation... I saw this thread on the forum: http://www.sugarcrm.com/forums/showt...ght=salutation but the only solution seemed to translate the salutations into English before importing... Do you know if this bug was fixed?

    Thanks for your help

    EDIT : I'm using Sugar CE 5.2.0a version.

  2. #2
    TestSugar1 is offline Senior Member
    Join Date
    Mar 2009
    Posts
    31

    Question Re: Impossible to import contacts - pb on 'salutation'

    Hello,

    I got an answer for the above problem: before the 5.0.2b version, you have to use the 'key' (not the 'label') of the field to import it. Then I have to translate my French salutations (M., Mme, Melle) into English (Mr., Mrs., Ms.) before importing my contact data.

    Now I have another problem...

    I created 2 fields in Sugar : the hierarchical level and the departement of the contact. They are created as 'dropdown lists'.

    When I try to import my contacts file (around 6500 contacts), the import fails, and I get a big error message on the import page, containing lines of this kind:


    NOTICE: [8] Undefined index: LBL_ERROR_INVALID_MULTIENUM on line 328 in file C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm\modules\Import\views\view.s tep4.php
    NOTICE: [8] Array to string conversion on line 231 in file C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm\modules\Import\ImportFile.p hp
    NOTICE: [8] Array to string conversion on line 329 in file C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm\modules\Import\ImportFieldS anitize.php
    WARNING: [2] Illegal offset type in isset or empty on line 209 in file C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm\modules\Import\ImportFieldS anitize.php
    NOTICE: [8] Array to string conversion on line 231 in file C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm\modules\Import\ImportFile.p hp


    Do you know what this means? I went to look at those php files, but I didn't understand what the problem was.

    - I tried the import without my 2 added fiels, and it works.
    - I tried the import without 1 of the 2 fields (one after the other), and it fails each time...

    Do you know how I can make the import work?
    Thanks for your help.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 2009-03-23, 10:54 AM
  2. Import Affaires impossible
    By PasGlop in forum Français
    Replies: 2
    Last Post: 2008-11-10, 10:14 AM
  3. Replies: 1
    Last Post: 2008-09-30, 12:00 PM
  4. Salutation field in contacts
    By hheckner in forum General Discussion
    Replies: 0
    Last Post: 2006-09-22, 10:09 AM
  5. Impossible to import Accounts
    By juanjo in forum Help
    Replies: 6
    Last Post: 2006-02-21, 09:41 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
  •