AR

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)

 

by Ilya Seletkov
Posted on Thu, 11/13/2014 - 13:27

Hello!

If you don't find the script you described, I could write it for you with your requirements.

0
by Alexander Ressler Author
Posted on Fri, 11/14/2014 - 17:15

In reply to by iseletkov

Thank's for your help.

I came back to you, when I don't find a solution.

0
by Tanguy Petre
Posted on Fri, 11/14/2014 - 10:25

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

0
by Alexander Ressler Author
Posted on Fri, 11/14/2014 - 17:24

In reply to by tpetr

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

0
by Michael Renner
Posted on Thu, 06/18/2015 - 16:43

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

0
by Pedro Peregrino
Posted on Mon, 12/14/2015 - 18:04

In reply to by mmrenner

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.

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