Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Discussion related to "Everything" 1.5 Alpha.
Post Reply
tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Sat May 15, 2021 10:27 am

Hi,

Properties: Date Taken (Everything Properties - EXIF: Date Taken)
[x] Include files
Include only files: D:\Bilder\**.jpg
[x] Fast Sort

Properties: Aufnahmedatum (Windows Property System - Aufnahmedatum (German))
[x] Include files
Include only files: D:\Bilder\**.jpg
[x] Fast Sort

Right click on column header -> Add Columns... "Date Taken", "Aufnahmedatum".

Everything Language: English (UK)
  • Right click on "Date Taken"
  • Click on "Search for Date Taken" -> date-taken: is displayed in the search box of 'Everything'
  • Enter "Date taken", e.g. 2.4.2021 -> search results with "Date taken" 2.4.2021 from the indexed folder "D:\Bilder"
    inclusive subfolders are displayed -> date-taken:2.4.2021 is displayed in the search box of 'Everything'.
     
  • Right click on "Aufnahmedatum"
  • Click on "Search for Aufnahmedatum" -> system.photo.datetaken: is displayed in the search box of 'Everything'
  • Enter "Aufnahmedatum", e.g. 2.4.2021 -> search result: 0 objects
- Everything Language: Deutsch (Systemstandard) -> did not help.
- Changing the system language from German to English did not help either,
  except that the column heading was also changed from "Aufnahmedatum" to "Date taken".

Please check.
Thank you!

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Sat May 15, 2021 10:36 am

Thanks for bringing this issue to my attention Tuska,

I will work on a fix.
Everything is missing the propertysystem: prefix.

For now, please try the following search:

propertysystem:system.photo.datetaken:<my date search>

where <my date search> is date, for example: 15/05/2021

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Sat May 15, 2021 10:45 am

Thank you for the prompt response!

Code: Select all

propertysystem:system.photo.datetaken:02/04/2021
brings me no result, but for me there is no hurry....

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Sat May 15, 2021 11:06 am

Thanks for checking.

Windows is inserting LTR markers in the filetime text.

I will work on a fix.

For now:
wildcards:propertysystem:system.photo.datetaken:*02*/*04*/*2021*

There's an invisible LTR marker before 02, 04 and 2021.

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Sat May 15, 2021 11:08 am

void wrote:
Sat May 15, 2021 11:06 am
For now:
wildcards:propertysystem:system.photo.datetaken:*02*/*04*/*2021*
Thanks, but unfortunately, that doesn't work either.

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Sat May 15, 2021 11:11 am

Does:
wildcards:propertysystem:system.photo.datetaken:*2021*
find any results?

Please make sure the search matches the same display format, eg:
DD/MM/YYYY

The syntax is different to the normal Everything syntax.
propertysystem: will always treat the value as text (not a date)

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Sat May 15, 2021 11:15 am

Thanks!

These queries work: :)

Code: Select all

wildcards:propertysystem:system.photo.datetaken:*2021*
wildcards:propertysystem:system.photo.datetaken:*02*.*04*.*2021*

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Fri May 21, 2021 5:58 am

Everything 1.5.0.1260a will now ignore control characters (LTR and RTL markers) when match diacritics is disabled.

This change requires a rebuild of your index.

Searching for propertysystem:system.photo.datetaken:02.04.2021 should now work as expected.

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Fri May 21, 2021 10:41 am

void wrote:
Fri May 21, 2021 5:58 am
Searching for propertysystem:system.photo.datetaken:02.04.2021 should now work as expected.
Yes, it does and just like property-system:system.photo.datetaken:02.04.2021

Thank you for the bugfix! :)
Tested with Everything 1.5.0.1260a (x64) | Windows 10 Pro (x64) Version 20H2 (OS build 19042.985).
---------------------------------------------------------------------------------------------------------------------------

I have noticed differences in the query, namely from
1    Date Taken      (= "Aufnamedatum" in German)
2    Aufnahmedatum   (= "Date Taken" in English)

1    Date Taken (date-taken:)
1.1 Entering the day, eg 27, does not yet bring photos with the date of the 27th -> please see: point 2.1
      The date must be entered completely in order to receive a search result.
1.2 Entry of "Date Taken" is also possible, for example, in the following formats: 27.1.2021, 27/1/2021 (German)
      MM = month must always be entered with 2 digits .. 9.02.2021 works!
1.3 It is possible to record a period, e.g. date-taken:27.1.2021..17.2.2021
 
2    Aufnahmedatum (property-system:system.photo.datetaken:)
2.1 Entering the day, e.g. 27, brings photos with a date of 27.
2.2 When entering the "Aufahmedatum", the following format is mandatory: TT.MM.YYYY (German)
2.3 It is not possible to record a period, e.g. property-system:system.photo.datetaken:27.01.2021..17.02.2021

Suggestion:
If you could make an adjustment to the "best of both worlds", then I would be pleased.
1.2 -> 2.2
1.3 -> 2.3
2.1 -> 1.1

Thank you for your efforts!

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Fri May 21, 2021 11:17 am

date-taken: Uses the Everything date syntax.
property-system:system.photo.datetaken: Uses a text search.

Date syntax expects a year, year-month, or year-month-day.

Use the tostring: search modifier to search the date-taken property as text.
For example: tostring:date-taken:27.
(Note the text search will need to match the displayed text)

Everything knows Date Taken is a date property.
Everything doesn't know property-system:system.photo.datetaken: is a date property.
1.1 Entering the day, eg 27, does not yet bring photos with the date of the 27th -> please see: point 2.1
The date must be entered completely in order to receive a search result.
Use tostring:date-taken:27. or tostring:date-taken:27/ depending on how the date is displayed.
1.2 Entry of "Date Taken" is also possible, for example, in the following formats: 27.1.2021, 27/1/2021 (German)
MM = month must always be entered with 2 digits .. 9.02.2021 works!
When Everything knows the property is a date, it will accept a variety of date syntaxes., such as d.mm.yyyy or d/mm/yyyy or yyyy-mm-dd
1.3 It is possible to record a period, e.g. date-taken:27.1.2021..17.2.2021
When Everything knows the property is a date, you can specify a range with .. and use operators such as > or <=
2.1 Entering the day, e.g. 27, brings photos with a date of 27.
2.2 When entering the "Aufahmedatum", the following format is mandatory: TT.MM.YYYY (German)
2.3 It is not possible to record a period, e.g. property-system:system.photo.datetaken:27.01.2021..17.02.2021
Everything will match this property as text.
Everything doesn't know it is a date.
The search must match the display format.


If you could make an adjustment to the "best of both worlds", then I would be pleased.
1.2 -> 2.2
1.3 -> 2.3
2.1 -> 1.1
I will consider a todate: search modifier to do this.
or, a property-system-date: search function.
I can't guarantee it will match correctly as the property system can store values any way they like and render the text any way they like.

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Fri May 21, 2021 5:08 pm

Thank you for this very detailed and informative information!
void wrote:
Fri May 21, 2021 11:17 am
Use tostring:date-taken:27. or tostring:date-taken:27/ depending on how the date is displayed.
In my case, tostring:date-taken:27 is required (German).
void wrote:
Fri May 21, 2021 11:17 am
I will consider a todate: search modifier to do this.
or, a property-system-date: search function.
I can't guarantee it will match correctly as the property system can store values any way they like and render the text any way they like.
If it is not certain for me that I will get a correct search result, then I prefer to do without such a function.
Therefore, my choice clearly falls on the parameter date-taken: because this meets all of my requirements.

Thanks again!

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Fri May 28, 2021 8:48 am

Everything 1.5.0.1262a adds a property-system-date: search function.

property-system-date: will 'attempt' to convert the system property data to a filetime for comparison.
I say 'attempt' here because there is no way to know if the property data represents a filetime.

Usage:
property-system-date:<property-system-canonical-name>:<Everything date syntax>

You can find the <property-system-canonical-name> list under Result List Header -> Right click -> Add Columns -> Windows Property System.

Examples:
property-system-date:system.photo.datetaken:2008..2015
property-system-date:system.photo.datetaken:2021-05-28
property-system-date:system.photo.datetaken:>2020
property-system-date:system.photo.datetaken:today

tuska
Posts: 372
Joined: Thu Jul 13, 2017 9:14 am

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by tuska » Fri May 28, 2021 10:30 am

I have now added this field.

Right-clicking on "Aufnahmedatum" -> "Search for Aufnahmedatum" brings up the following in Everything's search box:

Code: Select all

property-system:system.photo.datetaken:
However, the new parameter should be present:

Code: Select all

property-system-date:system.photo.datetaken:
Could you please check? ... property-system-date:
Thanks!

A random check gave me a very good result. :)

Windows Property System – Search: system.photo.datetaken

Code: Select all

----------------------------------------------------------------------
Name		Type			Canonical Name:
Aufnahmedatum	Property System  	System.Photo.DateTaken
----------------------------------------------------------------------
Result		Shown			Intern
- Everything	17.‎09.‎2019 ‏‎11:50
- Excel		17.‎09.‎2019 ‏‎11:50	'‎17.‎09.‎2019 ‏‎11:50
======================================================================
For comparison...

Everything Properties – Search: date taken

Code: Select all

----------------------------------------------------------------------
Name		Type			Canonical Name:
Date Taken	Metadata	  	Date Taken
----------------------------------------------------------------------
Result		Shown			Intern
- Everything	17.‎09.‎2019 ‏‎11:50
- Excel		17.09.2019 11:50	17.09.2019  11:50:58
======================================================================
Thank you for your efforts!

void
Site Admin
Posts: 6907
Joined: Fri Oct 16, 2009 11:31 pm

Re: Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

Post by void » Fri May 28, 2021 1:53 pm

Thanks for testing tuska,
Right-clicking on "Aufnahmedatum" -> "Search for Aufnahmedatum" brings up the following in Everything's search box:
property-system:system.photo.datetaken:
This is expected.
Everything doesn't know this property is a 'date' property.


While the property does have a FILETIME storage, it might be possible to guess it is a date property.
However, this cannot be guaranteed to be correct.

I will consider defaulting to property-system-date: for properties with FILETIME storage.

Post Reply