Hi,
We need to create, a group hierarchy in the ARIS Database, from an excel sheet.
(Say )
Level 1(group)
Level 2(group)
Level 3(group)...
And we are new to Scripting in ARIS so i'm not sure if it can be done.
Please help.
I've managed to create a Report that reads the sheet using Excel Reader,
and a Macro that creates groups using Explorer.createGroup()
The problem is...that Context differs in a macro and a report.
I couldnt use the Explorer class in a reports
or find the excel reader in macros.
Is there a way to create groups in Reports or to read excel sheets (either in Common Files or on your local
system - preferably) in Macros.
Aswin
Yves Vanhoebroek on
Dear Aswin,
It should be possible via an xml-file. I know that IDS Scheer Belgium developed for us a script that uploaded data from a well structered excel-file (that served as a template if you like). The trick was that the script read an xml-file where the translation was made between the information in excel and the result in ABD. It is even possible to create the model with the objects, attributes and assignments to other models, using that technique.