MicrostockGroup
Microstock Photography Forum - General => Software => Software - General => Topic started by: 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
-
Photo Mechanic http://www.camerabits.com/products/ (http://www.camerabits.com/products/)
-
Doesn't have the option I described...
-
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.
-
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. :D
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. ;)
-
Thank you for your help, but I still can't work it out. I do not see the Text Export field anywhere.
-
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.
-
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 (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.
-
Ok, FotoStation from Fotoware does the best job in the easiest user friendly way.
-
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.
-
Right, now having thousands of keywords in txt file I need to remove duplicates. Can I do it in open office or excel ?
-
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 (http://office.microsoft.com/en-us/excel-help/find-or-replace-text-and-numbers-on-a-worksheet-HP001216390.aspx)
-
But it is just a manual work - typing every keyword, searching them and removing... Any automatic way ?
-
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 (http://www.cpearson.com/excel/duplicates.aspx)
-
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.
-
http://www.tracemyip.org/tools/remove-duplicate-words-in-text/ (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
-
Cool!
-
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 (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 :)
-
Even cooler!!
-
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
-
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.