Page 798 - ExtendSim User Guide
P. 798

Data Management and Exchange
Blocks for data management and exchange
• TheExtendSimDBAdd-in,whichallowsanexportedExtendSimdatabasetextfiletobe imported into Excel. The data can then be stored in Excel, edited and exported to an external database, or edited and exported back to ExtendSim as a database text file.
• Import Data and Export Data commands in the File menu to create text files that can be imported into a spreadsheet or to import a text file that has been exported from a spread- sheet. For more information, see “Importing and exporting data” on page 734.
• OLEandIPCfunctionstofacilitateDDEorActiveX/COM/OLEcommunicationwith spreadsheets. For more information, see the Developer Reference.
External databases
In many situations, the historical data for a a model is stored in an external database. Extend- Sim models can share information with external database applications:
• WiththeDataImportExportblock(Valuelibrary)tosenddatatoorfromADO-compliant database applications. This block can import a block of data to, or export a block of data from, an ExtendSim database or global array. See “Data access blocks” on page 781.
• ByusingExcelasanintermediaryapplicationbetweenanExtendSimdatabaseandanexter- nal database. In this case, the data is imported from the external database to Excel, where it is manipulated. The data is then exported from Excel to ExtendSim as a database text file using the ExtendSim DB Add-in.
• UsingADOfunctionstoinitiateanSQLqueryorperformotherfunctions.Formoreinfor- mation, see the Developer Reference.
Blocks for data management and exchange
Several ExtendSim blocks facilitate data storage and management. Some are used to establish and control dynamic links between ExtendSim and internal or external sources. Others are use- ful for importing or exporting data between ExtendSim and external applications.
In general there are several uses for data management and access blocks:
• Sharinginformationbetweenblockswhenadirectconnectionbetweenthemisinconve- nient.
• Storing information which can be accessed by a row and column index.
• Accessing existing spreadsheets, either embedded in the model or imported as a file.
• Accessing existing databases using ADO or ODBC/SQL.
• Accessing internet-based data.
Most of the following blocks allow block-level access to data structures without having to pro- gram with the ModL functions. An additional group of blocks are designed to help block developers, serving as templates for custom-built data management blocks.
How To

   796   797   798   799   800