{"id":794,"date":"2003-12-05T16:12:30","date_gmt":"2003-12-06T00:12:30","guid":{"rendered":"http:\/\/eclecticlibrarian.net\/blog\/2003\/12\/rss-for-opacs\/"},"modified":"2003-12-05T16:12:30","modified_gmt":"2003-12-06T00:12:30","slug":"rss-for-opacs","status":"publish","type":"post","link":"https:\/\/eclecticlibrarian.net\/blog\/library\/lib-tools\/rss-for-opacs\/","title":{"rendered":"rss for opacs"},"content":{"rendered":"<p>Yesterday, I was thinking some more about <a href=\"http:\/\/www.eclecticlibrarian.net\/blog\/archives\/000256.html\">uses for RSS with library OPACs<\/a>.  The idea of having an RSS feed for new books continues to nag me, but without more technical knowledge, I know this is something that I couldn&#8217;t make work.  Then something clicked, and I called up our library systems administrator to ask him a few questions.  As I suspected, our new books list in the OPAC is a text file that is generated by a <a href=\"http:\/\/rocky.uta.edu\/doran\/autolist\/\" target=\"_blank\" rel=\"noopener noreferrer\">script<\/a> that searches the catalog database once a week.  I began to ponder what it would take to convert that flat file into XML, and if would it be possible to automate that process.<\/p>\n<p>I grabbed a copy of the flat file from the server and took a look at it, just to see what was there.  First off, I realized that there was quite a bit of extraneous information that will need to be stripped out.  That could be done easily by hand with a few search &#038; replace commands and some spreadsheet manipulation.  So, the easy way out would be to do it all by hand every week.  <i>Here*<\/i> is what I was able to do after some trial and error, working with books added in the previous week.<\/p>\n<p>A harder route would be to put together a program that would take the cleaned up but still raw text file and convert each line into &lt;item&gt; entries, with appropriate fields for &lt;title&gt; (book title), &lt;description&gt; (publication information &#038; location), &lt;category&gt; (collection), etc.   This new XML file would replace the old one every week.  If I knew any Perl or ColdFusion, I&#8217;m certain that I could whip something up fairly quickly.<\/p>\n<p>The ideal option would be to write a program that goes into the catalog daily and pulls out information about new books added and generates the XML file from that.  I suspect that it would work similarly to <a href=\"http:\/\/rocky.uta.edu\/doran\/\" target=\"_blank\" rel=\"noopener noreferrer\">Michael Doran<\/a>&#8216;s New Books List program, but would go that extra step of converting the information in to RSS-friendly XML.<\/p>\n<p>If anyone knows of some helper programs or if someone out there in library land is developing a program like this, please let me know.<\/p>\n<p><i>* File is now missing.  I think I may have delete it by accident.  1\/13\/05<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anna gets semi-techie about RSS and OPACs.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[32,36],"tags":[987,1054,1067,3001,3015,3220,3349,3643,3823,4017,4538,5154,5992],"class_list":["post-794","post","type-post","status-publish","format-standard","hentry","category-lib-tools","category-rss","tag-coldfusion","tag-computer-file-formats","tag-computing","tag-library-opacs","tag-library-systems-administrator","tag-markup-languages","tag-michael-doran","tag-newline","tag-online-public-access-catalog","tag-perl","tag-rss","tag-technical-communication","tag-xml"],"jetpack_publicize_connections":[],"cc_featured_image_caption":{"caption_text":false,"source_text":false,"source_url":false},"jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/posts\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":0,"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/posts\/794\/revisions"}],"wp:attachment":[{"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/categories?post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eclecticlibrarian.net\/blog\/wp-json\/wp\/v2\/tags?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}