Our server costs ~$56 per month to run. Please consider donating or becoming a Patron to help keep the site running. Help us gain new members by following us on Twitter and liking our page on Facebook!
Current time: March 28, 2024, 7:20 pm

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Digital image post processing: Question on adding data to a photo
#1
Digital image post processing: Question on adding data to a photo
I’ve got a young lady in Atlanta doing an inventory of the National Park Service’s Martin Luther King Collection. One of the requirements is photography of about 1200 items in the collection that the Park Service doesn’t currently have good digital photographs of. I’m hoping someone here can point me in the right direction of a method of adding data to a JPG file. We will be capturing the images as RAW (NEF since the camera is a NIKON D750) and JPG. The customer’s requirement is Tiff and JPG. We need to batch convert the RAW files to Tiff. That part is easy enough, but we also need to add the object’s accession number and a date to the JPG. The end result needs to look like this.

[Image: 3BrPOPX.jpg]

I need to add the black rectangle with the object name and data. Are there any tools available that would let us add the data we need to the digital file’s metadata then extract it out and put it in the JPG in a batch process. Can we do it in real time with a laptop connected to the camera? Are we stuck with doing that manually one photo at a time in Photoshop or something?
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply
#2
RE: Digital image post processing: Question on adding data to a photo
Have you tried this ?
https://www.arclab.com/en/watermarkstudio/

There is a free trial
'Those who ask a lot of questions may seem stupid, but those who don't ask questions stay stupid'
Reply
#3
RE: Digital image post processing: Question on adding data to a photo
Thanks! I'll look into that. It sounds like what I need.
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply
#4
RE: Digital image post processing: Question on adding data to a photo
I've got some experience in doing stuff like this. Photoshop has macros, or it's actually fairly easy just to write a Windows program that will do this. It should be trivially simple to add a text box to an existing image. I might be coerced into helping, actually, since it sounds like an important project.

My first question would be-- where is the data coming from? Are you entering it by hand on a per item basis? Is the data already in a spreadsheet or database, and you are just adding the images to match? Are the numbers sequential (in which case you could generate the complete list auomatically in Excel, save it to a file, and use a dropdown menu to just pick which ID goes with which image)? Are the images all the same size and orientation?

With 1200 items, I'd definitely recommend spending some time getting the exact right tool for your process, because that's a lot of elbow grease you're talking about there.
Reply
#5
RE: Digital image post processing: Question on adding data to a photo
(November 20, 2017 at 9:47 pm)bennyboy Wrote: I've got some experience in doing stuff like this.  Photoshop has macros, or it's actually fairly easy just to write a Windows program that will do this.  It should be trivially simple to add a text box to an existing image.  I might be coerced into helping, actually, since it sounds like an important project.

My first question would be-- where is the data coming from?  Are you entering it by hand on a per item basis?  Is the data already in a spreadsheet or database, and you are just adding the images to match?  Are the numbers sequential (in which case you could generate the complete list auomatically in Excel, save it to a file, and use a dropdown menu to just pick which ID goes with which image)?  Are the images all the same size and orientation?

With 1200 items, I'd definitely recommend spending some time getting the exact right tool for your process, because that's a lot of elbow grease you're talking about there.

After looking at some of the tools yesterday I think this is probably the way to go. It is kind of what I had in mind to begin with. I'm just not a Photoshop kinda guy so I don't know how to pull it off. Neither does the museum technician we hired for the project. As far as coercing goes I could probably pay you to consult if you are interested. I just need to make sure that wouldn't be a problem first since this is a for the government. I wouldn't want to get in trouble with Girly for hiring a North Korean spy to insert fractals into the JPG's that upload a virus into the Park Service server that burns down the Smithsonian. My available budget isn't unlimited though...

There is a spreadsheet, and we are adding images to match. The numbers are for the most part sequential, but the photos will not be taken in order since the items are randomly located in four different locations. The customer also already has photos of about 90 of the 1258 objects. These will not need to be photographed again, but the accession numbers for these objects aren't sequencial. There are columns in the spreadsheet for accession number, inventory date and item condition among others. The text we need to insert is the accession number and the inventory date. It might be nice if we could embed the item condition in the exif (my new word of the day yesterday) data too, but that is just an idea, not a requirement. What I see in my mind goes go something like this:

1. Complete the inventory (A lot of this is already done)
2. Photograph the objects (this won't start until after the first of the year)
2a. The images will be captured in NEF (Nikon RAW) and JPG
2b. We can at this point name (rename) the photos manually to match the accession number if there isn't an easy way to do that later in the process
3. Batch convert the NEF images to TIFF (rename the images if we didn't do that earlier)
4. Insert the watermarks and edit the exif data
5. Batch convert the TIFF images to JPG (the deliverable is both formats, edited and unedited)
6. Profit???

If you are interested in consulting let me know, and we'll talk offline. I see your part as developing the macro and showing Becca and/or me how to use it.
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply
#6
RE: Digital image post processing: Question on adding data to a photo
(November 20, 2017 at 11:44 am)popeyespappy Wrote: I’ve got a young lady in Atlanta doing an inventory of the National Park Service’s Martin Luther King Collection. One of the requirements is photography of about 1200 items in the collection that the Park Service doesn’t currently have good digital photographs of. I’m hoping someone here can point me in the right direction of a method of adding data to a JPG file. We will be capturing the images as RAW (NEF since the camera is a NIKON D750) and JPG. The customer’s requirement is Tiff and JPG. We need to batch convert the RAW files to Tiff. That part is easy enough, but we also need to add the object’s accession number and a date to the JPG. The end result needs to look like this.

[Image: 3BrPOPX.jpg]

I need to add the black rectangle with the object name and data. Are there any tools available that would let us add the data we need to the digital file’s metadata then extract it out and put it in the JPG in a batch process. Can we do it in real time with a laptop connected to the camera? Are we stuck with doing that manually one photo at a time in Photoshop or something?


I took the liberty of re-posing your question anonymously at a Digital darkroom forum.
Reply
#7
RE: Digital image post processing: Question on adding data to a photo
(November 21, 2017 at 10:49 am)Anomalocaris Wrote: I took the liberty of re-posing your question anonymously at a Digital darkroom forum.

Thanks. I've bookmarked the link. I'll join the forum if the thread gets any hits.
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply
#8
RE: Digital image post processing: Question on adding data to a photo
(November 21, 2017 at 9:13 am)popeyespappy Wrote:
(November 20, 2017 at 9:47 pm)bennyboy Wrote: I've got some experience in doing stuff like this.  Photoshop has macros, or it's actually fairly easy just to write a Windows program that will do this.  It should be trivially simple to add a text box to an existing image.  I might be coerced into helping, actually, since it sounds like an important project.

My first question would be-- where is the data coming from?  Are you entering it by hand on a per item basis?  Is the data already in a spreadsheet or database, and you are just adding the images to match?  Are the numbers sequential (in which case you could generate the complete list auomatically in Excel, save it to a file, and use a dropdown menu to just pick which ID goes with which image)?  Are the images all the same size and orientation?

With 1200 items, I'd definitely recommend spending some time getting the exact right tool for your process, because that's a lot of elbow grease you're talking about there.

After looking at some of the tools yesterday I think this is probably the way to go. It is kind of what I had in mind to begin with. I'm just not a Photoshop kinda guy so I don't know how to pull it off. Neither does the museum technician we hired for the project. As far as coercing goes I could probably pay you to consult if you are interested. I just need to make sure that wouldn't be a problem first since this is a for the government. I wouldn't want to get in trouble with Girly for hiring a North Korean spy to insert fractals into the JPG's that upload a virus into the Park Service server that burns down the Smithsonian. My available budget isn't unlimited though...

There is a spreadsheet, and we are adding images to match. The numbers are for the most part sequential, but the photos will not be taken in order since the items are randomly located in four different locations. The customer also already has photos of about 90 of the 1258 objects. These will not need to be photographed again, but the accession numbers for these objects aren't sequencial. There are columns in the spreadsheet for accession number, inventory date and item condition among others. The text we need to insert is the accession number and the inventory date. It might be nice if we could embed the item condition in the exif (my new word of the day yesterday) data too, but that is just an idea, not a requirement. What I see in my mind goes go something like this:

1. Complete the inventory (A lot of this is already done)
2. Photograph the objects (this won't start until after the first of the year)
2a. The images will be captured in NEF (Nikon RAW) and JPG
2b. We can at this point name (rename) the photos manually to match the accession number if there isn't an easy way to do that later in the process
3. Batch convert the NEF images to TIFF (rename the images if we didn't do that earlier)
4. Insert the watermarks and edit the exif data
5. Batch convert the TIFF images to JPG (the deliverable is both formats, edited and unedited)
6. Profit???

If you are interested in consulting let me know, and we'll talk offline. I see your part as developing the macro and showing Becca and/or me how to use it.


It sounds like an interesting project.  I don't think Photoshop is the right tool for this job-- straight-up Windows programming should be much better, because it allows for complete control.

As for security, probably the easiest way around that would be for me to provide source code along with the executable.  Then it can pretty easily be determined that there's nothing fishy going on.  To be honest, I don't think the whole project will need more than a couple hundred lines of code.

I also use images at work (pictures for making test questions for English), so I can benefit later by my work on this project.
Reply
#9
RE: Digital image post processing: Question on adding data to a photo
(November 22, 2017 at 10:12 am)bennyboy Wrote:
(November 21, 2017 at 9:13 am)popeyespappy Wrote: 1. Complete the inventory (A lot of this is already done)
2. Photograph the objects (this won't start until after the first of the year)
2a. The images will be captured in NEF (Nikon RAW) and JPG
2b. We can at this point name (rename) the photos manually to match the accession number if there isn't an easy way to do that later in the process
3. Batch convert the NEF images to TIFF (rename the images if we didn't do that earlier)
4. Insert the watermarks and edit the exif data
5. Batch convert the TIFF images to JPG (the deliverable is both formats, edited and unedited)
6. Profit???
It sounds like an interesting project.  I don't think Photoshop is the right tool for this job-- straight-up Windows programming should be much better, because it allows for complete control.

Can you do 2b through 5 in windows without accessing Photoshop or something similar? i.e. inserting the watermark and format conversions? What kind of hardware and software requirements would the user have to run the program?

I going to PM my work email so we can take this offline if you want.
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply
#10
RE: Digital image post processing: Question on adding data to a photo
(November 20, 2017 at 9:47 pm)bennyboy Wrote: With 1200 items, I'd definitely recommend spending some time getting the exact right tool for your process, because that's a lot of elbow grease you're talking about there.

All done! 2036 different images each in NEF, TIF, and JPG formats. About 311 GB total.

The tools I used were Fastone Image Viewer, ExifTool and a spreadsheet. Faststone Image Viewer to batch convert the NEF images to TIF and JPG. It also inserted the metadata for item number and date photographed into the photo during the conversion process. I used the excel concatenate command to build command lines then saved them as batch files to rename everything. Only had to write one command then drag it down the column to create thousands of commands. Then built the commands to edit the EXIF data the same way. Those batch files used the ExifTool to edit the EXIF data to add the inventory information to each photo.

I spent about three days total on it, but a lot of that time was spent debugging Becca's spreadsheet that cross referenced the original photograph filename with the park's object number. Once that was straight it was mostly just waiting on FastStone to do the conversions. The 8144 lines of command line stuff went really fast.
Save a life. Adopt a greyhound.
[Image: JUkLw58.gif]
Reply



Possibly Related Threads...
Thread Author Replies Views Last Post
  Data John 6IX Breezy 3 573 May 21, 2022 at 3:28 pm
Last Post: BrianSoddingBoru4
  External hard drive has lost all its data fredd bear 33 2763 February 27, 2019 at 10:19 pm
Last Post: Ravenshire
  Digital “Resurrections” LadyForCamus 12 1292 April 23, 2018 at 7:33 am
Last Post: Edwardo Piet
  ISP's selling your data Sterben 2 414 October 24, 2017 at 9:39 pm
Last Post: Minimalist
  Microsoft wins US data access case account_inactive 2 753 July 19, 2016 at 8:30 pm
Last Post: account_inactive
  ISP Web Activity Data Love 3 1500 May 17, 2013 at 11:35 pm
Last Post: dazzn
Question Best photo editing software Welsh cake 4 1551 January 9, 2013 at 1:11 pm
Last Post: Annik
  photo hosting sites? Oldandeasilyconfused 3 1446 August 24, 2012 at 7:25 am
Last Post: Angrboda
  Wireless Data From Every Light Bulb thesummerqueen 2 1444 August 11, 2011 at 7:23 pm
Last Post: frankiej
  Why you shouldn't delete crappy photos you take with a digital camera. Tiberius 7 2433 December 21, 2010 at 9:20 pm
Last Post: Autumnlicious



Users browsing this thread: 1 Guest(s)