{"id":79,"date":"2007-12-06T02:57:14","date_gmt":"2007-12-06T01:57:14","guid":{"rendered":"http:\/\/muttznutz.net\/muttzblog\/post-processing\/converting-pse-tags-for-lightroom\/2007\/12\/06"},"modified":"2008-07-27T18:09:10","modified_gmt":"2008-07-27T17:09:10","slug":"converting-pse-tags-for-lightroom","status":"publish","type":"post","link":"https:\/\/muttznutz.net\/muttzblog\/post-processing\/converting-pse-tags-for-lightroom","title":{"rendered":"Converting PSE tags for Lightroom"},"content":{"rendered":"<p>I&#8217;ve covered how to <a href=\"https:\/\/muttznutz.net\/muttzblog\/post-processing\/lightroom-keywords-import-export-and-hierarchies\/2007\/12\/05\" title=\"Import Keywords into LightRoom\">import tags into Lightroom<\/a>.<br \/>\nSo how do we get them into the right format (starting from Photoshop Elements) in the first place ?<\/p>\n<p>Well first of all, we need to export them from Photoshop Elements.<br \/>\nIn the Organiser, choose the Photo Browser (as opposed to the Date View), then click on the &#8220;Tags&#8221; tab and select &#8220;Save Tags to File&#8221;.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"\/muttzblog\/wp-content\/uploads\/psesavetags.PNG\" alt=\"psesavetags.PNG\" title=\"psesavetags.PNG\" align=\"middle\" border=\"0\" vspace=\"8\" width=\"205\" height=\"165\" hspace=\"8\" \/><\/p>\n<p>Choose a filename (let&#8217;s call it &#8220;Keywords.xml&#8221;) and there you go.<br \/>\nExcept that what you have is an XML file that needs &#8220;decoding&#8221; into something more straightforward.<\/p>\n<p>I&#8217;ve included an easy way and a slightly less easy way&#8230;.<\/p>\n<h3>The Easy Way<\/h3>\n<p>-This doesn&#8217;t handle hierarchies (parents).<\/p>\n<p>1) Open <a href=\"\/muttzblog\/wp-content\/uploads\/code\/psetags.xsl\">this link<\/a>, select &#8220;View Source&#8221; in your browser and copy the code into a text editor (such as Notepad).<br \/>\nTen save it in the same folder as your output file, naming the file &#8216;psetags.xsl&#8217;. (This is an XSL transform routine, which reformats the XML data)<\/p>\n<p>2) Then edit your &#8220;Keywords.xml&#8221; output file (again, using NotePad) and insert the second line of code by Viewing the Source of <a href=\"\/muttzblog\/wp-content\/uploads\/code\/sharks.xml\">this file<\/a>.<br \/>\n.. then save Keywords.xml.<\/p>\n<p>3) Double click to open the file in your browser, and you should see all your tags as a table (similar to the file in step 2).<br \/>\nSelect the table (CTRL-A) and copy the data (CTRL-C).<\/p>\n<p>4) Open up NotePad and paste the data (CTRL-V)<br \/>\nSave the file (as &#8211; for example &#8211; &#8220;Keywords.txt&#8221;) and you&#8217;ve done the complicated bit &#8211; this is ready for import into Lightroom!<\/p>\n<p>5) Import to LightRoom<\/p>\n<h3>The Slightly Less Easy Way &#8230;<\/h3>\n<p>This will support one level of hierarchy, but includes an extra step.<br \/>\nAll Keywords must have a parent.<br \/>\nI&#8217;m assuming you have access to a spreadsheet such as <a href=\"http:\/\/www.openoffice.org\/\">OpenOffice&#8217;s Calc<\/a>. You&#8217;ll probably be able to dothis with Excel as well (although I don&#8217;t have a copy with me).<\/p>\n<p>1) As above, except that you should copy the code from <a href=\"\/muttzblog\/wp-content\/uploads\/code\/psetags3.xsl\">this link<\/a><\/p>\n<p>Steps 2) and 3) &#8211; as above<\/p>\n<p>4) When you open this in your browser, you&#8217;ll see that the second level of tags is indented.<br \/>\nAgain, select and copy, but this time load it into Calc as a new spreadsheet.<br \/>\nYou should see two columns &#8211; one for parents, one for the &#8220;Child&#8221; tags.<\/p>\n<p>Save this as a .csv type file <strong>but<\/strong> with a .txt filetype (e.g. &#8211; again &#8211; &#8220;Keywords.txt&#8221;).<br \/>\nCheck the &#8220;Edit Filter Settings&#8221; box<br \/>\n<img decoding=\"async\" loading=\"lazy\" src=\"\/muttzblog\/wp-content\/uploads\/savecsv.PNG\" alt=\"savecsv.PNG\" title=\"savecsv.PNG\" align=\"middle\" border=\"0\" vspace=\"8\" width=\"568\" height=\"487\" hspace=\"8\" \/><\/p>\n<p>In the next dialogue, set the &#8220;Field delimiter&#8221; to &#8220;{Tab}&#8221; and empty the &#8220;Text delimiter&#8221; box &#8230;<br \/>\n<img decoding=\"async\" loading=\"lazy\" src=\"\/muttzblog\/wp-content\/uploads\/savecsv2.PNG\" alt=\"savecsv2.PNG\" title=\"savecsv2.PNG\" align=\"middle\" border=\"0\" vspace=\"8\" width=\"508\" height=\"190\" hspace=\"8\" \/><\/p>\n<p>5) Import to Lightroom &#8211; as above<\/p>\n<h3>A slight variation on the Slightly Less Easy Way<\/h3>\n<p>1) Using the code from 1) As above, except that you should copy the code from <a href=\"\/muttzblog\/wp-content\/uploads\/code\/psetags2.xsl\">this link<\/a> will uncheck the &#8220;Include on Export&#8221; box for parents. However, the &#8220;Export Containing Keywords&#8221; box will still be checked at detail level, so those have to be sorted out manually.<br \/>\nAll other steps as for the Slightly Less Easy Way &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8230; How to get Tags out of Photoshop Elements and into a format where they&#8217;ll feed Lightroom<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[7,5],"tags":[],"_links":{"self":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/posts\/79"}],"collection":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":0,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/posts\/79\/revisions"}],"wp:attachment":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/categories?post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/tags?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}