How to get Combine Data work with some of the attributes read-only? RRS feed

  • General discussion

  •     After we set permission of an attribute on an entity to read-only for a group of users, the users can no longer use the combine data button to bulk load data through the excel add-in. The error we get is something like "cannot use combine data because the excel sheet is protected".

        How do we get around it? We would like to let one group of users to add data to all attributes except the approval attribute, which is set to read-only. An approval group would be able to change the values in the approval attribute.

        We like the combine data in excel add-in because it has been proven much better than the error-prone copy/paste method, especially when the source sheets do not have the exact same number and order of columns as the MDS entity destination.

        We appeciate any suggestions to solve this problem.

    Friday, April 19, 2013 2:24 PM