Re: [CODE4LIB] getting started with Drupal for library website

2015-05-27 Thread Karl Holten
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?)

2015-05-18 Thread Karl Holten
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?

2015-05-15 Thread Karl Holten
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

2015-05-05 Thread Karl Holten
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]

2015-02-12 Thread Karl Holten
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

2013-09-20 Thread Karl Holten
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