Customize The Exported CSV File Name Using Export Table Command

Question

question

anon-user asked Oct 3, '22 Arun Kr commented Oct 5, '22

Customize The Exported CSV File Name Using Export Table Command

Hi Support,

I tried exporting a global table to a CSV file using the export table command. We could export it successfully with a static name to the file. But when I tried to give a dynamic name using the name and date. the export is not working. Kindly help us with this.

Table Summary=Table("TableName");
string Name ="ModelData";
exporttable(Summary,Name,1,1); //This is Working and CSV file is getting created.

But when I tried the following script

Table Summary=Table("TableName");
string Name ="ModelData" + Model.dateTime.toString();
exporttable(Summary,Name,1,1); //This is not Working

The CSV file is not getting created. How can I resolve this?

Regards,

Brijesh Kumar

Software Version:

FlexSim 22.1.2

exporttable

· 1

Jason Lightfoot ♦ commented · Oct 03, 2022 at 12:33 PM

Does the format contain any illegal characters for filenames? Can you manually rename the file to the expected string?

1 ·

Answer 1 · 2022-10-03T12:18:33Z

Joerg Vogel answered Oct 3, '22 Arun Kr commented Oct 5, '22

Does it work with a much simpler number depended string like a counter in your name. Perhaps the datetime string composed Format contains characters that are not allowed in a file name like “:”.

anonymous user !

· 1

Arun Kr commented · Oct 05, 2022 at 05:14 AM

Hi anonymous user ,

Try this.

Table Summary=Table("TableName");
int Day = Model.dateTime.day;
string Days = string.fromNum(Day,0);
int Month = Model.dateTime.month;
string Months = string.fromNum(Month,0);
int year = Model.dateTime.year;
string Years = string.fromNum(year,0);
string Name ="ModelData" + Days+"-"+Months+"-"+Years;

Regards,

Arun KR

0 ·

question