qt-data-extractor 0.3.0

Extract data from industrial historians

Industrial Data Extractor

Industrial Data Extractor is an open-source Windows application to extract process data from industrial systems and historians.

The following systems are currently supported:

• Osisoft PI

It supports browsing and selecting tags on the target system and extract periods of data into zipped CSVs.

Installation

Please use https://github.com/imubit/qt-data-extractor/releases to download the latest version of the extractor.

If you would like to extract data from Osisoft PI historian (which is the only one supported at this point). Please make sure you have PI SDK and AF SDK installed and configured on your workstation.

Getting Started

• Configure the target historian using Server drop down.
• Using left panel filter editor to browse for tags or import an Excel sheet with a list of tags.
• Select tags you would like to extract on left panel and add then to the right panel with Add to Selected Tags button.
• Select a period to be extracted and sample rate (use Raw Data option to extract the original sample rate that is stored within the historian).
• Select Save Directory in which your archive will be populated.
• Click Extract and confirm your selection.
• Wait until extraction is finished.

Development

Python Install

pip install qt-data-extractor

Running under CLI

PS C:\> qt-data-extractor

• If the application is not starting this way, Python Scripts directory is probably not in the PATH. In this case you can run the script from Python installation directory (i.e. c:\Python\Python39\Scripts\qt-data-extractor.exe)

Building Windows Executable

pipx run tox -e winexe

Building MSI Installer

Install environment

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco install -y go-msi

Build MSI

go-msi make --msi dist\windows-msi\ --version 0.1.1