Batch import .JSON into corresponding .JPG file possible?

[mr.SVG]

Hello everybody!
I came to you from Flickr Help forum with topic "Update metadata from JSON file to JPEG"
Unfortunately, Flicker has lost some of my metadata in my JPG files after download 'em. About 1/3 of 40,000 photos lost "date_taken" info.

As is the case of topicstarter, I have downloaded my collections from FlickR with some software that created .JSON files for each image.  I would like to batch process each directory to add only one Tag "date_taken" to my .JPG files.

I really lucky that I successfully updated one of my JPEG file. But it was one problem - I have to remove "license" info in JSON data before.

Structure of my Data requested files was:
photo_21541919504.json
21541919504_60e8af7cff_o.jpg

I ran: exiftool -TagsFromFile photo_21541919504.json "-DateTimeOriginal<date_taken" 21541919504_60e8af7cff_o.jpg
and it updated successfully!

So I got two questions to respected community:
1) Which command should I run for removing license info "All Rights Reserved" in JSON data for ALL files?
2) Which command should I run for updating all JPEG files in a batch mode for only one Tag "date_taken"?
Thanks in advance for your any advice!

[Phil Harvey]

I'm not sure I understand what you are asking, but ExifTool doesn't have the ability to edit JSON files.  You can export selected metadata to a JSON file with the -j option, but importing from a JSON file will import all of the metadata from the file.

- Phil

[StarGeek]

I ran: exiftool -TagsFromFile photo_21541919504.json "-DateTimeOriginal<date_taken" 21541919504_60e8af7cff_o.jpg
and it updated successfully!
...
2) Which command should I run for updating all JPEG files in a batch mode for only one Tag "date_taken"?

Your command is pretty much the command to run, but the problem is matching the jpg file to the json file due to the differences in the file names.  In this case, the first 11 characters in the file name is what is needed to create the json name, but you should verify that this is the case for all the other files.

Your basic command would be something like:
exiftool --ext json -TagsFromFile %dphoto_%11f.json "-DateTimeOriginal<date_taken" /path/to/target/directory

Add the -r (recurse) option to recurse into subdirectories.  The -ext (extension) option with two hyphens is used to make sure that json files are not processed while scanning directories.

[mr.SVG]

I'm not sure I understand what you are asking, but ExifTool doesn't have the ability to edit JSON files.  You can export selected metadata to a JSON file with the -j option, but importing from a JSON file will import all of the metadata from the file.

- Phil

When I'm trying to writing the exif data into the jpg, the message appears:
"Warning: [minor] XMP-cc:License written as a literal because value is not a valid URI"
and nothing happens with updating.
To avoid this, I have to open .JSON file and delete license info "All Rights Reserved", I fill "0" instead.
If I do this, my JPEG converting successfull. How to do it in batch mode?

.... with two hyphens is used to make sure that json files are not processed while scanning directories.

Thank you! My English is not so good, but worst of all, I was not familiar with the command line before. But I will try as hard as I can. Thanks again.

[Phil Harvey]

This warning shouldn't affect the way anything else is written.  ExifTool is just warning you that the XMP-cc:License will be stored in a non-standard format since it isn't a valid URL.  Everything else should still be written OK.

- Phil

[Phil Harvey]

To illustrate, here is the relevant XMP that is produced, both with an ok URI, and one that is not ok:

Code Select Expand

> exiftool -o -.xmp -xmp-cc:license="ok" | grep cc:license
  <cc:license rdf:resource='ok'/>

> exiftool -o -.xmp -xmp-cc:license="not ok" | grep cc:license
Warning: [minor] XMP-cc:License written as a literal because value is not a valid URI -
  <cc:license>not ok</cc:license>

Notice how the valid URI is stored as an rdf:resource, but the invalid one isn't.  A valid URI may not contain spaces (among other things).

- Phil

[mr.SVG]

Finaly I've updated all my 40K jpg files from Flickr, thanks to all good people from here and Flickr forum! 
But one problem is still here - I can't update *.PNG files. Not once not in a batch mode. It doesn't work anymore:
C\user\user>exiftool -TagsFromFile 21541919504.json "-DateTimeOriginal<date_taken" 21541919504.png
How can I update all my *.png files from *.json files with the same name in batch ? I need to update only one parameter "Date_taken"

[Phil Harvey]

What you you mean by "doesn't work"?  Is this FAQ number 3?

Check to see what tags are available in the JSON file with this command:

exiftool -s 21541919504.json

- Phil

[Phil Harvey]

ExifTool 13.03 adds the ability to include or exclude specified tags from the JSON import, and 13.12 will expand this ability to allow group names and/or wildcards to be used when specifying which tags to import:

            Specific tags may be imported from the JSON database by adding
            -TAG options to the command, or excluded with --TAG, with
            exclusions taking priority.  Group names and wildcards are
            allowed.  If no tags are specified, then all except FileName and
            Directory are used.  Tags are imported in the same order as the
            database entries.

- Phil