Skip to main content
Skip table of contents

External Data Generator

image-20240222-181020.png

Generators have an option to be defined by data imported from an Excel sheet.

The Excel sheet should have a column labeled Time that specifies when cases are generated.

If there is a Count column, that specifies how many cases are generated at that time. If not, 1 case will be generated each time.

Any other columns will set the value of case variables for the generated case(s). In the example below, the case variable “x” will be set to the values in the column.

The Time column is the only column that is not optional.

image-20240222-181513.png

Selecting a file makes a dialog appear. Click “Add” to add the data. If the data is in an incorrect format, a different dialog will appear. Note that even though Excel may display times in a different format, ISO format times following “yyyy-mm-dd hh:mm:ss” will not cause formatting errors.

image-20240222-182004.png

Once the data is added, scroll down to see the entries.

image-20240222-182121.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.