🌍
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
#16 2021-01-15 22:09:52
- erAck
- Only trying to help
- 2015-09-06
- 2026
Re: Partial dates
Which is unrelated to the problem of partial or fuzzy dates.
Running Piwigo at https://erack.net/gallery/
Offline
#17 2021-01-16 05:05:42
- jnashpiwigo
- Piwigo Team
- 2014-10-21
- 254
Re: Partial dates
In thinking about this...
One could use an IPTC field [Circa Date Created] comes to mind...
Then display this IPTC field
If you wanted to get creative with the theme, then pseudo-code:
if circadatecreated exists display this field
else
display creationdate
again, not well thought out, but just thinking out loud for you...
Offline
#18 2021-01-16 13:08:18
- jclifford
- Member
- 2019-01-06
- 36
Re: Partial dates
Tnank you, jnashpiwigo. That is an interesting suggestion which I will pursue.
I am part way there already as I have used the IPTC Date Created field to add a date to many of my old photos. At present I am mapping this to '2#055' in Piwigo which is presumably the SQL field where the Exif date created/taken is stored.
So I need to choose another SQL field which I don't use to map the IPTC date into and then write some pseudo-code as you suggest and then discover where to put the code.
I am not sure that I can do this but a good start would be to find a list of all the fields/columns in the appropriate SQL table (2 or piwigo_images?). Can anyone tell me where to find this in the Piwigo documentaion or Help pages?
Offline
#19 2021-01-16 13:19:48
- Katryne
- Member
- 2016-12-03
- 369
Re: Partial dates
jclifford, you can create any new property field with the extension "Manage properties photos" https://piwigo.org/ext/extension_view.php?eid=783 I do not know how it is stored, but they will be either displayed among the photo informations or hidden, but still existing.
http://photos.katrynou.fr/ v.14.1.0 https://album.chauvigne.info/ v.13.8.0
Système d'exploitation: Linux - Hébergeur 1&1-Ionos PHP: 8.0.28 - MySQL: 5.7.38
Bibliothèque graphique: External ImageMagick 6.9.10-23
Offline
#20 2021-01-18 15:56:54
- jclifford
- Member
- 2019-01-06
- 36
Re: Partial dates
Katryne
Thank you for the suggestion but I have given up trying to find a solution at present.
I did investigate how TNG copes with flexible dates. It has two fields/columns for each date in its SQL database. One is type=VARCHAR where it stores whatever comes in as a Gedcom file and the other is type=DATE where every date is translated into yyyy mm dd format with zeroes where a day month and/or year is unknown/missing. The first field is used for display and the second for sorting and searching.
Piwigo will read and store correctly an IPTC partial date like 19640600 but displays it under a photo as 1st January 1964. It seems to be the routine which formats the date for display which needs attention but I have not located it.
Offline