Import data in ENUM

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rucrm
    Member
    • May 2016
    • 84

    Import data in ENUM


    help me please. ex. I have
    -NAME---TIP--
    name1 / tip1
    name2 / tip1
    name3 / tip2
    name4 / tip1
    I creat new object with field (NAME/VarChar) and (TIP/Enum). how i can import data in crm?
    If i import as text dont work group seach
    ru /Возможно ли импортировать данные в поле Enum не как текст, а именно значение enum.
    thank
    Last edited by rucrm; 01-18-2018, 07:35 PM.
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    In general enum field contains the set of keys and values
    In database is stored only keys.

    If your import file contains the key in column, but not the value - of course, you can import this column in enum field.
    But an import doesn't autofill the enum with opions

    Comment

    • rucrm
      Member
      • May 2016
      • 84

      #3

      maybe I can only import a list into the field? I checked if there is a value in enul that the filter of the imported data works

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        Originally posted by rucrm
        maybe I can only import a list into the field?
        What do you mean?
        Do you want multi-enum field (a several keys for the field in one record ) or you want to increase enum options, if it is in import, but not in current option list?

        Comment

        • rucrm
          Member
          • May 2016
          • 84

          #5
          I want to import only the keys and values ​​in the enum field. The second step is importing data into a custom object

          Comment

          • rucrm
            Member
            • May 2016
            • 84

            #6
            OK. in the database are stored only ID enum and where are the values enum ​​stored?
            I did not find the value enum in the database
            Last edited by rucrm; 01-20-2018, 03:24 PM.

            Comment

            • tanya
              Senior Member
              • Jun 2014
              • 4308

              #7
              The value of enum a translation, so you can find it in Administration > Layout Manager. At first set the needed language, after select the needed entity from the list, than 'options'.
              Find {Field} . {Key} and set the translation

              Comment

              Working...