export global table to csv

Question

question

Paul G8 asked May 26, '22 Jason Lightfoot commented May 26, '22

export global table to csv

I have a global table with the following data. Worth noting that its set up with the 'Use Bundle' option.

I'm using a script in the onRunStop event to do the export. The file is created with the correct name/location, but aside from a single comma, it's empty. What am I missing?

Software Version:

FlexSim 22.1.2

exporttable

1653551621098.png (14.5 KiB)

1653551653486.png (13.5 KiB)

· 3

Paul G8 commented · May 26, 2022 at 07:55 AM

I have been trying to post the code snippet as a code snippet rather than an image, but I kept on getting cloudflare you have been blocked message.

0 ·

Jason Lightfoot ♦ Paul G8 commented · May 26, 2022 at 12:06 PM

That should be find if you mark the text with the 'Code' tool (shown as '<>' in the format editor)

0 ·

Paul G8 Jason Lightfoot ♦ commented · May 26, 2022 at 12:10 PM

Could've been a temporary glitch I guess - but as I'd had to write the post up about 3 times before that U thought I'd play it safe :)

0 ·

Answer 1 · 2022-05-26T12:15:32Z

Jason Lightfoot answered May 26, '22 Jason Lightfoot commented May 26, '22

The subnode of GlobalTables isn't where the data is stored. I would use this instead:

forobjectlayerunder(Model.find("Tools/GlobalTables")){
    exporttable(Table(a.name),a.name+"_export.csv",1,1);
}

or just change your exporttable line to:

exporttable(Table(xTable.name),fileNameString,1,1);

· 2

Paul G8 commented · May 26, 2022 at 12:45 PM

Awesome! Rather much like the java for (Object x : setOfObect) loop I guess.

If the forobjectlayerunder command ever got removed (the manual says its deprecated), is there a way of doing it in a regular for loo

0 ·

Jason Lightfoot ♦ Paul G8 commented · May 26, 2022 at 12:56 PM

Yes - what you had looked fine too - that why I said you could just change your exporttable call to use Table(xTable.name). Hopefully it won't get removed - it's used withing flexSim's guis and other logic too so would be an effort to replace - but you never know.

0 ·

question