Re: [CODE4LIB] getting started with Drupal for library website
What you are describing sounds quite a bit like a knowledge base. There a lot of commercial solutions for these types of things, but open source options are a bit more limited. There's CUFTS, which is no longer under development as far as I know: http://researcher.sfu.ca/cufts There's also GOKb, which is under development and worth keeping an eye on: http://gokb.org/preview I've not used either of these products, so unfortunately, I can't vouch for either one. But hopefully this gives you a starting point to work from. Regards, Karl Holten Systems Integration Specialist SWITCH Inc 414-382-6711 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Ken Irwin Sent: Wednesday, May 27, 2015 8:02 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] getting started with Drupal for library website Hi folks, Thanks to all who responded a few weeks ago to my inquiry about updating the code on my library's website. Many folks suggested moving to a CMS, and I'm starting to look into that possibility, and particularly Drupal. In doing so, I'm hoping not to re-invent the wheel, and I'm hoping that maybe someone has already designed a basic infrastructure to replace the backbone of our current website, namely. Under our current arrangement we have an interlocking set of databases that performs some basic library functions: There's a database table that lists all of the databases we subscribe to. That database feeds a user interface that: * lists databases * counts click-thrus * routes traffic to our proxy server when appropriate * can list databases by subject area (defined in a table of subject associations) There's also a back-end UI to create subject/database associations, display click-thru stats, generate EZproxy config files based on the table of library databases. Does anyone know of a freely-available set of modules/pages/etc that's already designed to do this sort of thing? In my imagination, lots of libraries would want to basically this same thing, customized to their own particularly needs and maybe we wouldn't each have to start from scratch. Any advice? Thanks Ken
Re: [CODE4LIB] oops (was: [CODE4LIB] Any Apache mod_rewrite experts out there?)
As Joe cautioned might happen with the N directive, I get an infinite loop from this. It keeps prepending the domain name so you get http://www.google-com.topcat.switchinc.org/http://www.google-com.topcat.switchinc.org/http://www.google-com.topcat.switchinc.org/http:/www.google-com.topcat.switchinc.org// after the second pass, after the third pass you get the full domain three times and so on. My not-so-genius solution to this problem is just to put in the same RedirectRule 6 times in a row and skip the N directive. Not optimal, but this seems to work fine: RewriteEngine on RewriteCond %{HTTP_HOST} ^(.*)-(.*)ezproxy.switchinc.org RewriteRule ^(.*) %1.%2 ezproxy.switchinc.org$1 RewriteRule ^(.*)-(.*)ezproxy.switchinc.org(.*) $1.$2ezproxy.switchinc.org$3 (I repeated this 5 times) RewriteRule ^(.*)ezproxy.switchinc.org/(.*) https://0-$1topcat.switchinc.org$2 [L] Thanks everyone! Karl Holten Systems Integration Specialist SWITCH Inc 414-382-6711 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Joe Hourcle Sent: Monday, May 18, 2015 8:59 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] oops (was: [CODE4LIB] Any Apache mod_rewrite experts out there?) On Mon, 18 May 2015, Joe Hourcle wrote: RewriteRule ^(.*)-(.*)ezproxy.switchinc.org/(.*) $1.$2ezproxy.switchinc.org/$3 [N] I wasn't thinking ... RewriteRule doesn't operate on the full URL, only on the non-host portion. You might need to do strange things w/ RewriteCond and RewriteRule instead: RewriteCond %{HTTP_HOST} ^(.*)-(.*)ezproxy.switchinc.org RewriteRule ^(.*) http://%1.%2ezproxy.switchinc.org/$1http://%251.%2ezproxy.switchinc.org/$1 [N] The %1 and %2 come from the captures in RewriteCond, while the $1 comes from RewriteRule. -Joe
[CODE4LIB] Any Apache mod_rewrite experts out there?
My organization is changing proxy servers from WAM to EZproxy, and we would like to give staff time to change over their URLs before we make the switch. I would like to set up forwarding so the links using the new proxy get redirected to the old proxy. I'm planning on using apache's mod_rewrite to do this. Basically, this mod rewrite rule needs to do three things: 1) Change the part of the domain name (not the file path) that reads ezproxy.switchinc.org to our old domain topcat.switchinc.org 2) Append the prefix 0- in front of the domain name 3) Transform dashes in the domain name to periods. Could anyone provide me with some assistance? I am sure this takes maybe 10 lines of code from a mod_rewrite expert, but it has taken me several weeks to the first two objectives done, and all of my google fu is failing me for objective three. Below is what I have: RewriteEngine on RewriteCond %{HTTP_HOST} ^(.*)ezproxy.switchinc.org [NC] RewriteRule ^(.*) %{HTTP_HOST}/$1 [DPI] RewriteRule ^(.*)ezproxy.switchinc.org/(.*) http://0-$1topcat.switchinc.org/$3 [L] Thanks, Karl Holten Systems Integration Specialist SWITCH Inc 414-382-6711
Re: [CODE4LIB] Help with Auto Hot Key
This doesn't involve AutoHotkey, but maybe it would be easier to use SQL to pull that data from the Sierra database rather than screen scraping from the Sierra application. You wouldn't need to worry about where stuff displays in the interface, just where its stored on the backend. This solution would probably be cleaner to maintain as well. Excel has ways to pull in data from external sources like SQL databases, it looks like Microsoft Publisher does too. I can't speak to how easy it would be to set that up, but hopefully it would give you a start: https://support.office.com/en-ie/article/Import-data-into-Office-Publisher--Visio-or-Word-by-using-the-Data-Connection-Wizard-65295a62-8da3-49bc-8dd8-1f77d0a05127 Anyway, that's my 2 cents on an alternative tack you might want to try. Hope that helps, Karl Holten Systems Integration Specialist SWITCH Inc 414-382-6711 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eddie Clem Sent: Monday, May 4, 2015 1:50 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] Help with Auto Hot Key Hi there! I'm hoping someone here is a guru at AutoHotKey! :) We have a clerk that pays our invoices in Sierra. She will write the bib number on a sticky note, as well as the list price and the locations (that each copy will go to). I want to have Sierra copy the bib number, list price, locations, and order record notes onto a receipt and then this clerk would put this receipt with the first copy of the material, rather than hand write on sticky notes all day! Since I had looked, and couldn't find a way to do this easily from Sierra, I had another brilliant idea that we could have Autohotkey copy the fields I want into a template (say, in Publisher) and have the bib number turned into a barcode, and list the other fields that we want that travel around the tech services department. This barcoded bib number would be used by catalogers to enter the bib number in the 949 for overlay in Connexion, and then again by our barcoding clerk to search by bib number in Sierra. At this point, I'm thinking that Autohotkey is my best bet. Here is my prototype of what the routing slip would look like when it's done. The Thickety 2 is a note in the order record put in by our selectors for our catalogers to add that series to the bib record. The 978... is just a placeholder for where the list price will go once we get that field added to our order records: [cid:image001.png@01D08679.A5CC5160] Here is the corresponding order record. Part of my problem for Autohotkey is that not all order records will contain a note (in field z) and the locations may be different (fewer or more) on the LOCATIONS line. I have to include the multi line, because if it's just our Main Library that's receiving the item, then the LOCATIONS at the bottom don't show up at all...just the LOCATION fixed field (under ACQ TYPE). [cid:image002.png@01D08679.A5CC5160] Any thoughts would be greatly appreciated! Thanks! Eddie Eddie Clem, MLS Cataloging Librarian ec...@khcpl.orgmailto:ec...@khcpl.org | www.KHCPL.orghttp://www.khcpl.org/ Kokomo-Howard County Public Library Collection Management Department 305 East Mulberry Street Kokomo, IN 46901 765.626.0853|765.450.6290 (fax)
Re: [CODE4LIB] indexing word documents using solr [diacritics]
Ah, the wonderful world of character encoding... To quote the Solr wiki: There are no known bugs with Solr's character handling, but there have been some reported issues with the way different application servers (and different versions of the same application server) treat incoming and outgoing multibyte characters. In particular, people have reported better success with Tomcat than with Jetty... (https://wiki.apache.org/solr/FAQ#Why_don.27t_International_Characters_Work.3F ) I'd probably start by enabling UTF-8 in Tomcat/Jetty and see if that resolves the issue. If not, I'd check the original files to see what its character encoding is, and then check each application that handles the documents to make sure it's using that encoding. It might be that the original isn't in UTF-8, or if it is, that somewhere along the way the parser, the perl interface, or some other unknown culprit is attempting to change it. Regards, Karl Holten Systems Integration Specialist SWITCH Inc 414-382-6711 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eric Lease Morgan Sent: Thursday, February 12, 2015 2:38 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] indexing word documents using solr [diacritics] How do I retain diacritics in a Solr index, and how to I search for words containing them? I have extracted the plain text out of set of Word documents. I have then used a Perl interface (WebService::Solr) to add the plain text to a Solr index using a field type called text_general: fieldType name=text_general class=solr.TextField positionIncrementGap=100 analyzer type=index tokenizer class=solr.StandardTokenizerFactory / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt / filter class=solr.LowerCaseFilterFactory / /analyzer analyzer type=query tokenizer class=solr.StandardTokenizerFactory / filter class=solr.StopFilterFactory ignoreCase=true words=stopwords.txt / filter class=solr.SynonymFilterFactory synonyms=synonyms.txt ignoreCase=true expand=true / filter class=solr.LowerCaseFilterFactory / /analyzer /fieldType It seems as if I am unable to search for words like ejecución because the diacritic gets in the way. What am I doing wrong? — Eric
Re: [CODE4LIB] Open Source ERM
A couple of months ago our organization began looking at new ERM solutions / link resolvers, so I thought I'd share my thoughts based on my research of the topic. Unfortunately, I think this is one area where open source offerings are a bit thin. Many offerings look promising at first but are no longer under development. I'd be careful about adopting something that's no longer supported. Out of all the options that are no longer developed, I thought the CUFTS/GODOT combo was the most promising. Out of the options that seem to still be under development, there were two options that stood out: CORAL and GOKb. Neither includes a link resolver, so they weren't good for our needs. CORAL has the advantage of being out on the market right now. GOKb is backed by some pretty big institutions and looks more sophisticated, but other than some slideshows there's not a lot to look at to actually evaluate it at the moment. Ultimately, I came to the conclusion that nothing out there right now matches the proprietary software, especially in terms of link resolvers and in terms of a knowledge base. If I were forced to go open source I'd say the GOKb and CORAL look the most promising. Hope that helps narrow things down at least a little bit. Regards, Karl Holten Systems Integration Specialist SWITCH Consortium 6801 North Yates Road Milwaukee, WI 53217 http://topcat.switchinc.org/ -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Riesner, Giles W. Sent: Thursday, September 19, 2013 5:33 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Open Source ERM Thank you, Peter. I took a quick look at the list and found ERMes there as well as a few others. Not everything under this category really fits what I'm looking for (e.g. Calibre). I'll look a little deeper. Regards, Giles W. Riesner, Jr., Lead Library Technician, Library Technology Community College of Baltimore County 800 S. Rolling Road Baltimore, MD 21228 gries...@ccbcmd.edu 1-443-840-2736 From: Code for Libraries [CODE4LIB@LISTSERV.ND.EDU] on behalf of Peter Murray [peter.mur...@lyrasis.org] Sent: Thursday, September 19, 2013 4:44 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Open Source ERM I don't know about ERMes specifically, but wanted to point out that FOSS4Lib has 12 packages of various sorts in the Electronic Resource Management category: https://foss4lib.org/package-type/electronic-resource-management Peter On Sep 19, 2013, at 2:46 PM, Riesner, Giles W. gries...@ccbcmd.edu wrote: One of our Librarians saw an article about ERMes, an open source ERM from the University of Wisconsin-Lacrosse (http://murphylibrary.uwlax.edu/erm/) , and was asking about the possibility of our using it. If you're using it and wouldn't mind us picking your brain a little bit on it, please contact me off list . That said, if you have experience with any other open source ERM systems and wouldn't mind sharing some information about them, I'm happy to hear about them as well. Thanks. Giles W. Riesner, Jr., Lead Library Technician, Library Technology Community College of Baltimore County 800 S. Rolling Road Baltimore, MD 21228 gries...@ccbcmd.edu 1-443-840-2736 -- Peter Murray Assistant Director, Technology Services Development LYRASIS peter.mur...@lyrasis.org +1 678-235-2955 800.999.8558 x2955