Export table to any location and save the file in csv format

Question

question

karthik asked Jun 11, '23 karthik commented Jun 12, '23

Export table to any location and save the file in csv format

Hi,

I wanted to export the table "Hrt_Insp_In_rack_Max_cap_WIP" values into to csv file in other folder location not in model directory location.

I need the user to select the location where they can save the csv file. But the csv file name will be preset to data.csv as per the below image.

Please help me with this problem. I'm not getting any idea.

Please let me know if your solution works even when I'm running Experimenter (Meaning the user should get the popup to select the file location while running the experimenter).

Thanks in advance

Software Version:

FlexSim 22.1.4

expaorttable fileborweser

1686510774935.png (38.0 KiB)

· 3

Joerg Vogel commented · Jun 11, 2023 at 05:46 PM

@karthik, you want to delay automatic multithread cpu tasks just to open multiple system save dialogs to decide manually where to store some data?

0 ·

karthik Joerg Vogel commented · Jun 11, 2023 at 05:56 PM

No I don't want to delay automatic multithread cpu tasks, @Joerg Vogel I will be asking the user to select the file location only once at the end of the model run i.e., after 30 days.

0 ·

karthik karthik commented · Jun 11, 2023 at 06:08 PM

@Joerg Vogel I'm running the model for 30 days. In process flow and I'm creating the token on 30th days to flow to this custom code and wanted the user to get prompted to set the drive location alone not to select any csv files for storing the data, because I wanted my csv file name that is "data" as the name of the csv file to be saved in the user selected folder.

0 ·

Answer 1 · 2023-06-12T08:23:48Z

Vinay S answered Jun 12, '23 karthik commented Jun 12, '23

Hi Karthik,

Create a node in Tools Tree, rename it (Ex: GetFolder).

Right click on node and add some text data to it, by choosing 'Add Text Data' from Node option.

(We'll use this node to store folder location as string).

Add a Model trigger 'On Run Start'.

Enter this below code in the Code Editor.

getdirbrowse("","Select the folder to export CSV",Model.find("Tools/GetFolder"));

On Run Start, this will Opens a browser window to pick a folder, and the folder location will be stored in the Node: "Tools/GetFolder" as text. You can fetch data by using this code

Model.find("Tools/GetFolder").value;

And to export your table you can use this node value for example like this.

exporttable(Table("GlobalTable1"),(Model.find("Tools/GetFolder").value)+"/data.csv",1,1);

This will export "GlobalTable1" data to 'data.csv' inside the selected folder.

1686556597196.png (16.6 KiB)

1686556719405.png (48.9 KiB)

1686557160482.png (16.2 KiB)

· 1

karthik commented · Jun 12, 2023 at 11:58 AM

Thanks @Vinay S, this method is working great

0 ·

question

Export table to any location and save the file in csv format

1 Answer

Write an Answer

Things to know…

question details