Sort files by aspect ratio?

Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

On 8/7/2018 7:27 AM, Terry Pinnell wrote:
Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

Could you sort one of the extra columns (right click column Headers) and
sort of height or width?




--
2018: The year we learn to play the great game of Euchre

Terry Pinnell wrote:
Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

The third-party examples I could find, seem to
want to "sort" your image collection, into folders,
according to the complex criteria. So instead
of a search as such, they meddle with the collection.

*******

The only thing I can think of, is edit the metadata
on the images, find a field that is searchable
from Windows Search, then write a representative
value into that field in place of the original data.
Then, rebuild the Search Index, to use the new info.

Instead of writing 1.7778 into the field, if the field
was of string type, you could write "16:9" as a text
string.

So maybe in place of Camera, where it says "Nikon",
you could make the Camera "16:9" brand instead :-)

If would be fun if the Search Index was extensible,
but I don't get the impression it's programmable.
And it's limited to a subset of metadata field types.

Maybe it would take some scripting with EXIFTool or
similar. You would want a tool that doesn't mess up
the file system dates as well (which would be an added
complexity).

*******

If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

*******

Running parallel collections is another way to solve it.

You have one collection which is sorted by your standard
folder arrangements.

Then, a second collection is sorted by some criterion,
into folders.

It doubles the storage space.

It takes time to update the "derived" storage tree.

But this is why we have computers.

Paul

In article , Paul
wrote:

Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?


If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

otherwise known as photo asset manager, such as adobe lightroom:


https://industrydev.com/wp-content/u...sort-menu-item.
jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-20-55.jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-14-56.jpg

"Terry Pinnell" wrote

| Anyone know of a tool or hack that will do something that Win 10 File
| Explorer unfortunately cannot: sort a folder of files into aspect ratio
| (width/height)?
|
| It's an operation I need quite frequently, such as when trying to
| isolate all files with say a 16:9 ratio (to some fine tolerance if
| necessary).
|
You're talking about image w/h dimensions? Even on
XP I can choose to show "Dimensions" in detail view.
But that still won't sort the images. And it doesn't
calculate w/h ratio.

I doubt many people want that, either, so it's not
likely to exist as software.

It would be relatively simple to do with scripting,
as far as finding w/h and sorting the file list, but
then you'd still have the problem of how to display them.
It sounds like what you want is an Explorer substitute.
It might be easier to just sort and/or resize them by
folder.

nospam wrote:
In article , Paul
wrote:

Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?


If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

otherwise known as photo asset manager, such as adobe lightroom:


https://industrydev.com/wp-content/u...sort-menu-item.
jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-20-55.jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-14-56.jpg

Which I assume is free.

Paul

"Paul" wrote

| otherwise known as photo asset manager, such as adobe lightroom:

| Which I assume is free.
|

Yes, once you've delivered your firstborn.
Alternatively, you can pay Adobe "an arm and
a leg" gradually by renting Abode Creative suite
by the month.

Paul wrote:

Terry Pinnell wrote:
Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

The third-party examples I could find, seem to
want to "sort" your image collection, into folders,
according to the complex criteria. So instead
of a search as such, they meddle with the collection.

*******

The only thing I can think of, is edit the metadata
on the images, find a field that is searchable
from Windows Search, then write a representative
value into that field in place of the original data.
Then, rebuild the Search Index, to use the new info.

Instead of writing 1.7778 into the field, if the field
was of string type, you could write "16:9" as a text
string.

So maybe in place of Camera, where it says "Nikon",
you could make the Camera "16:9" brand instead :-)

If would be fun if the Search Index was extensible,
but I don't get the impression it's programmable.
And it's limited to a subset of metadata field types.

Maybe it would take some scripting with EXIFTool or
similar. You would want a tool that doesn't mess up
the file system dates as well (which would be an added
complexity).

*******

If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

*******

Running parallel collections is another way to solve it.

You have one collection which is sorted by your standard
folder arrangements.

Then, a second collection is sorted by some criterion,
into folders.

It doubles the storage space.

It takes time to update the "derived" storage tree.

But this is why we have computers.

Paul

Failing anything simpler (and especially faster), I may do it the
long-winded way with Macro Express Pro:
https://www.dropbox.com/s/tejhxmfa6a...pect.jpg?raw=1

1. Open file in IrfanView
2. Tap the 'i' key to display its properties
3. Select the 'Current size' field
4. Edit that to get a prefix like '1.333', 1.778, etc. (Need to avoid a
semi-colon. And a decimal value has the advantage of showing me at a
glance if AR is close to a standard. Or I could add that to my macro
after providing a percentage tolerance.)
5. Still in IrfanView, use F2 to change file name, e.g to
'1.333-Pugia-006.jpg' in the example shown.
6. Save that to a new folder.
7. Repeat for all files in the source folder.

A sort on Name with FE in the new folder should then give me what I
need.

Given all the obscure column options (I reckon there are 350 or so), the
absence of AR seems a major oversight.

Terry, East Grinstead, UK

Keith Nuttle wrote:

On 8/7/2018 7:27 AM, Terry Pinnell wrote:
Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

Could you sort one of the extra columns (right click column Headers) and
sort of height or width?

Thanks but that wouldn't help. An image could have an AR within 1% of
16:9 yet have any of hundreds of possible heights and widths.

Terry, East Grinstead, UK

nospam wrote:

In article , Paul
wrote:

Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?


If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

otherwise known as photo asset manager, such as adobe lightroom:


https://industrydev.com/wp-content/u...sort-menu-item.
jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-20-55.jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-14-56.jpg

Thanks, but that's a lot heavier than what I had in mind!

Terry, East Grinstead, UK

"Mayayana" wrote:

"Terry Pinnell" wrote

| Anyone know of a tool or hack that will do something that Win 10 File
| Explorer unfortunately cannot: sort a folder of files into aspect ratio
| (width/height)?
|
| It's an operation I need quite frequently, such as when trying to
| isolate all files with say a 16:9 ratio (to some fine tolerance if
| necessary).
|
You're talking about image w/h dimensions? Even on
XP I can choose to show "Dimensions" in detail view.
But that still won't sort the images. And it doesn't
calculate w/h ratio.

I doubt many people want that, either, so it's not
likely to exist as software.

It would be relatively simple to do with scripting,
as far as finding w/h and sorting the file list, but
then you'd still have the problem of how to display them.
It sounds like what you want is an Explorer substitute.
It might be easier to just sort and/or resize them by
folder.


Thanks, yes, I'll probably have to take the scripting approach, as per
my reply to Paul.

Terry, East Grinstead, UK

In article , Paul
wrote:

Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?


If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

otherwise known as photo asset manager, such as adobe lightroom:


https://industrydev.com/wp-content/u...sort-menu-item.
jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-20-55.jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-14-56.jpg

Which I assume is free.

lightroom is not free.

In article , Mayayana
wrote:

| otherwise known as photo asset manager, such as adobe lightroom:

| Which I assume is free.
|

Yes, once you've delivered your firstborn.
Alternatively, you can pay Adobe "an arm and
a leg" gradually by renting Abode Creative suite
by the month.

where 'arm and a leg' is just $10/mo, less than a large pizza.

In article , Wolf K
wrote:

If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

otherwise known as photo asset manager, such as adobe lightroom:


https://industrydev.com/wp-content/u...sort-menu-item.
jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-20-55.jpg

https://photojoseph.com/sites/defaul...ips/2016/2016-
07-18_14-14-56.jpg

Which I assume is free.

** Paul

Free versions are available from several sources, but on Adobe's own
website it's payware. Unclear exactly what "Lightroom" means in this
context.

what's unclear?

lightroom is the name of adobe's photo asset manager:
https://www.adobe.com/products/photoshop-lightroom.html

In article , lid says...

Terry Pinnell wrote:
Anyone know of a tool or hack that will do something that Win 10 File
Explorer unfortunately cannot: sort a folder of files into aspect ratio
(width/height)?

It's an operation I need quite frequently, such as when trying to
isolate all files with say a 16:9 ratio (to some fine tolerance if
necessary).

Terry, East Grinstead, UK

The third-party examples I could find, seem to
want to "sort" your image collection, into folders,
according to the complex criteria. So instead
of a search as such, they meddle with the collection.

*******

The only thing I can think of, is edit the metadata
on the images, find a field that is searchable
from Windows Search, then write a representative
value into that field in place of the original data.
Then, rebuild the Search Index, to use the new info.

Instead of writing 1.7778 into the field, if the field
was of string type, you could write "16:9" as a text
string.

So maybe in place of Camera, where it says "Nikon",
you could make the Camera "16:9" brand instead :-)

If would be fun if the Search Index was extensible,
but I don't get the impression it's programmable.
And it's limited to a subset of metadata field types.

Maybe it would take some scripting with EXIFTool or
similar. You would want a tool that doesn't mess up
the file system dates as well (which would be an added
complexity).

*******

If you could have, in effect, a File Manager separate
from Windows, with such complex sorting capabilities,
that would be another way to do it.

*******

Running parallel collections is another way to solve it.

Hi Terry

For Windows 10 :
Writing a little script in awk which is using EXIFTOOL will do the job.
This script will create a batch-file for moving (or copying) all
pictures of an certain witdth/height (+- n %) into a new folder.

If you like I will write this script for you in a few days for nothing.
Just send me an email.

Regards
Reinhard