Jump to content
Simio Forum

Search the Community

Showing results for 'output table functions'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Simio Public Forums
    • Welcome and How To Become a Simio Insider
    • Discussions
    • Simio News and Announcements
    • Simio Product Details
    • Simio-Related Positions Desired or Positions Available
  • Forums for Simio Insiders Only (See Public Forums Welcome topic to sign up)
    • SI Help Getting Started
    • SI General Discussions
    • SI Downloads
    • SI Shared Items
    • SI New Feature and Enhancements Submission and Voting
    • SI Ideas & Suggestions
    • SI Bugs and Issues
    • SI Performance Tips
    • SI Challenge Applications
    • SI Non-US Cultures
    • SI User Interface
    • SI Material Handling
    • SI Student Competition
    • SI Educational
    • SI Objects
    • SI Animation and Visualization
    • SI Reporting and Analysis
    • SI Agent Based Modeling
    • SI Scheduling
    • SI Emulation
    • SI Optimization
    • SI API


  • Simio Calendar


  • Files
    • Academic Information
    • Product Information
    • Case Studies

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



About Me












  1. Hi all, This one has been confusing me for a few days now. I'm busy building a large 200+ task process, using Task Sequence. For 95% of the tasks, task predecessors are used, and it works fine. However, some tasks can only start after x days. For example, task 5 requires task 4 to be complete & can only start after 4 days. I've tried looking for a place to put this. Things I've tried: 1. Branch type in Task info, where the condition is: "TimeNow > ModelEntity.TimeCreated + ProcessingTasks.Delay_Days" that checks if the current time is more than the initial start of the
  2. Assuming you are are using the prebuilt task sequencing logic in the server you could just add an add-on-process either after the predecessor task or before the successor task that delays for the given amount of time. If you are using a table to read these tasks add a column for the delay, make a model level process with a delay value of TaskTable.Delay. Then reference this process in the Before starting task or after completing task of the task sequence.
  3. Hi everyone, I have a question about the object created by the create step. In the attached sample model, I have two types of modelentity: Order and Item and three data tables: Orders(has primary key), Skus(has primary key), and Order_Item(has foreign keys of Orders and Skus). There is a source object which create Order entity based on the table Orders. When the Order entity enters the output@Source, I use an add-on process to create an associated object entity Item based on the Order_Item table. Then, the Item entity is transfered to a TransforNode and its destination is set based
  4. I need a way to access the worker seized for a given task in a task finished triggered add-on process. part of the functionality I am trying to achieve is when a specific task is done (not the last task) I want to assign that worker as to a ModelEntity.TransferWorker, reserve them, and use the worker to transport them (referencing ModelEntity.TransferWorker in the output node) Information about setup: Multiple tasks being assigned at once, this prevents ModelEntity.SeizedResources.LastItem from being useful Task resource is chosen from list, which differs for every task,
  5. How do I access a table column by name using a table property defined for the model? In my model, I have multiple data tables each with the same named columns defined for each. Each table has a different number of rows. For a run or a set of replications, I want to select a table to use. I have defined a model-level table property named _SelectedTable to support this. During simulation runs, I want to access this selected table's data by row and column name. Specifically, I want to use this data to update model entity state variables. I also want to stop creating entities when all of t
  6. Hi there I have been struggling with a problem whereby I need to determine the sum of all values in a table column (optionally given some criteria like Excel's 'SUMIF' function). This seems like a really simple problem but there appears to be no functionality to do this. If there is, please could someone point me in the right direction? I have gone as far as trying to write a process to perform this but it seems overkill for such a trivial operation. Thanks E
  7. I have a data table which has several rows that contain node and some other infomation. I want to move a transporter to a node in that data table and park at that node. Now I have my model and data table like this: In this model, when I click the move button, Myvehcile1 will move to TransferNode1 or TransferNode2( depend on some inputs for Myvehicle1). The problem is because I don't create any ModelEntity, I seize Myvehicle1 by itsself. So, Myvehicle1 is in its visitrequestqueue and it will never stop at a node and it keeps moving between nodes. Below is the process I create to find
  8. My model currently reads tasks from a table and I am trying to model material consumption. For each task there are groups of materials: A, B, C, and priority values: 1, 2, 3. To complete a task, only one material type from each group A, B, and C must be consumed, and the order they are consumed in should be based of the priority. For example, if task one had entries like the table below, if all materials were available, materials 1,4,6 would be consumed. If material 1 was no longer available materials 2,4,6 would be used, and if material 6 was not available the task could not be done. The m
  9. Hi Folks, We have a data driven model where entities require a value from a table with n named columns. For example, consider the column names might be "Group1", "Group2", and "Group3". For each randomly selected entity classification based on a random row for example, we wish to randomly select which column to grab a numeric value for that type entity. Each Type has a unique distribution of amounts in the table. Suppose an entity has a string state called MyGroup, and I set that value. For example ModelEntity.MyGroup could be set to "Group1". Is there a way to use th
  10. I am interested in using task sequencing reading from a data table to solve my issues with multiple tasks being done by different workers at the same time and task precedence. After looking at the simbit related to it (TaskSequenceandWorker) I did not see a way to add probabilistic and conditional columns like when it is done directly into the server. Also is there a way to have a column for entity types and have it only reference rows that are assigned to them.
  11. Let's see if I can elaborate... The following outlines the relevant characters in simio file "table_selection_by_name.spfx." Model->Definitions: Properties: OptionId (Entity Property, default=null) _SelectedTable (Table Property, default=tableOption1) States: RowId (integer, default=1) maxEntities (integer, default=2) ModelEntity->Definitions: States: _id (Integer, default=0) row_num (integer, default=0) temp (integer, default=0) Model->Facility: ModelEntity Types: Option1, Option2 Source1, Server1, Sink1 S
  12. I'm using Simio 12.205 and I'm trying to import data into a table from a MySQL database using a data connector. I am aware of the Simbit DBReadWrite example that uses a process to access the data. That is not what I am trying to do. Specifically, I have a Temperature table in my database containing a sampleId (primary key) and a sampleValue. I would like to read the sample values into a Simio table column named TempSample. Refer to the attached screenshot. The area of concern is circled in red. I've successfully connected to my database. However, I don't know how to define a SQL q
  13. I figured it out. The Data Object is the name of the table , view, or a stored procedure in the database.
  14. We are currently working on entity routing through a medical facility. There are individual servers that represent areas within the facility where patient type, current location, probability, and destination (Input node of next server) are all in one table as one column each. After processing we want to subset the table to only have the specific ModelEntity type, correct current location, and then use TableName.ProbabilityColumn.RandomRow on the subset table to find the destination location. We have not found a functional way to subset the table.
  15. If you are binding a table to SQL Server Express, use the following connection properties If using SQL Server Security, you can specify the server name, database name, user id and password in the fields that are provided. If using Windows security, use a custom connection string. In the connection string, specify the server (e.g. Server=.\SQLExpress), database (e.g. Database=MESDB) and Trusted_Connection=True
  16. Fernando, I'm curious as to whether you and Glenn ever resolved these issues... It's been over 3 years at this point. For what it's worth, I searched for MS-SQL connection string and found this site with various examples: https://www.connectionstrings.com/sql-server/ I'm assuming and hopeful that you did resolve your issue. Thus, I want to ask some follow up questions. Once you connected, how did you did you pull data from your database--did you use an add-on process or did you import it into a table? If you used a table, how did you construct our SQL query? Ryan
  17. Dear all, it seems I have the same issue with multiple entities and requirements for multiple paths in the sequence table. I would be very happy to have the solution shared with me. Kind regards, Harald
  18. Hi, You can do what you're after using a search step. See screen grab and attached project file (Simio version 12.208.20871) Regards, Lucas Table Row Sum.spfx
  19. You can use SetRow step in process logic to set a specific row reference in each table. If you don't know the specific row in each table then you can use Search step to find a row in the table and then use SetRow. Once you do SetRow, you will have row reference to the table. If you have conflicting row references then you may have to cancel previous row references when you do set row. You can do that using Advanced Options on the SetRow step.
  20. Hi All,


    I am trying to look as to how can we create experiments with various schedules in the SIMIO experiment tab.

    Currently I am not using RPS version.

    I have created a schedules for various servers using Simio process logic and schedule table for each server.  I am able to run one schedule and see the resulting performance, but it would be interesting to see how the changes to the sequence of orders changes the performance.  How could I set up experiments to make changes to the sequences in the tables?

  21. Is there a way I can concatenate string in table for e.g. Col 1 of table 1 has name "Simio" Col 2 of table 1 has name "Simulation" I need to create col 3 in table 1 that says "Simio-Simulation" One way is I do it outside Simio and then import but don't want to do that
  22. Hi all, I made a model of a production line (starting with 2 servers) and I am wondering whether it is possible to change the processing time of the second server based on the actual output of the first server. Theoretically seen the processing time of the server 2 = Speed of server 1 * E , in which E is a fixed formula (connected to server 2) to correct the speed. So if the first server performs according to expectation (without failures) for example 40 the processing speed of the second server is equal to 40*E with a delay of the conveyor time between server 1 and server 2.
  23. Hi Jim, Unfortunately, at this time, there is not a way to reference a column name with a string variable. The column needs to be directly specified by name (like MyTable.ColumnName) or you could specify the cell by the table row and column index (like MyTable[RowIndex, ColumnIndex]). The indexes can be State Variables that evaluate to an integer. The caveat is that you can not just specify the column index, the row index needs to be there as well. So assuming you can assign the row, one approach to consider is creating an integer State Variable to save the column index. A Math.If expres
  24. ~Created 4 entities of the same type-- let's call them EntBB-- with a run initialized process. Had them transferred into a server-- let's call it SrvBB-- output buffer. ~Worker goes and picks up one of those entities and takes to transfer node-- let's call it nBBRouter-- where that particular entity that the worker is carrying should be destroyed. nBBRouter_Entered Process Destroy step: specific object: EntBB[1] SetNode step: specific: Input@Sink1: specific object: Worker1 My problem: the first time around does what I want, but the second time around it
  25. Hello! One suggestion is to use Key/Foreign relational tables to accomplish your goal. If you have a table that defines your unique entities, you could then set the entity column as a Key. In the Task Sequence Data Table, you could then add the Foreign Key column to specify which rows pertain to the specific entity. This could limit which rows in the Task Table the Entity will have a reference to. Happy modeling, Liz
  • Create New...