4. Advanced installation procedure

4.1. Prerequisite

OpenLog requires the following general dependencies to be met:

Python 3.12
Python packages: psycopg2, pandas, sqlalchemy, GeoAlchemy2, xplordb, pyqtgraph, numpy
Python optional package : pyodbc

When running a xplordb database, the following additional dependencies shall be met

PostgreSQl 12+
PostGIS 3

Once the dependencies have been met, execute the following steps:

go to Plugins -> Manage and Install Plugins -> All
search for “OpenLog”
hit Install Plugin.

4.2. Direct dependency installations

4.2.1. Linux

Note

Tested against Ubuntu >= 24.04

4.2.1.1. Python system [Linux]

To install Python, run:

sudo apt-get install python3 python3-pip

4.2.1.2. Python mandatory packages

OpenLog - QGIS Plugin depends on several python package :

Package	Website	Description
`pandas`	https://pandas.pydata.org/	Data analysis and manipulation tool
`psycopg2`	https://www.psycopg.org/docs/	PostgreSQL database adapter for Python
`sqlalchemy`	https://www.sqlalchemy.org/	Python SQL Toolkit and Object Relation Mapper
`GeoAlchemy2`	https://geoalchemy-2.readthedocs.io/en/latest/	sqlalchemy extension for spatial database (Spatialite and Postgis)
`xplordb`	https://gitlab.com/geolandia/openlog/xplordb	Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS
`pyqtgraph`	https://pyqtgraph.readthedocs.io/en/latest/	Data visualization library for Python using Qt GUI
`numpy`	https://numpy.org/	Python package for scientific computation
`pint`	https://pint.readthedocs.io/en/stable/	Python package for units definition
`setuptools`	https://setuptools.pypa.io/en/latest//	Python packaging toolkit
`chardet`	https://chardet.readthedocs.io/en/latest/	Character encoding
`pluggy`	https://pluggy.readthedocs.io/en/latest/	Function hooks
`py-machineid`	https://github.com/keygen-sh/py-machineid	Machine ID extraction

To install the above packages with appropriate versions, run:

pip install --no-deps --force-reinstall --break-system-packages -U chevron "sqlalchemy>=1.4,<2.0" "GeoAlchemy2>=0.13.3,<0.14" "pyqtgraph>=0.13.3" "xplordb==0.13.8" "pint>=0.24.4" pluggy py-machineid mplstereonet flexparser flexcache typing-extensions platformdirs

4.2.1.3. Python optional packages

Package	Website	Description
`pyodbc`	https://github.com/mkleehammer/pyodbc	Python module for ODBC database access, required by `sqlalchemy` for MSSQL database access

To install the above packages, run:

pip install pyodbc

Note

You may need to install some external packages for compilation. See https://github.com/mkleehammer/pyodbc/wiki/Install for pyodbc.

4.2.2. Windows

Run QGIS 3.42.x
go to Plugins -> Python Console
run the following command in the Python Console dock:

!pip install --no-deps --force-reinstall --break-system-packages -U chevron "sqlalchemy>=1.4,<2.0" "GeoAlchemy2>=0.13.3,<0.14" "pyqtgraph>=0.13.3" "xplordb==0.13.8" "pint>=0.24.4" pluggy py-machineid mplstereonet flexparser flexcache typing-extensions platformdirs