question

Amélie avatar image
0 Likes"
Amélie asked Clair A commented

Referencing labels from Excel in 3D model

Hi,

I have already see this answer but I try it and it doesn't work.

https://answers.flexsim.com/questions/104029/referencing-labels-in-3d-model-to-process-flow-lab.html
I have a source that imports from an excel file with arrival times and data attached.CF : Modèle-test excel.xlsx And this is working, but when I want to use the labels to make a Triggers, labels doesn't exist.


1745401660174.png1745401699726.png
This is my model, import excel.fsm, could you help me, please ?

Thanks and best regards,

FlexSim 25.0.3
excel importassign labels
1745401660174.png (15.9 KiB)
1745401699726.png (12.5 KiB)
modele-test-excel.xlsx (99.9 KiB)
import-excel.fsm (25.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Clair A avatar image
0 Likes"
Clair A answered Clair A commented

Hello Amélie,

If you go to the FlowItem Bin and add a number label on any flowitem:

1745416886517.png

This label will then be added to the picklist options:

1745416049932.png

However, if the label is a string label, it is not added by default to these picklist options. I think that this could actually be an idea of improvement, I will send this idea to @Parker S.

If a label is added dynamically during the simulation run, like in your arrival schedule table, it is also not added to these picklist options. But anyway if you type the syntax item.labelname, this will work fine as long as the labelname exists on the flowitem.


1745416049932.png (25.2 KiB)
1745416886517.png (57.7 KiB)
· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Clair A avatar image Clair A commented ·

I have added an idea of improvement for future releases here: https://answers.flexsim.com/questions/178916/add-string-labels-to-by-case-pickoptions.html

0 Likes 0 ·
Amélie avatar image Amélie Clair A commented ·

Hello Clair,


Thank you for your response, so if I anderstand correctly I can't use "letter" for the "Case" because it's Number Label. I'm right ? 1745419174104.png

0 Likes 0 ·
1745419174104.png (13.6 KiB)
Clair A avatar image Clair A Amélie commented ·

You can use text in the Case field, but it should be between quotes:

1745420969968.png

0 Likes 0 ·
1745420969968.png (25.6 KiB)