Format In Importing Multi Enum Fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nkutlug
    Junior Member
    • Dec 2023
    • 17

    Format In Importing Multi Enum Fields

    Hi All,

    I am trying to import data into Contacts. I have created a multi enum field with 6 options. I keep receiving validation errors for that field. When importing the corresponding data I have tried the formats below:

    option 1, option5, option6

    "option 1", "option5", "option6"

    Both did not work. I am checking the data versus the options' values and I do not see any discrepancies.

    Any assistance will be of great value.

    Thanks and cheers,
    Neşet


  • victor
    Active Community Member
    • Aug 2022
    • 755

    #2
    nkutlug,

    Code:
    ["option 1","option5","option6"]
    For the future, to know exactly which format to use for a certain type of field, first export the record where this field is filled.

    Click image for larger version  Name:	image.png Views:	0 Size:	1.6 KB ID:	101051

    Comment

    • nkutlug
      Junior Member
      • Dec 2023
      • 17

      #3
      Thank you very mush victor.

      I have tried ["option 1","option5","option6"] without success. Still validation error.

      Then, as you have suggested I have exported a record where the multi enum field is filled. I get the following result on the csv file:

      "[""option 1"",""option5"",""option6""]"

      However, when I format the data similar to this exported one just to test, I still get a validation error.

      Any further suggestions will be more than welcomed.

      Comment

      • nkutlug
        Junior Member
        • Dec 2023
        • 17

        #4
        Dear victor, I am sorry it was a typing difference between my data and the field values. It is working.

        Many thanks.

        Comment

        Working...