Profile picture for user vanheckeb

Hi community,

I'm doing some experiments with the report "create template for data import" but i get stuck when trying to fill in the elements in the excel table.

In the template a table is created for the objects with headings SYMBOL and O_TYPE. I tried to figure out what I had to fill in in these tables, using the name of the object types, the corresponding number, even the API_name, but nothing seems to work.

What exactly do I have to put in these columns? And how do I have to define the attribute headers in the other columns? Is there a specfic syntax or can I just use the attribute name?

thanks in advance,

Bruno

by Jens Heylmann
Posted on Mon, 09/12/2011 - 22:01

Hi Bruno!

The colored cells with brackets are references to values in the other mapping sheets. Look at this example which will create a simple EPC and set some attributes like name and description:

/system/files/editor/files/Import example.xls

 

0
by Bruno Vanhecke Author
Posted on Tue, 09/13/2011 - 08:07

Hi Jens,

thanks for your response. I'm however not able to open the attached file. (not in a recognisable format). Perhaps an incompatibility between xls versions. Could you provide a PDF version of the pages? Thanks in advance.

Bruno 

0
by John William
Posted on Thu, 12/12/2013 - 09:37

In reply to by Jens Heylmann

How to create a model(EPC)through Process Generator?Please guide me in this regard.

0
by Silje Hetland
Posted on Tue, 09/13/2011 - 20:00

Hi Bruno,

In Mapping_sym sheet you add the symbol you want to use for the object. You write a name of the symbol (replace<SymType1>), and then in column 2 you write either the GUID or the typenumber of the symbol.

In Mapping_obj sheet you add a name (replace<ObjType1>) and the GUID or typenumber of the object you want to use,

In Object sheet you use the name that you used in the Mapping_sym sheet for SYMBOL and the object for O_TYPE.

Do the same for the attributes.

Remember to remove everything in the excelsheet that you are not using :-)

Its very fast to create lots of objects using this standard functionallity!

Good luck:-)

 

0
by Rick Bosworth
Posted on Tue, 09/13/2011 - 22:46

The Help is also helpful. Look under Evaluate->Run Reports->ARIS Reports->Standard to find the report you are referring to. FYI, one thing not mentioned in the Help is that if the thing you are mapping does not have a API Name (i.e. user defined attributes) you need to use the GUID instead.

0
by Bruno Vanhecke Author
Posted on Wed, 09/14/2011 - 07:50

Thanks for the info.

I tried the reports and obtained some results. I created new objects in the database, with certain attributes from an excel table based on the template.

If I don't want to create new objects, but just adapt or enter attributes "en masse" to a lot of existing objects, can I do this with the same reports, or does that just create duplicate objects?

regards

0
by Deepti Mittal
Posted on Tue, 04/17/2012 - 12:12

Hi Bruno,

I can see that your post was long time back but just wanted to check if you found any solution to your problem as in ....any way to update the attributes of the existing object. I have a project requirement wherein lot of attributes keep on changing every 2-3 weeks...

Thanks 

Deepti

 

0
by Carmen Jacobs
Posted on Tue, 06/18/2013 - 01:08

Hi Bruno and Deepti,

even though I believe you migth have found your answer already (I hope), there are two easy ways to mass maintain attributes in order of my personal preference:

1) Attribute wizard

select either the main group r-click and select 'attribute wizard' (last item in the context menu) and then specifiy if you want to change attributes of a group, model, objects or connections, if it should be recursive and if you want to restrict the method (e.g. select for application system type only) or

you select a number of models or objects you want to change, one object type at a time is recommended, r-click and select 'attribute wizard' (last item in the context menu) and then specifiy the changes.

In both cases you can specify if you want to delete an attribute or fill it and if you want to overwrite the current value. You can change a number of different attributes at the same time with different value.

It allows you do to changes through the entire database, in a particular group or just on the selected object/model.

2) Report 'Preplace text attributes' (under Administration reports) lets you change any text attribute value with something else.

3) Export information to excel, change it there and then import it again. This can be done either via process generator or other import/output reports.

4) If you are changing a lot of values regularly and they are all the same, I would suggest to develop a custom report script for import and output of the data. It would allow people to make the changes outside of ARIS and then for one person to import it back in.

A problem with this is usually that you will need to make sure that nobody will change any objects that you are about to overwrite with the new data from the Excel list.

Hope it helps anyone. :-)

Cheers,

Carmen

 

0
by Tom Moore
Posted on Thu, 12/04/2014 - 17:56

Is there a cheat sheet or some way of quickly getting the symbol type numbers?   For Example...  How did you know that Symbol Type 335 is a Function?

0
by Roland Woldt
Posted on Fri, 12/05/2014 - 22:45

You can look into the Administration area of ARIS (object/model types), or have a look at the installation DVD. On that you will find a Documents folder that contains a PDF with all the method tables - those include the numbers.

0
by Silvia Ionescu
Posted on Thu, 03/26/2020 - 18:11

Hi,

I'm following this topic. I'm using ARIS 10 and I need help to get the <CxnType1>, <SymbType1> and so on numbers/codes. I don't have the installation disk to get the "documents" file and cannot find in the Administration area of ARIS  the object/model types. or most probably I don't know where. I do have permissions to the Admnistration area. is there a report I can run to get this codes for all objects, connections, and so on?

Thank you

0
by M. Zschuckelt
Posted on Thu, 03/26/2020 - 21:07

Hi,

you find all API names in the Administration under Configuration -> Method and then model types / object types / connection types etc.

On the data tabs you only use aliases of your choice. On the tabs named something with "map" you then map your aliases to the API names. Where you have custom attributes or symbols you need to map your alias to the GUID that you find in the API names column.

Good luck.

0
by Silvia Ionescu
Posted on Fri, 03/27/2020 - 17:30

Thank you,

I guess I don't have the right permission though. I cannot find Method in Administration. I only see Documents, Evaluations, Analyses, and Publish (Aris Architect 10.05).

do you know what permisions I need to ask for to see also the method?

Thank you,

BR/Silvia

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

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