From f3a0e02a67ec8eb49bb6098847692716c51b6539 Mon Sep 17 00:00:00 2001
From: Robert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Date: Wed, 16 Feb 2011 15:00:48 -0500
Subject: [PATCH 1/1] A few more fixes from Bug 720068 reported by Demian Katz.

---
 1.6/admin/migratingdata_1.6.xml | 8 ++++----
 2.0/admin/migratingdata_2.0.xml | 8 ++++----
 2 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/1.6/admin/migratingdata_1.6.xml b/1.6/admin/migratingdata_1.6.xml
index cb665ae48b..da9d890320 100644
--- a/1.6/admin/migratingdata_1.6.xml
+++ b/1.6/admin/migratingdata_1.6.xml
@@ -319,7 +319,7 @@ circ_modifier 999 t
 <programlisting language="sql">
 BEGIN;
 
-egid, hseq, l_call_num, l_barcode, l_location, l_owning_lib, l_circ_modifier,
+egid, hseq, l_callnum, l_barcode, l_location, l_owning_lib, l_circ_modifier,
 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
@@ -357,13 +357,13 @@ l_location, l_owning_lib, l_circ_modifier <emphasis>FROM stdin;</emphasis>
 <programlisting language="sql">
 CREATE TABLE staging_items (
         l_callnum text, -- call number label
-	hseq int, -- call number label
+	hseq int, 
         egid  int,  -- biblio.record_entry_id
         createdate      date,
         l_location        text,
         l_barcode         text,
         l_circ_modifier       text,
-        l_owning_lib      text  -- actor.org_unit.shortname
+        l_owning_lib      text -- actor.org_unit.shortname 
 );
 </programlisting>
 			</step>	
@@ -432,7 +432,7 @@ SELECT  DISTINCT ou.id AS circ_lib,
 	cn.id AS call_number
 	FROM  staging_items l
 		JOIN actor.org_unit ou
-			ON (l.owning_lib = ou.shortname)
+			ON (l.l_owning_lib = ou.shortname)
 		JOIN asset.copy_location cl
 			ON (ou.id = cl.owning_lib AND l.l_location = cl.name)
 		JOIN metabib.real_full_rec m 
diff --git a/2.0/admin/migratingdata_2.0.xml b/2.0/admin/migratingdata_2.0.xml
index 8cd94c3e63..fff4b6fb03 100644
--- a/2.0/admin/migratingdata_2.0.xml
+++ b/2.0/admin/migratingdata_2.0.xml
@@ -303,7 +303,7 @@ extract_holdings --marcfile=clean.marc.xml --holding 999 --copyid 999i --map hol
 				<para>The <option>map</option> option <filename>holdings.map</filename> refers to a file to be used for mapping subfields to the holdings data you would like extracted. Here is an example based on mapping holdings data to the 999 data field:</para>
 <programlisting>
 <![CDATA[
-call_num 999 a
+callnum 999 a
 barcode 999 i
 location 999 l
 owning_lib 999 m
@@ -314,7 +314,7 @@ circ_modifier 999 t
 <programlisting language="sql">
 BEGIN;
 
-egid, hseq, l_call_num, l_barcode, l_location, l_owning_lib, l_circ_modifier,
+egid, hseq, l_callnum, l_barcode, l_location, l_owning_lib, l_circ_modifier,
 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
@@ -352,7 +352,7 @@ l_owning_lib, l_circ_modifier <emphasis>FROM stdin;</emphasis>
 <programlisting language="sql">
 CREATE TABLE staging_items (
         l_callnum text, -- call number label
-	hseq int, -- call number label
+	hseq int, 
         egid  int,  -- biblio.record_entry_id
         createdate      date,
         l_location        text,
@@ -427,7 +427,7 @@ SELECT  DISTINCT ou.id AS circ_lib,
 	cn.id AS call_number
 	FROM  staging_items l
 		JOIN actor.org_unit ou
-			ON (l.owning_lib = ou.shortname)
+			ON (l.l_owning_lib = ou.shortname)
 		JOIN asset.copy_location cl
 			ON (ou.id = cl.owning_lib AND l.l_location = cl.name)
 		JOIN metabib.real_full_rec m 
-- 
2.43.2