How to read ItemType and ItemName in the source arrival schedule table from a global table?

Question

question

sanaz karamimoghaddam asked Sep 12, '16 ernesto daniel AG2 commented Nov 27, '18

How to read ItemType and ItemName in the source arrival schedule table from a global table?

I have a large number of specific flowitems (about 25 item types) that are created based on a specified schedule. I have used a code to read the arrival dates from a global table to the source triggers on reset. How can I read the ItemType and ItemName lable from the global table to the arrival schedule table of the source.

P.S. Are these values (ItemName and ItemType) that are shown in the arrival schedule table of the source, flow item lables and can they be used as lables?

Software Version:

FlexSim 16.2.0

global table itemtype source schedule flowitem lables

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2016-09-12T17:14:47Z

Sam Stubbs answered Sep 12, '16 ernesto daniel AG2 commented Nov 27, '18

So in the OnReset trigger of the Source I entered the following code:

/**Custom Code*/
treenode current = ownerobject(c);


treenode schedule = getvarnode(current, "schedule");


for (int column = 1; column <= gettablecols("Source Table"); column++)  {
	for (int row = 1; row <= gettablerows("Source Table"); row++)  {
		if (getdatatype(gettablecell("Source Table",row,column))==DATATYPE_NUMBER)  {
			settablenum(schedule,row,column,gettablenum("Source Table",row,column));
		}
		if (getdatatype(gettablecell("Source Table",row,column))==DATATYPE_STRING)  {
			settablestr(schedule,row,column,gettablestr("Source Table",row,column));
		}
	}
}

You basically have a for loop parse through the table of the Source's schedule, as well as the Global Table. I put a check in there as well to see if the table value is a String or Number, since the commands are gettablenum or gettablestr respectively.

To answer your other question, the Name value changes the name of the item, which by default on an inter arrival source is "Box". (This value can be retrieved using the getname() command.) The ItemType is in fact a label.

I've attached the example below.

schedulesourceexample.fsm

schedulesourceexample.fsm (81.7 KiB)

· 6

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

sanaz karamimoghaddam commented · Sep 12, 2016 at 07:19 PM

Thank you very much. It worked great!

0 ·

ernesto daniel AG2 sanaz karamimoghaddam commented · Nov 27, 2018 at 05:01 PM

hi @Sam Stubbs, in that same example

Now, how could I color each item in the production plan from the global table?

this to be able to observe better how the table is fulfilled.

After that when they pass to the processor, at the end of the process, separate them by colors in different queues.

thanks!!

production-plan.fsm

0 ·

production-plan.fsm (17.8 KiB)

Sam Stubbs ♦ ernesto daniel AG2 commented · Nov 27, 2018 at 05:19 PM

One way might be to assign a numeric value to each item from the table based on the row number. And then use the Color.byNumber(...) command, with the row number as the parameter. This would give a new unique color for each row number so you could see them through the model. Is this what you're asking about?

1 ·

Show more comments

question