Fixes and New Features in SIMPROCESS Release 5.3
- Java version updated to Java 8. This changed the JDBC driver requirements for MS Access databases. See the properties file in the DatabaseDemo directory. (DatabaseDemo.spm is an example model in the Demos directory.) Also, see the section SQL Tips in Chapter 2 of Part B of the SIMPROCESS User’s Manual.
- Corrected problem with automatic connection of Activities that prohibited automatic connection when adding a Activity or Process from a template library.
- Eliminated erroneous Attribute validation errors when using System Attributes in Functions.
- Since Java 8 removed the JDBC-ODBC bridge SIMPROCESS can only interface with MS Access database by using a JDBC driver. Thus, all references to Database Source Name (DSN) have been removed. Any existing DSNs should continue to function but that is not guaranteed. As of 5.3 a properties file must be used to establish connection with a database. SIMPROCESS includes a JDBC driver for MS Access.
- An issue with the fitting of Poisson distributed data by ModelFit has been corrected.
- File/Export/Activity List has been changed to File/Export/Activities with two menu items: Activity List and Activity By Type. The Activity By Type option allows the export of activity information by activity type to a .cvs or .xls file. There are also options to include other activity information. See the description in Chapter 1 of Part A of the SIMPROCESS User’s Manual.
- There is a new Report Menu item, Export Results, with three sub items, Database, Spreadsheet, and Simulation. The Simulation item was moved from the File/Export menu (and renamed from Simulation Results). The Database item facilitates the creation of Insert, Update, and Delete SQL statements for execution before, during, and after a simulation run. The Spreadsheet item facilitates the creation of output spreadsheets. See Chapter 4 of Part B of the
SIMPROCESS User’s manual for a full description.
- Generate Activities can now have multiple exiting Connectors. This includes a new Family Name field on the Generate properties. See the section Multiple Generate Connectors in Chapter 3 of Part B of the SIMPROCESS User’s Manual for details.
- There are new Expression statements. BasicDateTime returns the simulation date and time in the format MM/DD/YYYY HH:MM:SS. (DateTime continues to return the simulation date and time to nanoseconds.) GetInputSourceValue returns a value from File, Spreadsheet, and Database Input Sources. See Chapter 3 of Part A of the SIMPROCESS User’s Manual for more information on Input Sources.
- OpenSpreadsheet Expression statement now properly creates XML spreadsheets for output.
- The Layout Toolbar was renamed to Model Toolbar.
- Eight buttons were added to the bottom of the Model Toolbar. These buttons perform actions from the Define menu. The buttons are Define Entities, Define Resources, Define Resource Downtimes, Define Resource Shifts, Define Functions, Define Global Attributes, Define Model Expressions, and Define Time Stamps.
- The Gate Activity has a new Trigger Release option, Sequence Number. This option allows the release of a specific Entity when an Entity enters the trigger pad. The Entity to release is specified by the Entity’s sequence
number. See the discussion of the Gate Activity in Chapter 4 of Part A of the SIMPROCESS User’s Manual.
- A View Data option was added to the File, Spreadsheet, and Database Input Sources. This displays the requested input values.
- Meter graph on Dashboards was updated to use a dial plot.
- The Standard, Tabular, and Auto Fits options on the Distributions item of the Define menu have been removed. The Distributions menu item now displays a dialog for defining all three types of distributions.
- The File, Spreadsheet, and Database options on the Input Sources item of the Define menu have been removed. The Input Sources menu item now displays a dialog for defining all three types of input sources.
- Excel stores dates as a number representing the number of days since January 1, 1900. This number is returned when reading a Date/Time cell. The automatic conversion of this number to the format MM/DD/YYYY HH:MM:SS has been removed. There is a new Expression statement ConvertToDateTime that can be used to convert that number to a date/time string.
- New background images were added and some of the original background images were renamed. SIMPROCESS will still recognize older named images in models.