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
FAQ Downloads Calendar Search Mark Forums Read

Q&A Using Flexsim and building models

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2007
Lolke Koopmans's Avatar
Lolke Koopmans Lolke Koopmans is offline
Talumis, Flexsim Distributor, The Netherlands
 
Join Date: Aug 2007
Posts: 42
Downloads: 21
Uploads: 0
Thanks: 24
Thanked 14 Times in 10 Posts
Rep Power: 161
Lolke Koopmans is on a distinguished road
Default importtable() csv-file

I use the advanced-window of the global tables to import a csv-file (which I previously exported from flexsim).
The number of columns become much more then in the original csv-file.
It works fine with a table with a few rows, but if the file becomes longer, more empty columns are created.
When loading more then 10000 rows, Flexsim hangs.
Any suggestions or work-arounds??


regards,
Lolke
Reply With Quote
  #2  
Old 12-13-2007
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: 162
tobias.biemueller is on a distinguished road
Default

Hi Lolke,

i am not sure if this is the same problem, but maybe it is.
To import ASCI Files we have written a import logic. The problem in this case was that the logic everytime add a new row in the table, if its found a new line in the ASCI File. If you have a File with less than 1000-2000 lines, its no problem, but if you increase the lines than Flexsim seems like hanging up. A few minutes later change it from "Hang up" to normal and the import was complete. So my opinion was, adding nodes take a lot of time. What i have done is, i expand the logic to count the lines, set the global table to the size i want and then copy the data out of the ASCI File. This decrease the amount of time for each import from 10-30 min to 10-15 sec. (Files with 18000-25000 lines).
The only defect of this is the c code you need for
Hope this helps a little bit, and sorry for the bad english ^^

Tobias
Reply With Quote
  #3  
Old 12-14-2007
Lolke Koopmans's Avatar
Lolke Koopmans Lolke Koopmans is offline
Talumis, Flexsim Distributor, The Netherlands
 
Join Date: Aug 2007
Posts: 42
Downloads: 21
Uploads: 0
Thanks: 24
Thanked 14 Times in 10 Posts
Rep Power: 161
Lolke Koopmans is on a distinguished road
Default

Thanks for your answer Tobias!
I was thinking at importing it line by line as well. However I do not want to use C++
Does anyone know if there is a bug in importtable???
Reply With Quote
  #4  
Old 12-26-2007
Cliff King's Avatar
Cliff King Cliff King is offline
Vice President Technical Services
 
Join Date: Jul 2007
Location: Utah
Posts: 272
Downloads: 158
Uploads: 14
Thanks: 102
Thanked 304 Times in 110 Posts
Rep Power: 409
Cliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud of
Default

There will be more flexscript commands available in v4.3 to work with text files. In the mean time, the only text file read command available is importtable and importdataset, and it looks like it has bugs. I'll add this to the Known Issues list.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 05:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Copyright 1993-2018 FlexSim Software Products, Inc.