Steven, The Voyager driver with VuFind is built for a Voyager 6 system - you are probably experiencing problems since you are on Voyager 5.  The getMyProfile is working for our Voyager installation.

 

Andrew

 

From: vufind-tech-bounces@lists.sourceforge.net [mailto:vufind-tech-bounces@lists.sourceforge.net] On Behalf Of Steven McPhillips
Sent: Thursday, November 08, 2007 12:52 AM
To: vufind-tech@lists.sourceforge.net
Subject: [VuFind-Tech] Voyager users: confirmation of patron profile details please

 

Hi,

 

I've just been looking at the Patron profile information being extracted from Voyager via Vufind and need some help from another Voyager site.

 

For our Voyager (5) installation, the getMyProfile function doesn't quite work out of the box - below is a patch I had to apply to get some workable data out. I was wondering if anybody else could comment on the effectiveness of this function on their site? I have a sneaking suspicion that Endeavor / Ex Libris did/do a bit of onsite tinkering to get things working...

 

The patch below is against the 190 subversion release.

 

cheers,

 

Steve

 

(ref: web/services/Search/Drivers.Voyager.php)

 

@@ -174,10 +174,11 @@

     public function getMyProfile($patronId)

     {

         $sql = "SELECT PATRON.LAST_NAME, PATRON.FIRST_NAME, PATRON.HISTORICAL_CHARGES, PATRON_ADDRESS.ADDRESS_LINE1, PATRON_ADDRESS.ADDRESS_LINE2, PATRON_ADDRESS.ZIP_POSTAL, PATRON_PHONE.PHONE_NUMBER, PATRON_GROUP.PATRON_GROUP_NAME " .

-               "FROM $this->dbName.PATRON, $this->dbName.PATORN_ADDRESS, $this->dbName.PATRON_PHONE, PATRON_GROUP " .

+               "FROM $this->dbName.PATRON, $this->dbName.PATRON_ADDRESS, $this->dbName.PATRON_PHONE, $this->dbName.PATRON_BARCODE, $this->dbName.PATRON_GROUP " .

                "WHERE PATRON.PATRON_ID = PATRON_ADDRESS.PATRON_ID " .

-               "AND PATRON.PATRON_ID = PATRON_PHONE.PATRON_ID " .

-               "AND PATRON.PATRON_ID = PATRON_GROUP.PATRON_ID " .

+               "AND PATRON.PATRON_ID = PATRON_BARCODE.PATRON_ID " .

+               "AND PATRON_ADDRESS.ADDRESS_ID = PATRON_PHONE.ADDRESS_ID " .

+               "AND PATRON_BARCODE.PATRON_GROUP_ID = PATRON_GROUP.PATRON_GROUP_ID " .

                "AND PATRON.PATRON_ID = '$patronId'";

         try {

             $sqlStmt = $this->db->prepare($sql);

 

 

 

 

----

Steven McPhillips <smcphillips@nla.gov.au>

IT Business Systems

National Library of Australia