Batch embedding metadata into JPGs with a csv file
Posted: 2015-03-13T10:09:45-07:00
Hello,
I work at a company that provides digital archival services. We normally use ExifTool to batch transfer meta data from a .csv file into multiple JPGs at once. Recently, however, one of our clients said that the metadata we embedded with ExifTool did not work with there database, and they suggested we use ImageMagick instead.
I use a Windows operating system. What I need to do is batch transfer meta data from a csv file into a set of JPGs. The csv spread sheet would contain all the file names under "SourceFile", and corresponding fields "DateCreated", "Keywords", "Description", and "Writer-Editor". With ExifTool, I do it like this: I put all the JPGs in a folder with ExifTool.exe and the corresponding csv. Then, from the command prompt, in the correct directory, I type:
exiftool.exe -csv="name of csv file" .
and all the metadata from the csv file is embedded into the appropriate fields in the JPGs. I also need to be able to extract meta data from a JPG file to see which fields are populated. With ExifTool I type:
exiftool.exe -s "name of image file'
and it shows me all the metadata fields and the information they are populated with.
So my question is, can I do the same thing, or a similar thing with ImageMagick?
I work at a company that provides digital archival services. We normally use ExifTool to batch transfer meta data from a .csv file into multiple JPGs at once. Recently, however, one of our clients said that the metadata we embedded with ExifTool did not work with there database, and they suggested we use ImageMagick instead.
I use a Windows operating system. What I need to do is batch transfer meta data from a csv file into a set of JPGs. The csv spread sheet would contain all the file names under "SourceFile", and corresponding fields "DateCreated", "Keywords", "Description", and "Writer-Editor". With ExifTool, I do it like this: I put all the JPGs in a folder with ExifTool.exe and the corresponding csv. Then, from the command prompt, in the correct directory, I type:
exiftool.exe -csv="name of csv file" .
and all the metadata from the csv file is embedded into the appropriate fields in the JPGs. I also need to be able to extract meta data from a JPG file to see which fields are populated. With ExifTool I type:
exiftool.exe -s "name of image file'
and it shows me all the metadata fields and the information they are populated with.
So my question is, can I do the same thing, or a similar thing with ImageMagick?