Announcement

#1 2020-07-09 09:41:10

qusi
Member
2019-10-17
5

Import hierarchical keywords into the database

Hello/Hi/Greetings,

Our images have hierarchically organized keywords. Obviously, Piwigo did not take over the hierarchy while reading them, but I saw this should be possible. What is the latest, best way for Piwigo to read the keywords hierarchically into the database?

Why we need the hierarchical keywords: We want to build a template for Piwigo that displays the keywords hierarchically as they are in the images. This will help us and the users to search in a structured way.

See the planned side menu:
https://www.traumtreppe.ch/2020-07-09/01_Index%20Side%20Menu.jpg

Piwigo version: 2.10.2
PHP version: 7.2.31
MySQL version: 5.5.5-10.1.45-MariaDB
Piwigo URL: http://www.traumtreppe.ch

Offline

 

#2 2020-08-25 12:16:53

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13316

Re: Import hierarchical keywords into the database

Tags are not hierarchical. With [extension by plg] Tag Groups you can simulate 2 levels, but not more.

Albums are hierarchical. You can use them quite the same way as tags if you want.

Offline

 

#3 2020-08-25 20:10:46

qusi
Member
2019-10-17
5

Re: Import hierarchical keywords into the database

Well, I tested the plugin. This does not help me to import the hierarchical keywords from the images as hierarchically recognizable keywords into the database. Is this possible, and how big would the effort be?
Actually we need 3 levels, but maybe we should start with 4 levels from the beginning, if that is not much more complicated. Let's think about.

Offline

 

#4 2020-08-29 16:51:05

Aevaris
Member
2020-08-23
13

Re: Import hierarchical keywords into the database

What are you trying to do?

If you need a structured hierarchy, you could use the galleries synchronize feature since that will import the images as albums as defined by your folder hierarchy wherever the images are stored. That will likely be the best/most maintainable method for a structured hierarchy.

Offline

 

#5 2020-08-31 08:41:12

qusi
Member
2019-10-17
5

Re: Import hierarchical keywords into the database

We are not looking for a hierarchical folder structure, we want to be able to display the keywords for the user not only in a cloud, but structured as they are captured in the images. Let me explain:
The keywords are captured hierarchically in the images. In Digikam it looks like this:
https://www.traumtreppe.ch/2020-07-09/hierarchical-keywords-digikam.jpg
From this we want to create a menu that has the same hierarchy. The user can open and collapse the menu items, and select the keywords of his choice. This gives him a much better overview of the choices he has. But this requires that the keywords are stored in the database in a way that the hierarchy remains recognizable without confusing the whole logic of the piwigo database.
Here the draft of this menu:
https://www.traumtreppe.ch/2020-07-09/01_Index%20Side%20Menu.jpg
We are also happy to share the extension with the community if it ever works and proves itself. I am convinced that it will be a very useful extension, not only for us.

Hence the key question: what is the best way to write the hierarchy of the keywords to the database?
thanks in advance for all input.

Last edited by qusi (2020-08-31 08:44:13)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2020 · Contact