topic Re: No options of To Table about database connector export data to in FlexSim Forum

No options of To Table about database connector export data to

PDKG — Tue, 20 Aug 2024 07:34:17 GMT

[ FlexSim 22.2.0 ]

I have already connected with database. Why no options of "To Table" can let me export my flexsim table?

Could you provide me the coding to export my data to dasebase?

Re: No options of To Table about database connector export data to

borja_lorenzo — Tue, 01 Oct 2024 11:52:53 GMT

Hello @PD

The same thing happens to me. You can use the following syntax detailed in the manual:
Database Connectors (flexsim.com)
FlexScript Class - Database.Connection (flexsim.com)

The question is to understand why the Database Connection tool does not show the tables of the database we are connected to. I have several queries made about it, if I get any satisfactory response, I will let you know.

If the code I wrote could be of help and confirmed that there was a connection to the database and I was able to write two values, it is this one:

Re: No options of To Table about database connector export data to

Jeanette_Fullmer — Wed, 23 Oct 2024 14:52:14 GMT

Hi @PD,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

Re: No options of To Table about database connector export data to

borja_lorenzo — Wed, 23 Oct 2024 18:12:01 GMT

Hello,
The export function of the DataBase Connector is still not working. To perform the export, I had to do it through the code, using this part of the manual. However, I would like to know if I have a configuration problem or if it is a software bug.

FlexScript Class - Database.Connection

Re: No options of To Table about database connector export data to

Jeanette_Fullmer — Mon, 04 Nov 2024 16:47:09 GMT

The Development team has been notified.

Re: No options of To Table about database connector export data to

philboboADSK — Tue, 05 Nov 2024 00:21:00 GMT

The Database Connector's export function is working just fine in our tests. You'll need to provide the Support team with more information for them to be able to help you determine why it isn't working for your configuration.

Re: No options of To Table about database connector export data to

borja_lorenzo — Tue, 05 Nov 2024 15:09:06 GMT

Hello Phill
I explain more details about this issue in this post: Export a Global Table from FlexSim to BaseDate MySQL - FlexSim Community

Beside, Jordan Jonson replied me about this issue this:
https://answers.flexsim.com/comments/171503/view.html

If any further clarification is necessary, I am at your disposal. Tell me what I would have to report and I will be happy to do so.

Re: No options of To Table about database connector export data to

Jeanette_Fullmer — Wed, 06 Nov 2024 16:46:36 GMT

Hello @PD ,

This has been submitted to the development team. A workaround for the time being is to go into the tree node and add in the table name there.

MODEL:/Tools/DatabaseConnectors/DatabaseConnector1>variables/exporters/1/tableName

I did not have the UI open when writing the table name. This will prevent the UI from overwriting what you wrote in the tree node. You can open the UI after you have added the table name.

Re: No options of To Table about database connector export data to

borja_lorenzo — Thu, 07 Nov 2024 06:54:15 GMT

Hello @PD ,

This works for me.
I share the link to my answer posted: https://answers.flexsim.com/comments/172543/view.html