Capturing Data from Files Using Parsely

Experimental data can be captured in Riffyn in multiple ways. Measure Mode can be used as the primary data capture tool by creating runs on each step, connecting runs to new runs on other steps, assigning resources, and manually entering data. Alternatively the experimental data might first be captured outside of Riffyn, in one or more files (or databases). These data sources can be used to populate experimental data in Riffyn.  

The tool to capture data from data file sources is called Parsely (as it "parses" data files). Parsely can be configured to extract data directly from a file and also saves parsing configurations for future file uploads.

To access Parsely, click either the file icon in the bottom bar (circled in red).

bottombar-file.png

or on one of the steps. 

step-fileindicator.png

The file icon will display on a step if a file has already been uploaded. If data is required to be uploaded for a step this can be indicated by right-click on a step.

The step that is highlighted in the design canvas at the moment when Parsely is opened is referred to as the "current step".

To begin the import process, browse the file system to select the Excel, CSV or Tab-delimited file with the data to upload. 

Once you have selected a file, Parsely will present you with your first set of choices:

1) New or stored configuration - To create a new configuration click "CREATE NEW" in the top right corner and enter a name for the configuration.

2) Reorganize stored configurations - The table in the middle of this modal initially contains a list of all the configurations that have been stored on the current step. Using a mouse will reveal three icons at right that allow the configuration to be duplicated, renamed, or deleted. Only the creator of the configuration is allowed to rename or delete the configuration.

3) Choose a configuration to use - The most recently modified configuration is selected by default and highlighted in blue. A different configuration can be chosen by clicking on it. Stored configurations for other steps can also be accessed by clicking the drop-down menu above the table of stored configurations. Another option is to write data to multiple steps from a single file using Collections of stored configurations.

4) Apply or edit the stored configuration - Selecting apply will immediately close the Parsely interface, and the data file will be processed. This option should be selected whenever a stored configuration has successfully been used previously and the structure of the data file (or template) has not changed. Selecting edit will allow a review of the parsing instructions and validation feedback prior to submission of the data file.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request