Export Flexsim data to SQL

[aa0976382405]

[ FlexSim 20.0.10 ]

Hello everyone, I have let information of agv (e.t.c. traveling times a day or every load time) into global tables. And I want to export these data instantly to SQL. I have been looking for the answers on Flexsim doc and Flexsim community, but it all failed. Both of the coding on these two page will have system console. So, I want to know is there any other method to solve this question? Thank you so much.

[jason_lightfoot_adsk · Accepted solution]

Which "two pages" are you referring to?

You connect to your Database using the database connection and prepare a statement with the INSERT INTO syntax required.

[aa0976382405]

Thanks for your reply.

Both Flexsim Doc and Flexsim Community.

Below is the code in Flexsim and system console will always appear.

[joerg_vogel_HsH]

I don’t have any knowledge to this case, but I think an assignment of Table agv should be completed before you prepare a statement that a compiler interprets as system code.

[jason_lightfoot_adsk]

Do you have a space in the table local variable between 'agv' and 'information' ? That would not be allowed.

[aa0976382405]

Thanks for your reply.

The following picture is the data table of MySQL.I hope my model global table to automatically send data to the database table immediately after running for a day (86400 seconds).

FlexsimSQL.fsm

[aa0976382405]

Thank you.

[jason_lightfoot_adsk]

This looks like a space between "agv" and "information" - that's not allowed.

[ryan_c10]

Hi @Ingrid Hung, was Jason Lightfoot'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.