User / Examples / Building Workflows With Excel / Uploading To Existing Workflows

Uploading to Existing Workflows

Last updated on 29-Aug-2018 by Thomas P. Boesen
Thomas P. Boesen

Founder
boesen@scifeon.com

In the previous tutorial we learned to change the input and output data of steps using the Scifeon Builders.
Until now, we have focused on creating new experiments. We might, however, want to add new information, such as results arrays, to already-existing workflows.

1. A New Workflow Format

Previously, we have always had experiment written in the top-left corner of our Excel worksheet (cell A1*). This prompts the creation of a new experiment in the database.
To upload data to workflows already in the database, we write *Upload
instead.
It is still important that the sheet is named Scifeon.

2. Uploading Results Arrays

It is very easy to upload a results array:



The Excel file looks almost the same as it did when we uploaded results straight away*. The *Results keyword requires an [array] tag defines the data array to be uploaded while the Step keyword tells Scifeon which step in the database to latch the data on to.
If you would like to try it out for yourself, the experiment file can be found [here](./Demo 4 Result Upload 1.xlsx) and the upload file [here](./Demo 4 Result Upload 2.xlsx).

3. Uploading Platelayers

Uploading new platelayers is just as easy as results arrays:



Once again, the Excel file looks very similar to the experiment setup file: The Readings keyword has a [PlateLayer] tag and defines the data matrix while the two properties Step and Plate identify the connecting entities in the Scifeon database. If you would like to try it out for yourself, the experiment file can be found [here](./Demo 9 PlateLayer to RS 1.xlsx) and the upload file [here](./Demo 9 PlateLayer to RS 2.xlsx).

4.

Note that step names are not necessarily unique in the database: make sure your entities end up with the right experiment.