X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fexcel_mapping_reports.xml;fp=mig-xml%2Fexcel_mapping_reports.xml;h=4a84698afa534a3d98cea71da87f96704b9eb79a;hp=397f2143424201c9fb57705d33e98373ee07cde8;hb=487593103da4b1d75da917e7e8bdabaffd3ce2da;hpb=69d5f4ce477e7613b29e5a3e643ecc207f109147
diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 397f214..4a84698 100644
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -74,16 +74,6 @@
- tlc_load_asset_in_house_use
- Copies With In House Uses
- tlc
- 0
- Copy Count.Sum of In House Uses.Do Not Migrate
- SELECT COUNT(l_totalinhouseuses), SUM(l_totalinhouseuses::INTEGER) FROM ititeminformation_tsv_clean WHERE l_totalinhouseuses != '0'
- TLC doesn't have dates recorded for in house use so these can only be migrated as date of migration or we can not migrate them.
-
-
-
tlc_load_asset_holdings_codes
Holdings Codes
tlc
@@ -113,15 +103,6 @@
-->
- tlc_load_asset_barcodes_with_spaces
- Count of Barcodes with Spaces
- tlc
- 0
- Count of Barcodes With Spaces.Transformation
- SELECT COUNT(l_itembarcode) FROM ititeminformation_tsv_clean WHERE l_itembarcode ~* ' '
-
-
-
tlc_load_money_migrating_bills
Migrating Bills By Bill Type
tlc
@@ -187,15 +168,6 @@
- tlc_load_usrs_alternate_ids
- Count of Patrons w Alt Id
- tlc
- 0
- Count.Migration Need
- SELECT COUNT(l_agencynumber) FROM itagency_tsv_clean WHERE l_alternateid IS NOT NULL
-
-
-
tlc_load_active_usr_passwords
Count of Patrons w Passwords
tlc
@@ -205,24 +177,6 @@
If any PINS are blank we will have to choose a method to supply them as Evergreen requires passwords.
-
- tlc_load_usr_barcodes_wspacess
- Barcodes with Spaces
- tlc
- 0
- Count
- SELECT COUNT(l_agencynumber) FROM itagency_tsv_clean WHERE l_barcode ~* ' '
-
-
-
- tlc_load_usr_barcode_lengths
- Barcode Lengths by Library
- tlc
- 0
- Count of Barcode.Barcode Length.Branch.Transformation Note
- SELECT COUNT(l_agencynumber), LENGTH(l_barcode), l_issuingbranch FROM itagency_tsv_clean GROUP BY 2, 3 ORDER BY 3, 2
-
-
tlc_load_usr_notes
Count of Patron Notes
@@ -233,15 +187,6 @@
- tlc_load_misc
- Miscellaneous Options
- tlc
- 0
- Count.Option.Value.Note
- SELECT COUNT(l_agencynumber), 'Create Evergreen Grouped/Family Accounts?' FROM itagency_tsv_clean WHERE l_responsibleagencynumber IS NOT NULL GROUP BY 2 UNION ALL SELECT COUNT(l_itembarcode), 'Lost Items' FROM ititemlocation_tsv_clean WHERE l_outdate IS NOT NULL AND l_status = 'L' GROUP BY 2
-
-
-
tlc_load_usr_balance
Count and Sum of Balances
tlc