Export a Global Table from FlexSim to BadeDate MySQL

Question

question

Borja Lorenzo asked Sep 30, '24 Logan Gold answered 2 hours ago

Export a Global Table from FlexSim to BadeDate MySQL

Hello,

I am trying to export a Global Table “FlexSimtoCPLAB” from FlexSim to a MySQL Database. I have tested the connection with the database and I use HeidiSQL for managing this database. Previously, I imported data into this same database and it worked perfectly.

The DatabaseConnector tree appears as follows:

Where it can be seen that the exporters node does not have the subnodes that it should have. It can be seen that in the tableList node, two subnodes appear corresponding to the two tables I have in my database, but the names do not appear.

In the following image, I have observed in a model that I downloaded from this forum that the export node does expand and has subnodes and the tableList has name

When I want to make the export to DB, but it does not show this table created in the database, and therefore, I cannot map the columns.

What am I doing wrong? How is it done?

I had to configure the root user with the authentication plugin:

mysql_native_password.

because the "caching_sha2_password" was giving me an error.
The version of MySQL I am using is 8.0.26.

Software Version:

FlexSim 24.1.1

export data mysql base dados base date

conectividad-flexsim.jpg (60.9 KiB)

export-from-flexsim.jpg (103.6 KiB)

export-from-flexsim-2.jpg (95.6 KiB)

1727707456942.png (125.7 KiB)

1727707498202.png (39.6 KiB)

1728070648955.png (26.3 KiB)

1728070782574.png (22.2 KiB)

· 4

5 |100000

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

Borja Lorenzo commented · Oct 01 at 06:25 AM

Hello @Matthew Gillespie,

Sorry to mention you directly, but I have reviewed your response to this question "Connection Failed with Error: libmySQL.dll - FlexSim Community" and it aligns very well with certain problems I am encountering with MySQL and FlexSim. Could you help me with the question I have posted? Thanks in advance.

0 ·

Borja Lorenzo commented · Oct 09 at 08:48 PM

I am adding an update to this question for anyone interested. According to the recent comment by Jordan Johson, it could be a bug. They will look into it

https://answers.flexsim.com/comments/171503/view.html

0 ·

Jeanette F ♦♦ commented · 2 days ago

Hi @Borja Lorenzo,

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.

0 ·

Borja Lorenzo Jeanette F ♦♦ commented · 2 days ago

Hello Janette, thanks for your comments.
I didn’t quite understand. Do I need to respond to one of my own comments? Has no one given me an answer about this yet? I have posted this question or commented on this same topic from different points in the forum without success. Below, I am pasting the same response that I am giving you from other published points.

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.

Thanks in adance for your feedback.

0 ·

Answer 1 · 2024-10-25T21:35:41Z

Logan Gold answered 2 hours ago

Hey @Borja Lorenzo, I do see the issue on the dev list, so we'll just have to wait until a developer can look into it more. We'll try to update this post if we get any more information, but I don't know when that might be.

5 |100000

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

question