Buggy bundle + importtable() interaction

Question

question

Przemyslaw Pasich asked Jan 07 2025 at 12:00 PM Jeanette F answered Jan 22 2025 at 5:38 PM

Buggy bundle + importtable() interaction

The issue happens when importing a .csv using importtable() into a table that is defined to be a bundle: if the first row contains an empty string, the whole column gets disregarded completely and the import ends prematurely.

The expected result:

The achieved result:

The issue does not occur if the table is NOT a bundle type.

I am attaching a dummy model that recreates this issue + a sample CSV:

missing_col_when_importing_CSV_to_bundle.fsm

sample_csv.txt

Right now the workaround is to modify the .csv as a text file using fileopen() and replacing all the empty values in the first row with a dummy string value (e.g. " "), but can you please fix the issue in some future release of FlexSim so that importing to a bundle table and a non-bundle one behaves consistently?

Software Version:

FlexSim 24.2.0

csv importtable

expected-result.png (4.2 KiB)

actual-result.png (4.0 KiB)

missing-col-when-importing-csv-to-bundle.fsm (25.3 KiB)

sample-csv.txt (44 B)

· 2

Nil Ns commented · Jan 07 2025 at 5:45 PM

Hello,

It looks like a bug.

As a workaround, you can import without using the bundle and then change to that using a code like this:

missing-col-when-importing-csv-to-bundle.fsm

treenode selObj = Model.find("Tools/GlobalTables/Bundle_tbl");
createview(gets(guifocusclass(selObj)), nodetopath(selObj), "");
treenode view = views().find("active>Documents/Table").last.find("+/../../..");
 
function_s(view.find("/TableView"), "changeBundleData");
repaintview(view.find("/TableView"));
 
Table tbl = Table("Bundle_tbl");
string file_path = filebrowse("*.csv;*.txt", "CSV files", modeldir());
importtable(tbl, file_path, 1,0,",");
 
 
function_s(view.find("/TableView"), "changeBundleData");
repaintview(view.find("/TableView"));

0 ·

missing-col-when-importing-csv-to-bundle.fsm (26.4 KiB)

Przemyslaw Pasich Nil Ns commented · Jan 08 2025 at 7:17 AM

Hi Nil, thanks for the workaround! Yours is a good one especially when you cannot edit the source CSV file. I'll keep it in my notes

1 ·

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2025-01-22T17:38:50Z

Jeanette F answered Jan 22 2025 at 5:38 PM

This has been submitted to the development team for further investigation

question