Processing Data in Different Applications with LabOne Net Link

Many HF2 and UHF users take advantage of the API provided by Zurich Instruments to program in Matlab, Python, Labview and C to record data from the HF2 and UHF devices. Both HF2 and UHF also provide the possibility to stream out demodulated data in CSV format, while the UHF users can even enjoy the convenience of streaming out data directly in Matlab MAT-file format. Nevertheless, we sometimes get requests from customers to be able to record data directly inside other programming platforms such as Visual Basic or C Sharp (C#).  Up until now, the standard response to these ZI customers would be for them to first save the CSV data in the graphical user interface and then load the CSV data in the desired platform.

Since LabOne software release 14.02, loading measurement data has been made much more convenient and transparent not just for Matlab and Python users, but also for other data processing tools including C#, Igor Pro, Origin, and even Excel which supports the Visual Basic language. As a matter of fact, one can now use a new feature in LabOne called LabOne Net Link to read the cursor data through an URL link from LabOne to another application, all without opening up the CSV files manually.

Where to find LabOne Net Link

Basically any LabOne tool tabs with Math functions (i.e. Scope, Sweeper, Plotter, Boxcar, Output PWA) contains the LabOne Net Link function. Take the Scope tool as an example. One can find a Link button in the bottom right corner of the Math sub-tab. By clicking on the button, a link address will be given by LabOne which then can be used to call up selected cursor data in another application.

 

Live Link in Scope

How to set up LabOne Net Link

To select the measurement cursor data to be streamed out, one simply has to position the cursors to the desired position and then select the functions in the Math sub-tab. In the example above, the distance between two sine wave peaks (i.e. X2-X1) and the maximum peak value (i.e. X2-X1) are added to the Math dialogue box. When this is done, one simply press on Link to get the assigned URL as below.

LiveLink

 

LabOne Net Link example using Excel

The instructions for how to link to LabOne data can be founded by clicking on the Help button as shown in the screenshot above. For those who do not have LabOne installed, here is an example of how it works in Excel 2010.

In Excel, click on the cell where the data is to be placed. From the Data ribbon, click the “From Text” icon. The “Import Text File” dialog will appear.

filename

 

Copy the URL into the File name field and click the “Open” button. This will start the text import wizard. Ensure that the “Delimited” buttion is checked before clicking the “Next” button.

 

csv_1

In the next dialog, select the delimiter character corresponding to that selected in LabOne. The default is semicolon. Click the “Next” button. In the next dialog, click on “Finish” and then “OK” in the “Import Data” dialog.

csv_2

 

The data from the Math tab will now appear in the Excel sheet as shown below. Now, one can see that the original selected calculations are now displayed in an Excel worksheet. To obtain an update, click simply on the “Refresh All” icon. The “Import text file” dialog can be suppressed by clicking on “Properties” and deactivate the prompt for file name each time. From there, one can perform more complex data analysis through the Excel functions. Automatic update can even be performed using the Visual Basic programming within Excel.

Excel

 

Conclusion

LabOne Net Link is a very convenient way to automatically process  a CSV file containing the output data from the different LabOne tools. More than that, it can be pretty much used in any software that can read an URL link which contains address of the LabOne output data socket. Having said that, LabOne Net Link is not meant to be a high speed output of the demodulated data since the readout by a software is very slow. For fast and large demodulation data transfer, one still needs to use the Record function in the LabOne Config tool tab.

 If you have advanced codes for Matlab, Python, C# .NET, Igor Pro, Origin, or Excel (Visual Basic) that can read LabOne Net Link directly, please feel free to share them here with other LabOne users.

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>