X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=92c723684a30c12a08904ab6022f6492c44c44cb;hp=1d1e19adf67a7246fd36328a87de95213a80af02;hb=73d5fd17efb5b98b42e37325cbcfafe5de3190ca;hpb=1ffe967c6f41f0f5f4ca47c038ce0ff5328ffc6d
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 1d1e19a..92c7236 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -386,14 +386,14 @@
SELECT COUNT(ac.id), acl.name, aou.name, ac.x_migrate::TEXT FROM asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3, 4 ORDER BY 2, 3, 4
-
+
asset_barcode_patterns
@@ -660,13 +660,21 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- bibs
- Extracted Bibliographic Records
+ bibs_loaded
+ Loaded Bibliographic Records
bibs
0
- Count.Sourcee.Migrated
- SELECT COUNT(bre.id), bre.x_source, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3
- False means the records are not deleted.
+ Count
+ SELECT COUNT(bre.id) FROM biblio_record_entry_legacy bre WHERE id IN (SELECT id FROM biblio.record_entry) ORDER BY 1
+
+
+
+ bibs_loaded
+ Loaded Bibliographic Records
+ bibs
+ 1
+ Count
+ SELECT COUNT(bre.id) FROM biblio_record_entry bre WHERE id IN (SELECT id FROM biblio.record_entry) ORDER BY 1
@@ -676,6 +684,16 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
0
Count
SELECT COUNT(id) FROM biblio_record_entry where id NOT IN (SELECT DISTINCT record FROM asset_call_number)
+ These records would not have been loaded.
+
+
+
+ bibswuri
+ Bibliographic Records With 856$9s
+ bibs
+ 0
+ Count
+ SELECT COUNT(id) FROM biblio_record_entry where id IN (SELECT record FROM asset.call_number WHERE label ~* '##URI##')
@@ -737,19 +755,33 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
Bibliographic Merge Count
bibs
0
- Records Merged.Incumbent Records Merged INto
+ Records Merged.Incumbent Records Merged Into
SELECT SUM(array_length(records,1)), COUNT(*) FROM groups
- bib_merges_by_search_format
+ bib_merges_searchformat
Bibliographic Merges By Search Format
bibs
0
Count.Item Type
- WITH g AS (SELECT UNNEST(records) FROM groups) SELECT COUNT(record), search_format_str FROM dedupe_batch WHERE record IN (SELECT * FROM g) GROUP BY 2
+ DROP TABLE IF EXISTS temp_unnest; CREATE TABLE temp_unnest AS (SELECT UNNEST(records) FROM groups); SELECT COUNT(record), search_format_str FROM dedupe_batch WHERE record IN (SELECT * FROM temp_unnest) GROUP BY 2 ORDER BY 2
+
+ bibs_not_loaded
+ Bibliographic Records That Failed to Load
+ bibs
+ 0
+ Title.Author.Control Number
+ SELECT LEFT(ARRAY_TO_STRING(oils_xpath( '//*[@tag="245"]/*[@code="a"]/text()', a.marc),''),50) AS "Title",
+ LEFT(ARRAY_TO_STRING(oils_xpath( '//*[@tag="100"]/*[@code="a"]/text()', a.marc),''),50) AS "Author",
+ ARRAY_TO_STRING(oils_xpath( '//*[@tag="001"]/text()', a.marc),'') AS "001"
+ FROM biblio_record_entry a LEFT JOIN biblio.record_entry b ON b.id = a.id WHERE b.id IS NULL AND a.x_migrate
+
+
+
+
@@ -806,23 +838,23 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
SELECT COUNT(id), active::TEXT FROM actor_card GROUP BY 2
-
+
-
+
usr_barcode_patterns
@@ -841,10 +873,10 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
Count of Barcodes (greater than 10).Left 60% of Characters
SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
-
-
- usr_barcode_collisions
- Patron Barcode Collisions
+
+
+ usr_barcode_incoming_collisions
+ Incoming Patron Barcode Collisions
actors
0
Collision Count
@@ -852,21 +884,39 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
- usr_barcode_collisions
- Patron Barcode Collisions
+ usr_barcode_incoming_collisions
+ Incoming Patron Barcode Collisions
actors
1
Collision Count
SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode ~* 'collision'
+
+ usr_barcode_incumbent_collisions
+ Incumbent Patron Barcode Collisions
+ actors
+ 0
+ Collision Count
+ SELECT COUNT(acard.id) FROM actor_card_legacy acard WHERE barcode ~* '^x_' AND x_migrate = TRUE
+
+
+
+ usr_barcode_incumbent_collisions
+ Incumbent Patron Barcode Collisions
+ actors
+ 1
+ Collision Count
+ SELECT COUNT(acard.id) FROM actor_card acard WHERE barcode ~* '^x_'
+
+
usr_barcode_collision_shortlist
Patron Barcode Collisions (first 20)
actors
0
Collision List
- SELECT acard.barcode FROM actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card_legacy acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20
This is a shortlist of patron barcode collisions that maxes out at 20. If there are more collisions we will need to run a custom report. In some cases we may flag individual accounts to not migrate.
@@ -876,7 +926,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
1
Collision List
- SELECT acard.barcode FROM actor_card acard WHERE acard.barcode ~* 'collision' ORDER BY 1 LIMIT 20
+ SELECT acard.barcode FROM actor_card acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') ORDER BY 1 LIMIT 20
This is a shortlist of patron barcode collisions that maxes out at 20. If there are more collisions we will need to run a custom report. In some cases we may flag individual accounts to not migrate.
@@ -886,7 +936,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
0
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
+ SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card_legacy acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') AND acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
@@ -895,7 +945,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
actors
1
Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters
- SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard WHERE acard.barcode ~* 'collision' GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
+ SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor_card acard WHERE (acard.barcode ~* 'collision' OR acard.barcode ~* '^x_') GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2
@@ -1017,6 +1067,17 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
ORDER BY 2, 1, 3
+
+ usr_settings
+ Patron Settings
+ actors
+ 0
+ Count.Setting.Value
+ SELECT COUNT(*), name, 'User''s Phone' FROM actor_usr_setting WHERE name IN ('opac.default_phone') GROUP BY 2, 3
+ UNION ALL SELECT COUNT(*), name, value FROM actor_usr_setting WHERE name IN ('opac.hold_notify') GROUP BY 2, 3
+ UNION ALL SELECT COUNT(*), a.name, aou.shortname FROM actor_usr_setting a JOIN actor.org_unit aou ON aou.id = REPLACE(a.value,'"','')::INTEGER
+ WHERE a.name IN ('opac.default_pickup_location','opac.default_search_location') GROUP BY 2, 3 ORDER BY 2, 3;
+
@@ -1127,9 +1188,9 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
notices_overview
notices
0
- Overview of Notices for Migration
- ID.Active.Owner.Name.Delay.Validator.Reactor
- SELECT ed.id, ed.active, aou.shortname, LEFT(ed.name,25) || '...', ed.delay, ed.validator, ed.reactor
+ Action Triggers Setup for Notices
+ ID.Active.Owner.Name
+ SELECT ed.id, ed.active, aou.shortname, ed.name
FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
WHERE ed.owner IN (SELECT DISTINCT home_ou FROM actor_usr)
@@ -1143,7 +1204,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
0
Count of Notices Run with State
Count of Notices.State.ID.Owner.Name
- SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, LEFT(ed.name,25) || '...'
+ SELECT COUNT(ate.id), ate.state, ed.id, aou.shortname, ed.name
FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
JOIN action_trigger.event ate ON ate.event_def = ed.id