Announcement

#1 2021-01-13 13:29:18

jclifford
Member
2019-01-06
22

Partial dates

Hello/Hi/Greetings,

There seems to have been a lot of discussion in the forum about this subject five years ago but giving the impression that it was impossible to fix.

Is it really that difficult to allow the entry of just a year or just a month and year, particularly for Date Created on photos taken before digital cameras were invented?


    Piwigo 2.10.2 Check for upgrade
    Operating system: Linux
    PHP: 7.2.34 (Show info) [2021-01-13 07:23:26]
    MySQL: 10.3.22-MariaDB-cll-lve [2021-01-13 13:23:26]
    Graphics Library: ImageMagick 7.0.10-10


Piwigo URL: http://www.johnclifford.me.uk/piwigo

Offline

 

#2 2021-01-13 22:22:04

executive
Member
2017-08-16
1028

Re: Partial dates

if you don't know the day, just enter '1'

Offline

 

#3 2021-01-13 22:34:12

Katryne
Member
2016-12-03
60

Re: Partial dates

Just to follow the topic, I am interested.

Last edited by Katryne (2021-01-13 22:34:34)


https://photos.revestou.fr/  - http://photos.katrynou.fr/
Piwigo 2.10.1 -  OS : Linux - Hosting provider 1&1-Ionos
PHP: 7.3.15 - MySQL: 5.7.28-log
Graphic library: External ImageMagick 6.8.9-9

Offline

 

#4 2021-01-13 23:41:39

jclifford
Member
2019-01-06
22

Re: Partial dates

It can be misleading for guests/viewers to have the wrong day displayed and it gives a false impression of accuracy.

I am using the 15th day as a stop gap, but I think the situation is a definite flaw in Piwigo.

Offline

 

#5 2021-01-14 03:33:14

executive
Member
2017-08-16
1028

Re: Partial dates

then disable the display of day of the month.

I don't think this a problem that many people face.

Offline

 

#6 2021-01-14 11:37:11

jclifford
Member
2019-01-06
22

Re: Partial dates

If you mean "disable the display of the day in Piwigo", that sounds a helpful compromise.

Would you tell me how to do this please?  I have not found anything in the Piwigo Docs that is relevant.

Offline

 

#7 2021-01-14 12:06:09

Katryne
Member
2016-12-03
60

Re: Partial dates

Hello !
In my genealogy software TNG, one can enter the dates in a variety of way : years only, month and year, with locutions as before, after, between, about ... and we can still make computation on the dates. Such a development would be interesting for some Piwigo, especially when dealing with old photos or postcards.


https://photos.revestou.fr/  - http://photos.katrynou.fr/
Piwigo 2.10.1 -  OS : Linux - Hosting provider 1&1-Ionos
PHP: 7.3.15 - MySQL: 5.7.28-log
Graphic library: External ImageMagick 6.8.9-9

Offline

 

#8 2021-01-14 12:07:53

executive
Member
2017-08-16
1028

Re: Partial dates

you would need to write a plugin

Offline

 

#9 2021-01-14 13:14:32

jclifford
Member
2019-01-06
22

Re: Partial dates

Katryne,

I think that applies to all genealogical software - I use TNG, Family Historian and Legacy among others.

So I guess that all genealogists would be taken aback by Piwigo's poor handling of dates.

Offline

 

#10 2021-01-14 20:40:15

Katryne
Member
2016-12-03
60

Re: Partial dates

@executive : I am no coder and the initial post was in the "Request" section.


https://photos.revestou.fr/  - http://photos.katrynou.fr/
Piwigo 2.10.1 -  OS : Linux - Hosting provider 1&1-Ionos
PHP: 7.3.15 - MySQL: 5.7.28-log
Graphic library: External ImageMagick 6.8.9-9

Offline

 

#11 2021-01-15 11:52:01

Wallbert
Member
2020-12-01
6

Re: Partial dates

This is a recognized problem. See this IDImager forum thread for a link to standards that define how to handle partial dates: https://forum.idimager.com/viewtopic.php?t=28109 .

Note that IDImager Photo Supreme does not handle partial dates at this time.

Offline

 

#12 2021-01-15 11:55:51

jclifford
Member
2019-01-06
22

Re: Partial dates

As Katryne says, I deliberately posted this in the Request Forum as a suggestion for an improvement in Piwigo.
I do not have enough familiarity with PHP to identify the problem myself or to write a plug-in to correct it.

It looks as though "executive" is responding to my request with "no chance, ever"

Offline

 

#13 2021-01-15 13:43:56

jclifford
Member
2019-01-06
22

Re: Partial dates

Wallbert

The example you give is more about fuzzy dates, slightly different to partial dates.
In so far as it is a recognised problem, it is not specific to images but is about how to display any date on the internet and many different solutions are available.

A simple approach is to treat any date in the metadata of an image as a text field and display it as such. This would not suit Piwigo because it is incompatible with allowing sorting on dates.

I referred in a previous post to genealogical programmes which each have their own way to display dates, but there is also a standard defined for interchanging genealogical information as Gedcom (.ged) files in which dates can be entered and understood in a few standard formats such as:

1 JAN 2021
JAN 2021
2021
ABT MAY 2021
BET  JAN 2021   AND  May 2021

These formats also solve the problem of accomodating dd/mm/yyyy and mm/dd/yyyy dating.

Offline

 

#14 2021-01-15 13:50:26

erAck
Only trying to help
2015-09-06
735

Re: Partial dates

The EXIF date+time fields are specified as "yyyy:mm:dd hh:mm:ss" strings. Using partial dates like "1984" or "1984:00:00 00:00:00" probably would make trip most consuming applications or not have them read a date at all, so writing such values to images is not supported by applications most likely for that reason.

Additionally, the date+time in Piwigo is stored in MySQL as a type datetime field, which does not allow such partial values.

So no, without completely reorganizing and rewriting date+time handling there's no chance supporting such.


Running Piwigo at https://erack.net/gallery/

Offline

 

#15 2021-01-15 21:49:41

jclifford
Member
2019-01-06
22

Re: Partial dates

Thank you for that explanation, which I understand.

But I am puzzled as to why the datetime type of date was chosen in the first place.  I have not found any Piwigo websites which display the time created or appear to use it any way.

On w3 schools.com there is a page on "SQL Working With Dates" which specifically warns students "Tip: To keep your queries simple and easy to maintain, do not allow time components in your dates!"

Offline

 

Board footer

Powered by FluxBB

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