mjlassila

const gaTrackingId = '...';
 
class GoogleAnalytics {
  constructor($rootScope, $location, $window) {
    this.$rootScope = $rootScope;
    this.$location = $location; 
    this.$window = $window;
    this.loadAnalytics(this.$window);
  }
  

mjlassila

declare option output:method "csv";
declare option output:csv "header=yes, separator=;";

let $docs_with_affils:=
<records>{
  for $record in //oai_marc
    where $record/controlfield[@tag eq "001"] contains text {'article.*'} using wildcards
  let $parent:=substring-before(substring-after(base-uri($record),"/journalfi-data/"),".xml")
  let $affiliation_count:=count($record//datafield[@tag eq '100' or @tag eq '700']/subfield[@code eq 'u'])
  let $orcid_count:=count($record//datafield[@tag eq '100' or @tag eq '700']/subfield[@code eq '0' and . contains text {"orcid.*"} using wildcards])

mjlassila

declare option output:method "csv";
declare option output:csv "header=yes, separator=comma";

declare function local:to-datestamp($raw_date){
  let $parts:=tokenize($raw_date," / ")
  return $parts[2] || '-' || $parts[1] || '-1'
  
};

declare function local:not-total($string) {

mjlassila

JUFO-konferenssit

Julkaisufoorumi-tietokannasta poistetut konferenssien vakiintuneet nimet. Muunnettu Julkaisufoorumin sivulta ladatusta PDF-tiedostosta käyttäen Tabula-työkalua ja merkistöt siivottu ftfy:llä.

mjlassila

# vim:set ft=perl:ts=4:sw=4
#
# Ref.: http://librecat.org/Catmandu/
# https://github.com/LibreCat/Catmandu/wiki/Example%20Fix%20Script
# https://github.com/scriptotek/simplemarcparser/blob/master/src/BibliographicRecord.php

# For ElasticSearch 2.0
# See https://github.com/LibreCat/Catmandu-Store-Elasticsearch/commit/63795416d2585eab7af1d5263f5823b4cae94251
# <s>Note that we use _identifier over _id to cover deleted records which do not have _id</s>
# UPDATE: When importing from a MARC dump, we don't have OAI IDs, so use the simple _ids instead.

mjlassila

SELECT
	biblio.title as 'Nimeke',
	CONCAT('<a href=\"/cgi-bin/koha/catalogue/moredetail.pl?', 
       'biblionumber=', biblio.biblionumber, '&itemnumber=', items.itemnumber, 
       '\">', items.barcode, '</a>' ) AS 'Viivakoodi',
	items.datelastborrowed as 'Lainattu viimeksi',
	items.datelastseen as 'Käsitelty viimeksi',
	  CONCAT(
        '<a target="_blank" href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=',
        borrower.borrowernumber,

mjlassila

#!/usr/bin/env perl
#
# Match authors against VIAF
#
# License: http://dev.perl.org/licenses/artistic.html
#
# Author: Patrick Hochstenbach <Patrick.Hochstenbach@UGent.be>
#
# Apr 2015
$|++;

mjlassila

SELECT 
	RTRIM(REGEXP_REPLACE(biblio.title,'[/,:]$','')) as 'Nimeke',
	DATE(issues.issuedate) AS 'Lainattu',
	reserves.reservedate AS 'Varattu',
	CONCAT(
        '<a target="_blank" href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=',
        borrowers.borrowernumber,
        '\">',
        borrowers.cardnumber,
        '</a>'

mjlassila

/*=============================================================
    Koha-raporttikyselyitä
    Matti Lassila, Avoimen tiedon keskus, Jyväskylän yliopisto.

    Huomaa kyselyitä käyttäessäsi, että esimerkiksi URL-
    osoitteet sisältävät parametreina JYU:n Kohan raporttien ID:t
    joten kyselyitä ei voi useimmissa tapauksissa käyttää suoraan
    ilman muokkausta.
==============================================================*/

mjlassila