[VuFind-Tech] Voyager users: confirmation of patron profile details please

[Steven M. <smc...@nl...>]

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 <smc...@nl...>
IT Business Systems
National Library of Australia