Updating Object-Attributes in Bulk from Excel-Input

Hi,

There is potentially another way using spreadsheets; but this depends on the number of definition copies you need to update. I believe the number of lines in a spreadsheet is somewhat limited. But you could use the if formula in combination with the write formula in spreadsheets. I've done that in the past for smaller changes and it worked well.

However, if you have bigger data sets, I would use a custom script which allows you to be also more flexible.

Alternatively, (I assume people fill out an Excel spreadsheet with the data that you want to import) people (who have a viewer license) could also be granted with contribution rights and directly enter the "new" values in the tool; this is how we are doing it today and it is by far our preferred approach.

Hope I was able to give you some additional brain food :D

Best,

Veronika  

Thank you so much Veronika!

This was the hint I needed!

I actually never worked with spreadsheets in ARIS before, but thanks to the Excel-resemblence, I think I'll manage! There is still a struggle with the limited number of lines in spreadsheets (255) - so for some objects I'll need 5 tables, but still this will be manageable for the time being. I already ran some tests and think that this might be the solution we need.

We'll get the data as Excel-Exports from other Databases so there's actually no user interference here and the idea with contribution rights alas is not applicable in our case.

The script-idea is one for the long run (and one I need to do some research for), but for now we just needed a quick solution for some trials.

Thanks again and have a nice day!
Sonja

Hi, 

ARIS also provides a REST API. So if you invest a little in external scripting you might eliminate the human interface and save some people very dull work.

Hi!

Thank you! This is definitly in the planning for the long run!