Extract data from industrial historians
Project description
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:
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for qt_data_extractor-0.2.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6e4e7a1098a82026d104003388d41a3bc832f0241bab50dadf35a4d0c8be280d |
|
MD5 | 9d16c6c305ac1a4628058e150e167fe5 |
|
BLAKE2b-256 | 5988e0dc51a040fcf2e01dd7164523dcb14d17de6741efff10aa7cf61dddb4ee |