Hi @all
I search for the code/script for the standard Excel-Import. Because I need to create relations between objects and models, when I import the data. I hope you can help me or give me a tip.
Thanks
Alex
Hallo zusammen,
gibt es eine Möglichkeit mithilfe des Excel-Imports Verknüpfungen zwischen Modellen und Objekten zu definieren?
Bzw. gibt es eine Möglichkeit, das Script was beim Import der Excel-Datei benutzt wird zu ändern? (Ich kann es leider nicht finden)
Hello!
If you don't find the script you described, I could write it for you with your requirements.
Hello Alex,
not sure which version you are using but I think it is the same for 7.2 or 9.x.
The way it works is you first have to make the Excel template, so in ARIS, from any ARIS group, you can launch a report with the name "Create template for data import".
The template is relatively simple to understand - you specify ARIS object number, relation, attribute. You use the model or object pages to have relationships and attributes.
Once done, you launch another report from an ARIS group (where you want the model and objects) that is called "Import data in Excel format"
This will create objects, models, relationships, attributes.
It works great for hierarchical models, objects and attributes uploads. It doesn't check for uniqueness so it creates only new definitions.
I hope it helps you
Regards
Tanguy
Thank's for your help.
I came back to you, when I don't find a solution.
Hello Tanguy,
thank's for your help and description.
I use ARIS 9.6 and yes the scenario that you describe is exactly that what I do at the moment.
But I need a way to create relations between the models that I create. You can create relations between objects, but not between models, the have no connector (Edge).
Do you understand what I mean? In the xml files you see only plaintext name for the model, but no the connection.
When I have the code/script for the Excel-Import "Import data in Excel format" I can manipulate it and then I create this connections (I hope so)
Regards
Alex
Is there any basic example of using the Excel import script to import objects? I have minimal success following the "Report - Import data in Excel format" help page. A sample input file would be great as a test showing what can actually be accomplished. With ARIS Excel import.
Thanks in advance for any tips.
MR
I second that.
There is actually very few resources on how to successfully use the "Import Data from Excel" report.
A sample input file would be great for understanding how it works.