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