Changing an attribute from single value to multi value

Are there any issues or are you allowed to change an existing attribute that has been used from a single value attribute to a multi value attribute?  Thanks for your help in advance.

Alex Talbott

  • Hello Alex,

    You can select multi value attribute  from "multi value" column by expanding attribute topic.

    In Director Go to System admin, Expand Information Modeling > Classes and Attributes > Select Object and expand attributes topic

    ~ Priyanka



  • I think this failed when I attempted it, as single value attributes are stored in db table called char_data and multi values are stored in a different table called char_data_mv
  • Andy is right, it's not possible
    Alex is that documents attributes you are refering to and do you have Documents with change controll? I need to know as there might be a workaround for this.



  • No it is a Project attribute but I would like to know the answer for both Document attributes and Project attributes.
  • Hello,
    In theory there is a way that should work for both objects.
    Steps needs to be taken:
    1) Create reports to retrieve attribute value and main information on object it’s related to using custom eQL report (Object code, middle, revision)

    START WITH Document
    SELECT
    Code,
    Middle,
    Revision,
    Attributes["Global", "XXX"].Value
    WHERE
    Attributes["Global", "XXX"].Value IS NOT NULL

    START WITH Project
    SELECT
    Code,
    Attributes["Global", "XXX"].Value
    WHERE
    Attributes["Global", "XXX"].Value IS NOT NULL

    2) Run report and export result to excel using ‘Download All Results’ as we will need this data later
    3) Retrieved results also move to Basket (better clear basket before doing taking this step)
    4) In Basket using Action>Bulk update feature hide this attribute by taking of view permissions for everyone.
    5) In Director rename this attribute
    6) In Director Create new attribute using old attributes name (create it as multi value)
    7) After taking all these steps now we need to import old values for this new attribute. This can be done by using Provisioning spreadsheet. Fill in data from step 2 to Provisioning spreadsheet.

    Note:
    a) Document type = 3, Project type = 9 (information required in provisioning spreadsheet for attribute import)
    b) new attribute must be assigned to templates and synced as in web it might won’t be visible for edit if value will not exist.

    Let me know if I missed something.