Export Bundle data

Hello,
Can anyone tell me how to export a bundle data to csv?

Best Regards,
Ahsanur Rahman

Hello Ahsanur,

If you are trying to export the data from a specific dashboard widget to CSV file you can just right click on that specific widget and you have the option export to csv file.
If you want to point to data node you can export by
MODEL:/Tools/Statistics/WidgetName>variables/data

You can try exportdataset(<node>,<filename>,DATATYPE_BUNDLE)

There is currently no function available to export a bundle. So you have to do it yourself. There are 2 simple approaches you can use:
1. Loop through the bundle and use the fileopen and pft functions to write your data to a file directly.
2. Loop through the bundle and fill a global table and then use exporttable to export it.

Both require a little work but it is not that complicated.


Sorry just see that I stand corrected. Thanks Jason, but my solutions are still valid!

Sorry i misunderstood your question.Here are some threads discussed on this topic
http://www.flexsim.com/community/for...ead.php?t=2203
http://www.flexsim.com/community/for...ead.php?t=2774

Hello,
I have tried this following option
1. Loop through the bundle and use the fileopen and pft functions to write your data to a file directly.

It's not working nor it's giving me an error. Hence, I am providing an example data and my scripts. Can you tell me what I am doing wrong?

Example data:
7 entries, [StationName, Date, Time, Inventory, WIP, WIP_Chart]
0 ["STA000", "2/27/2015 08:00:12", "08:00:12", 0, 1, 1]
1 ["STA000", "2/27/2015 08:07:11", "08:07:11", 0, 1, 0]
2 ["STA000", "2/27/2015 08:07:12", "08:07:12", 0, 0, -1]
3 ["STA000", "2/27/2015 09:34:08", "09:34:08", 0, 0, 0]
4 ["STA000", "2/27/2015 09:34:09", "09:34:09", 0, 1, 1]
5 ["STA000", "2/27/2015 09:40:08", "09:40:08", 0, 1, 0]
6 ["STA000", "2/27/2015 09:40:09", "09:40:09", 0, 0, -1]

Script:
string columnname1 = getbundlevalue(so(),1,"StationName");
pt(columnname1);pr();
if(fileexists("test.csv"))
{
pt("I have my file");pr();
fileopen("test.csv", "a");
fpt(columnname1);fpr();
//fpr();
fileclose();
}