locked
Pasting "Name" instead of code for Domain-based attributes in Excel Addin RRS feed

  • Question

  • It seems like it is a restriction by design, that I'm not able to paste names into an attribute of an entity when it is a domain based attribute. Now, the reason why we will like to be able to do that is that we would like the key of domain attributes to have auto incremental codes generated (dummy keys), but then the user who want to paste the data from his spreadsheet does not know the (internal dummy) code.

    So my questions are :

    1) any chance that I can make the Addin paste names into domain attributes (that would be nice)

    2) recommendation for pasting (related) data. Should I make the user have the domain based attributes on another sheet and use vlookup when preparing the "paste dataset"

    3) Other tricks for the end user to easily paste cross entity data in to MDS

    Thanks in advance

    Stig

    Thursday, October 31, 2013 8:57 PM

Answers

  • Hi Stig,

    It is not possible to use "Name" for domain based attribute because by default, the "Name" attribute is not a unique field.

    The only option I think of is using vlookup as you suggested.

    Cheers,

    Guillaume

    Wednesday, November 6, 2013 6:14 AM

All replies

  • Hi Stig,

    It is not possible to use "Name" for domain based attribute because by default, the "Name" attribute is not a unique field.

    The only option I think of is using vlookup as you suggested.

    Cheers,

    Guillaume

    Wednesday, November 6, 2013 6:14 AM
  • Thanks Guillaume.

    Thursday, November 7, 2013 9:24 PM