Piwigo.org

jclifford · 2021-01-13 13:29:18

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

executive · 2021-01-13 22:22:04

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

Katryne · 2021-01-13 22:34:12

Just to follow the topic, I am interested.

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

jclifford · 2021-01-13 23:41:39

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.

executive · 2021-01-14 03:33:14

then disable the display of day of the month.

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

jclifford · 2021-01-14 11:37:11

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.

Katryne · 2021-01-14 12:06:09

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.

executive · 2021-01-14 12:07:53

you would need to write a plugin

jclifford · 2021-01-14 13:14:32

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.

Katryne · 2021-01-14 20:40:15

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

Wallbert · 2021-01-15 11:52:01

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.

jclifford · 2021-01-15 11:55:51

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"

jclifford · 2021-01-15 13:43:56

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.

erAck · 2021-01-15 13:50:26

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.

jclifford · 2021-01-15 21:49:41

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!"

Piwigo.org

Announcement

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

Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

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

Re: Partial dates

Board footer