question

pc neo avatar image
0 Likes"
pc neo asked Phil BoBo answered

export to database not working

I try to export a global table "Availability" to my local hosted database table "try". It does not seem to export the data successfully as it is not reflected in the database record, though there is no error message appearing in FlexSim.

The database table does not have any restriction setup and I'm using login of root rights.

I tried uncheck "Append to Table", it shows that the database table is cleared. However, if I check "Append to Table", nothing happens. I wonder if the change is "committed" to the database table at all?

A pic is attached to show the global table setup and mapping written for the export to database.

Hope to get some enlightenment... :)database-export.png

FlexSim 19.0.2
export to database
database-export.png (201.9 KiB)
· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

pc neo avatar image pc neo commented ·

@phil.boboDo you have a "try" table? Yes. I do. If you are to look at the right side of the screen shot, you will see the line "Server:127.0.0.1>>database:flexsittraining>>Table:try

it is reflecting the table "try".

0 Likes 0 ·
Phil BoBo avatar image Phil BoBo ♦♦ pc neo commented ·

Your screenshot does not show enough information about what is happening with your system to tell you what is wrong.

Try opening the system console as you do the export. Do you have any errors printed?

You could also record a video of what you are doing and maybe something will stand out to explain your results.

0 Likes 0 ·
pc neo avatar image pc neo Phil BoBo ♦♦ commented ·

Thank you for your tips. I've attached a video which shows the steps that I've taken.

When I click on export there is no errors printed out. It is only that the database does not show any update of data when "Append Table" is checked. However, if the "Append Table" is uncheck, the database reflects that the table is cleared.

Any tips will be appreciated. :)

screencaptureproject1.rar

0 Likes 0 ·
screencaptureproject1.rar (10.3 MiB)

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered

I found the issue.

There's a bug in the export code when there's only 1 row to export. If you add another row, it should export correctly.

I'll fix the bug for the next bugfix release.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.