How to use Win2Parser & Parser add-on? - LabCollector

Search Knowledge Base by Keyword

You are here:
← All Topics

LabCollector offers the possibility to automatically import data files from your Windows computer into your instance with the help of Win2Parser middleware.

Win2Parser is a Windows middleware utility allowing automation of raw data file acquisition from multiple locations into LabCollector. Each instance can monitor multiple folders allowing dedicated parsing logic. It connects to the Parser add-on or to any customized parsing script hosted on LabCollector server.

Win2Parser provides an interface to select a folder from your windows computer for LabCollector to parse files from. Data is extracted from various electronic file types such as txt, csv, and others. For example, Win2Parser can be used in a test lab to extract a list of samples data (.csv file) and import it directly into the Samples module . LabCollector will parse (split & extract) data from the excel file to import individually, sample IDs, patient names, tests and other parameters to insert them in the fields created inside the module.

Follow the bellow steps to learn how to use Win2Parser and the Parser add-on.

1. Win2Parser

2. Parser add-on

3. Link Win2Parser to the Parser add-on

1. Win2Parser

Win2Parser provides an interface to select a folder to parse files from and options to indicate which parser model is associated to which folder. The Parsing actions can be started or stopped, logs may be viewed, and folder details can be created, edited or deleted.

Down below is a screenshot of the Win2Parser Homepage.

A: Here you can add new folders to parse, edit or delete already added ones.

B: Here you will see the full list of all folders you added to Win2Parser and their corresponding details.

C: You can choose whether you want to Start or Stop sending your folder(s) to the specified URL. If you click on Start, the service status below will display running. And when you click on Stop, it will display stopped.

D: Win2Parser allows you to see logs containing changes done to your files, here you can see a history of all messages, timestamps and their status. Once you finish, you can click on “Done“. 

Down below is a screenshot of the Win2Parser Configuration page, which you can access by clicking on the “New” button on the Homepage.

A: Here you can choose and select the folder you want to parse by clicking on “Browse Folder“.

B: Here you need to define the URL to which your folder and all added documents will be sent, you can find this URL by clicking on Model List inside the Parser add-on, and then click on the following icon found in the Actions column (as shown in the screenshot below).

C: Define the number of retries, which corresponds to the number of parsing attempts that will be done.

D: Select the action you want to get executed in case your folder failed to upload to the specified URL, whether you want to rename it, delete it, or move it to failed folder.

E: Select the action you want to get executed once your folder get successfully uploaded, whether you want it to get deleted, or moved to the success folder.

2. Parser add-on

To input your Parser license number, all you have to do is click on Setup, then License. You will get the following page.

A: Here you can see your activation key.

B: Your current License will be displayed in this box (if you already have one).

C: Here you can input a new license number, once finished click on Submit.

You can also set-up email alerts, this will help you receive notifications in case a file parse fails. To do so, click on Setup, then Email Alerts Setup. You will get the following page.

You can also view the whole file parsing history containing all files, their status and the corresponding remarks. To do so, click on “File Parsing History“.

If you decide to perform a Manual Execution, click on the button on the top right corner, you will then get the following page.

You can then click on any folder and upload the files manually.

You can also view the List of Templates/Models that are already used. To do so, click on “Model List” located in the top right corner, here you will see a list of all parsing models. Plus, users with an authorized permission level will be able to edit existing ones.

3. Link Win2Parser to the Parser add-on

In order to Add or edit a new model, you will have to click on “Add new model” located on the top right corner. Once done, you will get the following page.

After giving your template/model a name, you can now select Win2Parser amongst other options as your file source. (See screenshot below for the full list of file sources that you can select).

Once you select Win2Parser as your File Source, other options will appear in the list. (As shown in the screenshot below).

A: Input your LabCollector API token.

B: Select the module to which you want the files to be sent.

C: Here you can choose to update already existing records and add new ones or ignore them if they weren’t found inside the module.

D: You can also select the file type you want to parse, down below is a screenshot will all available options.

E: Choose whether or not you want to create a drop files folder.

Related topics: