CW

Hi,

I have 250 Information Carrier objects for which I have created a specific attribute (text). Now, the content to be filled into this attribute is placed in Excel.

How can I transfer this?

Thanks!

by Rick Bosworth
Posted on Tue, 11/17/2009 - 17:16

Carsten,

There are a couple of ways to do this. You can copy and paste from excel directly into the Attribute editor in ARIS. This is quick and easy and works well for a relatively small number of objects. 250 may be pushing the limits a little although you could break it into several smaller groups. Basically you just multi-select the objects you want to update and open the attribtue editor for them. You will get the standard Attribute Editor window but there will now be one column per object. You can go to excel and copy a selection of columns and rows and paste them into the grid. Click OK and then save changes and you are done

You can also use the Process Generator macro. You can invoke this by selecting the objects you wish update attributes for and right-clicking and  select Evaluate -> Start Macros from the pop-up menu. There should be a choice of Open Excel Table in Process Generator. The help facility in the Process Generator excel toolbar explains the process of using Process Generator. You will need to copy and paste the data from your spreadsheet into the Process Generator SS before upadting ARIS.

The above comments are in regards to ARIS 7.1, in previous versions Process Generator was run as a report rather than a macro.

Rick

0
by Carsten Wolff Author
Posted on Wed, 11/18/2009 - 13:58

Hi Rick,

thank you - I am using the Attribute Editor.

So now I converted my column in excel to a row. And I shoudl be able to paste now.

But for some reason, the order in which the objects are listed in the attribute editor is not alphabetical. That is a problem for me. Even if I order it by name first - when i right-click and go into the editor they are not alphabetical.

Do you know a way?

Thanks again

0
by Carsten Wolff Author
Posted on Wed, 11/18/2009 - 14:08

Now I used the Excell Process Generator - great tool. It worked perfectly.

Thanks!

0
by Rick Bosworth
Posted on Wed, 11/18/2009 - 18:19

Carsten,

I played around a little and it seems that if you select the objects in a model and invoke the editor they show up a random order. If you select them from Explorer or from a Find result set they appear to come up alphabetically. No guarantee that this is always the case, but that is the way it worked on several tests I tried.

I'm glad that Process Generator worked for you.

Rick

0
by Kris Nunes
Posted on Thu, 11/19/2009 - 18:14

The Process Generator tool is a great way to fill attributes in a collaborative environment. Like mentioned before, it is order of the context from which the macro is executed. If you do a sort based on name on the find panel, and run the macro, the ojects are arranged alphabatically.

best of luck

Kris Nunes

http://archi-e.blogspot.com/

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock