[AA] osxphotos query --field ... to get Original File Name with extension

[Als-Home]

Using : osxphotos query --field name "{name}" --field original_name "{original_name}"
I was surprise that the "original_name" of the file does not contain the extension when imported into Photo.

I integrated with a database that generate website html pages on search demand. In the original design, it is required to have the extension of the files such as .JPG or .MP4 or .MOV ...
I run the osxphotos query >> photosMetadata.csv
then imported into the database,
then some processes in the db using the metadata including the name of the file.ext
then from PHP using API against the database, generate dynamic html

Did I missed something or misunderstand the osxphotos query --field "options" that does not export the file name with the extension ? Can I achieve this ?

Thanks
AA

[RhetTbull]

Yes, you can get the original name with extension using {photo.original_filename}

From osxphotos template:

>>> current filename: {name} original filename: {original_name} filename with extension: {photo.original_filename}
current filename: 8846E3E6-8AC8-4857-8448-E3D025784410 original filename: IMG_1693 filename with extension: IMG_1693.tif

The {name} field isn't terribly useful. This is a hold-over from Photos 4 and before when Photos did not rename files on import. In Photos 5 and later, it shows the the current name of the photo in the library. When you import a photo, it is renamed using a random UUID (unique ID) so the file on disk is actually called something like 8846E3E6-8AC8-4857-8448-E3D025784410.heic. This is what {name} shows you.

The {original_name} field shows what the name was before import (and typically, what the name will be on export). It does not include extension because it was designed to be used with the --filename option of osxphotos export where the user can specify the stem of the filename without having to worry about the extension, which osxphotos automatically applies on export. For example, osxphotos export ... --filename "{original_name}_{created.year}{created.mm}{created.dd}" would output something like IMG_3092_20200919and osxphotos would export the file asIMG_3092_20200919.heic, etc. Some photos such as RAW+JPEG or Live Photos have more than one extension per asset, for example, IMG_1234.jpgandIMG_1234.cr2thus osxphotos manages this automatically when usingosxphotos export`.

In query, to get the original name with extension, you can use {photo.original_filename} to get IMG_3092.heic. The {photo.X} template allows you to access the various properties of the PhotoInfo class that osxphotos creates for each photo.

[Als-Home]

The {photo.original_filename} does work very well. Thank you very much
where all these metadata variables are documented ?

[RhetTbull]

where all these metadata variables are documented ?

See osxphotos docs then see the page on OSXPhotos Template System. Alternatively, you can see the docs here. The PhotoInfo properties are documented in the Python API docs here.