[Qgis-user] Problems for condition classification in QKan

[Schmidt, Céline]

Hello,

my problem concerns condition classification using the QKan plugin.

I work in an engineering office with QGIS on a sewer rehabilitation project. For this, I received the raw data from a CCTV inspection of a sewer network, where the defects were recorded separately for reaches, pipes, and manholes. Among these files is, for example, an XML file containing all information on geometry, inspection date, and inspection results. The inspection results were documented as AI condition codes according to DWA-M 149-2 and Isybau.

I am a beginner in QGIS and this project is my first time working with the software. I managed to create both a Spatialite and a PostgreSQL database and uploaded my data into them. The data also appears as layers in my layer tree and in my map. When I now start the condition classification, QKan shows the following message:
"2025-09-22T15:43:05 INFO Qkan.Zustandsklassen - Creating DB
2025-09-22T15:43:05 INFO Qkan.Zustandsklassen - DB creation finished, starting Zustandsklassen"
In my layer tree, the layers "Ergebnis_ZK_Haltungen" ("Result_ZK_Reaches") and the condition classes 0–5 appear. However, when I open the layer "Ergebnis_ZK_Haltungen" to check the condition classes in the column "Objektspalte_gesamt" ("ObjectColumn_Total"), it only shows "-" or "Einzelfallbetrachtung" ("Case-by-case consideration") everywhere. No condition class was determined anywhere.

I have already checked the following:
I have all read and write permissions for QKan. My QGIS version is 3.44.3 and I installed the QKan plugin only a few days ago. I am working on an Apple Mac. In my table "untersuchdat_haltung_bewertung" ("inspectiondata_reach_evaluation"), all fields are now filled, none contains "NULL". The table includes the columns "Kuerzel" (“code”), "charakt1", "charakt2", "quantnr1", "quantnr2", "streckenschaden" ("section_damage"), "haltnam" ("reach_name"), "Baujahr" ("year_of_construction"), "Material", "Durchmesser" (diameter"), and "Länge" ("length"). The columns "Zustandsklasse_D" ("Condition_Class_D"), "Zustandsklasse_S", and "Zustandsklasse_B" cannot be filled; they always show "NULL".
I modified the table using query statements in the DB Manager after the condition classification showed the following error:
"2025-09-22T13:36:01 WARNING Traceback (most recent call last):
File "/Users/celineschmidt/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/application.py", line 103, in run_import self._doimport()
File "/Users/celineschmidt/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/application.py", line 160, in _doimport zustand.run()
File "/Users/celineschmidt/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/zustandsklassen_funkt.py", line 90, in run self.bewertung_dwa_leitung()
File "/Users/celineschmidt/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/zustandsklassen_funkt.py", line 7552, in bewertung_dwa_leitung curs.execute(sql, data)
sqlite3.OperationalError: near ",": syntax error"

I filled the fields for the condition codes with "." wherever "NULL" was present, since I read that no mandatory fields are allowed to be empty. The columns "haltnam", "Baujahr", "Material", "Durchmesser", and "Länge" were added later and copied from the table "Haltungen" ("Reaches"). The two tables are also linked via the column "haltnam". After making these changes, I restarted the program to refresh the tables.

Now I am wondering: what mistake am I making that no condition classes are being calculated? What should the input data I import look like? Which tables and columns are required by QKan in order to perform the calculation? Do I have to activate any function? I would be really thankful if you have any ideas on how to solve my problem!

Kind regards / Mit freundlichen Grüßen –/i. A. Céline Schmidt
--
B.Sc. Céline Schmidt
Junior-Projektingenieurin

[Ein Bild, das Text, Schrift, Grafiken, Screenshot enthält.  Automatisch generierte Beschreibung]


Sebrathweg 5
44149 Dortmund
T: 0151 46700621
E: c.schmidt at bbp-gruppe.de<mailto:c.schmidt at bbp-gruppe.de>
I: www.bbp-gruppe.de<http://www.bbp-gruppe.de/>
[Ein Bild, das Symbol, Schrift, Kreis, Logo enthält.  Automatisch generierte Beschreibung]<https://www.linkedin.com/company/bbp-beratende-ingenieure-becker-&-barenberg-partg-mbb/>
[Ein Bild, das Kreis, Entwurf, Grafiken, Design enthält.  Automatisch generierte Beschreibung]<https://www.instagram.com/bbp_ingenieure/>


BBP Becker & Barenberg PartG mbB
Beratende Ingenieure für Projektmanagement und Baubetrieb
Sitz: Dortmund
Register: Amtsgericht Essen PR 2576
Geschäftsführende Partner: Pecco Becker, Volker Barenberg
[Ein Bild, das Muster, nähen, monochrom enthält.  Automatisch generierte Beschreibung]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250923/8987bbb3/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10676 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250923/8987bbb3/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5637 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250923/8987bbb3/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 7288 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250923/8987bbb3/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 3573 bytes
Desc: image004.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250923/8987bbb3/attachment-0007.png>