Hi all,
I'm trying to export my global table to the database(MySQL). But the exporting fails.
My guess is that because the column name has symbol-characters. I experimented on exporting. When I used ',' or '(', it failed. But when I used '$' or '_', it succeeded.
What characters can I use in the column name?
Thanks.
Thank you for your question!
To help us in providing a clearer answer, could you send us a copy of your model?
Here is my model.
In GlobalTable1, I can export only "Time" column.
In GlobalTable2, I can export only "$" column.
Hi @Yokota T, was Jordan Johnson's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
In the database export tool, try wrapping your flexsim column names in square brackets:
To export to the database, we currently run a query in FlexSim to create the table that will be exported. Basically, this tool writes the following code:
Table toExport = Table.query("SELECT [#], [!], [)] FROM GlobalTable2");
// Then we iterate through the rows of toExport, sending them to the target table
So the "From FlexSim Column" values may need to be wrapped in [].
16 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.