Help - Creating Groups / Folders in ARIS Database from Excel Translate this page Printer-friendly version bookmark or share this page
Aswin's picture

Posted: 2010-02-09
219 views | 3 comments | category: ARIS Support

0
show all articles

 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

Comments
Yves's picture

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.

 

Rupesh's picture

Aswin,

Yes, it is possible to create the groups you have specified belwo using the input in the excel file. In the Database class there is a method to create group. You can also pass the name of the group from the excel file.

We have implemented several flavours of creating and managing groups via ARIS scripts. It is definitely possible.

Regards,

Rupesh

Aswin's picture

 Hi Rupesh,

                     I'm talking about ARIS Groups (folders) not User Groups.

I couldnt find a method to create groups in Database Class :(

I finally managed to create them using the CreateChildGroup(string,g_nloc)

function from Groups.

Thank you, all, for your help.

Aswin