Dating uploads

Just curious: is there a way to tell when a file was uploaded online? On this site, https://pideja.ca there are files dating back to 1989, but have been uploaded probably since around 2013. But can I precisely tell?

I don’t see a way to find this information in Backlight. Might be a cool feature to have though.

But you can look in the database.
When you get in, click on “Publisher” in the Change Database box on the left. Then click on “photo” in the Publisher box that appears.

There is a column for Filename where you can sort on the filename. At the far right of the table is a column titled “created.” This appears to be the upload date (I just added an album of images to a test site and the “created” date/time coincides to the upload date/time).

image

You’ll probably have to scroll horizontally to get to the “created” column. There’s a little bar at the bottom of the window.

I don’t know if you can use the LUA metadata token to program an upload date into your metadata.

If you’re handy at using Excel or SQL databases, you can export the “photo” table (as CSV for Excel) and then save it on your computer.

I was just messing with this and found that if you want to export as CSV, then in the Options section, set Fields terminated by to a comma.

This actually worked pretty good. After opening in Excel, I could drag the columns to show only the relevant information, such as filename, url of the album, and created (uploaded) date.