The academic dashboard has a number of features that are only available if the “loans cache” part of LORLS has been set up. \u00a0The installer will create the required database and install the following three scripts in the “\/usr\/local\/LUMP\/bin” directory.<\/p>\n
The “updateISBNMap” and “updateLoanCache” scripts require access to the following APIs on your Library Management System (LMS).<\/p>\n
You will probably have to create these APIs for your LMS. \u00a0We have example API scripts for the Aleph LMS from ExLibris that are available at the bottom of this page.<\/p>\n
The getISBNMap API takes no parameters and returns the XML mapping between each ISBN in the system and its local control number and at the end it should also contain a total count of the isbns. An example of the output is:<\/p>\n
<isbns>\n <map>\n <isbn>155587083x<\/isbn>\n <sysno>000281827<\/sysno>\n <\/map>\n <map>\n <isbn>072920720x<\/isbn>\n <sysno>000241757<\/sysno>\n <\/map>\n .\n .\n .\n <map>\n <isbn>0116308125<\/isbn>\n <sysno>000158641<\/sysno>\n <\/map>\n <total_isbn_count>398964<\/total_isbn_count>\n<\/isbns><\/pre>\nThe getLoanTransactions API should take one parameter “on” which contains the date to list the loan transactions for. The date should be in the format YYYY-MM-DD. The XML returned should contain for each loan either issued or returned on that date the following details:<\/p>\n
Again the XML file should finish with a total count of the number of loan transactions it has returned. An example output of this API is:<\/p>\n
<loan_transactions>\n <loan>\n <lcn>001050151<\/lcn>\n <isbn>0880119683<\/isbn>\n <issue_date>20121203 1421<\/issue_date>\n <return_date><\/return_date>\n <item_type>01<\/item_type>\n <department>LB<\/department>\n <\/loan>\n <loan>\n <lcn>000840951<\/lcn>\n <isbn>0850361850<\/isbn>\n <issue_date>20121203 1709<\/issue_date>\n <return_date><\/return_date>\n <item_type>01<\/item_type>\n <department>LB<\/department>\n <\/loan>\n .\n .\n .\n <loan>\n <lcn>000224944<\/lcn>\n <isbn>0631195203<\/isbn>\n <issue_date>20121203 1709<\/issue_date>\n <return_date><\/return_date>\n <item_type>01<\/item_type>\n <department>LB<\/department>\n <\/loan>\n <total_loan_count>3237<\/total_loan_count>\n<\/loan_transactions><\/pre>\nWhen the APIs are available then you will need to run the updateISBNMap script which will populate a mapping between item’s ISBNs and its local control number.<\/p>\n
After the updateISBNMap script has completed you can then run the preloadLoanCache script which will populate the loancache with a refined version of the last years worth of loan transactions from your LMS.<\/p>\n
After the preloadLoanCache script has completed you will need to put entries in your cron to run the updateISBNMap and the updateLoanCache scripts each day.<\/p>\n
Example getISBNMap API script for Aleph<\/h3>\n
You will need to replace <ORACLE HOME DIR>, <DATABASE>, <DB_USERNAME> and <DB_PASSWORD> and <BIB_LIBRARY> with the relevant values for your aleph configuration.<\/p>\n
#!\/exlibris\/aleph\/a20_2\/product\/bin\/perl\n#\nuse strict;\nuse CGI;\nuse DBI;\n\n$ENV{\"ORACLE_HOME\"} = \"<ORACLE HOME DIR>\";\n\nmy $dbh = DBI->connect(\"DBI:Oracle:<DATABASE>\",\"<DB_USERNAME>\",\"<DB_PASSWORD>\") || die \"$!\";\n$| = 1;\nmy $q = new CGI;\n\nmy $getISBN2SysNo=$dbh->prepare(\"select Z00R_TEXT, Z00R_DOC_NUMBER from <BIB_LIBRARY>.Z00R where Z00R_FIELD_CODE='020'\");\n\nmy $total_number=0;\n\nprint STDOUT \"Content-type: text\/xmlnn\";\nprint STDOUT \"<isbns>n\";\n\n$getISBN2SysNo->execute();\nwhile (my ($isbn, $sysno) = $getISBN2SysNo->fetchrow_array) {\n $sysno=substr($sysno,0,9);\n $isbn=~s\/^$$a\/\/;\n $isbn=~s\/s.*$\/\/;\n print STDOUT \" <map>n\";\n print STDOUT \" <isbn>$isbn<\/isbn>n\";\n print STDOUT \" <sysno>$sysno<\/sysno>n\";\n print STDOUT \" <\/map>n\";\n $total_number++;\n}\nprint STDOUT \" <total_isbn_count>$total_number<\/total_isbn_count>n\";\nprint STDOUT \"<\/isbns>n\";\n\n<\/pre>\nExample getLoanTransactions API script for Aleph<\/h3>\n
You will need to replace <ORACLE HOME DIR>, <DATABASE>, <DB_USERNAME> and <DB_PASSWORD>, <BIB_LIBRARY> and <ADMIN_LIBRARY> with the relevant values for your aleph configuration.<\/p>\n
\n#!\/exlibris\/aleph\/a20_2\/product\/bin\/perl\n#\nuse strict;\nuse CGI;\nuse DBI;\n\n$ENV{\"ORACLE_HOME\"} = \"<ORACLE HOME DIR>\";\n\nmy $dbh = DBI->connect(\"DBI:Oracle:<DATABASE>\",\"<DB_USERNAME>\",\"<DB_PASSWORD>\") || die \"$!\";\n$| = 1;\nmy $q = new CGI;\nmy $on = $q->param('on');\n\nmy ($onDate)=$on=~m\/(d{4}-d{2}-d{2})\/;\n$onDate=~s\/^(d{4})-(d{2})-(d{2})$\/$1$2$3\/;\n\nif(!$onDate){\n print STDOUT \"Content-type: text\/xmlnn\";\n print STDOUT \"<loan_transactions>n\";\n print STDOUT \"<error>No Date Specified<\/error>n\";\n print STDOUT \"<\/loan_transactions>n\";\n exit;\n}\n\nmy $getISBN=$dbh->prepare(\"select Z00R_TEXT from <BIB_LIBRARY>.Z00R where Z00R_DOC_NUMBER=? and (Z00R_FIELD_CODE='020' or Z00R_F\nIELD_CODE='022')\");\n\nmy $total_number=0;\n\nprint STDOUT \"Content-type: text\/xmlnn\";\nprint STDOUT \"<loan_transactions>n\";\n\nmy $currentloan =\n $dbh->prepare('select Z36_REC_KEY, Z36_LOAN_DATE, Z36_LOAN_HOUR, Z36_ITEM_STATUS, Z36_BOR_TYPE' .\n ' from <ADMIN_LIBRARY>.Z36 ' .\n ' where Z36_LOAN_DATE= ' . $dbh->quote($onDate)\n );\n$currentloan->execute;\nwhile (my ($id, $date, $hour, $itemStatus, $borStatus) = $currentloan->fetchrow_array) {\n $id=substr($id,0,9);\n print STDOUT \" <loan>n\";\n print STDOUT \" <lcn>$id<\/lcn>n\";\n my @ISBNs=getISBNs($id);\n foreach my $ISBN (@ISBNs){\n print STDOUT \" <isbn>$ISBN<\/isbn>n\";\n }\n print STDOUT sprintf(\" <issue_date>%08d %04d<\/issue_date>n\", $date, $hour);\n print STDOUT \" <return_date><\/return_date>n\";\n print STDOUT \" <item_type>$itemStatus<\/item_type>n\";\n print STDOUT \" <department>$borStatus<\/department>n\";\n print STDOUT \" <\/loan>n\";\n $total_number++;\n}\n$currentloan->finish;\n\nmy $pastloans =\n $dbh->prepare('select Z36H_REC_KEY, Z36H_LOAN_DATE, Z36H_LOAN_HOUR, Z36H_RETURNED_DATE, Z36H_RETURNED_HOUR, Z36H\n_ITEM_STATUS, Z36H_BOR_TYPE' .\n ' from <ADMIN_LIBRARY>.Z36H ' .\n ' where Z36H_LOAN_DATE= ' . $dbh->quote($onDate) . ' or Z36H_RETURNED_DATE= '.$dbh->quote($onDate)\n );\n$pastloans->execute;\nwhile (my ($id, $date, $hour, $rdate, $rhour, $itemStatus, $borStatus) = $pastloans->fetchrow_array) {\n $id=substr($id,0,9);\n print STDOUT \" <loan>n\";\n print STDOUT \" <lcn>$id<\/lcn>n\";\n my @ISBNs=getISBNs($id);\n foreach my $ISBN (@ISBNs){\n print STDOUT \" <isbn>$ISBN<\/isbn>n\";\n }\n print STDOUT sprintf(\" <issue_date>%08d %04d<\/issue_date>n\", $date, $hour);\n print STDOUT sprintf(\" <return_date>%08d %04d<\/return_date>n\", $rdate, $rhour);\n print STDOUT \" <item_type>$itemStatus<\/item_type<n\";\n print STDOUT \" <department>$borStatus<\/department<n\";\n print STDOUT \" <\/loan>n\";\n $total_number++;\n}\n$pastloans->finish;\n\nprint STDOUT \" <total_loan_count>$total_number<\/total_loan_count>n\";\nprint STDOUT \"<\/loan_transactions>n\";\n\nsub getISBNs\n{\n my ($lcn)= @_;\n $getISBN->execute($lcn);\n my @isbns;\n while(my ($t)=$getISBN->fetchrow_array){\n if($t=~m\/^$$a([dw-]{9,13})\/){\n push @isbns, $1;\n }\n }\n return @isbns;\n}\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"The academic dashboard has a number of features that are only available if the “loans cache” part of LORLS has been set up. \u00a0The installer will create the required database and install the following three scripts in the “\/usr\/local\/LUMP\/bin” directory. updateISBNMap updateLoanCache preloadLoanCache The “updateISBNMap” and “updateLoanCache” scripts require access to the following APIs on […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":129,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-1566","page","type-page","status-publish","hentry","count-0","even alt","author-lbjlclboro-ac-uk","last"],"_links":{"self":[{"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/pages\/1566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/comments?post=1566"}],"version-history":[{"count":0,"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/pages\/1566\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/pages\/129"}],"wp:attachment":[{"href":"https:\/\/blog.lboro.ac.uk\/lorls\/wp-json\/wp\/v2\/media?parent=1566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}