Unable to create connections between some EPC objects

Last activity on November 21, 2025 - 12:44 28.2k Views 3 Replies Reports & Macros

Laurent Seiler on August 22, 2013

Hi,

I am developing a small script that should be able to import excel data and generate a model.

However, I am unable to get connections between some objects of specific types, even though these connections can be created in the "Designer" module.

Concrete illustration of my problem:

My raw data in Excel:
Expected outcome:
What I get:

As you can see, there are some links missing. It WOULD work if the "Position" would be, for example, a "Function".

I try to connect (all) the objects with the following function:

function connect (source, target) {
    // This function "brute force" connects two objects
    
    var i = 0;
    var connection = null;
        
    while(!connection && i < 1000) {
        connection = model.CreateCxnOcc(true, source, target, i++, pointList);
    }
    
    //if(!connection) Dialogs.MsgBox("Still no connection")
}

so I think we can exclude that I chose the wrong CxnType (Type number of the relationship occurrence to be created -- in this case: i).

So, has anybody got an idea what could be the problem or has a different solution / workaround for this?

If you need some more code, please feel free to ask!

Many thanks,

Laurent

Tags: #arisscript; #arisreport; #excel; #epc; #aris

Bookmark

Notify Moderator

3 Replies

function connect (source, target, stop) {
    // This function "brute force" connects two objects
    
    var i = 0;
    var connection = null;
        
    while(!connection && i < 1000) {
        connection = model.CreateCxnOcc(true, source, target, i++, pointList);
    }
    
    if(!connection && typeof(stop) == 'undefined') connect(target, source, true);
}

Short explanation: If the connection fails, try swapping the source and target value and try again -- straight and simple :)

Again, thank you very very much for your help!

Thanks,

Laurent

Upcoming events

June 9, 2026, 09:30 to 11:00

ARIS User Group DACH Meeting zum Thema Konsolidierung

ARIS User Group DACH Meeting zum Thema "Konsolidierung"

June 10, 2026, 11:30

ARIS Roadshow London 2026 - Let’s Get AI Working!

The ARIS Roadshow is a must-attend gathering for leaders turning AI ambition into controlled operational execution.

June 10, 2026, 12:00 to 16:00

ARIS Usergroup AUSTRIA in Linz, OÖ

Das ARIS-Community Event des Jahres in Österreich

June 25, 2026, 09:30 to 12:00

ARIS User Group Netherlands (AGNL) theme session: Solution Management

🎯 From Custom Chaos to Controlled Change - Peer insights on managing ARIS in a world of monthly releases. Upgrades that used to happen occasionally are now...

All events

Reset Password

Ellen Gambrell Pelletier on August 22, 2013 - 17:26

Hi Laurent -

Why are you not just setting the connection type in the code rather than iterating through 1000 connection types? This should work:

or register to reply.

Laurent Seiler Author on August 23, 2013 - 08:44

Hi Ellen,

First of all, thank you for your answer. It pointed me in the right direction and my script works now :)

I was not setting the exact connection type because

I wanted to save time and
because I didn't know to which object combinations the different types belong to.

I tried your code, and much to my regret it didn't solve my problem either (which was to be expected, as all those constant values were already covered by my function). However, I noticed that the argument order plays a major role here: a "Position" has to be the source of the connection. Therefore, I updated my function as follows:

function connect (source, target, stop) {
    // This function "brute force" connects two objects
    
    var i = 0;
    var connection = null;
        
    while(!connection && i < 1000) {
        connection = model.CreateCxnOcc(true, source, target, i++, pointList);
    }
    
    if(!connection && typeof(stop) == 'undefined') connect(target, source, true);
}
Short explanation: If the connection fails, try swapping the source and target value and try again -- straight and simple :)
Again, thank you very very much for your help!
Thanks,
Laurent

Ellen Gambrell Pelletier on August 26, 2013 - 17:19

Source and target are definitely important in the code. Glad I could help!