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-19-2008
David Chan David Chan is offline
Flexsim Distributor
 
Join Date: Sep 2007
Posts: 326
Downloads: 74
Uploads: 0
Thanks: 217
Thanked 73 Times in 44 Posts
Rep Power: 218
David Chan has a spectacular aura aboutDavid Chan has a spectacular aura aboutDavid Chan has a spectacular aura about
Default Problem with importing Excel data

Hi all,

When I was conducting training in importing Excel spreadsheet data, my client faced problem in importing. I have enclosed the error log file.

They are using V4.32, XP and Microsoft office 2000.

Anyone faced the same problem in working with these combination?

David
Attached Files
File Type: txt oleexlogfile.txt (2.0 KB, 427 views)
__________________
Advent2 Labs
David
  #2  
Old 08-19-2008
Steven Hamoen's Avatar
Steven Hamoen Steven Hamoen is offline
Talumis, Flexsim Distributor, The Netherlands
 
Join Date: Aug 2007
Location: Soest, NL
Posts: 854
Downloads: 43
Uploads: 0
Thanks: 391
Thanked 661 Times in 379 Posts
Rep Power: 684
Steven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond reputeSteven Hamoen has a reputation beyond repute
Default

David,

Somewhere along the line, Flexsim has changed from DDE to OLE with importing from Excel, and office 2000 doesn't support OLE.

You can use the maintance command with parameter 1000 to get back to DDE. write something like: "maintenance(1000, 1);" before you make any calls to excel commands. that should do the trick.

Steven
The Following 2 Users Say Thank You to Steven Hamoen For This Useful Post:
David Chan (08-20-2008)
  #3  
Old 08-20-2008
tobias.biemueller tobias.biemueller is offline
Flexsim User
 
Join Date: Aug 2007
Location: Bielefeld, Germany
Posts: 42
Downloads: 22
Uploads: 0
Thanks: 23
Thanked 18 Times in 16 Posts
Rep Power: 164
tobias.biemueller is on a distinguished road
Default

Hi,

we have had the same problem last time.
We tried to change from OLE to DDE and the other way, every time the same error like you have. Maybe v4.32 doesnt support office 2000.

We adviced them to update the office version.

regards
Tobias
The Following User Says Thank You to tobias.biemueller For This Useful Post:
David Chan (08-20-2008)
  #4  
Old 08-20-2008
David Chan David Chan is offline
Flexsim Distributor
 
Join Date: Sep 2007
Posts: 326
Downloads: 74
Uploads: 0
Thanks: 217
Thanked 73 Times in 44 Posts
Rep Power: 218
David Chan has a spectacular aura aboutDavid Chan has a spectacular aura aboutDavid Chan has a spectacular aura about
Default

Steven and Tobias, thanks for the information.

As I was using the MTEI to import the data, how and should I trigger the maintenance command? At the Script?
__________________
Advent2 Labs
David
  #5  
Old 08-20-2008
Kris Geisberger Kris Geisberger is offline
Flexsim Canada, Forum Moderator
 
Join Date: Aug 2007
Location: Canada
Posts: 209
Downloads: 54
Uploads: 1
Thanks: 99
Thanked 389 Times in 133 Posts
Rep Power: 451
Kris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud ofKris Geisberger has much to be proud of
Default

I believe we found that the maintenance(1000,1) trick works for Single Table and Custom Import/Export, but does not help the MTEI in this situation. I don't know of a fix for the MTEI.

Kris
The Following 3 Users Say Thank You to Kris Geisberger For This Useful Post:
RalfGruber (08-25-2008)
  #6  
Old 03-05-2009
Olivier Pellegrin Olivier Pellegrin is offline
FlexSim User
 
Join Date: Sep 2007
Location: Montpellier, France
Posts: 20
Downloads: 16
Uploads: 0
Thanks: 36
Thanked 14 Times in 7 Posts
Rep Power: 163
Olivier Pellegrin will become famous soon enough
Default

Jeff from Flexsim Support team wrote:

"In Excel 2003 and above, the way Flexsim interfaces with Excel is OLE. In Excel 2000, Excel used DDE. The maintenance(1000,1) changes from the default OLE back to DDE. If done in a script window or on a reset trigger somewhere, it should work fine with the MTEI. You only have to run the command once. Until you close Flexsim, it should still be in force."

Thank you Jeff for this detailed answer.
__________________
[SIGPIC][/SIGPIC]


Thread Thread Starter Forum Replies Last Post
draw network nodes using data from an excel sheet Vinay Mehendiratta Q&A 7 10-14-2014 08:40 AM
Excel Data Import Sung Kim Q&A 2 07-16-2010 10:41 AM
Excel Tutorial - Need Input! Brandon Peterson Q&A 4 03-12-2008 10:54 AM
dbimporttable: importing date Lolke Koopmans Q&A 7 02-22-2008 05:57 AM
Excel and global tables Bill Nordgren Q&A 2 10-15-2007 04:36 AM


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.