Announcement

#1 2024-04-28 09:38:44

Otto_Riehl
Member
Kirchlinteln, DE-NI
2024-02-29
13

[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


Description of my installation: Bildarchiv

Offline

 

#2 2024-04-28 12:38:33

erAck
Only trying to help
2015-09-06
2075

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
13

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?


Description of my installation: Bildarchiv

Offline

 

#4 2024-04-28 16:02:02

Otto_Riehl
Member
Kirchlinteln, DE-NI
2024-02-29
13

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'
  );


Description of my installation: Bildarchiv

Offline

 

#5 2024-04-28 16:23:43

Otto_Riehl
Member
Kirchlinteln, DE-NI
2024-02-29
13

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.


Description of my installation: Bildarchiv

Offline

 

#6 2024-04-28 23:22:57

erAck
Only trying to help
2015-09-06
2075

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
13

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.


Description of my installation: Bildarchiv

Offline

 

Board footer

Powered by FluxBB

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