topic Checking success of export to CSV in FlexSim Forum

Checking success of export to CSV

jeremy_r — Fri, 07 Dec 2018 00:28:09 GMT

[ FlexSim 18.2.0 ]

Is there a way to test if an export to CSV was successful?

We have discovered that if the user has the CSV file open when they try and overwrite it from FlexSim using the exporttable command, FlexSim continues without any kind of warning. Is there a way to validate that the export was successful? I tried returning the value of exporttable, but it is always 0 regardless of whether it succeeds or not.

Ideally, we would want to be able to check if the export failed, and display a warning message to the user if this was the case.

Re: Checking success of export to CSV

tanner_p — Fri, 07 Dec 2018 17:42:29 GMT

Could you try using the FlexScript Code Profile? Just an idea..

Re: Checking success of export to CSV

jeremy_r — Mon, 10 Dec 2018 01:31:20 GMT

I'm not sure how this helps. How do you use the code profile to detect if the export was successful?

Re: Checking success of export to CSV

JordanLJohnson — Tue, 11 Dec 2018 09:56:02 GMT

You can check if FlexSim has permission to write to it by using the file API in FlexSim:

int success = fileopen(fileName, "a"); // open in append mode
if (success) {
    fileclose();
} else {
    print("Could not open file ", fileName);
}
exporttable(...);

It should catch whether exporttable will be able to actually write to the file.