Horizon Information Portal 3.x
From WikiThing
If you're only installing the Reviews Enhancement and not the Catalog Enhancements, please go here.
[edit] LibraryThing for Libraries enhancements: Installation instructions
[edit] 1. Sign into your account
You should have an email with your username and password.
- Sign into your account at http://www.librarything.com/forlibraries
- Enter your account name and password at the bottom left-hand corner of the page where it says "sign in".
[edit] 2. Export file
Use the SirsiDynix-supplied marcout utility to export all of your "non-staff-only" MARC records. For instructions on using marcout, please refer to your Horizon documentation.
You could also use the LibraryThing-developed "exportLT" utility to export data—this method will not work for Shelf Browse, as it does not include call numbers. See exportLT instructions. If exportLT does not work for your library, you should export your data as MARC records.
Important note for Shelf Browse: If you're installing the Shelf Browse Enhancement, you'll need a full MARC export that includes item level call numbers, or a tab delimited file containing call number information. Before uploading, you'll need to set which type of call number (LC or Dewey) you're using, the call number location in your records, and the subfield for the collection code (if using collections to group items within Shelf Browse). Set this on the Configure tab, under Shelf Browse.
Exporting the call number in 949 is achievable using the built-in MARC export feature within Horizon.
- Go to Table Editor / Export_target and create a new export target
- In the "item tag" field enter "949" and in the "item columns" section enter a column of "call_reconstructed" and a subfield of d. Save the record
- Go to Cataloging / Export / Batch bib export. Select the export target you created earlier. In the next window enter in the "from" field bib_control. Then select a windows file name and folder to save the exported marc records.
If you are uploading a tab-delimited file for Shelf Browse, the fields should be ordered as:
ISBN TITLE AUTHOR LOCATION (can be empty) CALLNO COLLECTION
- The first three (ISBN, title, and author) are self explanatory. Location is a location code--typically used by libraries or consortia with multiple branches. If you don't have or don't use location codes, leave this empty (but include the tab for it). Call number is your call number. Collection is the collection code that indicates things like "teen graphic novels" (optional).
To export a tab delimited file containing all the fields you need for shelf browse, copy the following SQL into Web Reporter freeform SQL (note, the librarian who came up with this SQL says "I usually only do approx 100,000 bibs at a time, otherwise our server has a hissy fit."):
SELECT distinct substring(isbn.isbn,1,14) 'isbn',
substring(t.processed,1,100) 'Title',
substring(author.processed,1,40) 'Author',
i.location AS 'Location',
isnull(substring(i.call_reconstructed,1,20),'') 'Call',
i.collection AS 'Collection'
FROM item i
inner join bib b on i.bib# = b.bib#
inner join isbn_inverted isbn on b.bib# = isbn.bib#
inner join bib_auth bu on b.bib# = bu.bib# and b.tag = '100' and b.cat_link_xref# = bu.auth#
left join author on author.auth# = bu.auth#
inner join title t on b.bib# = t.bib#
WHERE t.bib# BETWEEN 600000 AND 609439 /* CHANGE THESE BIB NOS – I usually do approx 100000 at a time */
AND i.collection in (put your collections in here)
AND i.item_status in (put your item status in here)
)
ORDER BY t.title, isbn.isbn
[edit] 3. Upload file
- Click on the "Upload holdings" link on the Enhancements tab.
- Choose a file format
- Choose an action. "Add additional items" adds new items to the list of items you have already uploaded. "Replace all items" deletes previous files and replaces them.
- Enter your email to get a note telling you that the indexing is done (indexing is processed every evening)
- Click "Next". The Choose a file to upload page will open
- Click on the "Get File" button to upload your file from your computer
- Click the "Browse" button to find the file
- Click "Begin File Upload" to ... begin the file upload
[edit] 4. Add code to your OPAC
[edit] Catalog Enhancement
- You will be copying and pasting a section of javascript, and also div tags into the code of your bibliographic template page.
- Open your bibliographic template page, called fullnonmarcbib.xsl. To access this, you'll need to find the actual file on the HIP server (it's in something like c:\dynix\XSLprocessor\xsl or /opt/dynix/xslprocessor/xsl on Linux ) and edit it with a text editor -- or send it to us and we can edit it for you, then you can replace the original with the version we've modified.
- You have two options of where to place the enhancements - underneath the item information in the main part of the screen, or in the sidebar.
To place the enhancements underneath the item information in the main part of the screen, find the form with name="details". This is around line 2900 in fullnonmarcbib.xsl. Copy and paste the following code:
<script src="http://ltfl.librarything.com/forlibraries/widget.js?id=XXX-XXXXXXXXX" type="text/javascript"></script><noscript>This page contains enriched content visible when JavaScript is enabled or by clicking <a href="http://ltfl.librarything.com/forlibraries/noscript.php?id=XXX-XXXXXXXXX &accessibility=1">here</a>.</noscript> <div style="padding:3px;"> <table> <tr> <td> <div id="ltfl_tagbrowse" class="ltfl"></div> </td> </tr> <tr> <td> <div id="ltfl_related" class="ltfl"></div> </td> </tr> <tr> <td> <div id="ltfl_similars" class="ltfl"></div> </td> </tr> </table> </div>
- You will need your LTFL Account Number, which you can find on your account page. It will look like this: XXX-XXXXXXXXX
- In the code you've just pasted, look for the placeholders for your account number. There are two of them, and they will look like this: XXX-XXXXXXXXX. Replace the two placeholders with your account number.
- Shuffle around the div ids if you want the enhancements in a different order.
To put them on the sidebar: You want to insert the data around line 1264, before <xsl:if test="$display_marcdisplay_link = $true">. Copy and paste the following:
<script src="http://ltfl.librarything.com/forlibraries/widget.js?id=XXX-XXXXXXXXX" type="text/javascript"></script><noscript>This page contains enriched content visible when JavaScript is enabled or by clicking <a href="http://ltfl.librarything.com/forlibraries/noscript.php?id=XXX-XXXXXXXXX &accessibility=1">here</a>.</noscript> <tr> <td></td> <td colspan="2"> <div id="ltfl_similars"></div> </td> </tr> <tr> <td></td> <td colspan="2"> <div id="ltfl_tagbrowse"></div> </td> </tr> <tr> <td></td> <td colspan="2"> <div id="ltfl_related"></div> </td> </tr>
- You will need your LTFL Account Number, which you can find on your account page. It will look like this: XXX-XXXXXXXXX
- In the code you've just pasted, look for the placeholders for your account number. There are two of them, and they will look like this: XXX-XXXXXXXXX. Replace the two placeholders with your account number.
- Shuffle around the div ids if you want the enhancements in a different order.
- Save the page.
[edit] Reviews Enhancement
- If you are also installing the Reviews Enhancement, keep the bibliographic template page open.
- Insert the following code around line 1278 in fullnonmarcbib.xsl, right before
<xsl:if test="boolean(normalize-space(searchresults/results/row/HOOK/data/text))">
<xsl:comment>Begin added by LibraryThing</xsl:comment> <tr> <td colspan="2"> <div class="ltfl_reviews"></div> </td> </tr> <xsl:comment>End added by LibraryThing</xsl:comment>
- Save the page.
[edit] (Optional)Reviews in the search results/summary page
- If you'd like the Reviews Enhancement to appear on the search results summary display, it is imperative that the javascript code only appear once in the HTML output (not multiple times for each item on the summary screen.)
- Open the search results/summary template page, called summary.xsl.
- Copy and paste this code right around line 765, after </xsl:for-each> and right before <xsl:call-template name="summary_items"/>:
<xsl:comment>Begin added by LibraryThing</xsl:comment>
<TR>
<xsl:attribute name="class">ltfl_reviews_tr</xsl:attribute>
<TD>
<table>
<xsl:attribute name="class"><xsl:value-of select="$css_table_background"/></xsl:attribute>
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="cellspacing">0</xsl:attribute>
<xsl:attribute name="cellpadding">0</xsl:attribute>
<TR>
<TD>
<xsl:attribute name="rowspan">1</xsl:attribute>
<xsl:attribute name="valign">top</xsl:attribute>
<xsl:comment>LTFL reviews label</xsl:comment>
<a>
<xsl:attribute name="class"><xsl:value-of select="$css_bold_black_font1"/></xsl:attribute>
Reviews:
</a>
</TD>
<TD>
<div>
<xsl:attribute name="class">ltfl_reviews</xsl:attribute>
</div>
</TD>
</TR>
</table>
</TD>
</TR>
<xsl:comment>end added by LibraryThing</xsl:comment>
- For the javascript placement, insert the widget.js code around line 1324, after the closing </script> script tag, but before the closing </xsl:template> tag.
<script src="http://ltfl.librarything.com/forlibraries/widget.js?id=XXX-XXXXXXXXX" type="text/javascript"></script>
- You must not place the javascript code right after the HTML -- that will make the javascript load once for each item on the page, which is a bad, bad thing.
- Don't forget to replace the XXX-XXXXXXXXX with your Account number.
- Save the file.
- If you want to add other Reviews moderators, under the Reviews section, click the "Create/manage moderator accounts" link.
- You can create the secondary user an account. (What this is doing is creating a LibraryThing.com account.)
- If the person already has a LibraryThing account (for the main site), they can associate their username to moderate reviews. (It will not affect their LibraryThing.com account.)
- You can add more people to be alerted when there are reviews to moderate, by adding them in the "Email when moderation needed" text box, with commas between:
jeremy@librarything.com, casey@librarything.com
[edit] Shelf Browse Enhancement
- If you are also installing the Shelf Browse Enhancement, keep the bibliographic template page open.
- Copy the following div tag in the HTML where you'd like the enhancement to appear. If you want the Shelf Browse to appear above the holdings table, insert the divs just before the form with name=details.
<div id="ltfl_shelfbrowse_both" class="ltfl"></div>
- You could also add the divs individually if you like—"ltfl_shelfbrowse_mini" is the small shelf which appears on the big page and "ltfl_shelfbrowse_large" provides the link to the full-screen shelf. So you would add one or both of the following:
<div id="ltfl_shelfbrowse_large" class="ltfl"></div> <div id="ltfl_shelfbrowse_mini" class="ltfl"></div>
- Important: add either the "both" div or the individual ones, but not all of them!
- Save the file.
Limit items shown by collections and/or collection groups
- Collections and Collection Groups can be used to limit the items viewed in the Shelf Browse to items in the same collection. If, for example, you are viewing a book in a children's collection, you would only see other children's books around that book. If you do not use Collections and Collection Groups, Shelf Browse will sort your items by call number only, irrespective of collections.
- Under Shelf Browse > Advanced options on the Configure tab, select whether to use collections and/or collection groups.
- Click "Manage collections". Here you will see all the collection codes that we've indexed from your data. You can assign human readable names to the collections, and group collections together.
[edit] Series and Awards Enhancements
- If you are also installing the Shelf Browse Enhancement, keep the bibliographic template page open.
- Copy the following div tags in the HTML where you'd like the enhancement to appear.
<div id="ltfl_series" class="ltfl"></div>
<div id="ltfl_awards" class="ltfl"></div>
[edit] Lexile Measures
- This is a FREE enhancement for anyone using any of the other LTFL in-catalog enhancements. To add it to your OPAC, just include the div tag on your bibliographic template page, wherever you'd like it to appear:
<div id="ltfl_lexile" class="ltfl"></div>
If you want to make the Lexile search available on its own, just include a link like this:
<a href="#" onclick="LibraryThingConnector.widgets.wiki.showLexile('');">LexileFramework search</a>
- We can also help you add the appropriate code to non-catalog pages.
[edit] 5. Add the ISBN-based URL
You will fill in the ISBN-based URL within your LTFL account, on the Enhancements tab, under Settings > Global configuration.
http://<your catalog server>/ipac20/ipac.jsp?index=ISBNEX&term=MAGICNUMBER
If you are installing the Shelf Browse Enhancement, you will also need to fill in the Title based URL and Keyword based URL on the Configure tab, under Global Configuration. Those URLs should be:
http://<your catalog server>/ipac20/ipac.jsp?index=.TS&term=TITLE http://<your catalog server>/ipac20/ipac.jsp?index=.GW&term=KEYWORDS
- If you're not sure how to find your library's link, read here.
[edit] 6. Configure the enhancements
Control how the enhancements look by clicking on the Enhancements tab.
- Make changes on the Global Configuration page.
- You can add, change, and edit the Cascading Style Sheets (meaning: change the way the LTFL text looks to match your existing catalog page)
- If you have one of the OPACs listed on the configure page, and would like to prepopulate the CSS fields, click on the appropriate link.
- You can continue to edit the CSS after clicking the link - it's a great starting point.
- If you click the link again, any editing you did will revert to the generic settings for your OPAC, erasing anything you'd edited - so beware.
[edit] 7. Testing LTFL
[edit] Testing mode
For each of our enhancements, we have 'testing' mode. On the Enhancements tab, under Settings > Account info, you can switch each enhancement on, off, or to testing mode.
- You can test the enhancements without needing a development or testing server with this. In 'testing mode', the enhancements only show up if you manually add &testing=1 to the end of the bib result page URL. Example:
URL from catalog: http://durfingtonpl.com/ipac20/ipac.jsp?index=ISBNEX&term=0765318741
Now modified to show LTFL: http://durfingtonpl.com/ipac20/ipac.jsp?index=ISBNEX&term=0765318741&testing=1
Everything will look and work the way it would if it were live, including the tag browser, and links to similar titles.
- If you will be using a development server, you'll turn the enhancements from 'off' or 'testing' to 'on'.
[edit] Test on a development server
- On the development server, modify your templates to include the HTML for the reviews link (and our javascript, if it's not already there).
- If you already have the catalog enhancements, make sure 'auto-insert review link' setting on the Configure page is set to off. If this setting is on and the reviews feature is on and you already have the catalog enhancements, it will try to automatically show the reviews feature on your production server.
- Make sure the reviews feature is turned to on (not testing).
[edit] 8. Go live!
- Go to Settings > Account info and switch the enhancements to "on" - LTFL content should now appear in your OPAC.
[edit] 9. (Optional) Add widgets
Recent library reviews widget
Instructions on how to set up the widget to show recent reviews from your patrons, to put on your library's front page (or wherever you like.)