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

[Andrew N. <and...@vi...>]

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

Andrew

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

Hi,

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

For our Voyager (5) installation, the getMyProfile function doesn't quite w=
ork out of the box - below is a patch I had to apply to get some workable d=
ata 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 =3D "SELECT PATRON.LAST_NAME, PATRON.FIRST_NAME, PATRON.HISTO=
RICAL_CHARGES, PATRON_ADDRESS.ADDRESS_LINE1, PATRON_ADDRESS.ADDRESS_LINE2, =
PATRON_ADDRESS.ZIP_POSTAL, PATRON_PHONE.PHONE_NUMBER, PATRON_GROUP.PATRON_G=
ROUP_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.PATR=
ON_GROUP " .
                "WHERE PATRON.PATRON_ID =3D PATRON_ADDRESS.PATRON_ID " .
-               "AND PATRON.PATRON_ID =3D PATRON_PHONE.PATRON_ID " .
-               "AND PATRON.PATRON_ID =3D PATRON_GROUP.PATRON_ID " .
+               "AND PATRON.PATRON_ID =3D PATRON_BARCODE.PATRON_ID " .
+               "AND PATRON_ADDRESS.ADDRESS_ID =3D PATRON_PHONE.ADDRESS_ID =
" .
+               "AND PATRON_BARCODE.PATRON_GROUP_ID =3D PATRON_GROUP.PATRON=
_GROUP_ID " .
                "AND PATRON.PATRON_ID =3D '$patronId'";
         try {
             $sqlStmt =3D $this->db->prepare($sql);




----
Steven McPhillips <smc...@nl...<mailto:smc...@nl...>>
IT Business Systems
National Library of Australia