Announcement

#1 2018-09-07 00:40:01

tterrellbanks
Member
2015-02-16
4

Need list of valid IPTC names

Hello/Hi/Greetings,

I need to use several IPTC fields in the metadata.  Where can I find a list of all the (in example below) piwigo_images column names that correspond to the '2#nnn' values where 'nnn' is a 3 digit numeric?

I will be using several more of these values for the mapping like this one.

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

I can't get the metadata synchronisation to work.  It fails because of invalid column names during the MySQL statements.

Piwigo version: 2.9.4
PHP version: 7.0.0 (and 5.6.10)
MySQL version: 5.5.42
Piwigo URL: http://. -- not on publicly accessible server.

Thanks,
  Terry Banks

Offline

 

#2 2018-09-07 08:26:37

executive
Member
2017-08-16
374

Re: Need list of valid IPTC names

Offline

 

#3 2018-09-14 19:46:19

RegSputnik
Member
2018-09-11
5

Re: Need list of valid IPTC names

Hi Terry

I had exactly the same question as you.

In my case, I saw the word Example in the code and concluded there must be more, perhaps many more fields in piwigo_images that could store IPTC data. Is that what you thought?

I've suggested a change to the documentation https://piwigo.org/forum/viewtopic.php?id=28872.
Would such a change have helped you?

Anyway, to answer your question - I've attached a jpeg showing all the columns in the piwigo_images table.

As you'll see, the only ones which will accept text are:

'file'
'name'
'comment'
'author'

'keywords' will accept text but the data is actually stored in the piwigo_tags table.

I imagine someone who knows their way round SQL could add more columns in piwigo_images but I'm a newbie at this and don't know if that would adversely affect the software. Anyone?

Hope this helps

Reg


Uploaded Images

Last edited by RegSputnik (2018-09-14 19:50:31)

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact