Choose Currency:
Menu

Tab-Delimited List Keyword-Linking Tool

Input List A (editable) - This is your Messed-Up List of keywords exported from Lightroom

Input Lines:   In A but not B:   Duplicate Lines:   Illegal Characters:
Errors Found:   Bracket Counters   [   ]   {   }

Input List B (editable) - This is your Master Keyword List that may contain your un-matched keywords

Input Lines:   In B but not A:   Duplicate Lines:   Illegal Characters:
Errors Found:   Bracket Counters   [   ]   {   }

Tooltip Answer Search for Keyword Matches
Performs error check before and after list comparison.
(Click for full explanation in new page)
Tooltip Answer Search for Keyword Matches without Error-Checking
Search for Keyword Matches without checking for list-errors.
(Click for full explanation in new page)
Tooltip Answer Clear All
Clear Input and Output Lists.
(Click for full explanation)
Tooltip Answer Load a Test List with No Errors
This list demonstrates the sorting capabilities.
(Click for full explanation)
Tooltip Answer Load a Test List with Included Errors
This list demonstrates how errors are caught and reported.
(Click for full explanation)

List Differences: In list A but not in list B     (Converted to 'Flat File' format)

Matches found for these keywords:

No Matches found for these keywords:

 

Instructions
Please read these instructions carefully to understand what this tool does, and how to use it!!

This webpage provides access to an online tool which finds matches for keywords that don't have a direct hierarchical equivalent in a master list.

Consider this scenario: You start adding keywords to some of your photos 'on the fly', without reference to a proper hierarchical list, by choosing keywords off the top of your head, as they occur to you, as most newbies do. You add the keywords to your photos in Lightroom or whatever - the program doesn't matter. Some keywords may have a hierarchy attached to them, whilst others don't - that doesn't matter either. After a while you realize that a proper hierarchical list would be a good idea. You either write your own list, or you buy one. Lets call this list the 'Master List'. You import the 'Master List' into your photo program and do some more keywording, choosing keywords from your new 'Master List'. The problem then arises that a lot of your initial keywords don't match the entries in the 'Master List'. Is there some way to sort out this mess?

This tool tries to help, by looking for matches for your initial keywords to entries in the 'Master List', even if the hierarchy of the latter is different.

How to use this Tool
We will use Lightroom as an example, though these instructions apply to any program that can export its current keyword catalog in TAB-delimited format.

  1. In Lightroom click 'Metadata > Export Keywords' to download your current list as a backup. Keep it somewhere safe. You will need it later on.
     
  2. In Lightroom click 'Metadata > Purge Unused Keywords' to delete any keywords that you are not using. These unused keywords are not important right now, and make no difference to the results.
     
  3. In Lightroom click 'Metadata > Export Keywords' to download your 'Messed-Up List'.
     
  4. Paste this 'Messed-Up List' list into the 'Input List A' box above.
     
  5. Paste your 'Master List' list into the 'Input List B' box above.
     
  6. Click one of the 'Search' buttons. Unless 'Search for Keyword Matches without Error-Checking' is pressed, the program will perform a number of useful checks to locate the following common tab-indented list errors before list-comparison:
    • Illegal characters ,;<>|?
    • Missing or extra Square or Curly Brackets
    • Excess TAB characters
    • Blank Lines
    • Trailing TAB characters
    • Duplicate Lines
    • Non-ASCII characters
    You should fix these errors before proceeding.
     
  7. It will then locate all entries in your 'Messed-Up List' that don't appear in your 'Master List', and show any differences in the 'List Difference' window.
     
  8. It will then try to match the keyword in each of these differences with an entry in your 'Master List'.
     
  9. Any matches it finds will be shown in the 'Matches' window. You can then judge for yourself whether the match is close enough to transfer that keyword to the suggested entry in the 'Master List'.
     
  10. Any keywords that can't be matched are shown in the 'No-Matches' window. You can then judge for yourself whether to leave the keyword as-is, or delete it and choose one from your 'Master List'.
     
  11. Now is the time to re-import your 'Master List' by clicking 'Metadata > Import Keywords'. Even though you haven't used all of its keywords so far, you will want them back on board for use another day.
     

NB: This tool will NOT work if either of the lists has been indented with a column of extra TABs (i.e. if the first line has one or more leading TABs on it). Please remove these before using the Tab-Delimited List Sorting Tool. An easy way to do this is described on the Tab-Indented List Tutorial page.

You can't type a Tab-character into the Input List, but you can copy and paste one from somewhere else.

If no list has been pasted into the 'Input List' windows, two error-free test lists are displayed with some included differences between them. Try deleting or adding some more lines to see the List Comparison in action. There is also a test list with a range of errors available, that is useful to check error-trapping. Click 'Clear All' to clear the lists.

If the page times-out before it has completed its task, then use a smaller list of keywords in 'Input List A' by splitting your list into more manageable chunks.

For further information, please see the Tab-Delimited List Sorting and Error-Check Tool Help Page.

If you want to error-check and merge two tab-indented lists, see the Tab-Delimited List Merge Tool.

If you want to see what a tab-indented list will look like when its loaded into your image-processing program, see the Tab-Delimited List Visualisation and Error-Check Tool.

If you need additional tools for error-correction and common list-processing tasks, see the Tab-Delimited List Sorting and Error-Check Tool.

If you find the Tab-Delimited List Keyword-Linking Tool useful I'd appreciate a mention in your Blog and any online groups.

Web design and photography by photo-keywords.com   ::   All images and pages on this site are © 2005 - 2017   ::   All rights reserved
Flag Counter