Hi all, I was not aware of this channel. First tim...
# csvimports
e
Hi all, I was not aware of this channel. First time posting here: I have a custom record that has associated a contact and items, additional the custom record only has a name as mandatory field. The items source a multiselect field, I'm using pipe | symbol to separate the items the following works for creating a new instance of my custom record:
items, contact , name
id1 | id2 | id3, customer name : contact name , custom record name
A very similar CSV for update is throwing me an error that the item internal id is invalid. Invalid items reference key "21743". Is there any special trick for multi select fields sourcing from items?
m
Do you have spaces between your pipes and values?
Also lookup that internal id for items. Is the item marked inactive?
e
I have tried with and without spaces, the items I have tried are active. I have even just tried with a single item, enclosing this on double quotes, many things, I have double checked the encoding of the file since it was an issue for the creation. I'm not sure what is this expected for the update, since the create works well.
Oh, I just tried omitting the items multiselect field and then the import says success.
m
Do you have any filters on the field level settings?
what role are you in when you are doing the import?
do you have subsidiaries and does the subsidiary of the items match your role?
e
No filters, I have reviewed, I'm admin and yes, the account has subsidiaries, I'm wondering if that might be blocking me in any way.
k
look at your first line, there is a space between coma and "contact", also same space on the second line after "name". I do not think there should be spaces there
e
Thanks guys for your suggestions. I was using 2 saved imports that someone else did and the create was working fine. I do not usually perform CSV uploads but after researching a little more, I found out that on the Field Mapping step, you can click on the edit icon/button next to your fields and for multiselect fields you need to select 'internal id', the default value is 'name' so, it makes totally sense why it was failing.
👍 1