what to fill in in template for data import

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

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 

Of course!

/system/files/editor/files/Import example.pdf

Try also the 2007 version:

/system/files/editor/files/Import example.xlsx

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:-)

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.

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

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

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

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

After entering the data as mentioned in the excel,what do i need to do to create an EPC?

After entering the required data,what is the next step to create an EPC?

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?

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.

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

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.

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