[Ils-source] r1362 - trunk/sql

scribe at crosswire.org scribe at crosswire.org
Thu Dec 17 10:57:31 MST 2015 

Author: scribe
Date: 2015-12-17 10:57:31 -0700 (Thu, 17 Dec 2015)
New Revision: 1362

Added:
   trunk/sql/users.csv
   trunk/sql/workgroups.csv
Modified:
   trunk/sql/importroles.properties
   trunk/sql/importworkgroups.properties
   trunk/sql/roles.csv
Log:
update workgroup and role import scripts to unquote companyID
Added sample users.csv and workgroups.csv


Modified: trunk/sql/importroles.properties
===================================================================
--- trunk/sql/importroles.properties	2015-12-17 17:31:27 UTC (rev 1361)
+++ trunk/sql/importroles.properties	2015-12-17 17:57:31 UTC (rev 1362)
@@ -4,6 +4,6 @@
 Requires=CompanyID
 
 Heading=Create Site Roles
-ImportDupCheck=SELECT * FROM ILSGROUP WHERE COMPANYID='{CompanyID}' AND GROUPNAME='{0}' AND GROUPTYPEID=1
-ImportFile=roles.csv|INSERT INTO ILSGROUP (COMPANYID, GROUPNAME, GROUPDESC, GROUPTYPEID) VALUES ('{CompanyID}', '{0}', '{1}', 1)
+ImportDupCheck=SELECT * FROM ILSGROUP WHERE COMPANYID={CompanyID} AND GROUPNAME='{0}' AND GROUPTYPEID=1
+ImportFile=roles.csv|INSERT INTO ILSGROUP (COMPANYID, GROUPNAME, GROUPDESC, GROUPTYPEID) VALUES ({CompanyID}, '{0}', '{1}', 1)
 SQL=NA

Modified: trunk/sql/importworkgroups.properties
===================================================================
--- trunk/sql/importworkgroups.properties	2015-12-17 17:31:27 UTC (rev 1361)
+++ trunk/sql/importworkgroups.properties	2015-12-17 17:57:31 UTC (rev 1362)
@@ -4,6 +4,6 @@
 Requires=CompanyID
 
 Heading=Create Site Workgroups
-ImportDupCheck=SELECT * FROM ILSGROUP WHERE COMPANYID='{CompanyID}' AND GROUPNAME='{0}' AND GROUPTYPEID=2
-ImportFile=workgroups.csv|INSERT INTO ILSGROUP (COMPANYID, GROUPNAME, GROUPDESC, GROUPTYPEID) VALUES ('{CompanyID}', '{0}', '{1}', 2)
+ImportDupCheck=SELECT * FROM ILSGROUP WHERE COMPANYID={CompanyID} AND GROUPNAME='{0}' AND GROUPTYPEID=2
+ImportFile=workgroups.csv|INSERT INTO ILSGROUP (COMPANYID, GROUPNAME, GROUPDESC, GROUPTYPEID) VALUES ({CompanyID}, '{0}', '{1}', 2)
 SQL=NA

Modified: trunk/sql/roles.csv
===================================================================
--- trunk/sql/roles.csv	2015-12-17 17:31:27 UTC (rev 1361)
+++ trunk/sql/roles.csv	2015-12-17 17:57:31 UTC (rev 1362)
@@ -1,542 +1,6 @@
-24/7 Press Oper
-Acc Admtr I
-Acc Admtr II
-Acc Bus Process Analyst
-Acc Corres
-Acc Corres I
-Acc Corres II
-Acc Corres III
-Acc Exec
-Acc Mgr
-Acc Mgr FMS+
-Acc Mgr I
-Acc Mgr II
-Acc Mgr III
-Acc Mgr IV
-Acc Rep
-Acc Spec
-Acctg Assoc
-Acctg Clrk
-Acctg Clrk I
-Acctg Clrk II
-Acctg Clrk Iii
-Acctg Clrk Iv
-Acctg Coord
-Acctg Mgr
-Acctg Supv
-Acquisition Title
-Admin Aide I
-Admin Aide II
-Admin Aide III
-Admin Aide IV
-Admin Asst
-Appl Devmt Mgr/Bill Solns
-A/R Control Clrk
-Art Dir
-Assoc Bus Analyst
-Assoc Developer
-Asst Controller
-Asst Credit Corres
-Baler Oper
-Bill Clrk
-Bill Clrk Team Leader
-Bill Cntrl Analyst
-Billing Rep
-Bill Mgr
-Bindery Helper
-Bindery Oper
-Bindery Oper/Lp
-Bindery Supp
-BSC Mgr
-BSC Opern Mgr
-BSC Opertn Mgr
-Bus Analyst
-Bus Devmt Dir
-Bus Devmt Spec
-Bus Sys Analyst
-Bus Sys Analyst-Senior
-Buyer I
-Buyer II
-Cage
-Camera/Strip
-Camera/Strip/Plate/Lp
-Catcher
-Cmptr Oper
-Cmptr Oper-Senior
-Collator Catcher
-Collator Oper
-Collator Oper/Lp
-Commcl Flat Press Oper
-Commcl Graphics Consult
-Commcl Graphics Coord
-Commissions Spec
-Composition Spec
-Compstn/Form Designer
-Compstn/Form Designer Lp
-Contract Admtn/TL
-Contract Analyst/Buyer
-Controller
-Cost Acct
-Creative Dir
-Credit Analyst
-Credit Corres
-Credit Corres I
-Credit Corres Ii
-Credit Supv
-Csr Supv
-Cust Acct Rep
-Cust Doc
-Custom Order Entry
-Custom Press Oper
-Cust Sat Interviewer
-Cust Serv Clrk I
-Cust Serv Clrk Iii
-Cust Serv Coord
-Cust Serv/Lp
-Cust Serv Rep
-Cust Serv Rep I
-Cust Serv Rep/Lp
-Cust Serv Spec
-Cust Serv Supp
-Cutter
-Data Analyst
-Data Analyst Sr II
-Database Admtr-Associate
-Database Admtr-Senior
-Data Entry Clrk
-Day Attendant
-DC Coord
-Dealer Consult
-De Oper
-De Oper Iii
-Desktop Prtg Analyst
-Developer
-Developer-Associate
-Developer-Senior
-Digital Print Oper Ii
-Dir, Billing Solutions
-Dir Bill & Transaction Svcs
-Dir Brand Mgmt & Comm
-Dir Bsd Cost Acctg
-Dir Client Fincl Serv Sr
-Dir Client Servs
-Dir Credit/Coll
-Dir Fincl Acctg & Plng
-Dir Fincl Plng/Analysis
-Dir/Gm Small Bus Solutions
-Dir Hr
-Dir Infrastructure
-Dir Integrated Srvs
-Dir Internal Audit
-Dir IT
-Dir Mktg
-Dir Opertn
-Dir Opertn Fincl Serv
-Dir Plng Bus Devmt
-Dir Pricing Admin
-Dir Proposal to Cash Distrib
-Dir Reengr & Distrib Sys
-Dir, Reg Distrib Svcs
-Dir Sales
-Dir Sales Bill Solutions
-Dir Sales Opertn
-Dir Stock Tab
-Dir Strat Devmt
-Dir Supply Chain
-Dir Supply Chain Mgt
-Divisional Sales Mgr
-Dms Coord
-Dms Inven Coord
-Doct Proc Tech I
-Doct Project Spec
-Doct Solutions Tech Ii
-Doct Spec
-Doct System Analyst
-Doct System Analyst Clrk Ii
-Docutech Oper
-Docutech Oper I
-Docutech Oper Ii
-Docutech Oper/Lp
-Encoder
-Encoder/Lp
-Engineering Dir
-Enterprise Acc Rep
-Envelope Adj
-Envelope Catcher
-ERP Sales Dir
-Est/Cust Serv
-Estimator
-Facilities Services Coord
-Factory Tool Mgmt
-Fax Oper
-Field Supp Spec
-File Clrk
-Fincl Analyst
-Fincl Analyst II
-Fincl Assoc Sr
-Fincl Spec
-Fincl Team Lead
-Flat Litho Press Oper
-Flat Press Oper
-Flat Sheet Press Oper
-Flexo Press Oper
-Flexo Press Oper/Lp
-Fms Team Leader
-Form Finishing
-Forms Collator Oper
-Forms Designer
-Fulfillment Coord
-Fulfillment Supv
-Gen Clrk Ii
-General Counsel
-GM, Billing Solutions
-GM, Natl Acct Healthcare
-Graphic Artist
-Graphic Art Tech
-Graphic Designer
-Graphic Supp Analyst
-Graphic Technology Spec
-Graphic Thru Put
-Hand Sort/Gl
-Help Desk Support
-HR/Benefits Admntr
-HR Benefits Coord
-HR Coord
-HRIS/HR Admtr
-HR Mgr
-HR Rep
-HR Sourcing Spec
-HTML Dev
-Hunkeler Oper
-Implement Acct Mgr II
-Implement Project Mgr
-Imprint Oper
-Imprint/Vertical Oper
-Imprint/Vertical Oper/Lp
-Inserter Oper
-Inside Acc Rep
-Inter Ops Coord
-Intranet Coord
-Inven Analyst
-Inven Control Coord
-Inven Control Spec
-Inven Coord Ii
-Inven Planner
-Inventory Control Coordinator
-It Audit Mgr
-IT Prod Mgr, Assoc
-Janitor/Baler
-Janitor/Baler/Lp
-Jet Press Oper
-Kitting Appl Spec
-Kitting Assoc
-Kitting Assoc/LP
-Label Press
-Label Press II
-Label Press II/LP
-Label Press Oper
-Label Spec
-Large Flat Press Oper
-Laser Oper
-Letter Press Oper
-Logistics Buyer
-Logistics Mgr
-Mac Oper
-Mac Oper/Lp
-Mailer Collator Oper
-Mailer Collator Oper/Lp
-Maint
-Maint I
-Maint I/LP
-Maint/Lp
-Maint Mechanic
-Maint Mechanic/Lp
-Maint Supv
-Maint Tech
-Material Handler
-Material Handler/Lp
-Material Spec
-Messenger
-Mfg Eng
-Mgr Acct Profitability
-Mgr A/P-OSB
-Mgr Appl Devmt
-Mgr Bus Analysis/Fincl Sys
-Mgr Bus Integration Team
-Mgr Celina Pre Press Sys
-Mgr Central Pricing
-Mgr Compensation & Benefits
-Mgr Computing Servs
-Mgr Cost Acctg
-Mgr Credit Coll Bill
-Mgr CSC
-Mgr, Cust Appl
-Mgr Cust Opertn
-Mgr Cust Serv
-Mgr Dist Ctr
-Mgr Doc Sys Analysis
-Mgr Doct Mgmt Supp
-Mgr EHS/Facilities
-Mgr Engr
-Mgr Finance/Admin
-Mgr Fincl Analysis
-Mgr Fincl Reptg
-Mgr Fincl Sys
-Mgr Gen Acctg
-Mgr Graphic Supp
-Mgr Graphic Svcs
-Mgr Graphic Tech Svcs
-Mgr Inven Control
-Mgr Large Acc
-Mgr Mfg/Qual Process
-Mgr Mktg Admin
-Mgr Mktng
-Mgr Office Opertn
-Mgr Operational Serv
-Mgr Pre Press
-Mgr, Proposal Response
-Mgr Quality Admtn
-Mgr Sales & Cust Serv
-Mgr Serv Devmt
-Mgr Strategic Accounts
-Mgr Strat Partnerships
-Mgr Supply Chain Sys
-Mgr Supply Mgt
-Mgr S/W Eng
-Mgr Tax
-Mgr Tech Systems
-Mgr Warehouse Opertn
-Mktg Mgr, Sr
-Mktg Rep Natl Acc Supp
-Mktg Spec
-Natl Acc Exec
-Natl Acc Rep
-NE Div Sales VP
-Network Eng
-Network Eng-Senior
-Network Mgr
-Oe/Estimator
-Office Admtr
-Office Assoc
-Office Clrk
-Office/Lp
-Office Mgr
-Office Serv/Lp
-Office Supv
-Opertn Mgr
-Opertn Mgr/Epm
-Order Planner
-Order Processor
-Paralegal
-Payroll Admntr
-PCM Press Oper
-Planner
-Planner/Artist
-Plant Controller
-Plant Eng
-Plant Mgr
-Plant Opertn Mgr
-Plant Supt
-Platemaker
-Platemaker I
-Platemaker Ii
-Platemaker/Stripper
-Postal Coord
-Post Press Oper
-Post Press Oper Lead
-Pre Press Mgr
-Pre Press Oper
-Prepress Oper/Lp
-Prepress Sys Analyst
-Prepress Tech Supp
-Pre Press Utility Oper
-President & CEO
-Press Helper
-Press Oper
-Press Oper II
-Press Supv
-Pricer
-Pricing Coord I
-Pricing Mgr
-Pricing Spec
-Printer Oper
-Process Editor
-Process Editor/Lp
-Procurement Coord
-Prod Mgr
-Prod Mgr, Sr
-Prod Mktg Spec
-Prodn Helper
-Prodn Mgr
-Prodn Oper
-Prodn Oper/Lp
-Prodn Scheduler
-Prodn Supv
-Prodn Supv/Epm
-Production
-Programmer
-Project Mgr
-Project Mgr/Associate
-Project Mgr Budgets/Fincl Anal
-Project Mgr/Master
-Promo Prod Mgr
-Promo Prod Spec
-Proofreader
-Proposal Analyst
-Propsal Writer
-Purchasing Agent/Inven Spec
-Purchasing Clerk III
-Purchasing Coord
-Quality Control Clrk
-Quality Control Mgr
-Quality Mgr
-Quality Spec
-Quality Supp Spec
-RDP Press Oper
-Real Estate Mgr
-Recept
-Recg Lead
-Reg Dir Novation
-Reg HR Mgr
-Reg Sales Mgr
-Reg Sales VP
-Rewinder
-Rotary Helper
-Rotary Litho Press
-Rotary Press Helper
-Rotary Press I
-Rotary Press II
-Rotary Press Iii
-Rotary Press Iii/Lp
-Rotary Press Ii/Lp
-Rotary Press Oper
-Rotary Press Oper II
-Rotary Press Oper/Lp
-Sales Admin Asst
-Sales Analyst, Sr
-Sales Asst
-Sales Consult
-Sales Consult II
-Sales Mgr SBS Direct
-Sales Office Admtr
-Sales Opertn Sr Analyst
-Sales Opertn Supv
-Sales Rep
-Sales Secy I
-Sales Secy Iii
-Sales Supv
-Scheduler
-Scheduler/Planner
-Security Analyst
-Security Officer
-Sheet Feed Press Oper
-Ship Clrk
-Ship Clrk I
-Shipper
-Ship/Recg
-Ship/Recg Clrk Ii
-Ship/Recg/Lp
-Short Run Oper
-Solutions Architect
-South Div Sales VP
-Sr Acc Corres
-Sr Acc Exec
-Sr Acc Mgr
-Sr Acctg Clrk
-Sr Admin Asst
-Sr Art Dir
-Sr Bill Clrk
-Sr Bindery Oper
-Sr BSC Mgr
-Sr Bus Analyst
-Sr Bus Sys Analyst
-Sr Credit/Coll Corres
-Sr Credit Corres
-Sr Cust Serv Rep
-Sr Dir, Distrib Svcs
-Sr Dir Fincl Oper
-Sr Dir Mfg
-Sr Fincl Analyst
-Sr Imaging Oper
-Sr Inserter Oper
-Sr Material Oper
-Sr Mgr Corp Sys
-Sr Mgr Cust Implement
-Sr Office Assoc
-Sr Security Analyst
-Sr Staff Acct
-Sr Sys Admtr
-Sr Tech Sys Eng
-Sr VP Sales
-Sr Warehouse Assoc
-Sr Warehouse Assoc/Lp
-Staff Acct I
-Staff Acct II
-Staffing Consult
-Staffing Consult II
-Stock Cutter
-Strat Acc Exec
-Strat Pricing Analyst
-Stripper
-Supply Mgt Analyst
-Supp Spec Assoc
-Supp Spec Field/Associate
-Supp Spec Field/Senior
-Supp Spec Sr
-Supv
-Supv 2Nd Shift
-Supv 3Rd Shift
-Supv Cost Acctg
-Supv Credit Supp
-Supv Cust Serv
-Supv DMS
-Supv Fulfillment
-Supv Payroll Admtn
-Supv Pegboard Imprint
-Supv Pegboard Litho
-Supv Pre Press
-Supv Print Shop
-Supv Quality Control
-Supv Warehouse
-Sys Admintr
-Sys Admtr
-Sys Admtr/Senior
-Team Leader Central Pricing
-Tech Analyst
-Tech Analyst - Associate
-Tech Analyst I
-Technical Sales Consult
-Technical Trng
-Tech Spec I
-Tech Sys Eng
-Telecomm Analyst
-Telecomm Analyst/Senior
-Time Maint Clrk
-Trainer IT
-Training Mgr
-Training Spec
-Typesetter
-Unempl Comp Admtr
-Utility Helper
-Utility Oper
-Utility Oper/Lp
-VP CIO
-VP Cust Support
-VP Enterprice Accs
-VP Human Resources
-VP Marketing
-VP Supply Chain
-Warehouse
-Warehouse Assoc
-Warehouse Assoc/Lp
-Warehouse Assoc/LP
-Warehouse Inven Control Spec
-Warehouse/Lp
-Warehouse Order Packer
-Warehouse/Quality Assurance
-Warehouse Recg Coord
-Warehouse Ship Coord
-Warehouse Supv
-Web Prog/Developer
-Workers Comp Admntr
-Workers Comp/Unemp Coord
+AOA|AOA
+Escort Authorized|Escort Authorized
+Movement Area Driver|Movement Area Driver 
+NonMovement Area Driver|NonMovement Area Driver
+SIDA|SIDA
+Sterile|Sterile

Added: trunk/sql/users.csv
===================================================================
--- trunk/sql/users.csv	                        (rev 0)
+++ trunk/sql/users.csv	2015-12-17 17:57:31 UTC (rev 1362)
@@ -0,0 +1,24 @@
+BRHomola0572|Ben|R|Homola||AECOM TRANSPORTATION||AOA|||Escort Authorized||NonMovement Area Driver|SIDA|Sterile
+CLPhillips4534|Christian|Ladesse|Phillips||AECOM TRANSPORTATION||AOA|||||NonMovement Area Driver|SIDA|Sterile
+CMOhara6726|Christopher|Michael|Ohara||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+CRRepperger3178|Clifford|Raymond|Repperger||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+DHKomito7270|Donald|Harold|Komito||AECOM TRANSPORTATION||AOA|||Escort Authorized||NonMovement Area Driver|SIDA|Sterile
+DRBrockmiller7384|Dustin|Robert|Brockmiller||AECOM TRANSPORTATION||AOA||||||SIDA|Sterile
+GEHoup9266|Garry|Edward|Houp||AECOM TRANSPORTATION||||||||SIDA|Sterile
+JFWalz9670|John|Fred|Walz||AECOM TRANSPORTATION||AOA|||Escort Authorized||NonMovement Area Driver|SIDA|Sterile
+JJWetzel5889|John|Joseph|Wetzel||AECOM TRANSPORTATION||AOA||||||SIDA|Sterile
+JKEaton1085|Jaime|Kathleen|Eaton||AECOM TRANSPORTATION||AOA|||Escort Authorized||NonMovement Area Driver|SIDA|Sterile
+JMFernandez1774|John|Matthew|Fernandez||AECOM TRANSPORTATION||AOA||||||SIDA|Sterile
+JMWalden7613|Jason|Michael|Walden||AECOM TRANSPORTATION||AOA||||||SIDA|Sterile
+JSchrager3736|Jacob||Schrager||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+JTFrench5212|Jamey|Thomas|French||AECOM TRANSPORTATION|||||Escort Authorized|||SIDA|Sterile
+JTFrench7633|Jamey|Tyler|French||AECOM TRANSPORTATION||AOA||||||SIDA|Sterile
+LMiekley9650|Lisa||Miekley||AECOM TRANSPORTATION||AOA|||Escort Authorized|Movement Area Driver|NonMovement Area Driver|SIDA|Sterile
+MACarringer7656|Mark|Anthony|Carringer||AECOM TRANSPORTATION|||||Escort Authorized|||SIDA|Sterile
+MMTarnowicz5942|Marcin|Michal|Tarnowicz||AECOM TRANSPORTATION||||||||SIDA|Sterile
+MSpringer1657|Michael||Springer||AECOM TRANSPORTATION||AOA|||Escort Authorized|Movement Area Driver|NonMovement Area Driver|SIDA|Sterile
+TDBuchanan4780|Timothy|Dale|Buchanan||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+THGiles6326|Thomas|Haines|Giles||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+TWLytell9446|Troy|William|Lytell||AECOM TRANSPORTATION||AOA|||Escort Authorized|||SIDA|Sterile
+WAndraca6228|William||Andraca||AECOM TRANSPORTATION|||||Escort Authorized|||SIDA|Sterile
+IBenitez3433|Ismael||Benitez||AEROTERM||AOA|||Escort Authorized|||SIDA|

Added: trunk/sql/workgroups.csv
===================================================================
--- trunk/sql/workgroups.csv	                        (rev 0)
+++ trunk/sql/workgroups.csv	2015-12-17 17:57:31 UTC (rev 1362)
@@ -0,0 +1,2 @@
+AECOM TRANSPORTATION|AECOM TRANSPORTATION
+AEROTERM|AEROTERM

More information about the Ils-source mailing list