-
1. Re: Any way to locate original image number in LR4?
areohbee Sep 30, 2013 4:58 PM (in response to soloalpinist)I don't think Lr saves the original image number anywhere. It has 'originalFIlename', but that's as it was upon import, not out-of-camera.
That said, you can obtain the original file number using exiftool, e.g.
exiftool -fileNumber {file}
If you are not familiar with exiftool and executing such commands, there are plugins you can use for assistance, e.g.
* Jeffrey Friedl's metadata viewer: http://regex.info/blog/lightroom-goodies/metadata-viewer
* ExifMeta
Rob
-
2. Re: Any way to locate original image number in LR4?
Jim Wilde Sep 30, 2013 5:15 PM (in response to areohbee)The original file name, i.e. the pre-rename file name, is stored in the "importHash" field in the agLibraryFile table in the catalog. Pity it can't be seen in the metadata panel, rather than having to delve into the catalog tables.
-
3. Re: Any way to locate original image number in LR4?
soloalpinist Oct 1, 2013 6:35 AM (in response to areohbee)I'm not familiar with exiftool and the commands
-
4. Re: Any way to locate original image number in LR4?
areohbee Oct 1, 2013 7:45 AM (in response to soloalpinist)soloalpinist wrote:
I'm not familiar with exiftool and the commands
Then I'm guessing you'd not know how to access the importHash via SQL.
That said, try one of the plugins mentioned above.
* jf's is best for on-demand display (since the format is very nice - e.g. color-coded...)
* ExifMeta is best if you want to use exif info in lib filters or smart collections or take the time to exclude all but what you are interested in, and see it in right-hand library panel...
Rob
-
5. Re: Any way to locate original image number in LR4?
areohbee Oct 1, 2013 7:52 AM (in response to Jim Wilde)Jim Wilde wrote:
The original file name, i.e. the pre-rename file name, is stored in the "importHash" field in the agLibraryFile table in the catalog.
Good find Jim. But note, that only works if Lr did the renaming. i.e. those who use pre-import ingestion (renaming) or import plugin (like me) can not get file-number from import-hash. In other words, it stores the filename before rename-upon-import, not info from exif.
-
6. Re: Any way to locate original image number in LR4?
Jim Wilde Oct 1, 2013 8:03 AM (in response to areohbee)There are other circumstances as well where it doesn't work, but it does work in the more usual "rename during (or after) import" operation, which is what I thought the OP was describing.
-
7. Re: Any way to locate original image number in LR4?
areohbee Oct 1, 2013 8:19 AM (in response to Jim Wilde)Jim Wilde wrote:
There are other circumstances as well where it doesn't work
Do tell.
Jim Wilde wrote:
which is what I thought the OP was describing.
Indeed, the import-hash may be viable in the OP's case (I really don't know the history of the OP's files pre-import), but to be clear: access to the import-hash requires SQL with catalog not open in Lr.
-
8. Re: Any way to locate original image number in LR4?
Jim Wilde Oct 1, 2013 9:22 AM (in response to areohbee)Rob Cole wrote:
Do tell.
I think you'll find that if you "Import from another catalog" and bring in new photos in that process, the "importHash" field for those new photos will be blank in the receiving catalog post import, even if the same field in the incoming catalog is correctly filled. Being totally blank means (I'm pretty sure) that if you then tried to import those images via "normal" means the "Suspected Duplicates" checking would be invalidated as (I'm pretty sure) it's the "importHash" field which is used for that check.
Also, I think you'll find that derivatives such as Tif created via the "Edit In..." process also get a blank "importHash" field....though that's probably a lesser concern.
Rob Cole wrote:
...but to be clear: access to the import-hash requires SQL with catalog not open in Lr.
Yes, but nowhere near as difficult as some might imagine. No SQL knowledge is required, using something like the SQLite plug-in in Firefox is as easy as browsing an Excel spreadsheet. If I can do it, it must be easy.
-
9. Re: Any way to locate original image number in LR4?
soloalpinist Oct 1, 2013 9:24 AM (in response to areohbee)http://blogs.adobe.com/jkost/2013/03/saving-the-original-file-name-in-lightroom.html
Found what I was looking for here...
Thanks for the input
-
10. Re: Any way to locate original image number in LR4?
areohbee Oct 1, 2013 9:31 AM (in response to soloalpinist)I had assumed the "original filename" field was not cutting it, since I mentioned it in my first post (first sentence), and it didn't get any traction.
Anyway, glad you got it sorted...
And I learned some things from Jim .
R
-
11. Re: Any way to locate original image number in LR4?
Jim Wilde Oct 1, 2013 9:34 AM (in response to soloalpinist)Not really, unless you decide you change your import workflow. The "Original Filename" field will only be displayed if your rename AFTER import. If you rename either during import (or before import) you will only see the one "File Name" entry in the Metadata panel, which will be the filename that the file has on conclusion of the import.
-
12. Re: Any way to locate original image number in LR4?
areohbee Oct 1, 2013 9:35 AM (in response to Jim Wilde)Thanks Jim. That all makes sense.

