`The value "Contact Mechanisms/Type" for field "Type" in "Contact Mechanism" is not one of the allowed options.` during import csv file

Support User
1

Hello ,

I want to import data reliant to the party. I have used the csv file.
So i created a csv file contain the “Name”, and the “email” which is the “type of the contact mechanism” of each party “Name” field.

This is how i had put the data on the csv file:

image

and those are the fields selected on the party:

image

The error displayed:

The value “Contact Mechanisms/Type” for field “Type” in “Contact Mechanism” is not one of the allowed options.

what does mean this error ? and how i can correctly import data and specially the email (contact mechanism) for each name party.

Thanks in advance.

2

In the latest 6.2 series you can use directly the “Email” field in party which avoids the need of using the Contact Mechanism relation. If you are on such version, I will recomend using this fiel as it will make everything simpler.

3

I made the test on demo using same data and it is working. So I suspect that you have some character that makes the “Type” value not really “email”. Looking at the screenshot, it looks like there is a space between “email” and “,”. (This is one more reason to not use screenshot but text).

4

It looks like you are trying to import the first line (containing the headers) as a party.

Make sure that the “Lines to Skip” in the CSV parameters is set to 1 not 0.

1 Like
5

Thanks M.@pokoli, M.@ced and M.@dave Now the error gone.

I have just delete the first line(Name,Contact Mechanisms/Type,Contact Mechanisms/Value)

-I have another question related to this thread subject ;
I want to add both website and email for every party name so I have choosen type and value 2 times

image

and I have written the csv like that :

website,http://websiteurl.com,email,testeurde@gmail.com,Mario Alvares

the result was that Just the email was entered with ignoring the type and the value of the website:

image

My question is what I should choose on the “Fields selected” to import both website url and the email .

Thanks again.

6

Indeed you can not duplicate the same column because in this case only the last value of the line will be used.
To fill multiple values for a One2Many, you must create a second line with all columns empty except the one for the One2Many.

But as @pokoli suggested on 6.2 series there are fields for each type of contact mechanism directly on the party to ease such operations.

1 Like