topic Re: Export Flexsim data to SQL in FlexSim Forum

Export Flexsim data to SQL

aa0976382405 — Mon, 04 Apr 2022 11:26:23 GMT

[ 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.

Re: Export Flexsim data to SQL

jason_lightfoot_adsk — Mon, 04 Apr 2022 14:09:17 GMT

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.

Re: Export Flexsim data to SQL

aa0976382405 — Mon, 04 Apr 2022 18:19:13 GMT

Thanks for your reply.

Both Flexsim Doc and Flexsim Community.

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

Re: Export Flexsim data to SQL

joerg_vogel_HsH — Tue, 05 Apr 2022 06:20:19 GMT

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.

Re: Export Flexsim data to SQL

jason_lightfoot_adsk — Tue, 05 Apr 2022 10:13:41 GMT

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

Re: Export Flexsim data to SQL

aa0976382405 — Tue, 05 Apr 2022 11:49:03 GMT

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

Re: Export Flexsim data to SQL

aa0976382405 — Tue, 05 Apr 2022 11:49:31 GMT

Thank you.

Re: Export Flexsim data to SQL

jason_lightfoot_adsk — Wed, 06 Apr 2022 17:03:16 GMT

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

Re: Export Flexsim data to SQL

ryan_c10 — Mon, 11 Apr 2022 18:30:34 GMT

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.