5. Download Impala requests

Auteur Jan Corthouts
Aanmaak 19 okt 2004
Aangepast door Tom De Mey
Aangepast op 19 apr 2015
Oud BVV nr 2093

5.1. Abstract

This document describes the format in which the Impala requests can be downloaded as a csv-file for Import in Access or Excel.

5.2. CSV format

The so-called CSV (Comma Separated Values) format is the most common import and export format for spreadsheets and databases. There is no ‘’CSV standard’‘, so the format is operationally defined by the many applications which read and write it. The lack of a standard means that subtle differences often exist in the data produced and consumed by different applications. These differences can make it annoying to process CSV files from multiple sources. Still, while the delimiters and quoting characters vary, the overall format is similar enough that it is possible to write a single module which can efficiently manipulate such data, hiding the details of reading and writing the data from the programmer.

In Impala you can export requests from the Impala system into a csv-file. The format of this file is described below. While downloading Impala request in csv-format we use following conventions:

  • The first line of the file contains the field identifier.
  • delimiter (field separator): ;
  • lineterminator: rn
  • quotechar: “
  • character set : ISO-Latin-1

5.3. How to download Impala requests

Impala requests can be downloaded from the different overviews in Impala: the current requests (Own requests and Received requests) as well as the old requests.

Download Impala requests from a list

As there can be many requests in an overview, download time can vary from a few seconds to a few minutes. Alternatively you can limit the number of requests in the list by

  • checking individual requests and then chose the option Chosen selection
  • apply filters to the list e.g. on data, type, keyword and then download only the requests matching the filter values.

As a result of the download operation Impala will display the URL pointing to the csv file. Click on the link to download the file to your PC.

Download Impala requests from a list

5.4. Impala fields

The csv file holds all the request data in separate rows. The first row contains the field identifiers. These identifiers are as follows:

Impala fields
gen_rq Impala request number in format rq:impala:1812345
gen_source

Origin of the Impala request. The origin contains the identifier of the Impala catalogue, such as

  • antilope
  • anet
  • unicat
  • vlacc
  • ...
gen_method

Way in which the request arrived to Impala Possible values include:

euser
indicates that the request was submitted by the end user. This is only the case for Anet libraries using Brocade.
man
indicates that the request was submitted as a manual request by ILL staff.
openurl
indicates that the request arrived to Impala as a resut from a search in one of the catalogues available in Impala. Requests generated from a catalogue search are submitted to Impala using OpenURL syntaxis.
   
state_date_active Date and time on which the request became active in Impala. Format is DD/MM/YYYY hh:mm
state_current_state

Current status of the request. This is always one of the following values:

  • active
  • atsupplier-aware
  • atsupplier-aware-rfi
  • atsupplier-aware-rfi-answer
  • atsupplier-aware-timeout
  • atsupplier-failure
  • atsupplier-redirect
  • atsupplier-released
  • atsupplier-success
  • atsupplier-unaware
  • atsupplier-unaware-skipped
  • atsupplier-unaware-stopped
  • atsupplier-unaware-timeout
  • finished-failed-nosuppliers
  • finished-failed-timeout
  • finished-stopped
  • finished-success-delivered
  • finished-success-timeout
state_currentstate_date Date and time on which the current state was reached. Format is DD/MM/YYYY hh:mm
state_current_lib Identifier of the supplying library which most recently handled the request. The identifier takes the form of number. The explanation of the numbers can be found in the impala_ill.csv file.
state_current_wos ILL-centre of the supplier which most recently handled the request. The ILL-centre takes the form of an abbreviation (=acronym). Explanation of the abbreviations can be found in the impala_ill.csv file.
state_current_clib The acronym of the library which most recently handled the request. The explanation of the acronyms can be found in the impala_lev.csv file.
state_current_pk Location of the requested item. Only the location corresponding to the library which most recently handled the request is given.
state_current_pkgenre Collection code. This is only given if the library which most recently handled the request, uses the Brocade library system.
state_current_ownid Record number identifying the holding. This is only given if the library which most recently handled the request, uses the Brocade library system.
state_applicant_wos Identifier of the ILL-center of the requesting library. The ILL-centre takes the form of an abbreviation (=acronym). Explanation of the abbreviations can be found in the impala_ill.csv file.
state_applicant_lib Identifier of the requesting library. The identifier takes the form of number. The explanation of the numbers can be found in the file impala_ill.csv.
   
bib_type

Type of the request. Is always on of the following values:

  • article
  • monograph
  • object
bib_title Title of the monograph/object/journal
bib_creator Author of the monograph/object/journal
bib_series Title of the series to which the requested monograph pr object belongs
bib_publisher Publisher and place of publication of the requested monograph/object/journal
bib_date Year of publication of the monograph/object
bib_identifier Standard bibliographic number (ISBN,ISSN, CODEN, SICI, ...)
bib_coverage Carrier of the requested object (cd, dvd, video, ...).
bib_rights Currently not used.
bib_source Source of the request (database + identifier within the database. Currently not used).
bib_subject Statistical code as given while entering the request
   
bib_atitle Article title
bib_acreator Article author
bib_adate Year
bib_avol Volume
bib_aissue Issue
bib_apages Begin- and en pages of the requested article
   
adm_euser Borrower number
adm_neuser Borrower name
adm_email Borrower e-mail address
adm_link Currently not used
adm_pdf URL of the electronic document: this is only supplied if the document was received on the central VirLib server at the UA
adm_ownid Identifier of the request in the local ILL system
adm_keyword Keyword as given while entering the request in Impala
adm_note_internal Internal note
adm_note_external Note to the supplier
adm_cost Delivery cost in EUR as entered by the supplier upon successful delivery
adm_edelivery Takes the value of 1 (item was delivered electronically) or 0 ((item was not delivered electronically)

5.5. CSV file supplying libraries

As explained in the previous chapter, the acronyms of the supplying libaries are given in the state_current_clib field. Further details on these acronyms can be found in the impala_lev.csv file.

This file holds address and contact info for all supplying libraries in Impala. The first row contains the field identifiers. These field identifiers are as follows:

Supplying library
id Acronym of the supplying library, e.g. as found in the Antilope catalogue.
libloi Internal Impala record identifier for the supplying library
Naam Name of the library
Bibliotheektype

Library type. This can be one of the following:

  • bedrijf: corporate library
  • documentatie: documentation centers
  • gov: governmental library
  • ob: public library
  • speciaal: special library
  • univ: university library
  • wet: academic/scientifc library other then universities and university colleges
Straat Street
Postcode Zip code
Gemeente City
Land Country
Telefoon Telephone number
Fax Fax number
E-mailadres email address
URL Home page of the library
Persoon Contact person

Contact the Impala helpdesk if data need to be corrected.

5.6. CSV file ILL departments

As explained in the previous chapter, the acronyms of the ILL departments are given in the state_current_wos, state_applicant_wos and state_current_lib fields. Further details on these acronyms can be found in the impala_ill.csv file.

This file holds address and contact info for all ILL departments in Impala. The first row contains the field identifiers. These fields serve different purposes in the Impala application. The most important identifiers are as follows:

ILL departments
id Acronym of the ILL department
libloi Internal Impala record identifier for the institution to which the ILL department belongs
Naam Name of the ILL department
Bibliotheektype

Library type. This can be one of the following:

  • bedrijf: corporate library
  • documentatie: documentation centers
  • gov: governmental library
  • ob: public library
  • speciaal: special library
  • univ: university library
  • wet: academic/scientifc library other then universities and university colleges
Straat Street
Postcode Zip code
Gemeente City
Land Country
Telefoon Telephone number
Fax Fax number
E-mailadres email address
URL Home page of the library
Persoon Contact person
stat

Statistical code used to group several ILL departments together for purpose of statistics. Examples of statistical grouping codes are:

  • all-corp: all corporate libraries
  • all-extern: all foreign document suppliers
  • all-gov: all governmental libraries
  • all-ob: all Flemish public libraries
  • all-school: all university colleges
  • all-spec: all special libraries/documentation cenetrs
  • all-univ: all university libraries
  • all-wet: all scientifc libraries other than university or university college
  • ce: all libraries at the European Unionan
  • oba: all public libraries City of Antwerp
  • obhgew: all public libraries in the Brussels Hoofdstedelijk Gewest
  • obprovant: all public libraries in Province of Antwerp
  • obprovlim: all public libraries in the Province of Limburg
  • obprovovl: all public libraries in the province Oost-Vlaanderen
  • obprovvlbr: all public libraries in the province of Vlaams-Brabant
  • obprovwvl: all public libraries in the Province of West-Vlaanderen
apply_pref list of preferential ILL partners for the given ILL department. Sequence of identifiers is in order of preference (most prefered partners first).

Contact the Impala helpdesk if data need to be corrected.