Metadata-Version: 2.1
Name: qt-data-extractor
Version: 0.2.2
Summary: Extract data from industrial historians
Home-page: https://github.com/imubit/qt-data-extractor/
Author: Meir Tseitlin
Author-email: meir@imubit.com
License: LGPLv3
Project-URL: Documentation, https://github.com/imubit/qt-data-extractor/
Project-URL: Source, https://github.com/imubit/qt-data-extractor/
Platform: any
Classifier: Development Status :: 4 - Beta
Classifier: Programming Language :: Python
Description-Content-Type: text/markdown; charset=UTF-8; variant=GFM
License-File: LICENSE.txt
Requires-Dist: pandas
Requires-Dist: openpyxl
Requires-Dist: PySide6
Requires-Dist: data-agent >=0.2.0
Requires-Dist: data-agent-osisoft-pi >=0.3.0
Requires-Dist: data-agent-zip
Requires-Dist: importlib-metadata ; python_version < "3.8"
Provides-Extra: testing
Requires-Dist: setuptools ; extra == 'testing'
Requires-Dist: pytest ; extra == 'testing'
Requires-Dist: pytest-cov ; extra == 'testing'
Provides-Extra: winexe
Requires-Dist: pyinstaller ; extra == 'winexe'

<!-- These are examples of badges you might want to add to your README:
     please update the URLs accordingly

[![ReadTheDocs](https://readthedocs.org/projects/qt-data-extractor/badge/?version=latest)](https://qt-data-extractor.readthedocs.io/en/stable/)
[![Conda-Forge](https://img.shields.io/conda/vn/conda-forge/qt-data-extractor.svg)](https://anaconda.org/conda-forge/qt-data-extractor)
[![Monthly Downloads](https://pepy.tech/badge/qt-data-extractor/month)](https://pepy.tech/project/qt-data-extractor)
[![Twitter](https://img.shields.io/twitter/url/http/shields.io.svg?style=social&label=Twitter)](https://twitter.com/qt-data-extractor)
-->

[![PyPI-Server](https://img.shields.io/pypi/v/qt-data-extractor.svg)](https://pypi.org/project/qt-data-extractor/)
[![Project generated with PyScaffold](https://img.shields.io/badge/-PyScaffold-005CA0?logo=pyscaffold)](https://pyscaffold.org/)

# 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](https://github.com/imubit/data-agent-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](https://techsupport.osisoft.com/Products/PI-System-Access/PI-SDK/Overview) 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

```python
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

```bash
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
```
