VuFind 4: Koha ILS driver

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

VuFind 4: Koha ILS driver

P. S. Mukhopadhyay

Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------
by Thompson, JoLinda,
Published 2014
Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...
An error has occurred
Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?


--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------
by Thompson, JoLinda,
Published 2014
Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...
An error has occurred
Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?


--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:
In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------
by Thompson, JoLinda,
Published 2014
Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...
An error has occurred
Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?


--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Demian Katz

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards



On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Demian Katz

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)

Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:
Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)

Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Demian Katz

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM
To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing


2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'
 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:
It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Demian Katz

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM
To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Yes Demian. It seems the latest stable release of Koha includes a structural change, VuFind community may see this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196.
Possibly some modifications require in KohaILSDI.php for tuning with the Koha structural change.

Regards

On Wed, Jul 12, 2017 at 10:29 PM, Demian Katz <[hidden email]> wrote:

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Demian Katz

Yes, it does appear that this change will require a modification to the ILS driver. The question is how best to manage this – do we need a new .ini setting to indicate the version so that we can adjust behavior for version 3 vs. version 4? Do we simply want to change the behavior on the assumption that users will upgrade to 4? Does this all become a non-issue at some point in the future when the RESTful driver is released? (see https://github.com/vufind-org/vufind/pull/874).

 

It may be worthwhile to contact the current users/developers of the KohaILSDI driver to get their opinions – since I am not a Koha user myself, I do not have strong feelings about this matter.

 

Please let me know if I can be of any further assistance!

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 2:44 PM
To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. It seems the latest stable release of Koha includes a structural change, VuFind community may see this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196.

Possibly some modifications require in KohaILSDI.php for tuning with the Koha structural change.

Regards

 

On Wed, Jul 12, 2017 at 10:29 PM, Demian Katz <[hidden email]> wrote:

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Yes Demian. It seems better to wait for the RESTfull driver.

On Thu, Jul 13, 2017 at 12:19 AM, Demian Katz <[hidden email]> wrote:

Yes, it does appear that this change will require a modification to the ILS driver. The question is how best to manage this – do we need a new .ini setting to indicate the version so that we can adjust behavior for version 3 vs. version 4? Do we simply want to change the behavior on the assumption that users will upgrade to 4? Does this all become a non-issue at some point in the future when the RESTful driver is released? (see https://github.com/vufind-org/vufind/pull/874).

 

It may be worthwhile to contact the current users/developers of the KohaILSDI driver to get their opinions – since I am not a Koha user myself, I do not have strong feelings about this matter.

 

Please let me know if I can be of any further assistance!

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 2:44 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. It seems the latest stable release of Koha includes a structural change, VuFind community may see this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196.

Possibly some modifications require in KohaILSDI.php for tuning with the Koha structural change.

Regards

 

On Wed, Jul 12, 2017 at 10:29 PM, Demian Katz <[hidden email]> wrote:

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

Josef Moravec
Hello all,

the future planned RESTful driver should not have this problem - in Koha API this is solved internally... 

Anyway, I did try to fix it for now in Koha ILS-DI driver: https://github.com/vufind-org/vufind/pull/1007

Parthasarathi could you test it please?

st 12. 7. 2017 v 21:06 odesílatel P. S. Mukhopadhyay <[hidden email]> napsal:
Yes Demian. It seems better to wait for the RESTfull driver.

On Thu, Jul 13, 2017 at 12:19 AM, Demian Katz <[hidden email]> wrote:

Yes, it does appear that this change will require a modification to the ILS driver. The question is how best to manage this – do we need a new .ini setting to indicate the version so that we can adjust behavior for version 3 vs. version 4? Do we simply want to change the behavior on the assumption that users will upgrade to 4? Does this all become a non-issue at some point in the future when the RESTful driver is released? (see https://github.com/vufind-org/vufind/pull/874).

 

It may be worthwhile to contact the current users/developers of the KohaILSDI driver to get their opinions – since I am not a Koha user myself, I do not have strong feelings about this matter.

 

Please let me know if I can be of any further assistance!

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 2:44 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. It seems the latest stable release of Koha includes a structural change, VuFind community may see this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196.

Possibly some modifications require in KohaILSDI.php for tuning with the Koha structural change.

Regards

 

On Wed, Jul 12, 2017 at 10:29 PM, Demian Katz <[hidden email]> wrote:

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: VuFind 4: Koha ILS driver

P. S. Mukhopadhyay
Reporting the result of fix as developed by Josef Moravec for KohaILS driver:

1.Debug mode with driver = KohaILSDI report:

2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Rows count: 2
2017-07-13T16:19:40+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Processing finished, rows processed: 2, took 0.0021791458129883 sec
2017-07-13T16:19:40+05:30 DEBUG: VuFindSearch\Backend\Solr\Connector: Query fl=%2A%2Cscore&wt=json&json.nl=arrarr&q=id%3A%221%22
2017-07-13T16:19:40+05:30 DEBUG: VuFindSearch\Backend\Solr\Connector: => GET http://localhost:9090/solr/biblio/select?fl=%2A%2Cscore&wt=json&json.nl=arrarr&q=id%3A%221%22
2017-07-13T16:19:40+05:30 DEBUG: VuFindSearch\Backend\Solr\Connector: <= 200 OK
2017-07-13T16:19:40+05:30 DEBUG: Deserialized SOLR response

2.
Auto Configure

Basic Configuration... OK

Cache... OK

Database... OK

Dependencies... OK

ILS... OK

Solr... OK

Security... OK

SSL... OK

3.extraHoldFields = pickUpLocation:requiredByDate:comments is working as expected

4.Holds and Holds canceled worked fine


I think it is working as expected. Congratulations Josef.

Any suggestions for any specific test?


On Thu, Jul 13, 2017 at 1:57 PM, Josef Moravec <[hidden email]> wrote:
Hello all,

the future planned RESTful driver should not have this problem - in Koha API this is solved internally... 

Anyway, I did try to fix it for now in Koha ILS-DI driver: https://github.com/vufind-org/vufind/pull/1007

Parthasarathi could you test it please?

st 12. 7. 2017 v 21:06 odesílatel P. S. Mukhopadhyay <[hidden email]> napsal:
Yes Demian. It seems better to wait for the RESTfull driver.

On Thu, Jul 13, 2017 at 12:19 AM, Demian Katz <[hidden email]> wrote:

Yes, it does appear that this change will require a modification to the ILS driver. The question is how best to manage this – do we need a new .ini setting to indicate the version so that we can adjust behavior for version 3 vs. version 4? Do we simply want to change the behavior on the assumption that users will upgrade to 4? Does this all become a non-issue at some point in the future when the RESTful driver is released? (see https://github.com/vufind-org/vufind/pull/874).

 

It may be worthwhile to contact the current users/developers of the KohaILSDI driver to get their opinions – since I am not a Koha user myself, I do not have strong feelings about this matter.

 

Please let me know if I can be of any further assistance!

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 2:44 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. It seems the latest stable release of Koha includes a structural change, VuFind community may see this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196.

Possibly some modifications require in KohaILSDI.php for tuning with the Koha structural change.

Regards

 

On Wed, Jul 12, 2017 at 10:29 PM, Demian Katz <[hidden email]> wrote:

That error is coming from the driver code – it seems to expect there to be a marcxml column in the database that it can extract details from. Perhaps this is not a universally enabled/supported feature. Unfortunately, I don’t know enough about Koha to know the full context here, but a search for “marcxml” in the code should help you pinpoint what it is trying to do.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:57 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Sorry Demian. There was an extra dot in the file name. Now it is reflecting the local values but one error is showing

2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://localhost:8007/cgi-bin/koha/ilsdi.pl
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: GEN
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connected to DB
2017-07-12T22:23:42+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marcxml' in 'field list'

 

 

On Wed, Jul 12, 2017 at 10:13 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

It seems Okay.

# This line points to the local override directory where you should place your customized files
  # to override VuFind core features/settings.  Set to blank string ("") to disable.
  SetEnv VUFIND_LOCAL_DIR /usr/local/vufind/local

 

On Wed, Jul 12, 2017 at 10:02 PM, Demian Katz <[hidden email]> wrote:

Is VUFIND_LOCAL_DIR also set correctly in your $VUFIND_LOCAL_DIR/httpd-vufind.conf file?

 

I just tested this on my own system, and when I copied KohaILSDI.ini into my local config directory and turned on debug, my edits to that file were immediately reflected in the debug messages.

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 12:31 PM


To: Demian Katz
Cc: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

My vufind.sh  is pointing VUFIND_LOCAL_DIR rightly

export JAVA_HOME="/usr/lib/jvm/default-java"
export VUFIND_HOME="/usr/local/vufind"
export VUFIND_LOCAL_DIR="/usr/local/vufind/local"
export SOLR_PORT=9090

 

On Wed, Jul 12, 2017 at 9:56 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

Demain It seems a bug. The debug = true shows;

2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Config Summary:
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: DB Host: localhost
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: ILS URL: http://library.myuniversity.edu/cgi-bin/koha/ilsdi.pl
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Locations: 
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Default Location: MAIN
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Function getHolding(1, ) called
2017-07-12T21:51:39+05:30 DEBUG: VuFind\ILS\Driver\KohaILSDI: Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'mysqlusername'@'localhost' (using password: YES)
Possibly the values as given in local/config/vufind/kKohaILSDI is not taken into consideration at all. What to do? 

 

On Wed, Jul 12, 2017 at 7:44 PM, Demian Katz <[hidden email]> wrote:

Have you tried turning on debug mode near the top of config.ini? It appears that the KohaILSDI driver offers verbose debug output, including which request URLs it is attempting to make. That might reveal where the problem lies….

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 10:11 AM
To: Demian Katz
Cc: vufind-tech


Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Yes Demian. My second mail is based on wrong understanding. It is still calling Koha driver. Changed driver again as driver = KohaILSDI but reporting the same error.

My Koha version is the latest one 17.05.01. It is providing ISLDI service through http://localhost:8007/cgi-bin/koha/ilsdi.pl. For example:

1. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetRecords&id=3 gives >>

-----------------------
<GetRecords><record><isbn>1122334455</isbn><publishercode>World Press</publishercode><issues>
    </issues><marcxml><?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>         a              </leader>
  <datafield tag="020" ind1=" " ind2=" ">
    <subfield code="a">1122334455</subfield>
  </datafield>
  <datafield tag="100" ind1=" " ind2=" ">
    <subfield code="a">Das, A. K.</subfield>
  </datafield>
  <datafield tag="245" ind1=" " ind2=" ">
    <subfield code="a">Library cataloguing</subfield>
  </datafield>
  <datafield tag="250" ind1=" " ind2=" ">
    <subfield code="a">2nd ed. </subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="b">World Press</subfield>
    <subfield code="c">2010</subfield>
  </datafield>
  <datafield tag="999" ind1=" " ind2=" ">
    <subfield code="c">3</subfield>
    <subfield code="d">3</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">3</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0567</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c2</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="0">0</subfield>
    <subfield code="1">0</subfield>
    <subfield code="2">ddc</subfield>
    <subfield code="4">0</subfield>
    <subfield code="7">0</subfield>
    <subfield code="9">4</subfield>
    <subfield code="a">nml</subfield>
    <subfield code="b">nml</subfield>
    <subfield code="c">GEN</subfield>
    <subfield code="d">2017-05-04</subfield>
    <subfield code="e">1</subfield>
    <subfield code="g">400.00</subfield>
    <subfield code="p">0543</subfield>
    <subfield code="r">2017-05-04</subfield>
    <subfield code="t">c1</subfield>
    <subfield code="v">500.00</subfield>
    <subfield code="w">2017-05-04</subfield>
    <subfield code="y">BK</subfield>
  </datafield>
</record>
</marcxml><biblioitemnumber>3</biblioitemnumber><cn_sort/><editionstatement>2nd ed. </editionstatement><biblionumber>3</biblionumber><reserves>
    </reserves><timestamp>2017-05-04 12:47:17</timestamp><items><item><homebranch>nml</homebranch><dateaccessioned>2017-05-04</dateaccessioned><permanent_location>GEN</permanent_location><date_due/><replacementprice>500.00</replacementprice><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><withdrawn>0</withdrawn><barcode>0567</barcode><copynumber>c2</copynumber><cn_source>ddc</cn_source><notforloan>0</notforloan><biblioitemnumber>3</biblioitemnumber><itype>BK</itype><cn_sort/><price>400.00</price><biblionumber>3</biblionumber><itemnumber>3</itemnumber><location>GEN</location><itemlost>0</itemlost><timestamp>2017-05-04 15:51:48</timestamp><homebranchname>NML Library</homebranchname><holdingbranch>nml</holdingbranch><booksellerid>1</booksellerid><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged></item><item><itemnumber>4</itemnumber><price>400.00</price><biblionumber>3</biblionumber><itype>BK</itype><cn_sort/><biblioitemnumber>3</biblioitemnumber><notforloan>0</notforloan><copynumber>c1</copynumber><barcode>0543</barcode><cn_source>ddc</cn_source><holdingbranchname>NML Library</holdingbranchname><damaged>0</damaged><booksellerid>1</booksellerid><holdingbranch>nml</holdingbranch><timestamp>2017-05-04 15:52:06</timestamp><homebranchname>NML Library</homebranchname><location>GEN</location><itemlost>0</itemlost><permanent_location>GEN</permanent_location><dateaccessioned>2017-05-04</dateaccessioned><homebranch>nml</homebranch><withdrawn>0</withdrawn><datelastseen>2017-05-04</datelastseen><replacementpricedate>2017-05-04</replacementpricedate><replacementprice>500.00</replacementprice><date_due/></item></items></record></GetRecords>
-------------------------------------------

2. http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=GetAvailability&id=1+2&id_type=item

-------------------------
<dlf:collection xsi:schemaLocation="http://diglib.org/ilsdi/1.1     http://diglib.org/architectures/ilsdi/schemas/1.1/dlfexpanded.xsd"><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="1"><dlf:simpleavailability><dlf:identifier>1</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record><dlf:record><dlf:bibliographic id="1"/><dlf:items><dlf:item id="2"><dlf:simpleavailability><dlf:identifier>2</dlf:identifier><dlf:availabilitystatus>not available</dlf:availabilitystatus><dlf:availabilitymsg>Checked out</dlf:availabilitymsg><dlf:location>NML Library</dlf:location></dlf:simpleavailability></dlf:item></dlf:items></dlf:record></dlf:collection>
-------------------------

My KohaILSDI.ini is as follows:

-----------------
; KohaILSDI Driver Config

; This driver differs that it uses the ISL-DI API instead of direct database calls
; It does however, fallback to direct database calls to enhance functionaility
; that is not available in in the ILS-DI API.

; You must enable ILS-DI in the Web services preferences in Koha

[Catalog]
; database host, port, user, password, database
host        = localhost
port        = 3306
username    = koha_nml
password    = kohakoha
database    = koha_nml

; Url to the ILS-DI API
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl

;; In addition you can set 'renewals_enabled' and
;; 'cancel_holds_enabled' in config.ini to 'true' using this driver.
;; I would also recommend you set 'holds_mode' to '"holds"', as this
;; driver does not handle recalls.

[Holds]
; HMACKeys - A list of hold form element names that will be analyzed for consistency
; during hold form processing. Most users should not need to change this setting.
; Comment this line to disable VuFind integrated reservations.
HMACKeys = item_id:id:level

; defaultRequiredDate - A colon-separated list used to set the default "not required
; after" date for holds in the format days:months:years
; e.g. 0:1:0 will set a "not required after" date of 1 month from the current date
defaultRequiredDate = 0:1:0

; extraHoldFields - A colon-separated list used to display extra visible fields in the
; place holds form. Supported values are "comments", "requiredByDate" and
; "pickUpLocation"
; Note: As of the time of writing, eventhough ILSDI API docs have long declared
; support for 'comments' and 'requiredByDate' options when placing holds, these
; features might not yet be implemented (nulling any input passed to the appropriate
; functions). Should you decide to use them in extraHoldFields, please check that data
; entered in appropriate hold form is properly passed to Koha.
extraHoldFields = pickUpLocation

; A Pick Up Location Code used to pre-select the pick up location drop
; down list and provide a default option if others are not
; available. The default of 'false' will force users to pick a pickup
; location. By setting this to a Koha location code (e.g. '"MAIN"'),
; Vufind will default to that location.
; If no defaultPickUpLocation and no pickupLocations are defined,
; the driver will try to use the actual holdingbranch(es) of the item/title
; as a fallback.
defaultPickUpLocation = GEN

; branchcodes for libraries avalaible as pickup locations
pickupLocations[] = nml

[Other]
; Locations for Always Available by Default
;availableLocations[] = REFERENCEAREA
;availableLocations[] = INTERNET
;availableLocations[] = ONLINE
------------------------------

But the moment I set driver as KohaILSDI, the auto configure shows error and searching does not show information.

Regards

 

 

On Wed, Jul 12, 2017 at 7:06 PM, Demian Katz <[hidden email]> wrote:

Hello,

 

If you set your driver setting to “Koha”, you will get the legacy, database-driven Koha driver, which does not include holds or recall support. Its code is found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/Koha.php

 

If you set the driver setting to “KohaILSDI” you will get the newer, API-driven Koha driver, found here:

 

https://github.com/vufind-org/vufind/blob/master/module/VuFind/src/VuFind/ILS/Driver/KohaILSDI.php

 

… so I think your original message about having problems getting KohaILSDI to work may still be true. Are you using a Koha version that supports the ILS-DI API? Is the API activated in the software? Is your KohaILSDI.ini file pointing to the correct API URL?

 

- Demian

 

From: P. S. Mukhopadhyay [mailto:[hidden email]]
Sent: Wednesday, July 12, 2017 9:18 AM
To: vufind-tech
Subject: Re: [VuFind-Tech] VuFind 4: Koha ILS driver

 

Koha ILS driver is showing items availability perfectly. But 'renewals_enabled', 'cancel_holds_enabled' to 'true and 'holds_mode' to '"holds" in config.ini ' are not giving me any additional facilities in comparison with the traditional Koha driver works through direct database call.

Regards

 

On Wed, Jul 12, 2017 at 5:12 PM, P. S. Mukhopadhyay <[hidden email]> wrote:

In continuation of my previous mail, let me report that the problem has been solved. There was a problem in my understanding KohaILSDI; Actually driver name will be Koha but contents will be based on KohaILSDI.ini file.

Regards

 

On Wed, Jul 12, 2017 at 4:23 PM, P. S. Mukhopadhyay <[hidden email]> wrote:


Dear all

I'm trying to integrate Koha with VuFind 4 by using KohaILSDI.ini driver. The steps I followed are:

1. Make Koha ILSDI ready (http://localhost:8007/cgi-bin/koha/ilsdi.pl?service=Describe&verb=GetAvailability is giving response and thereby ensures Koha (ver.17.05.01) is ready;

2. Changed config.ini to include driver = KohaILSDI;

3. Placed default KohaILSDI.ini in local config folder

4. Changed KohaILSDI.ini as

host        = localhost
port        = 3306
username    = <mysql user>
password    = <password>
database    = <databse>
url             = http://localhost:8007/cgi-bin/koha/ilsdi.pl
HMACKeys = item_id:id:level
defaultRequiredDate = 0:1:0
extraHoldFields = pickUpLocation
defaultPickUpLocation = GEN <GEN is location code in Koha for General Shelf>
pickupLocations[] = nml <nml is branch code>

After this when I open http://localhost/vufind/Install/Home, it give me error;

Searching shows books but not item lavel information

-----------------------------------

by Thompson, JoLinda,
Published 2014

Table of Contents: '; ...The evolution of Web-scale discovery in libraries -- A closer look at Web-scale discovery options...

An error has occurred

Book An error has occurred
--------------------------------------------------------

But the moment I change to driver as Koha or MultiBackEnd it is working fine or as expected.

What am I missing?

 

--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--

-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------




--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech



--
-----------------------------------------------------------------------
Dr. Parthasarathi Mukhopadhyay
Associate Professor, Department of Library and Information Science, University of Kalyani,
Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Vufind-tech mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/vufind-tech
Loading...