From e154c690d543a089085596d93636c9719baf4a80 Mon Sep 17 00:00:00 2001 From: rsoulliere Date: Thu, 3 Mar 2011 15:08:44 -0500 Subject: [PATCH 1/1] fix a few typos. --- 1.6/admin/migratingdata_1.6.xml | 8 +++++--- 2.0/admin/migratingdata_2.0.xml | 8 +++++--- 2 files changed, 10 insertions(+), 6 deletions(-) diff --git a/1.6/admin/migratingdata_1.6.xml b/1.6/admin/migratingdata_1.6.xml index da9d890320..69bd16b116 100644 --- a/1.6/admin/migratingdata_1.6.xml +++ b/1.6/admin/migratingdata_1.6.xml @@ -333,11 +333,13 @@ BEGIN; TRUNCATE TABLE staging_items; INSERT INTO staging_items (egid, hseq, l_callnum, l_barcode, -l_location, l_owning_lib, l_circ_modifier FROM stdin; +l_location, l_owning_lib, l_circ_modifier) FROM stdin; 40 0 HD3616.K853 U54 1997 30731100751928 STACKS FENNELL BOOK 41 1 HV6548.C3 S984 1998 30731100826613 STACKS FENNELL BOOK 41 2 HV6548.C3 S984 1998 30731100804958 STACKS BRANTFORD BOOK -COMMIT; +\. + +COMMIT; This file can be used for importing holdings into Evergreen. the egid is a critical column. It is used to link the volume and copy to the bibliographic record. Please refer to for the steps to import your holdings into Evergreen. @@ -436,7 +438,7 @@ SELECT DISTINCT ou.id AS circ_lib, JOIN asset.copy_location cl ON (ou.id = cl.owning_lib AND l.l_location = cl.name) JOIN metabib.real_full_rec m - ON (m.value = l.egid) + ON (m.record = l.egid) JOIN asset.call_number cn ON (ou.id = cn.owning_lib AND m.record = cn.record diff --git a/2.0/admin/migratingdata_2.0.xml b/2.0/admin/migratingdata_2.0.xml index fff4b6fb03..dac76888e3 100644 --- a/2.0/admin/migratingdata_2.0.xml +++ b/2.0/admin/migratingdata_2.0.xml @@ -328,11 +328,13 @@ BEGIN; TRUNCATE TABLE staging_items; INSERT INTO staging_items (egid, hseq, l_callnum, l_barcode, l_location, -l_owning_lib, l_circ_modifier FROM stdin; +l_owning_lib, l_circ_modifier) FROM stdin; 40 0 HD3616.K853 U54 1997 30731100751928 STACKS FENNELL BOOK 41 1 HV6548.C3 S984 1998 30731100826613 STACKS FENNELL BOOK 41 2 HV6548.C3 S984 1998 30731100804958 STACKS BRANTFORD BOOK -COMMIT; +\. + +COMMIT; This file can be used for importing holdings into Evergreen. the egid is a critical column. It is used to link the volume and copy to the bibliographic record. Please refer to for the steps to import your holdings into Evergreen. @@ -431,7 +433,7 @@ SELECT DISTINCT ou.id AS circ_lib, JOIN asset.copy_location cl ON (ou.id = cl.owning_lib AND l.l_location = cl.name) JOIN metabib.real_full_rec m - ON (m.value = l.egid) + ON (m.record = l.egid) JOIN asset.call_number cn ON (ou.id = cn.owning_lib AND m.record = cn.record -- 2.43.2