Best Kept Secrets Tips and Tricks Presented by
Best Kept Secrets – Tips and Tricks Presented by: Fred Schuster, Associate Applications Engineer 1 | CBORD 2018 User Group Conference | Presentation
Highlights • Squadrondebug • Siteinformation table parms to limit days of logging for certain data • Admin. Web – Mass Updater • Disaster Recovery – Are you protected? ? 2 | CBORD 2018 User Group Conference | Presentation
3 | CBORD 2018 User Group Conference | Presentation
Squadrondebug tool 4 | CBORD 2018 User Group Conference | Presentation
Squadrondebug Test=1 5 | CBORD 2018 User Group Conference | Presentation
Squadrondebug Test=13 Current Devices on V 1000 according to the V 1000 6 | CBORD 2018 User Group Conference | Presentation
Squadrondebug – Reset V 1000 When to use: 1. Added new devices to V 1000 and devices don’t seem to come online 2. Clear V 1000 of old outdated Schedules 3. Other odd behavior of readers on this V 1000 7 | CBORD 2018 User Group Conference | Presentation
SITEINFORMATION Table 8 | CBORD 2018 User Group Conference | Presentation
SITEINFORMATION Table Values Logging Days and other Values Easiest way to access SITEINFORMATION table? 9 | CBORD 2018 User Group Conference | Presentation
SITEINFORMATION Table Values Logging Days and other Values 10 | CBORD 2018 User Group Conference | Presentation
SITEINFORMATION Table Values Logging Days and other Values 11 | CBORD 2018 User Group Conference | Presentation
Admin Web Mass Updater 12 | CBORD 2018 User Group Conference | Presentation
Overview • What is Mass Updater? • Application you use to add/modify/delete information for groups of patron accounts. • Mass Updater consists of four tabs: • General Information • Flags • Meal Plan • Stored Value/Credit 13 | CBORD 2018 User Group Conference | Presentation
Performing Mass Updates Basic Steps to performing a Mass Update: • STEP 1: Search for patrons. • STEP 2: Select patrons. • STEP 3: Select Action. • STEP 4: Run in Test Mode (verify change). • STEP 5: Perform Action (Mass Update). • STEP 6: Check your work! 14 | CBORD 2018 User Group Conference | Presentation
Simple and Advanced Searches Simple Search by PIK or Last Name. Advanced Search enter specific criteria. 15 | CBORD 2018 User Group Conference | Presentation
Advanced Searches • Select Field, enter Value, select Operator. • + adds another field condition. • - removes field condition. • <SEARCH> initiates patron search. • <CLEAR> removes search conditions. 16 | CBORD 2018 User Group Conference | Presentation
Advanced Searches (continued…) • When using multiple conditions of same field, choose Match All (AND) or Match Any (OR) logical operator • Such as: • Flag 1 and Flag 5 • Flag 1 or Flag 5 17 | CBORD 2018 User Group Conference | Presentation
Advanced Searches (continued…) • Operators are dependent on field selected. • Basic Field Operators • Starts With, Contains, Equals, Between, Ends With, Is Null, Is Not Null, Sounds Like, Greater Than, Less Than • Plan Operators • Patron Has Plan, Patron Does Not Have Plan, Patron Has Any Plan, Patron Has No Plan, Balance Greater Than, Balance Less Than • Patron Group Operators • In, Not In 18 | CBORD 2018 User Group Conference | Presentation
Selecting Patrons • After performing search, you can select: • individual patron. • all patrons. • specific patrons. • For large searches (over 500): • Only first 500 patrons display. • Message “there are more patrons not shown here” displays at end of list. • Patrons over 500 are included in Mass Update! 19 | CBORD 2018 User Group Conference | Presentation
Flag - Changes • You can insert/modify/delete multiple flags to/from patrons. • • Click Add A Flag to add flags and specify values. • Click X to remove flags. • For Boolean flags: • True (enables flag, 1) • False (disables flag, 0) • Delete (deletes flag) For Alphanumeric (string) flags: • Set (inserts/updates flag with value) • Delete (removes flag value by deleting flag) 20 | CBORD 2018 User Group Conference | Presentation
Disaster Recovery 21 | CBORD 2018 User Group Conference | Presentation
22 | CBORD 2018 User Group Conference | Presentation
23 | CBORD 2018 User Group Conference | Presentation
24 | CBORD 2018 User Group Conference | Presentation
We want your feedback! Please evaluate this session in the ERMobile app. Your feedback helps us improve future sessions. Find this session in the app, and touch COMPLETE SESSION SURVEY. Thank you!
- Slides: 26