question

tong avatar image
0 Likes"
tong asked tong commented

character length global table

How to modify the limit of character length in the global table cell of bundle format? I know that addbundlefield() command can set the character length of global table.But after I Import data by excel , the character length of global table resume default state.

FlexSim 18.1.0
character length global table
· 3
5 |100000

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

Phil BoBo avatar image Phil BoBo ♦♦ commented ·

Please attach a sample model and excel sheet showing the issue so that we can see how your model is configured to give suggestions on how to update it to use a different length for the field.

0 Likes 0 ·
tong avatar image tong Phil BoBo ♦♦ commented ·

demo.fsmdata.xlsx In the enclosure,There are demo model and excel sheet,Please check! Thank you!

0 Likes 0 ·
demo.fsm (17.0 KiB)
data.xlsx (8.6 KiB)
tong avatar image tong Phil BoBo ♦♦ commented ·

Thanks for your reply! The question is character length in the GlobalTable of bundle format is limited! Concrete case,Please look dynamic graph!Thank you very much!

0 Likes 0 ·

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered tong commented

The Excel interface is overriding the bundle column settings with its own addbundlefield() calls.

So to get around this for now, you can do one of the following:

  1. Do not toggle that table as Use Bundle.
  2. Format your bundle columns with the script and then use copy/paste to get the data from Excel into your table (copy/paste won't rebuild your columns).

FlexSim 18.2 will have a BUNDLE_FIELD_TYPE_VARCHAR field type that can hold strings of variable length. That will fix this issue.

· 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.

tong avatar image tong commented ·

OK!Thanks very much! Looking forward to the update of a new version!

0 Likes 0 ·