ATTENTION

This FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices.


flexsim.com

Go Back   FlexSim Community Forum > FlexSim Software > Q&A
Downloads

Q&A Using Flexsim and building models

  #1  
Old 08-02-2011
Robert Liu Robert Liu is offline
Flexsim User
 
Join Date: Oct 2009
Posts: 24
Downloads: 70
Uploads: 0
Thanks: 13
Thanked 0 Times in 0 Posts
Rep Power: 129
Robert Liu is on a distinguished road
Default How to let the DDE correct?

Dear Community Members,
In my model , the Dynamic Data Exchange was used to communicate with Excel, I had built this model in 5.1.2 and the codes was in ‘User Events’ in ‘tools’ menu and the communication was correct, but I want the communication only created one time when the model begin. But now it was triggered again and again. Who can tell me why? How can I let it correct?
Thanks.
Attached Files
File Type: zip DDE1.zip (63.6 KB, 124 views)
  #2  
Old 08-03-2011
Robert Liu Robert Liu is offline
Flexsim User
 
Join Date: Oct 2009
Posts: 24
Downloads: 70
Uploads: 0
Thanks: 13
Thanked 0 Times in 0 Posts
Rep Power: 129
Robert Liu is on a distinguished road
Default

My description was maybe not clearly. I want to read the processtime from Excel and store the data in global table ‘processtime’, this operation only need one time. Then I wrote the DDE codes in User Events. But when the model running, the DDE ran again and again when the item exit the source, enter the queue, exit the queue……, even I didn’t select ‘Execute event on reset only’ in User Events. I can’t understand this and find out the solution. Who can tell me? Thanks.
  #3  
Old 08-04-2011
Jason Lightfoot Jason Lightfoot is offline
Flexsim Consultant
 
Join Date: Aug 2007
Location: Somerset, UK
Posts: 719
Downloads: 20
Uploads: 0
Thanks: 123
Thanked 953 Times in 446 Posts
Rep Power: 773
Jason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond reputeJason Lightfoot has a reputation beyond repute
Default

The problem disappears if you remove the user event completely and then define the import in the Excel Auto (button) as part of a multi-table import. After that just call the function excelmultitableimport(), which you can do on reset or, if the data isn't going to change, when the model loads (see Model Triggers).
The Following User Says Thank You to Jason Lightfoot For This Useful Post:
Robert Liu (08-04-2011)
  #4  
Old 08-04-2011
Robert Liu Robert Liu is offline
Flexsim User
 
Join Date: Oct 2009
Posts: 24
Downloads: 70
Uploads: 0
Thanks: 13
Thanked 0 Times in 0 Posts
Rep Power: 129
Robert Liu is on a distinguished road
Default

Jason, thanks a lot! I will try your suggestion. But the logics in Flexsim are inexplicable sometimes. In my model, the idea using User Events may be a wrong selection? I don’t know.


Thread Thread Starter Forum Replies Last Post
Is Queue's AvgContent correct? qin tian Gripes and Goodies 3 03-02-2008 09:49 PM


All times are GMT -6.
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Copyright 1993-2018 FlexSim Software Products, Inc.