topic Re: Export table to any location and save the file in csv format in FlexSim Forum

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

KarthikSN — Sun, 11 Jun 2023 17:34:51 GMT

[ FlexSim 22.1.4 ]

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

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

joerg_vogel_HsH — Sun, 11 Jun 2023 17:46:35 GMT

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

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

KarthikSN — Sun, 11 Jun 2023 17:56:03 GMT

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.

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

KarthikSN — Sun, 11 Jun 2023 18:08:05 GMT

@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.

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

Vinay_S_Jindal — Mon, 12 Jun 2023 08:23:48 GMT

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.

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

KarthikSN — Mon, 12 Jun 2023 11:58:55 GMT

Thanks @Vinay S, this method is working great