Jump to content
Simio Forum


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About sparakh


  1. Its been a mildly annoying for a few years now. Every time we add a new property, state variable, object, table column....we have to give that property a Name and a Description but the 'General' category is right at the bottom and is closed. All the other <10% used categories are 'expanded' and on top of the listing. Can someone at Simio just change the order of the 'General' category to bring it right to the TOP and have it expanded by default. This will save us a whole bunch of clicks over our lifetimes Much Appreciated!
  2. sparakh

    Enhance Original Token Branch Flow

    I agree. Related to this request, a generic feature that would go hand-in-hand with Amy's request is the ability for inter-token relationship / communication. For example, if a Search step ran against a data table spawned 3 child tokens each validating data in their respective rows, we want the ability for the child token to pass any information (boolean, real, dates, objects) back to the parent token on the results of the search result branch. Currently the alternative is create 'global variables' at a model level, which is bad design, to allow the parent token to make decisions based on child tokens results. This is especially useful in writing compact code when we are trying to aggregate information in a data for statistics reporting. For example, if a table column contains 3 'True' and 4 'False' values, the current Search step's 'Search Expression' property only returns the sum of the expression for the found items in the ReturnValue state of the token. There is so much more we can use the Search step for beyond spawning independent parallel processing.
  3. sparakh

    Reading and setting nested states

    Good question. Anyone find the answer to this previously posted question?
  4. sparakh

    DB Read and DB Write Steps Example

    I ran into a problem with writing data to a MySQL database table from Simio. The issue was MySQL was complaining about the String representation of a node (Node.Name) that I was trying to write to a VARCHAR() type database column using the DBExecute Step (using native sql in the SQL Statement). The error was something on the lines of "Unknown Column in field list". Found the answer on a mySQL posting. The solution is to surround the String value with a single quote (') character when writing it out to using a DBExecute statement. MySQL thinks it reading a column name instead of an actual value (wierd!). For instance, if I wanted to write the String "ABC" to a VARCHAR column, I should instead write "'ABC'" (adding a single quote on either sides of the String). If I wanted to write the Node name to the VARCHAR column, I should write "'" + Node.Name + "'" I thought this might be helpful and save others valuable time debugging.
  5. sparakh

    Better Functions / Process Logic Calls

    I would like to request the following enhancements to Custom Tokens that will help us write better OO code : 1. State References: ability to carry a reference to a State variable very similar to what is available in Data tables. For instance, if we have a State variable State1 defined in the model, I would like to pass a reference to that global state variable into a process as argument such that the generic process does not need to hard code the name of the global state variable that it needs to modify. 2. List References: ability to assign a reference to a List to a custom token. For instance, if I have 3 different Object lists in my model each populated with different objects. I would like to invoke a generic process that takes a List as an argument such that this generic process can execute Seize From List. 3. Event References: Currently Custom Tokens do not have the ability to save a reference to an Event in the model. I do not think the Element reference on a custom token can be used for Events. Thoughts?
  6. sparakh

    Link LookupTables to Excel

    Good morning. While we are on the topic of Lookup tables, I would like to mention that there have been a few occasions where I needed a simple kind of lookup that did not need extra/intra-polations between non-numeric X,Y values. For example, X (of type String) Y (of type String/Integer/Entity etc...) ---------------------- --------------------------- "Large Bin" "Forklift" "Small basket" "Person A" I would like to lookup the value 'Forklift' if the x value is "Large Bin", in mechanism similar to how values are looked up currently using Lookup Tables, i.e. Table["Large Bin"] returns "Forklift". I think we can take this further and build it as a search feature in a regular data table. Table1 X (PK) Y (of any type) ---------------------- --------------------------- "Large Bin" "Forklift" "Small basket" "Person A" The way to use this search feature in an Expression would be something like, Search.Table1["Large Bin"].Y which returns the value "Forklift". I think it will reduce the need to rely on a Process everytime we need to look up a value in a table based on a Primary Key. The added benefit is that we can then extend this to search other columns as well. For a query performance standpoint, I think the cost should be comparable to the current Search step. Thoughts?