X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fmapping_reports.xml;h=47f07e63879803a3c0304f3147f736d490867179;hp=55c12be29688dc18c23ac5eedb6bd3f4e694a500;hb=b25dcd79fad7b40f8facc6d63decad2fdad74b9b;hpb=43afa94e2a1e3f6a24a731b71ddf5b3e6d30ee0a
diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 55c12be..47f07e6 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -6,7 +6,7 @@
money arbitrary tags, each should go in separate tag
Migrated Billings title used in the asciidoc output
Number of Billings.Migrated.Total period delimited
- SELECT COUNT(id),x_migrate,SUM(amount) FROM money_billing_legacy GROUP BY 2; query itself, will be replaced
+ SELECT COUNT(id),x_migrate,SUM(amount) FROM m_money_billing_legacy GROUP BY 2; query itself, will be replaced
Arbitrary note that can be included in the entries.
-->
@@ -14,31 +14,31 @@
- evg_asset_copy_statuses
+ evg_m_asset_copy_statuses
Statuses
evergreen
0
Copy Count.Migrating Status.New Evergreen Status.Notes
- SELECT COUNT(ac.l_id), cs.l_name FROM asset_copy_legacy ac JOIN config_copy_status_legacy cs ON cs.l_id = ac.l_status GROUP BY 2 ORDER BY 2
+ SELECT COUNT(ac.l_id), cs.l_name FROM m_asset_copy_legacy ac JOIN config_copy_status_legacy cs ON cs.l_id = ac.l_status GROUP BY 2 ORDER BY 2
You only need to fill this sheet out if you use custom statuses that need to be migrated.
- evg_asset_circ_mods
+ evg_m_asset_circ_mods
Circulation Modifiers
evergreen
0
Copy Count.Migrating Circ Mod.New Circ Mod.Notes
- SELECT COUNT(ac.l_id), ac.l_circ_modifier FROM asset_copy_legacy ac GROUP BY 2 ORDER BY 2
+ SELECT COUNT(ac.l_id), ac.l_circ_modifier FROM m_asset_copy_legacy ac GROUP BY 2 ORDER BY 2
- evg_asset_copy_locs
+ evg_m_asset_copy_locs
Copy Locations
evergreen
0
Count.Library.Migrating Copy Location.New Copy Location.Notes
- SELECT COUNT(ac.l_id), aou.l_name, acl.l_name FROM asset_copy_location_legacy acl JOIN actor_org_unit_legacy aou ON aou.l_id = acl.l_owning_lib JOIN asset_copy_legacy ac ON ac.l_location = acl.l_id GROUP BY 2, 3 ORDER BY 2, 3
+ SELECT COUNT(ac.l_id), aou.l_name, acl.l_name FROM m_asset_copy_location_legacy acl JOIN m_actor_org_unit_legacy aou ON aou.l_id = acl.l_owning_lib JOIN m_asset_copy_legacy ac ON ac.l_location = acl.l_id GROUP BY 2, 3 ORDER BY 2, 3
Any locations not mapped can be moved over as their existing locations.
@@ -48,7 +48,7 @@
evergreen
0
Count.Migrating Permission Group.New Permission Group.Notes
- SELECT COUNT(au.l_id), pgt.l_name FROM actor_usr_legacy au JOIN permission_grp_tree_legacy pgt ON pgt.l_id = au.l_profile GROUP BY 2 ORDER BY 2
+ SELECT COUNT(au.l_id), pgt.l_name FROM m_actor_usr_legacy au JOIN permission_grp_tree_legacy pgt ON pgt.l_id = au.l_profile GROUP BY 2 ORDER BY 2
@@ -62,7 +62,7 @@
- tlc_load_asset_notes
+ tlc_load_m_asset_notes
Item Notes
tlc
0
@@ -77,7 +77,7 @@
- tlc_load_asset_holdings_codes
+ tlc_load_m_asset_holdings_codes
Holdings Codes
tlc
0
@@ -86,7 +86,7 @@
- tlc_load_money_migrating_bills
+ tlc_load_m_money_migrating_bills
Migrating Bills By Bill Type
tlc
0
@@ -308,7 +308,7 @@
- destiny_load_asset_categories
+ destiny_load_m_asset_categories
Count of Categories
destiny
0
@@ -317,7 +317,7 @@
- destiny_load_asset_notes
+ destiny_load_m_asset_notes
Copies by Note Types
destiny
0
@@ -327,7 +327,7 @@
- destiny_load_asset_sublocation
+ destiny_load_m_asset_sublocation
Copies by Sub Location
destiny
0
@@ -336,7 +336,7 @@
- destiny_load_asset_vendor
+ destiny_load_m_asset_vendor
Copies by Vendor
destiny
0
@@ -346,7 +346,7 @@
- destiny_load_asset_descriptions
+ destiny_load_m_asset_descriptions
Copies with Description Fields
destiny
0
@@ -373,7 +373,7 @@
apollo
0
Count.Status.Type
- SELECT COUNT(id), l_status, l_type FROM action_circulation_legacy GROUP BY 2, 3
+ SELECT COUNT(id), l_status, l_type FROM m_action_circulation_legacy GROUP BY 2, 3
Circulations will only not be migrated if they can't be attached to a migrated patron and holding.
@@ -383,37 +383,37 @@
apollo
0
Count.Status
- SELECT COUNT(id), l_status FROM action_hold_request_legacy GROUP BY 2
+ SELECT COUNT(id), l_status FROM m_action_hold_request_legacy GROUP BY 2
Only unfilled holds are being migrated.
- asset_pending_bibs
+ m_asset_pending_bibs
Pending Records
apollo
0
Count.Year of Last Edit.Count of Copies Attached
- SELECT COUNT(bre.id), CASE WHEN LENGTH(bre.l_edited) > 1 THEN EXTRACT(YEAR FROM bre.l_edited::TIMESTAMP) ELSE '1900' END, COUNT(ac.id) FROM biblio_record_entry_legacy bre LEFT JOIN asset_copy_legacy ac ON ac.l_biblio = bre.l_id WHERE bre.l_status = 'pending' GROUP BY 2 ORDER BY 2
+ SELECT COUNT(bre.id), CASE WHEN LENGTH(bre.l_edited) > 1 THEN EXTRACT(YEAR FROM bre.l_edited::TIMESTAMP) ELSE '1900' END, COUNT(ac.id) FROM m_biblio_record_entry_legacy bre LEFT JOIN m_asset_copy_legacy ac ON ac.l_biblio = bre.l_id WHERE bre.l_status = 'pending' GROUP BY 2 ORDER BY 2
- asset_copies_by_status
+ m_asset_copies_by_status
Copies by Status
apollo
0
Count.Status
- SELECT COUNT(id), l_status FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(id), l_status FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2
Deleted copies with a delete date were not exported additionally those with the deleted status won't get loaded.
- asset_pending_copies
+ m_asset_pending_copies
Pending Copies by Last Edit
apollo
0
Count.Last Edited
- SELECT COUNT(id), CASE WHEN LENGTH(l_edited) > 1 THEN EXTRACT(YEAR FROM l_edited::TIMESTAMP) ELSE '1900' END FROM asset_copy_legacy WHERE l_status = 'pending' GROUP BY 2 ORDER BY 2
+ SELECT COUNT(id), CASE WHEN LENGTH(l_edited) > 1 THEN EXTRACT(YEAR FROM l_edited::TIMESTAMP) ELSE '1900' END FROM m_asset_copy_legacy WHERE l_status = 'pending' GROUP BY 2 ORDER BY 2
@@ -422,56 +422,56 @@
apollo
0
Count.Membership Number.Membership Name
- SELECT COUNT(ac.id), acl.l_membership_number, acl.l_membership_name FROM asset_copy_legacy ac JOIN asset_copy_location_legacy acl ON acl.l_membership_name = ac.l_memberships GROUP BY 2,3 ORDER BY 2
+ SELECT COUNT(ac.id), acl.l_membership_number, acl.l_membership_name FROM m_asset_copy_legacy ac JOIN m_asset_copy_location_legacy acl ON acl.l_membership_name = ac.l_memberships GROUP BY 2,3 ORDER BY 2
- money_bills
+ m_money_bills
Bills
apollo
0
Count.Status
- SELECT COUNT(id), l_status FROM money_billing_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(id), l_status FROM m_money_billing_legacy GROUP BY 2 ORDER BY 2
Unless there is a good reason to do so forgiven and paid bills will not be migrated.
- actor_groups
+ m_actor_groups
Patron Membership Groups
apollo
0
Membership List Name.Membership List ID.Membership Number.Membership Name.Membership Length in Monthst
- SELECT l_membership_list_name, l_membership_list_id, l_membership_number, l_membership_name, l_membership_length_months FROM actor_usr_legacy_groups_tsv ORDER BY 1, 3
+ SELECT l_membership_list_name, l_membership_list_id, l_membership_number, l_membership_name, l_membership_length_months FROM m_actor_usr_legacy_groups_tsv ORDER BY 1, 3
Age looks like a good target for a stat cat and / or juvenile setting while the patron type can map to profiles.
- actor_by_groups
+ m_actor_by_groups
Patrons by Membership Groups
apollo
0
Count.Membership List Name.Membership Number
- SELECT COUNT(*), l_membership_list_name, l_membership_number FROM (SELECT id, UNNEST(STRING_TO_ARRAY(l_memberships,'|')) AS m FROM actor_usr_legacy ) x JOIN actor_usr_legacy_groups_tsv t ON t.l_membership_name = x.m GROUP BY 2, 3 ORDER BY 2, 3
+ SELECT COUNT(*), l_membership_list_name, l_membership_number FROM (SELECT id, UNNEST(STRING_TO_ARRAY(l_memberships,'|')) AS m FROM m_actor_usr_legacy ) x JOIN m_actor_usr_legacy_groups_tsv t ON t.l_membership_name = x.m GROUP BY 2, 3 ORDER BY 2, 3
- actor_addresses_nulls
+ m_actor_addresses_nulls
Patron Addresses
apollo
0
Address Field.Nulls
- SELECT 'Street Address', COUNT(id) FROM actor_usr_address_legacy WHERE l_lines IS NULL UNION ALL SELECT 'City', COUNT(id) FROM actor_usr_address_legacy UNION ALL SELECT 'State', COUNT(id) FROM actor_usr_address_legacy WHERE l_country_division IS NULL UNION ALL SELECT 'Postal Code', COUNT(id) FROM actor_usr_address_legacy WHERE l_postal_code IS NULL
+ SELECT 'Street Address', COUNT(id) FROM m_actor_usr_address_legacy WHERE l_lines IS NULL UNION ALL SELECT 'City', COUNT(id) FROM m_actor_usr_address_legacy UNION ALL SELECT 'State', COUNT(id) FROM m_actor_usr_address_legacy WHERE l_country_division IS NULL UNION ALL SELECT 'Postal Code', COUNT(id) FROM m_actor_usr_address_legacy WHERE l_postal_code IS NULL
If any of these fields are null then we need defaults to fill in, note the extract had no city data.
- actor_phones
+ m_actor_phones
Patron Phones
apollo
0
Count.Type
- SELECT COUNT(*), l_type FROM actor_usr_phones_tsv GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_type FROM m_actor_usr_phones_tsv GROUP BY 2 ORDER BY 2
These need to be mapped to Evergreen phone types.
@@ -484,7 +484,7 @@
horizon
0
Count.Borrower Type
- SELECT COUNT(id), l_borrower_btype FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_borrower_btype FROM m_actor_usr_legacy GROUP BY 2 ORDER BY 2;
@@ -502,7 +502,7 @@
horizon
0
Count of Migratable Passwords / PINs
- SELECT COUNT(l_borrower_pin) FROM actor_usr_legacy WHERE LENGTH(l_borrower_pin) > 1;
+ SELECT COUNT(l_borrower_pin) FROM m_actor_usr_legacy WHERE LENGTH(l_borrower_pin) > 1;
@@ -529,7 +529,7 @@
horizon
0
Sample of Migratable Notes
- SELECT l_borrower_borrower_note FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1 LIMIT 20;
+ SELECT l_borrower_borrower_note FROM m_actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1 LIMIT 20;
@@ -547,7 +547,7 @@
horizon
0
Count
- SELECT COUNT(l_borrower_borrower_note) FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1;
+ SELECT COUNT(l_borrower_borrower_note) FROM m_actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1;
@@ -565,7 +565,7 @@
horizon
0
Count
- SELECT l_borrower_note2 FROM actor_usr_legacy WHERE LENGTH(l_borrower_note2) > 1 LIMIT 20;
+ SELECT l_borrower_note2 FROM m_actor_usr_legacy WHERE LENGTH(l_borrower_note2) > 1 LIMIT 20;
@@ -574,7 +574,7 @@
horizon
0
Count
- SELECT l_borrower_note3 FROM actor_usr_legacy WHERE LENGTH(l_borrower_note3) > 1 LIMIT 20;
+ SELECT l_borrower_note3 FROM m_actor_usr_legacy WHERE LENGTH(l_borrower_note3) > 1 LIMIT 20;
@@ -585,10 +585,10 @@
Count.Borrower Phone Type
SELECT COUNT(*), b
- FROM (SELECT l_borrower_phone_1_phone_type AS b FROM actor_usr_legacy
- UNION ALL SELECT l_borrower_phone_2_phone_type AS b FROM actor_usr_legacy
- UNION ALL SELECT l_borrower_phone_3_phone_type AS b FROM actor_usr_legacy
- UNION ALL SELECT l_borrower_phone_4_phone_type AS b FROM actor_usr_legacy) x
+ FROM (SELECT l_borrower_phone_1_phone_type AS b FROM m_actor_usr_legacy
+ UNION ALL SELECT l_borrower_phone_2_phone_type AS b FROM m_actor_usr_legacy
+ UNION ALL SELECT l_borrower_phone_3_phone_type AS b FROM m_actor_usr_legacy
+ UNION ALL SELECT l_borrower_phone_4_phone_type AS b FROM m_actor_usr_legacy) x
GROUP BY 2 ORDER BY 2
@@ -615,11 +615,11 @@
0
Count.BStat
SELECT COUNT(*), b
- FROM (SELECT l_borrower_bstat_1_bstat AS b FROM actor_usr_legacy
+ FROM (SELECT l_borrower_bstat_1_bstat AS b FROM m_actor_usr_legacy
UNION ALL
- SELECT l_borrower_bstat_2_bstat AS b FROM actor_usr_legacy
+ SELECT l_borrower_bstat_2_bstat AS b FROM m_actor_usr_legacy
UNION ALL
- SELECT l_borrower_bstat_3_bstat AS b FROM actor_usr_legacy) x
+ SELECT l_borrower_bstat_3_bstat AS b FROM m_actor_usr_legacy) x
GROUP BY 2 ORDER BY 1;
@@ -640,7 +640,7 @@
horizon
0
Count.Collection
- SELECT COUNT(id), l_collection FROM asset_copy_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_collection FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2;
@@ -658,7 +658,7 @@
horizon
0
Count.Item Type (itype)
- SELECT COUNT(id), l_itype FROM asset_copy_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_itype FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2;
@@ -676,7 +676,7 @@
horizon
0
Count
- SELECT COUNT(l_internal_note) FROM asset_copy_legacy WHERE LENGTH(l_internal_note) > 1;
+ SELECT COUNT(l_internal_note) FROM m_asset_copy_legacy WHERE LENGTH(l_internal_note) > 1;
@@ -694,7 +694,7 @@
horizon
0
Count
- SELECT l_internal_note FROM asset_copy_legacy WHERE LENGTH(l_internal_note) > 1 LIMIT 20;
+ SELECT l_internal_note FROM m_asset_copy_legacy WHERE LENGTH(l_internal_note) > 1 LIMIT 20;
@@ -714,96 +714,96 @@
0
Circs by Status
Count of Circs.Status
- SELECT COUNT(id), l_is_checked_out FROM asset_copy_legacy GROUP BY 2
+ SELECT COUNT(id), l_is_checked_out FROM m_asset_copy_legacy GROUP BY 2
- rm_load_asset_by_resource_type
+ rm_load_m_asset_by_resource_type
Resource Type
rm
0
Count.Resource Type
- SELECT COUNT(*), l_resource_type FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_resource_type FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2
- rm_load_asset_by_location
+ rm_load_m_asset_by_location
Copies by Location
rm
0
Count.Location
- SELECT COUNT(*), l_location FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_location FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2
- rm_load_asset_by_category
+ rm_load_m_asset_by_category
Copies by Category
rm
0
Count.Category
- SELECT COUNT(*), l_category FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_category FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2
- rm_load_asset_by_status
+ rm_load_m_asset_by_status
Copies by Status
rm
0
Count.Status
- SELECT COUNT(*), l_status FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_status FROM m_asset_copy_legacy GROUP BY 2 ORDER BY 2
- rm_actor_groups
+ rm_m_actor_groups
Patrons by User Groups
rm
0
Count.Group
- SELECT COUNT(id), l_user_group FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_user_group FROM m_actor_usr_legacy GROUP BY 2 ORDER BY 2;
- rm_actor_access
+ rm_m_actor_access
Patrons by Access Field
rm
0
Count.Access
- SELECT COUNT(id), l_access_if_applicable FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_access_if_applicable FROM m_actor_usr_legacy GROUP BY 2 ORDER BY 2;
- rm_actor_comments
+ rm_m_actor_comments
Patron Comments
rm
0
Count.Sample
- SELECT COUNT(id), 'All Comments' FROM actor_usr_legacy WHERE LENGTH(l_comments) > 1
- UNION ALL SELECT NULL, l_comments FROM actor_usr_legacy WHERE LENGTH(l_comments) > 1 LIMIT 10
+ SELECT COUNT(id), 'All Comments' FROM m_actor_usr_legacy WHERE LENGTH(l_comments) > 1
+ UNION ALL SELECT NULL, l_comments FROM m_actor_usr_legacy WHERE LENGTH(l_comments) > 1 LIMIT 10
- rm_actor_circulation_note
+ rm_m_actor_circulation_note
Patron Circ Notes
rm
0
Count.Sample
- SELECT COUNT(id), 'All Notes' FROM actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1
- UNION ALL SELECT NULL, l_circulation_note FROM actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10
+ SELECT COUNT(id), 'All Notes' FROM m_actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1
+ UNION ALL SELECT NULL, l_circulation_note FROM m_actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10