Piwigo.org

MarcRJacobs · 2024-01-02 14:39:22

Hi

I'm trying to figure out how to search by keywords.

I have ftp'd and sync'd a few albums and all is working well. When I look at a photo's details, the keywords appear fine, but these are coming out of the photos metadata. The piwigo_tags table is empty, rendering search by keyword non-functional. For one album i manually added the keyword, it inserted it into the table and that keyword search works perfectly.

Is there something i need to do differently such that after I ftp my photos up to galleries and then run synchronize that my keywords will get added to piwigo_tags?

I'm looking to import 106,000 photos that are all keyworded. My plan was to do the upload and sync, and then create my albums based upon keywords.

local/config/config.inc.php
<?php
/* The file does not exist until some information is entered below. Once information is entered and saved, the file will be created. */

$conf['upload_form_all_types'] = true;

$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_. ]+$/';

$conf['show_exif'] = true;
$conf['show_exif_fields'] = array(
'Make',
'Model',
'ExifVersion',
'Software',
'DateTimeOriginal',
'FNumber',
'ExposureBiasValue',
'FILE;FileSize',
'ExposureTime',
'Flash',
'ISOSpeedRatings',
'FocalLength',
'FocalLengthIn35mmFilm',
'WhiteBalance',
'ExposureMode',
'MeteringMode',
'ExposureProgram',
'LightSource',
'Contrast',
'Saturation',
'Sharpness',
'bitrate',
'channel',
'date_creation',
'display_aspect_ratio',
'duration',
'filesize',
'format',
'formatprofile',
'codecid',
'frame_rate',
'latitude',
'longitude',
'make',
'model',
'playtime_seconds',
'sampling_rate',
'type',
'resolution',
'rotation',
);

$conf['show_iptc'] = true;
$conf['show_iptc_mapping'] = array(
'iptc_creator' => '2#080',
'iptc_title' => '2#005',
'iptc_headline' => '2#105',
'iptc_description' => '2#120',
'iptc_keywords' => '2#025',
);

$conf['show_iptc_mapping'] = array(
'Author' => '2#080',
'Name' => '2#005',
'Comment' => '2#120',
'Keywords' => '2#025',
'Headline' => '2#105',
);
?>

Environment

Piwigo 14.1.0 Check for upgrade
Installed on 1 January 2024, 17 hours ago
Operating system: Linux
PHP: 8.1.2-1ubuntu2.14 (Show info) [2024-01-02 09:27:51]
MySQL: 8.0.35-0ubuntu0.22.04.1 [2024-01-02 13:27:51]
Graphics Library: ImageMagick 6.9.11-60
Cache size 27.93 Mo   calculated 23 seconds ago Refresh

Activated plugin list 27

Additional Pages
Batch Downloader
Contact 1 menu
Contact Form
Custom Download Link
Download Counter
Exif View
Exiftool GPS
Exiftool Keywords
Extended Description
Force HTTPS
gdThumb
Grum Plugins Classes.3
GuestBook
LocalFiles Editor
Most Commented
Most Downloaded
No Stats For Robots
Perso Footer
Personal Favicon
Piwecard
Read Metadata
RV Thumb Scroller
Smilies Support
Tag To Keyword
VideoJS
Write Metadata

Piwigo URL: https://marcsphotos.mywire.org/

erAck · 2024-01-02 16:20:30

Btw, you have $conf['show_iptc_mapping'] = array(...) twice (with different display names), that doesn't make sense; the second definition overrides the first.

The reason keywords aren't imported is that in your case they are in IPTC and probably you don't have use_iptc_mapping defined, like

Code:

// use_iptc_mapping : in which IPTC fields will Piwigo find image
// information ? This setting is used during metadata synchronisation. It
// associates a piwigo_images column name to a IPTC key
$conf['use_iptc_mapping'] = array(
  'keywords'        => '2#025',
  'author'          => '2#080',
  'name'            => '2#005',
  'comment'         => '2#120'
  );

MarcRJacobs · 2024-01-02 16:58:57

Thank you so much erAck.

I'm making headway now... All my keywords were added to piwigo_tags with the one I had put there manually using the change below.

When I ran the sync, I chose:
selected directories + files
checked synchronize metadata
checked including already synchronized photos
checked overrides existing values with empty ones
uncheck perform a simulation
checked search in sub-albums
Synchronize

Waited for it to complete...

However, two issues were not solved:
1. Search from the menu bar still only shows the one I put in manually
2. In Admin > Photos > Batch Manager if I add a keyword filter, all the records in piwigo_tags are available, but only the original one I added works.

I think I still am missing something.

$conf['show_iptc'] = true;
$conf['use_iptc'] = true;

$conf['show_iptc_mapping'] = array(
'Author' => '2#080',
'Title' => '2#005',
'Description' => '2#120',
'Keywords' => '2#025',
'Headline' => '2#105',
);

$conf['use_iptc_mapping'] = array(
'keywords' => '2#025',
'author' => '2#080',
'name' => '2#005',
'comment' => '2#120',
);

MarcRJacobs · 2024-01-02 17:02:46

Ah, I just found the reason....

The photos where I entered the keyword manually have records added to the table piwigo_image_tag, where the photos I just re-synced do not. That seems to be the difference.

Is there a way to solve this as well?

Thanks,
Marc

Piwigo.org

Announcement

#1 2024-01-02 14:39:22

Why aren't keywords in photos written into piwigo_tags?

#2 2024-01-02 16:20:30

Re: Why aren't keywords in photos written into piwigo_tags?

Code:

#3 2024-01-02 16:58:57

Re: Why aren't keywords in photos written into piwigo_tags?

#4 2024-01-02 17:02:46

Re: Why aren't keywords in photos written into piwigo_tags?

Board footer