Batch copy Description to Keywords with stop words

[Rusam]

Dear Phil and other program developers!

Can the exiftool.exe program on Windows do the following.

IPTC .jpg or .mov files have Description:

This is a beautiful elephant against the background of savvana

Is it possible to form a command line that copies Description to Keywords? At the same time, they should be separated by commas and remove the words that are blacklisted.

That is, the following should appear in the keywords in IPTC:

beautiful, elephant, against, background, savvana

Words "This, is, a,  of" are blacklisted and should not be inserted.

This should work in batches for the entire directory.

Thanks in advance!

[StarGeek]

For images, it's possible, but the blacklist might get really messy.  For video, the problem is figuring out where the keywords would go.  That depends upon what program you're using to view the keywords.

For images, your command would be something like
exiftool -sep "," "-Subject<${Description;s/word1|word2|word3|etc|wordN//g;s/ +/,/g}" /path/to/files/

Any blacklisted word would be separated by the pipe | character.  This would apply to alpha-numeric characters, as certain punctuation characters, such as ()[]!+^${} would have special meaning in this context.

I assumed in this that you meant IPTC Core, not IPTC IIM/Legacy tags.  If you meant the latter than it would be Keywords/Caption-Abstract instead of Subject/Description.

For videos, it would be similar, but it would also depend on what you would be viewing the keywords with.  If you are using Windows Properties->Details->Tags, than it isn't possible as Windows uses the Microsoft:Category tag which pretty much no software other than Windows has the ability to write.

[Rusam]

StarGeek, you are a great  and this program is great!
Everything works!

  To remove the dot, I put a slash:

Code Select Expand

| \. |

It is important for me to remove the quotes:

Code Select Expand

"
Nothing helps yet.

Backup files appear: _original
They are not needed.

[StarGeek]

It is important for me to remove the quotes:

Code Select Expand

"
Nothing helps yet.

Are the quotes in the original description?  If so, then try adding \" as a blacklist word, e.g.  word1|word2|\"|word3  Quotes are tricky on the Windows command line.

If quotes are not in the original description, most programs will display quotes when listing keywords that have spaces or similar characters in them.

Backup files appear: _original
They are not needed.

Add the -overwrite_original option.

[Rusam]

Are the quotes in the original description?  If so, then try adding \" as a blacklist word, e.g.  word1|word2|\"|word3  Quotes are tricky on the Windows command line.

I did both forward slashes and backslashes. Nothing works.

Add the -overwrite_original option.

Thank you!

[Rusam]

And further:

If the blacklist contains the the script destroys the word, for example, clothes. It turns out clos.
Is it possible to make the script respond not to a part of the word, but to the whole word?

[StarGeek]

Ah, yes, sorry.  Try this
"-Subject<${Description;s/\b(?:word1|word2|word3|etc|wordN)\b//g;s/ +/,/g}"

That will only cut on word boundaries.  There will still be some exceptions, such as contractions.  For example, blacklisting John will change John's into 's

Are the quotes in the original description?

[Rusam]

Are the quotes in the original description?

Yes, I'm sorry. Here's an example:

"Scarlet Rose" cream cake.

Me need it like this:

Code Select Expand

Scarlet, Rose, cream, cake
And it turns out like this:

"Scarlet, Rose", cream, cake.

[StarGeek]

As I said, double quotes are tricky to get passed through on the command line.  But you can use hex notation (had to look this up).  Add \x22 as a blacklisted word.

Code Select Expand

C:\>exiftool -g1 -a -s -description -subject y:\!temp\Test4.jpg
---- XMP-dc ----
Description                     : "Scarlet Rose" cream cake.

C:\>exiftool -P -overwrite_original "-subject<${Description;s/\x22|\.//g;s/ +/,/g}" -sep "," y:\!temp\Test4.jpg
    1 image files updated

C:\>exiftool -g1 -a -s -description -subject y:\!temp\Test4.jpg
---- XMP-dc ----
Description                     : "Scarlet Rose" cream cake.
Subject                         : Scarlet, Rose, cream, cake

[Rusam]

Add \x22 as a blacklisted word.

Thanks a lot, StarGeek, it is works!

I used to make php-file to insert from the description into the keywords. But there was a lot of manual copy-paste work there. And one file at a time.
exiftool has great possibilities!

[StarGeek]

There's a problem with your second command.  It makes a single, long keyword instead of multiple keywords (see FAQ #17).

So in the example above, you get one keywords of
Scarlet, Rose, cream, cake
instead of four separate keywords
Scarlet
Rose
cream
cake
For the second command, add -sep ", "

To double check the tag, try using different characters for the -sep option output

Code Select Expand

C:\>exiftool -g1 -a -s -sep "##" -subject y:\!temp\Test4.jpg
---- XMP-dc ----
Subject                         : Scarlet##Rose##cream##cake

[Rusam]

For the second command, add -sep ", "

Когда я добавил -sep ", ", у меня стало:

ScarletRosecreamcake

А если такой код, который я написал выше, то все нормально:

Scarlet, Rose, cream, cake

[Rusam]

StarGeek, you are a great specialist. I have re-read all threads with the same problem but couldn't find a solution anywhere.

I can explain with pictures. I've simplified everything for the experiment.

The d disk contains the m directory.

There are two files: 1.jpg and meta.csv .



Here is the content of the meta.csv file:

filename, keywords, description, title, content warnings, country, poster timecode
"1.jpg", "Women, Beautiful, Fashion, People, Caucasian Ethnicity", "", "", "", "", ""

I want to transfer keywords from the csv file to IPTC images.
I run the command:

Code Select Expand

exiftool.exe -csv = D:\m\meta.csv --Subject d:\m\

But nothing happens. Major error No SourceFile 'd:/m/1.jpg' in imported CSV database .



I set uppercase and lowercase drive letters - nothing works.

[StarGeek]

But nothing happens. Major error No SourceFile 'd:/m/1.jpg' in imported CSV database .

From the docs on the -csv option
   A special "SourceFile" column specifies the files associated with each row of information

Your example CSV has a "filename" column, not a "SourceFile" column.

Also take note that the "SourceFile" column must be a fairly exact match.  If you only have the filenames, no path, in that column, then the current dir must be the same as the file.

Also, as mentioned in the docs, you're going to need the -sep option to make sure the Keywords are split up into separate keywords as I mentioned above.

Another thing to watch for is that you're mixing groups.  Keywords is an older IPTC IIE/Legacy tag, while Description is a newer XMP tag, part of the IPTC Core.  The Subject tag is the place for keywords in the IPTC Core schema.

[Rusam]

Thanks a lot, StarGeek.

We'll have to edit large csv files every time.