Cant Import data to bundle tables

Question

question

martin.j asked Oct 10, '18 tannerp commented Oct 22, '18

Cant Import data to bundle tables

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?

bug report bundle csv importtable

· 2

5 |100000

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

Joshua S commented · Oct 11, 2018 at 05:51 PM

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

0 ·

martin.j Joshua S commented · Oct 12, 2018 at 12:01 PM

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.

0 ·

exportcsvmodel.fsm (20.0 KiB)

Answer 1 · 2018-10-12T19:49:28Z

Jordan Johnson answered Oct 12, '18

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.

5 |100000

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

question