Changing file date to field in json file (YouTube/Google Takeout)

[camjac251]

I am trying to process this YouTube export I have but sadly the original file dates only exist as fields in the VideoName-metadata.json file included. All dates in the files themselves are from when the export was done.

I was hoping to use the field below from VideoName-metadata.json and save as the FileModifyDate (or all) on the VideoName.mp4 file. Each video has its own -metadata.json file.

Code Select Expand

"publishedAt" : "2019-09-13T14:00:03.000Z",

I am attempting it with this but get back an error of Warning: No writable tags set from video-metadata.json

Code Select Expand

exiftool -tagsfromfile "%f-metadata.json" "-FileModifyDate<publishedAt" -ext mp4 .

Could it be that I'm missing a step of converting the publishedAt date to a readable format? I found something with php [https://stackoverflow.com/questions/56138576/how-i-can-convert-publishedat-to-date-and-time]using strtodate with Google Takeout info[/url] but wasn't sure how that would be possible in exiftools.

This is what I tried following but could not get this to work.
[https://exiftool.org/forum/index.php?PHPSESSID=edc8cc8b879d3bf08f8655837a944d2b&topic=8154.msg41851#msg41851]https://exiftool.org/forum/index.php?PHPSESSID=edc8cc8b879d3bf08f8655837a944d2b&topic=8154.msg41851#msg41851[/url]

Has anyone ran into the same problem as me before? I couldn't find any search results for YouTube takeout or publishedAt on the forums or Google with exiftool.

[StarGeek]

Could it be that I'm missing a step of converting the publishedAt date to a readable format?

Run this command on the JSON file.
exiftool -s file.json

Exiftool will return the tag names of the various data in the file.  You can then figure out what name to use instead of "publishedAt"

[camjac251]

Thank you very much.

Turns out it was

Code Select Expand

SnippetPublishedAt that I needed to use instead.