removing unneeded file
authorRogan Hamby <rhamby@esilibrary.com>
Tue, 20 Mar 2018 19:30:16 +0000 (15:30 -0400)
committerRogan Hamby <rhamby@esilibrary.com>
Tue, 20 Mar 2018 19:30:16 +0000 (15:30 -0400)
mig-xml/resource_mate.xml [deleted file]

diff --git a/mig-xml/resource_mate.xml b/mig-xml/resource_mate.xml
deleted file mode 100644 (file)
index e58e572..0000000
+++ /dev/null
@@ -1,211 +0,0 @@
-<reports_file>
-<!-- sample reports entry
-    <report>
-        <name>name of report</name>
-        <iteration value='0' /> which version, the first version to run is 0, first backup is 1, then so on
-        <tag>money</tag>  arbitrary tags, each should go in separate tag
-        <report_title>Migrated Billings</report_title>  title used in the asciidoc output
-        <heading column='1'>Number of Billings.Migrated.Total</heading> period delimited 
-        <query>SELECT COUNT(id),x_migrate,SUM(amount) FROM money_billing_legacy GROUP BY 2;</query>  query itself, will be replaced
-        <note>Arbitrary note that can be included in the entries.</note>
-    </report>
--->
-    <!-- branches -->
-    <!-- circs -->
-
-    <report>
-        <name>rm_load_circ_count</name>
-        <tag>circs</tag>
-        <iteration>0</iteration>
-        <report_title>Circulations in Extract</report_title>
-        <heading>Count of Circs.Status</heading>
-        <query>SELECT COUNT(id), l_is_checked_out FROM asset_copy_legacy GROUP BY 2</query>
-    </report>
-
-
-    <!-- holds -->
-    <!-- assets -->
-
-   <report>
-        <name>rm_load_asset_by_resource_type</name>
-        <report_title>Count of Copies in Extract by Resource Type</report_title>
-        <tag>assets</tag>
-        <iteration>0</iteration>
-        <heading>Count.Resource Type</heading>
-        <query>SELECT COUNT(*), l_resource_type FROM asset_copy_legacy GROUP BY 2 ORDER BY 2</query>
-    </report>
-     
-   <report>
-        <name>rm_load_asset_by_location</name>
-        <report_title>Count of Copies in Extract by Location</report_title>
-        <tag>assets</tag>
-        <iteration>0</iteration>
-        <heading>Count.Location</heading>
-        <query>SELECT COUNT(*), l_location FROM asset_copy_legacy GROUP BY 2 ORDER BY 2</query>
-    </report>
-    
-    <report>
-        <name>rm_load_asset_by_category</name>
-        <report_title>Count of Copies in Extract by Category</report_title>
-        <tag>assets</tag>
-        <iteration>0</iteration>
-        <heading>Count.Category</heading>
-        <query>SELECT COUNT(*), l_category FROM asset_copy_legacy GROUP BY 2 ORDER BY 2</query>
-    </report>
-    
-    <report>
-        <name>rm_load_asset_by_status</name>
-        <report_title>Count of Copies in Extract by Status</report_title>
-        <tag>assets</tag>
-        <iteration>0</iteration>
-        <heading>Count.Status</heading>
-        <query>SELECT COUNT(*), l_status FROM asset_copy_legacy GROUP BY 2 ORDER BY 2</query>
-    </report>
-
-    
-    <!-- money -->
-
-
-   <report>
-        <name>rm_accounts_with_fines</name>
-        <report_title>Count of Accounts with a Grocery Bill to Migrate</report_title>
-        <tag>money</tag>
-        <iteration>0</iteration>
-        <heading>Count</heading>
-        <query>SELECT COUNT(*) FROM fines</query>
-    </report>
-
-   <report>
-        <name>rm_fine_w_no_account</name>
-        <report_title>Fines with No Matching Account</report_title>
-        <tag>money</tag>
-        <iteration>0</iteration>
-        <heading>First Name.Last Name.Fine Amount</heading>
-        <query>SELECT first_given_name, family_name, amount FROM fines WHERE au_id IS NULL ORDER BY 2, 1</query>
-    </report>
-             
-      <report>
-        <name>rm_fine_w_multi_matching</name>
-        <report_title>Fines with Multiple Matching Accounts</report_title>
-        <tag>money</tag>
-        <iteration>0</iteration>
-        <heading>First Name.Last Name.Fine Amount</heading>
-        <query>SELECT first_given_name, family_name, amount FROM fines WHERE multi_au IS TRUE ORDER BY 2, 1</query>
-    </report>
-     
-
-
-    <!-- bibs -->
-
-    <report>
-        <name>rm_load_bibs_loaded</name>
-        <report_title>Bibs Successfully Staged</report_title>
-        <tag>bibs</tag>
-        <iteration>0</iteration>
-        <heading>Count</heading>
-        <query>SELECT COUNT(eg) FROM bib_id_map</query>
-    </report>
-
-    <!-- actors -->
-
-    <report>
-        <name>rm_actor_address_summary</name>
-        <report_title>Patrons Address Components</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Address Component</heading>
-        <query>SELECT COUNT(id), 'Address 1' FROM actor_usr_legacy WHERE LENGTH(l_address_1) > 1
-            UNION ALL SELECT COUNT(id), 'Address 2' FROM actor_usr_legacy WHERE LENGTH(l_address_2) > 1
-            UNION ALL SELECT COUNT(id), 'City' FROM actor_usr_legacy WHERE LENGTH(l_city) > 1
-            UNION ALL SELECT COUNT(id), 'State' FROM actor_usr_legacy WHERE LENGTH(l_state) > 1
-            UNION ALL SELECT COUNT(id), 'County' FROM actor_usr_legacy WHERE LENGTH(l_country) > 1
-            UNION ALL SELECT COUNT(id), 'Zip Code' FROM actor_usr_legacy WHERE LENGTH(l_zip_code) > 1                    
-        </query>
-    </report>
-    
-    <report>
-        <name>rm_actor_expirations</name>
-        <report_title>Patrons by Year of Expiration</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Expiration Year</heading>
-        <query>SELECT COUNT(id), RIGHT(BTRIM(l_membership_expiry),4) FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;       
-        </query>
-    </report>
-    
-    <report>
-        <name>rm_actor_barcodes</name>
-        <report_title>Patrons by Barcode Length</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Barcode Length</heading>
-        <query>SELECT COUNT(id), LENGTH(l_barcode) FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;       
-        </query>
-    </report>
-  
-    <report>
-        <name>rm_actor_birthdates</name>
-        <report_title>Patrons with Birthdates</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count</heading>
-        <query>SELECT COUNT(id) FROM actor_usr_legacy WHERE LENGTH(l_birthdate) > 1;       
-        </query>
-    </report>
-
-    <report>
-        <name>rm_actor_groups</name>
-        <report_title>Patrons by User Groups</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Group</heading>
-        <query>SELECT COUNT(id), l_user_group FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;       
-        </query>
-    </report>
-
-    <report>
-        <name>rm_actor_access</name>
-        <report_title>Patrons by Access Field</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Access</heading>
-        <query>SELECT COUNT(id), l_access_if_applicable FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;       
-        </query>
-    </report>
-
-    <report>
-        <name>rm_actor_contact_summary</name>
-        <report_title>Patrons Contact Fields</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Address Component</heading>
-        <query>SELECT COUNT(id), 'email' FROM actor_usr_legacy WHERE LENGTH(l_e_mail) > 1
-            UNION ALL SELECT COUNT(id), 'Phone (home)' FROM actor_usr_legacy WHERE LENGTH(l_phone_home) > 1
-            UNION ALL SELECT COUNT(id), 'Phone (work)' FROM actor_usr_legacy WHERE LENGTH(l_phone_work) > 1
-            UNION ALL SELECT COUNT(id), 'Phone (cell)' FROM actor_usr_legacy WHERE LENGTH(l_phone_cell) > 1
-        </query>
-    </report> 
-  
-    <report>
-        <name>rm_actor_comments</name>
-        <report_title>Patrons Comments Count and Sample</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Sample</heading>
-        <query>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
-        </query>
-    </report> 
-    
-    <report>
-        <name>rm_actor_circulation_note</name>
-        <report_title>Patrons Circulation Notes Count and Sample</report_title>
-        <tag>actors</tag>
-        <iteration>0</iteration>
-        <heading>Count.Sample</heading>
-        <query>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
-        </query>
-    </report>       
-</reports_file>
-