From 78f625d3ebeb1c0e82c774b6f16c6fd82e1e52c3 Mon Sep 17 00:00:00 2001 From: Robert Soulliere Date: Sat, 18 Sep 2010 19:41:51 -0400 Subject: [PATCH] Fix some of the overflow issues during PDF processing. --- 1.6/admin/migratingdata.xml | 23 ++++-- 1.6/admin/serveradministration.xml | 114 ++++++++++++++--------------- 1.6/admin/sip.xml | 10 ++- 3 files changed, 80 insertions(+), 67 deletions(-) diff --git a/1.6/admin/migratingdata.xml b/1.6/admin/migratingdata.xml index af32df16ca..fc524f96c0 100644 --- a/1.6/admin/migratingdata.xml +++ b/1.6/admin/migratingdata.xml @@ -37,8 +37,9 @@ sql CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, program_name text, email text, address_type text, street1 text, street2 text, city text, province text, - country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text + student_id int, barcode text, last_name text, first_name text, program_number text, program_name text, email text, address_type text, street1 text, + street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, + claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text ); Note the DEFAULT variables. These allow you to set default for your library or to populate required fields if you data allows @@ -56,8 +57,11 @@ UPDATE students phone = replace(replace(replace(rpad(substring(phone from 1 for Insert records from the staging table into the actor.usr Evergreen table: INSERT INTO actor.usr ( - profile, usrname, email, passwd, ident_type, ident_value, first_given_name, family_name, day_phone, home_ou, claims_returned_count, net_access_level) SELECT profile, students.usrname, - email, student_id, ident_type, student_id, first_name, last_name, phone, home_ou, claims_returned_count, net_access_level FROM students; + profile, usrname, email, passwd, ident_type, ident_value, first_given_name, family_name, day_phone, home_ou, claims_returned_count, + net_access_level) + SELECT profile, students.usrname, email, student_id, ident_type, student_id, first_name, last_name, phone, home_ou, claims_returned_count, + net_access_level + FROM students; @@ -117,15 +121,18 @@ BEGIN; -- Create staging table. CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, program_name text, email text, address_type text, street1 text, street2 text, city text, province text, - country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text + student_id int, barcode text, last_name text, first_name text, program_number text, program_name text, email text, address_type text, + street1 text, street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, + claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text ); --Insert records from the staging table into the actor.usr table. INSERT INTO actor.usr ( - profile, usrname, email, passwd, ident_type, ident_value, first_given_name, family_name, day_phone, home_ou, claims_returned_count, net_access_level) SELECT profile, students.usrname, - email, student_id, ident_type, student_id, first_name, last_name, phone, home_ou, claims_returned_count, net_access_level FROM students; + profile, usrname, email, passwd, ident_type, ident_value, first_given_name, family_name, day_phone, home_ou, claims_returned_count, + net_access_level) + SELECT profile, students.usrname, email, student_id, ident_type, student_id, first_name, last_name, phone, home_ou, claims_returned_count, + net_access_level FROM students; --Insert records from the staging table into the actor.usr table. INSERT INTO actor.card (usr, barcode) diff --git a/1.6/admin/serveradministration.xml b/1.6/admin/serveradministration.xml index a56de01265..68c0e03979 100644 --- a/1.6/admin/serveradministration.xml +++ b/1.6/admin/serveradministration.xml @@ -380,7 +380,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Permissions Table - + Permission Name @@ -399,7 +399,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati transit destination or source - ASSIGN_WORK_ORG_UNIT + ASSIGN_WORK_ORG_UNIT Allows user to define where another staff member's permissions apply via the Permissions Editor interface. @@ -412,12 +412,12 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to cancel holds - CIRC_CLAIMS_RETURNED.override + CIRC_CLAIMS_RETURNED override Allows user to check in/out an item that is claims returned - CIRC_EXCEEDS_COPY_RANGE.override + CIRC_EXCEEDS_COPY_RANGE override Allows user to override the copy exceeds range event @@ -430,12 +430,12 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati checkout - COPY_ALERT_MESSAGE.override + COPY_ALERT_MESSAGE override Allows user to check in/out an item that has an alert message - COPY_BAD_STATUS.override + COPY_BAD_STATUS override Allows user to check out an item in a non-circulating status @@ -448,7 +448,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to check out a copy - COPY_CIRC_NOT_ALLOWED.override + COPY_CIRC_NOT_ALLOWED override Allows user to checkout an item that is marked as non-circ @@ -457,21 +457,21 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to place a hold on a specific copy - COPY_IS_REFERENCE.override + COPY_IS_REFERENCE override Allows user to override the copy_is_reference event - COPY_NOT_AVAILABLE.override + COPY_NOT_AVAILABLE override Allows user to force checkout of Missing/Lost type items - COPY_STATUS_LOST.override + COPY_STATUS_LOST override Allows user to remove the lost status from a copy - COPY_STATUS_MISSING.override + COPY_STATUS_MISSING override Allows user to change the missing status on a copy @@ -510,12 +510,12 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati copies - CREATE_COPY_STAT_CAT_ENTRY + CREATE_COPY_STAT_CAT _ENTRY Allows user to create a new entry for a copy statistical category - CREATE_COPY_STAT_CAT_ENTRY_MAP + CREATE_COPY_STAT_CAT _ENTRY_MAP Allows user to link a copy to a statistical category (i.e., allows user to specify the appropriate entry for a copy and given statistical category) @@ -551,17 +551,17 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to create a new non-cataloged item type - CREATE_PATRON_STAT_CAT + CREATE_PATRON_STAT _CAT Allows user to create a new patron statistical category - CREATE_PATRON_STAT_CAT_ENTRY + CREATE_PATRON_STAT _CAT_ENTRY Allows user to create a new possible entry for patron statistical categories - CREATE_PATRON_STAT_CAT_ENTRY_MAP + CREATE_PATRON_STAT _CAT_ENTRY_MAP Allows user to link another user to a stat cat entry (i.e., specify the patron's entry for a given statistical category) @@ -589,7 +589,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to create another user - CREATE_USER_GROUP_LINK + CREATE_USER_GROUP _LINK Allows user to add other users to permission groups @@ -606,7 +606,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Volume Buckets, and Book Bags). - DELETE_CONTAINER_ITEM + DELETE_CONTAINER _ITEM Allows user to remove items from buckets and bookbags @@ -614,7 +614,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to delete a copy - DELETE_COPY_LOCATION + DELETE_COPY _LOCATION Allows user to delete a copy location @@ -622,16 +622,16 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to delete copy notes - DELETE_COPY_STAT_CAT + DELETE_COPY_STAT _CAT Allows user to delete a copy statistical category - DELETE_COPY_STAT_CAT_ENTRY + DELETE_COPY_STAT _CAT_ENTRY Allows user to delete an entry for a copy statistical category - DELETE_COPY_STAT_CAT_ENTRY_MAP + DELETE_COPY_STAT _CAT_ENTRY_MAP Allows user to delete a copy stat cat entry map @@ -641,16 +641,16 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati circulated). - DELETE_PATRON_STAT_CAT + DELETE_PATRON_STAT _CAT Allows user to delete a patron statistical category - DELETE_PATRON_STAT_CAT_ENTRY + DELETE_PATRON_STAT _CAT_ENTRY Allows user to delete an entry for patron statistical categories - DELETE_PATRON_STAT_CAT_ENTRY_MAP + DELETE_PATRON_STAT _CAT_ENTRY_MAP Allows user to remove a patron's entry for a given statistical category @@ -695,15 +695,15 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati interface - ITEM_AGE_PROTECTED.override + ITEM_AGE_PROTECTED override Allows user to place a hold on an age-protected item - ITEM_ON_HOLDS_SHELF.override + ITEM_ON_HOLDS_SHELF override Allows user to check out an item that is on holds shelf for a different patron - MAX_RENEWALS_REACHED.override + MAX_RENEWALS_REACHED override Allows user to renew an item past the maximum renewal count @@ -724,7 +724,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati batch - OFFLINE_UPLOAD + OFFLINE_UPLOAD Allows user to upload an offline/standalone script @@ -736,15 +736,15 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to login to the OPAC - patron_exceeds_checkout_count.override + patron_exceeds_checkout _count.override Allow user to override checkout count failure - patron_exceeds_fines .override + patron_exceeds_fines override Allow user to override fine amount checkout failure - patron_exceeds_overdue_count .override + patron_exceeds_overdue _count.override Allow user to override overdue count failure @@ -782,7 +782,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati and run reports - SET_CIRC_CLAIMS_RETURNED + SET_CIRC_CLAIMS _RETURNED Allows user to mark an item as claimed returned @@ -832,7 +832,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to change a copy statistical category - UPDATE_COPY_STAT_CAT_ENTRY + UPDATE_COPY_STAT _CAT_ENTRY Allows user to change a copy statistical category entry @@ -846,7 +846,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to edit a marc record - UPDATE_NON_CAT_TYPE + UPDATE_NON_CAT _TYPE Allows user to update a non cataloged type @@ -858,12 +858,12 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to change org unit settings - UPDATE_PATRON_STAT_CAT + UPDATE_PATRON_STAT _CAT Allows user to change a patron statistical category (such as renaming the category) - UPDATE_PATRON_STAT_CAT_ENTRY + UPDATE_PATRON_STAT _CAT_ENTRY Allows user to change a patron stat cat entry(such as renaming the entry) @@ -890,7 +890,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to view buckets and bookbags - VIEW_COPY_CHECKOUT_HISTORY + VIEW_COPY_CHECKOUT _HISTORY Allows user to view which users have checked out a given copy @@ -943,7 +943,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to view another user's Patron Record - VIEW_USER_FINES_SUMMARY + VIEW_USER_FINES _SUMMARY Allows user to view bill details @@ -968,16 +968,16 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati - actor.org_unit.closed_date.create + actor.org_unit.closed _date.create Allows user to create a new closed date for a location - actor.org_unit.closed_date.delete + actor.org_unit.closed _date.delete Allows user to remove a closed date interval for a given location - actor.org_unit.closed_date.update + actor.org_unit.closed _date.update Allows user to update a closed date interval for a given location @@ -986,32 +986,32 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to add/remove users to/from the User group - group_application.user.patron + group_application.user .patron Allows user to add/remove users to/from the Patron group - group_application.user.sip_client + group_application.user. sip_client Allows user to add/remove users to/from the SIP-Client group - group_application.user.staff + group_application.user. staff Allows user to add/remove users to/from the Staff group - group_application.user.staff.admin.global_admin + group_application.user.staff. admin.global_admin Allows user to add/remove users to/from the GlobalAdmin group - group_application.user.staff.admin.lib_manager + group_application.user.staff. admin.lib_manager Allows user to add/remove users to/from the LibraryManager group - group_application.user.staff.admin.local_admin + group_application.user.staff. admin.local_admin Allows user to add/remove users to/from the LocalAdmin group @@ -1020,30 +1020,30 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Allows user to add/remove users to/from the Cataloger group - group_application.user.staff.cat.cat1 + group_application.user. staff.cat.cat1 Allows user to add/remove users to/from the Cat1 group - group_application.user.staff.circ + group_application.user. staff.circ Allows user to add/remove users to/from the Circulator group - group_application.user.staff.supercat + group_application.user. staff.supercat Allows user to add/remove users to/from the Supercat group - group_application.user.vendor + group_application.user. vendor Allows user to add/remove users to/from the Vendor group - money.collections_tracker.create + money.collections_tracker. create Allows user to put someone into collections - money.collections_tracker.delete + money.collections_tracker. delete Allows user to take someone out of collections @@ -1114,7 +1114,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati - + @@ -1156,7 +1156,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati - CheckIn Missing/Lost/ClaimedReturned overrides + CheckIn Missing/Lost/ ClaimedReturned overrides * @@ -1175,7 +1175,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati - MaxRenewalReached override + MaxRenewal Reached override * * diff --git a/1.6/admin/sip.xml b/1.6/admin/sip.xml index 28872654f3..0d4f7f8a07 100644 --- a/1.6/admin/sip.xml +++ b/1.6/admin/sip.xml @@ -414,7 +414,10 @@ Escape character is '^]'. 10<resensitize><magnetic media><alert><xact date>[Fields AO,AB,AQ,AJ,CL,AA,CK,CH,CR,CS,CT,CV,CY,DA,AF,AG] Example (with a remote hold): 09N20100507 16593720100507 165937APCheckin Bin 5|AOBR1|AB1565921879|ACsip_01| - 101YNY20100623 165731AOBR1|AB1565921879|AQBR1|AJPerl 5 desktop reference|CK001|CSQA76.73.P33V76 1996|CTBR3|CY373827|DANicholas Richard Woodard|CV02| + +101YNY20100623 165731AOBR1|AB1565921879|AQBR1|AJPerl 5 desktop reference|CK001|CSQA76.73.P33V76 1996 +|CTBR3|CY373827|DANicholas Richard Woodard|CV02| + Here you can see a hold alert for patron CY 373827, named DA Nicholas Richard Woodard, to be picked up at CT BR3. Since the transaction is happening at AO BR1, the alert type CV is 02 for hold at remote library. @@ -519,7 +522,10 @@ Escape character is '^]'. 64YYYY 00020100623 141130000000000000000000000000AE|AAbad_barcode|BLN|AOBR1| Attempting to retrieve patron info with a good barcode (but bad patron password): 6300020060329 201700 AOBR1|AA999999|ADbadpwd| - 64 Y 00020100623 141130000000000000000000000000AA999999|AEDavid J. Fiander|BHUSD|BV0.00|BD2 Meadowvale Dr. St Thomas, ON Canada + +64 Y 00020100623 141130000000000000000000000000AA999999|AEDavid J. Fiander|BHUSD|BV0.00 +|BD2 Meadowvale Dr. St Thomas, ON Canada + 90210|BEdjfiander@somemail.com|BF(519) 555 1234|AQBR1|BLY|CQN|PB19640925|PCPatrons|PIUnfiltered|AFOK|AOBR1| See 23/24 Patron Status for info on BL and CQ fields. -- 2.43.2