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?

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

Hello Steven,

can you please tell me how to import data from an access 2007 database to flexsim? Thanks a lot!

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.

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.