🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2024-04-28 09:38:44
- Otto_Riehl
- Member
- Kirchlinteln, DE-NI
- 2024-02-29
- 10
[resolved] The import of metadata does not work reliably
Hello,
The import via the web form is not working as it should.
The metadata is not transferred to the MySQL database.
Thus, the descripten is missing in the image page below the image and the search cannot find the image.
Examples:
124a page-085 https://pw.krasna-photo-collection.de/p … tegory/115
124aa page-050 https://pw.krasna-photo-collection.de/p … tegory/115
124aa page-052 https://pw.krasna-photo-collection.de/p … tegory/115
124aa page-053 https://pw.krasna-photo-collection.de/p … tegory/115
124c page-026 bottom https://pw.krasna-photo-collection.de/p … tegory/115
124c page-030 top https://pw.krasna-photo-collection.de/p … tegory/115
I have published exactly the same images on the piwigo.com server.
Everything works wonderfully there.
Examples:
124a page-085 https://kpcpw.piwigo.com/picture?/109/category/6-0
124aa page-050 https://kpcpw.piwigo.com/picture?/129/category/6-0
124aa page-052 https://kpcpw.piwigo.com/picture?/12/category/6-0
124aa page-053 https://kpcpw.piwigo.com/picture?/13/category/6-0
124c page-026 bottom https://kpcpw.piwigo.com/picture?/132/category/6-0
124c page-030 top https://kpcpw.piwigo.com/picture?/135/category/6-0
The problem is reproducible.
The metadata is transferred for 70% of my images. The metadata is not transferred for the missing 30%.
If I delete the image and import it again, there is no improvement.
My MySQL database is missing
piwigo:images:name [Title] => 'iptc_title' => '2#005',
piwigo:images:comment [Description] => 'comment' => '2#120',
piwigo:images:autor [Author] => 'author' => '2#080',
piwigo: ? [Tags] => 'iptc_keywords' => '2#025',
What is the difference? What is different for me?
Piwigo 14.4.0
Operating system: FreeBSD
PHP: 8.1.24
MySQL: 5.7.42
Offline
#2 2024-04-28 12:38:33
- erAck
- Only trying to help
- 2015-09-06
- 2043
Re: [resolved] The import of metadata does not work reliably
Do you have set these in your local config?
$conf['use_iptc'] = true;
$conf['use_iptc_mapping'] = array( ...
See [Forum, post 189837 by erAck in topic 33627] Write metadata to the piwigo database..
Running Piwigo at https://erack.net/gallery/
Offline
#3 2024-04-28 14:23:10
- Otto_Riehl
- Member
- Kirchlinteln, DE-NI
- 2024-02-29
- 10
Re: [resolved] The import of metadata does not work reliably
erAck wrote:
Do you have set these in your local config?
See [Forum, post 189837 by erAck in topic 33627] Write metadata to the piwigo database..
In "local/config/config.inc.php" I only have the lines you specified.
That now works as expected!
In the database, the comment and author fields in the piwigo_images table are filled. This was previously missing.
So it can be found for the search.
Thank you.
I will now delete the existing albums.
Create the albums again.
Upload the images again.
No update via image batch processing and Synchronize metadata action. Is this correct?
Offline
#4 2024-04-28 16:02:02
- Otto_Riehl
- Member
- Kirchlinteln, DE-NI
- 2024-02-29
- 10
Re: [resolved] The import of metadata does not work reliably
erAck wrote:
Do you have set these in your local config?
See [Forum, post 189837 by erAck in topic 33627] Write metadata to the piwigo database..
The name has been transferred to the database.
The image title [name] does not appear on the image display page.
Can I set up the display of [name]?
Code:
// use_iptc: Use IPTC data during database synchronization with files metadata
$conf['use_iptc'] = true;
// 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'
);
Offline
#5 2024-04-28 16:23:43
- Otto_Riehl
- Member
- Kirchlinteln, DE-NI
- 2024-02-29
- 10
Re: [resolved] The import of metadata does not work reliably
erAck wrote:
Do you have set these in your local config?
See [Forum, post 189837 by erAck in topic 33627] Write metadata to the piwigo database..
Until now, I had the local configuration:
Code:
$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',
);
$conf['show_exif'] = false;
$conf['use_exif'] = false;
$conf['show_iptc_mapping'] = array(
'iptc_title' => '2#005',
'iptc_byline' => '2#080',
'iptc_byline_title' => '2#085',
'iptc_byline_contact' => '2#118',
'iptc_keywords' => '2#025',
'iptc_caption' => '2#120',
'iptc_caption_writer' => '2#122',
'iptc_country_code' => '2#100',
'iptc_country' => '2#101',
'iptc_city' => '2#090',
'iptc_copyright' => '2#116',
);
$conf['use_iptc_mapping'] = array(
'keywords' => '2#025',
'author' => '2#080',
'name' => '2#005',
'comment' => '2#120',
'country' => '2#101',
'copyright' => '2#116',
);
$conf['use_iptc'] = true;
$conf['show_iptc'] = true;
This has all been removed. Replaced by your specification.
Thanks again for that. Now filling the searchable database works.
In the side column I would like to remove below Exif metadata
- Hersteller
- Modell
- ApertureFNumber
In the side column I would like to output below Exif metadata
- Titel ('name' => '2#005',)
- Copyright ('copyright' => '2#116',)
This information is generated at runtime. They are not stored in the database.
Offline
#6 2024-04-28 23:22:57
- erAck
- Only trying to help
- 2015-09-06
- 2043
Re: [resolved] The import of metadata does not work reliably
Otto_Riehl wrote:
In the side column I would like to remove below Exif metadata
- Hersteller
- Modell
- ApertureFNumber
In local config have
Code:
$conf['show_exif'] = true; $conf['show_exif_fields'] = array( 'DateTimeOriginal' );
In the side column I would like to output below Exif metadata
- Titel ('name' => '2#005',)
- Copyright ('copyright' => '2#116',)
These are not Exif data but IPTC.
In local config have
Code:
$conf['show_iptc'] = true; $conf['show_iptc_mapping'] = array( 'Title' => '2#005', 'Copyright' => '2#116 );
For an excerpt of many more possible mappings see [Forum, post 166781 by ddtddt in topic 27721] Read and set tags from IPTC metadata.
Running Piwigo at https://erack.net/gallery/
Offline
#7 2024-04-29 07:16:29
- Otto_Riehl
- Member
- Kirchlinteln, DE-NI
- 2024-02-29
- 10
Re: [resolved] The import of metadata does not work reliably
erAck wrote:
In local config have
Code:
$conf['show_iptc'] = true; $conf['show_iptc_mapping'] = array( 'Title' => '2#005', 'Copyright' => '2#116 );For an excerpt of many more possible mappings see [Forum, post 166781 by ddtddt in topic 27721] Read and set tags from IPTC metadata.
Many thanks
https://pw.krasna-photo-collection.de/p … tegory/168
Thanks for the link to post 166781.
I was very suspicious of this blind configuration.
Offline