syncing labels or tables with database

Question

question

Roger W asked Oct 18 2017 at 1:38 AM Ben Wilson edited Oct 18 2017 at 3:58 PM

syncing labels or tables with database

I would like to know if it is possible to make a global table or label display values from database without event trigger to update. basically the table or label would be in sync with the database cell and purely displays the value from the database.

Thanks

Software Version:

FlexSim 17.2.2

label database table synchronize mysql

· 2

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2017-10-18T15:49:36Z

Ben Wilson answered Oct 18 2017 at 3:49 PM Ben Wilson edited Oct 18 2017 at 3:57 PM

@Roger W,

This answer at Stack Overflow suggests some methods that will allow you to watch for changes to a MySQL database. There are also other workarounds suggested on that page, but the basic gist is that MySQL doesn't offer an easy, out-of-the-box method for calling external functionality when changes happen in a database.

Assuming you can get one of the linked methods to work for you, such that some utility of your own making can sense when MySQL data has changed, that sensing utility could then send a message to FlexSim using sockets.

Anyway, there is no simple way to do what you'd like to do. It will take some effort.

If you switched to another database (Oracle, Microsoft, PostGreSQL, etc), there is a chance that better options might be available - though I have not researched these and don't know that for sure. Here is an example of connecting directly to Oracle using a DLL. Something like that might allow for an easier time accomplishing your goal, though I really don't know. Any solution that keeps your FlexSim data in sync with your database is going to require some research, creativity, and custom coding.

question