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 Sales and Services > Pre-sales Questions
Downloads

Pre-sales Questions Want to know more about Flexsim? Ask our existing users!

  #1  
Old 12-17-2008
Unregistered
Guest
 
Posts: n/a
Downloads:
Uploads:
Post Data integration

If I have a lot of master data already, can I import/export that data to Flexsim rather than recreate the data through manual input? XML? Webservices?
  #2  
Old 12-17-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

There a lot of ways to get data into Flexsim:

1 Copy paste into the tables of flexsim from Excel
2 Import from Excel with OLE or DDE
3 Import from a flat text file
4 Import from a database with ODBC

Use imagination and C++ to create any other way possible.

Steven

Last edited by Cliff King; 01-17-2009 at 07:35 PM.
  #3  
Old 07-24-2010
Congshi Wang Congshi Wang is offline
Student
 
Join Date: May 2010
Location: Germany
Posts: 58
Downloads: 2
Uploads: 0
Thanks: 48
Thanked 0 Times in 0 Posts
Rep Power: 124
Congshi Wang is on a distinguished road
Default Import from a database with ODBC

Hello Steven,

can you please tell me how to import data from an access 2007 database to flexsim? Thanks a lot!
  #4  
Old 07-24-2010
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

Like Steven and Cliff state, there are a number of ways and I think it might be your skill set that determines which will be easiest for you. One way (the one I use) is to set up user or system Data Source Name (DSN) to your database. Then use the commands prefixed with 'db' to read and write data:

dbchangetable
dbclose
dbexportnode
dbexporttable
dbgetfieldname
dbgetmetrics
dbgetmode
dbgetnumcols
dbgetnumrows
dbgettablecell
dbgettablenum
dbgettablestr
dbimportnode
dbimporttable
dbopen
dbsettablecell
dbsettablenum
dbsettablestr
dbsqlquery
dbusername
dbviewtable
dbwritechanges

These are described very well in the Commands help. There are two modes of use - table mode and query mode, as determined by the way you open the connection using dbopen(). I'm an SQL guy so that's the mode I find easiest.
The Following User Says Thank You to Jason Lightfoot For This Useful Post:
Congshi Wang (07-26-2010)
  #5  
Old 07-25-2010
Tom David's Avatar
Tom David Tom David is offline
Flexsim User
 
Join Date: Aug 2007
Location: Schwaebisch Gmuend, Germany
Posts: 430
Downloads: 157
Uploads: 47
Thanks: 486
Thanked 450 Times in 233 Posts
Rep Power: 520
Tom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant future
Default

There is a little example model I uploaeded some time ago as an example to prevent questions regarding the database connection ...

Here is a link to the model Sample_Database_TD.

Please see the description for further information.

Note:
Be sure there is an alias (Sample_Database_TD) created for the database. This is done using the "Data Sources" option in the Windows Control Panel.
In German Windows XP this is done under: Systemsteuerung | BDE Administrator or Systemsteuerung | Verwaltung | Datenquellen (ODBC).
In German Windows Vista this is done under: Systemsteuerung | Verwaltung | Datenquellen (ODBC) or if using Vista 64bit in the Explorer under \Windows\SysWOW64\odbcad32.exe.

I hope this model helps. I am not a database expert, so I use the table mode, which works for me.
__________________
tom the (A)tom: "We have solved our problems ... now we have to fight the solutions."
The Following User Says Thank You to Tom David For This Useful Post:
Congshi Wang (07-26-2010)

Tags
None



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.