question

Christian R. Houen avatar image
0 Likes"
Christian R. Houen asked Christian R. Houen commented

Stat collector in v18, when using "ID of row value" returns "Invalid ID"

Hi

When I try and set the stat collector to register pallet ID, I thought I might as well use the row ID, as the specific pallet ID does not matter to me. In the data table however, only the value "Invalid ID" is returned in all cells in this ID column.

Is there any better way to do this? Could I simply create a column of row IDs using SQL in the calculated table section? If so, how'd you do that?

regards,

FlexSim 18.0.0
statistics collector
· 1
5 |100000

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

Christian R. Houen avatar image Christian R. Houen commented ·

I actually managed to make it work now, but I still haven't gotten a clue how.
Also, if anyone knows how to register pallet ID in case I have multiple entry ports and listen to the data using different statistics collectors?

0 Likes 0 ·

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Christian R. Houen commented

This is due to how the ID system works on the statistics collector. If you get the id (using StatisticsCollector.getID) of a flowitem or token, you get an incrementing number. The first one you ID becomes number 1, the second, number 2, etc.

For permanent objects, like Fixed Resources, the ID is actually generated from the full path of the object. The ID is just a big number, however, and isn't helpful on its own.

That's where column formatting comes in. If you have an ID of a fixed resource (or other present-on-reset object), then you can choose not to see the big number, but the path that created the big number. This is the Object column format.

In your case, however, you are using the Object column format, which means "don't display the number, display the path that makes this number." Unfortunately, the number for tokens and flowitems is not generated by path, and so the collector says "Invalid ID" or "I couldn't find the path for that number, so I can't display this using the Object formatting."

So the fix is to not use the Object column format for the ID of a row value.

· 1
5 |100000

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

Christian R. Houen avatar image Christian R. Houen commented ·

Thank you, Jordan!

0 Likes 0 ·