Help - Creating Groups / Folders in ARIS Database from Excel

AB

Aswin Bhojarajan on February 9, 2010

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

Tags: #script; #excel

Sign in or register to reply.

Notify Moderator

3 Replies

Yves Vanhoebroek on February 10, 2010

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.

Like

Sign in
or register to reply.

Notify Moderator
Rupesh Shrestha on February 15, 2010

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

Like

Sign in
or register to reply.

Notify Moderator
AB

Aswin Bhojarajan on February 26, 2010

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

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.

Sign in

Reset Password