topic Re: Cant Import data to bundle tables in FlexSim Forum

Cant Import data to bundle tables

MBJEBZSRG — Wed, 10 Oct 2018 08:29:51 GMT

When making a table that has the bundle type and containing strings, I can export that table to CSV using the exporttable command. But I am unable to import that csv file to the table again with importtable. The size of the table is imported but all the cells are blank.

I have attempted to do the same with the exportdataset and importdataset commands but it doesnt work either. In fact I cant find any scenario where using format options 2 or 3 with importdataset ever works.

Is there something here I have completely misunderstood or is this i bug?

Re: Cant Import data to bundle tables

joshua_s — Thu, 11 Oct 2018 17:51:02 GMT

Can you upload your CSV file so we can try to understand the problem better?

Re: Cant Import data to bundle tables

MBJEBZSRG — Fri, 12 Oct 2018 12:01:44 GMT

exportcsvmodel.fsm,

The attached model has two global tables, both of them bundles, and two scripts. One script exports GlobalTable1 to the file LogFile.csv. The second script imports the csv file in to GlobalTable2 - which fails. If GlobalTable2 is not a bundle everything is fine, but if it is it will show only blank cells. I have tried the same with the importdataset() function with the format parameter set to 1 for table - Same difference.

Re: Cant Import data to bundle tables

JordanLJohnson — Fri, 12 Oct 2018 19:49:28 GMT

The importtable() command does work for bundles. We will put an issue on the dev list to look in to the issue.

For now, I would import the data into a non-bundle table. Then, use clone() or cloneTo() to copy the table to a bundle table. Then you could use setSize() to clear the first table.