Results 1 to 6 of 6

Thread: Import Blank Multiselect from CSV Error

  1. #1
    molson150 is offline Sugar Community Member
    Join Date
    Jul 2007
    Posts
    22

    Default Import Blank Multiselect from CSV Error

    When I try and Import a CSV file everything works fine with all the multiselects filled out. But when I have a blank multiselect in my CSV I get an error.

    So to check I did an export in a different module and the export has some blank multiselects so they are allowed.

    The only workaround I have to to create a dummy field in my mutliselect then delete it later but that is a very poor workaround.

    The error I get is:
    NOTICE: [8] Array to string conversion on line 231 in file sugarcrm\modules\Import\ImportFile.php

    Sugar 5.2d CE
    xampp 1.6.5
    PHP 5.2.5

    Thanks

  2. #2
    crmsiva's Avatar
    crmsiva is offline A Sugar Hero
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    1,130

    Default Re: Import Blank Multiselect from CSV Error

    Hi

    For multiselect fields, data should be in below format

    value1^,^value2^,^value3

    BTW, which version of sugar you are using?

  3. #3
    molson150 is offline Sugar Community Member
    Join Date
    Jul 2007
    Posts
    22

    Default Re: Import Blank Multiselect from CSV Error

    I can get sugar to import when there is data for the multiselect. The problem is when I don't want anything selected in the multiselect the csv field the represents the mutliselect is blank and that is the error.

    Sugar CE 5.2d

    Thanks

  4. #4
    crmsiva's Avatar
    crmsiva is offline A Sugar Hero
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    1,130

    Default Re: Import Blank Multiselect from CSV Error

    Try adding a blank entry to the drop down options and check the import

  5. #5
    molson150 is offline Sugar Community Member
    Join Date
    Jul 2007
    Posts
    22

    Default Re: Import Blank Multiselect from CSV Error

    It is a multiselect and on a multiselect the blank option is not selecting any.

    Thanks,
    Jeremy

  6. #6
    molson150 is offline Sugar Community Member
    Join Date
    Jul 2007
    Posts
    22

    Default Re: Import Blank Multiselect from CSV Error

    I realized what you were saying after the reply.

    Adding a blank field to the dropdown fixed it thanks

    Jeremy

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Import multiselect error
    By Amadeus7 in forum Help
    Replies: 5
    Last Post: 2009-02-11, 08:18 AM
  2. Import values in a Multiselect field
    By pitchalov in forum Help
    Replies: 3
    Last Post: 2008-07-10, 05:35 PM
  3. Email import blank messages
    By rfenn in forum Help
    Replies: 1
    Last Post: 2008-02-07, 03:56 AM
  4. Import Target Email blank
    By acherwinski in forum Help
    Replies: 1
    Last Post: 2008-01-22, 05:09 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
  •