Wed, 2023-09-27 16:00
IG
I know there is a report called Input data from excel that is able to create new models, their attributes and much more.
Unfortunately this is only for creating new ones and not for changing existing ones.
Is there any possibility to do something like:
Change process owner to Mr. Smith for 10 models
Ad I am not talking about the attribute wizard, because I want to have an excel filled out by users sent back and then changes can be uploaded!
Hello Ingo,
you can use the two reports Export and import attribute values for translation to update text attributes of existing objects in a round trip. As the report for import works on the whole database, you should have a backup.
Regards, Martin
You could bring the stuff you want filled in to a spreadsheet model and have the users edit the attributes you require. This feels very much like excel for the users, but they would need to have a designer licence, because editing of spreadsheet models is not (yet) possible in Connect. This is the no-code solution.
If you are comfortable coding and spinning Excel sheets, you also need to export the GUID of the objects people should edit, so your script reading the filled-in sheets can correlate the identity of the objects.
Another option are the translation reports. They export all text attributes to an Excel sheet with two columns for two different languages. If you "translate" to the same language you can use that to do a mass import of attribute values. An evaluation filter could limit the size of the output to some attributes you are really interested in. This pair of reports uses the GUIDs the way I described above.
Hi M.,
great. I'll tend to use the translation solution.
But the first one is also looking interesting. How can I get to this spreadsheet model view?
BR
Ingo
There are basically two ways, both work in ARIS Architect, one of them also in Designer:
1. Designer only: Create a new Spreadsheet model. Copy the models or objects you want into the spreadsheet in one column. Add column headers with attribute types and insert formulas into the attribute columns fetching the attribute values for the respective column. Then you can edit the attributes directly in the spreadsheet.
2. You build a query in Architect that creates a Spreadsheet result view. When you execute the query on a selection of objects or models (depending how you built the query), the spreadsheet result view (if you configured one for your query) is displayed and you can edit the attributes just the same as described above. Additionally you can persist your query result as a Spreadsheet model and thus appoint someone else to do the editing of the attributes.
That is the general idea. It takes a little learning to build queries, but then it is a strong tool.
Hi M.,
tried the translation report, but it is not extracting all attributes.
Any customizing which has to be done for the missing ones?
BR
Ingo
Found out that only language dependent attributes are extracted. Seeking to change that customizing
Okay, that is a reasonable restriction given the original intention of the report. You should be able to duplicate the reports and lift that restriction, if you know your way aroung JavaScript and the documented ARIS API