X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=92c723684a30c12a08904ab6022f6492c44c44cb;hp=ecdc30a6856d468ec76a66331d54ee23d4bee6c4;hb=73d5fd17efb5b98b42e37325cbcfafe5de3190ca;hpb=ae0cbef8cb836900fc8b70b8a4c58cb97021c0be
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index ecdc30a..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
@@ -838,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
@@ -873,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
@@ -884,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.
@@ -908,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.
@@ -918,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
@@ -927,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
@@ -1049,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;
+