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

In case the command above does not fully cover the dependencies, refer to the req file directly.

You may also 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