draw network nodes using data from an excel sheet

I saw a thread some time about getting and printing information about existing network nodes in a model.

now i have a need to create network nodes based on data from an excel sheet. Excel sheet has node id, x, y, and z coordinates. has some body done it before ?
thanks,
Vinay

Vinay,

I have written this code many times but am having trouble finding some that doesn't have a lot of other stuff built into it also. So, try the following code:

treenode nnobj = node("/NetworkNode", library()); //This gets a pointer to the network nodes
treenode tnode; //Create a pointer to use later to point to new nodes

for(int row = 1; row <= gettablerows("Nodes"); row++)
{
tnode = createinstance(nnobj, model()); //Create the new node
setname(tnode, gettablestr("Nodes", row, 1)); //Set the name of the node
setloc(tnode, gettablenum("Nodes", row, 2), gettablenum("Nodes", row, 3), gettablenum("Nodes", row, 4)); //Set the location of the node
}

That code requires that you import the Data in Excel into a Flexsim global table called Nodes. The first column of the table needs to be text.

Good Luck,
Brandon

Hi Brandon

We are working on a project which has a similar kind of structure. We would like to know how to modify the code above, to get the network nodes connected to each other, like for instance, i would like to read this table as a globular table and get the network nodes connected .

Station X coord Y coord No: of tracks Predecessor
NN1 10 12 1 NN2
NN2 13 11 2 NN3, NN4
NN3 15 14 2 NN1, NN5

and so on.......

Your code above helped us in displaying the nodes, but is it possible to get them connected........

You should be able to connect them using the contextdragconnection command

Hi Jason,

Thanks for your reply. Is this code still applicable to the current FlexSim 7.3?

Where should I implement the code on the OnModelOpen trigger??

Thanks a lot,

Thomas

There is a small change to the create instance code as the address of the network node has changed

createinstance(node("/travelnetworks/NetworkNode",library()),model());

I'd probably avoid putting it explicitly in the On Model Open as you will have a lot of trouble if it doesn't work etc. I have something similar and it's all held in a user command that I can launch from a trigger so you could include it within an If Statement based on a label/table switch so that you can turn it off and have a "Safe" version of your model.

I would suggest to put your code into a user command because it's more convenient
A good place to use this command could be the "Post Import Code" in the "Excel Interface". This will execute the command if you import a new Excel table.

Greetings,


Carsten

Originally Posted by michaelsmith

There is a small change to the create instance code as the address of the network node has changed

You can use the ? character in a node path to recursively find a subnode. You should use that to get the path to the NetworkNode in the library:

createinstance(node("?NetworkNode",library()),model());