SuiteCRM 8 Multi-Select Picklist challenge

đź’¬ General Discussion
1

Hi,

I have SuiteCRM 8.8.0 installed on hosted platform. It was installed using Softaculous and appears to be working fine.

I’m porting data from a Salesforce instance which is mostly going well.

I’m adding entries to a multi-select list and experiencing a challenge.

I’ve created a multi-select field and added the following:

Name: fka_activities_attended_c_list
Language:
English (US)
List Items:
Item Name[Display Label]
I4PL_2017_High_Performance_Learning_Organization [I4PL 2017 – High-Performance Learning Organization]

When I then import Contacts from Salesforce, I get errors that some weren’t added because the item didn’t match an entry in the list.

The error report shows I’m trying to import “I4PL 2017 – High-Performance Learning Organization”, which is correct, but the accepted list options shows “I4PL 2017 – High-Performance Learning Organization” not what I entered to create the field.

Somehow what I’ve entered into SuiteCRM looks ok when I look at the field list entries, but isn’t matching during the import.

It is happening with about 6 of 20 of the list entries. The - is being converted for some reason, but is fine in the rest of the entries.

Any thoughts on what is causing this?

Thanks,

…Dave

2

Looks like you have weird character between the words. I think it uses UTF-8.

You can check that in settings. Also, check in your php.ini file.

3

Check the encoding of your import text file, and I believe when importing you can also specify the encoding (though I’m not sure if my memory is confusing SuiteCRM with another software regarding this)

4

Thanks.

The issue doesn’t appear to be with the importing but with creating the list item.

I was able to sort it out by removing the spaces around the dash for those items in the list item and the import and they are working now.

…Dave