Author Topic: software to import the keywords from all my photos? (Read 7345 times)

niserin · « **on:** January 22, 2013, 18:51 »

Hi,

I am looking for a program which would gather all the keywords from all my stock photos that have metadata.
The keywords would be imported without duplicates and in the number of usages order.

Then, I would like to export it to a txt file.

Do you know such program ?

Thanks!
Michal

red · « **Reply #1 on:** January 22, 2013, 19:19 »

Photo Mechanic http://www.camerabits.com/products/

niserin · « **Reply #2 on:** January 23, 2013, 05:28 »

Doesn't have the option I described...

red · « **Reply #3 on:** January 23, 2013, 08:14 »

Depends. You can export all (or some) of the iptc info from Photo Mechanic to a text or database (Excel) file. You can write a macro to sort or eliminate the fields you don't want. It takes some experimenting but Photo Mechanic can export data into text fields. Use the Export Text command. Select the 'Text' template. Enter your desired variables (one variable is keywords) in your desired order. If you're trying to make a tab-delimited file (for importing into Excel) then use the {tab} variable between fields and the {nl} variable at the end of the line. Once you have the info in Excel you can eliminate duplicates and possibly determine how many times they appear. Sounds like a lot of work but it can be done.

MichaelJayFoto · « **Reply #4 on:** January 23, 2013, 08:40 »

Thanks a lot!

I ran across this topic as I am searching for a software to do it the other way around (get Metadata from a text file into the JPGs) and the demo version of PM is doing it just fine.

It's just not quite cheap as I'm looking for that bit only but it still might be worth it instead of keywords thousands of files manually.

niserin · « **Reply #5 on:** January 23, 2013, 09:09 »

Thank you for your help, but I still can't work it out. I do not see the Text Export field anywhere.

niserin · « **Reply #6 on:** January 23, 2013, 09:22 »

Ok, I think I found it, but the export command results in an unknown file type that after opeing in notepad or excel is blank.

red · « **Reply #7 on:** January 23, 2013, 09:33 »

Try this site for some info. It has to do with their template function (available in 4.6 and later) - http://www.photometadata.org/meta-tutorials-photo-mechanic-batch-captioning I work with an enterprise image content database called Canto Cumulus and it can do what you want but it is megabucks and for large businesses.

niserin · « **Reply #8 on:** January 23, 2013, 10:17 »

Ok, FotoStation from Fotoware does the best job in the easiest user friendly way.

red · « **Reply #9 on:** January 23, 2013, 10:24 »

Interesting. I see no prices. Is there a personal use version? I see they have a trial version but ask for a company name. A Digital Asset Management program is exactly what you need.

niserin · « **Reply #10 on:** January 23, 2013, 10:35 »

Right, now having thousands of keywords in txt file I need to remove duplicates. Can I do it in open office or excel ?

red · « **Reply #11 on:** January 23, 2013, 11:05 »

Yes, a simple find and replace. http://office.microsoft.com/en-us/excel-help/find-or-replace-text-and-numbers-on-a-worksheet-HP001216390.aspx

niserin · « **Reply #12 on:** January 23, 2013, 12:02 »

But it is just a manual work - typing every keyword, searching them and removing... Any automatic way ?

red · « **Reply #13 on:** January 23, 2013, 12:09 »

You will need to write a macro or find one by Googling. Here's an older macro but there may be newer ones - http://www.cpearson.com/excel/duplicates.aspx

disorderly · « **Reply #14 on:** January 23, 2013, 12:32 »

This sort of thing is trivial on a Unix system, including Linux, Mac and even Windows with a package like Cygwin installed. Given a text file of keywords, one to a line, the command

sort input.txt | uniq >output.txt

will remove duplicates. Find your closest Linux friend and they can knock it out in seconds.

niserin · « **Reply #15 on:** January 23, 2013, 15:28 »

http://www.tracemyip.org/tools/remove-duplicate-words-in-text/

I wish I had though about googling "remove duplicate words online" earlier

.

Thanks for your help,
Michal

red · « **Reply #16 on:** January 23, 2013, 15:35 »

Cool!

leaf · « **Reply #17 on:** January 23, 2013, 15:36 »

If all you want to do is remove duplicate keywords from a list, the MicrostockGroup keyword tool will to that

http://microstockgroup.com/tools/keywordcompare.html

You can stick a list of keywords in box one and it the duplicates will be removed and shown in the box on the bottom.

If you have two lists, the words appearing in both lists will be listed first in the results, then the words from box 1 then the words from box 2 .. with all the duplicates removed.

... and you don't have to ever click buttons, press enter or watch spammy ads

red · « **Reply #18 on:** January 23, 2013, 16:20 »

Even cooler!!

cascoly · « **Reply #19 on:** January 23, 2013, 19:19 »

Quote from: disorderly on January 23, 2013, 12:32

This sort of thing is trivial on a Unix system, including Linux, Mac and even Windows with a package like Cygwin installed. Given a text file of keywords, one to a line, the command

sort input.txt | uniq >output.txt

will remove duplicates. Find your closest Linux friend and they can knock it out in seconds.

on an ASP site it would be simple vbasic script - open sorted file, then write only unique keywords to a new file; and if you've been maintaining an ASP site, you probably already have something similar to use

Microstocksolutions · « **Reply #20 on:** January 24, 2013, 04:37 »

We probably import and export metadata from about 3000 or more images each day of the week.

This means taking images which come without embedded metadata and then injecting them with keywords found on an .xls or .txt file, or extracting metadata from photos or illustrations on to either an .xls or .txt file.

This was one problem which troubled us for years until we decided to create a solution in house.

We went through every scenario you can imagine, and finally created our own "app" to import and export metadata from one platform to another, i.e., extract metadata from .jpg, .eps., .tif files made created on Lightroom - for example - and then export it to an .xls file and have the capability to import that .xls or .txt file into image residing on any number of DAM platforms like Fotostation.

It took about 5 weeks of development, but it works great.

Outside of such a proprietary solution, nothing exists as an off-the-shelf solution. The reasons are simple. Adobe is not going to make it easy to import or export metadata made on any other platform. The same goes for Fotoware or any other similar program.

MicrostockGroup Sponsors

Author Topic: software to import the keywords from all my photos? (Read 7345 times)

niserin

red

niserin

red

MichaelJayFoto

niserin

niserin

red

niserin

red

niserin

red

niserin

red

disorderly

niserin

red

leaf

red

cascoly

Microstocksolutions

Related Topics

Sponsors

Microstock Poll Results

Sponsors