Argos

1
Argos  Moving Quickly into the Community
Bruce Knox Project/Program Director a. k. a.
Database Programmer Analyst
University of Arkansas Division of
Agriculture Cooperative Extension Service bknox
_at_uaex.edu
ABUG 2009 Arkansas Tech University Russellville
May 28, 2009
2
Introduction

• Purpose
• Discuss the Argos User Community
• Converting to Argos
• Overcoming Organizational Inertia
• Benefits
• Free Software
• Conversion Tips
• Tools for Ad Hoc Banner Reporting

3
Agenda Slide

• Whats an Argos?
• Trying the Product
• The Argos Community
• Converting to Argos
• Banner Record Selection Criteria
• Argos Training
• Overcoming Inertia
• Example Apps

4
Whats an Argos?
5
Whats an Argos?

• Argos is a Web Based
• Evisions
• Ad Hoc Reporting Tool
• Designed for Banner

6
A.R.G.O.S. Ad hoc Report Generation and Output
Solution

• Easy to Use
• Fast
• Secure

7
Argos, in Design Mode looks a lot like MS Access
8
Whats an Argos?

• MS Access Built for the SQL Database

9
Trying the Product
10
Trying the Product Get a Password
11
Trying the Product Download and Install
12
Trying the Product DBA and SysAdmin

• You will need IT for early parts of the Server
  Install

13
Trying the Product Download
14
Trying the Product Install
15
Trying the Product Import Sample DataBlocks
16
Trying the Product Client Written Query
17
Trying the Product Note the Credit Given
18
Trying the Product Visual Design
19
The Argos Community
20
The Argos Community

• Community is a big part of Argos
• Sharing in Argos secured repository is
  encouraged.

21
The Argos Community
22
The Argos Community
23
The Argos Community
24
The Argos Community
25
Converting to Argos
26
Converting to Argos from a GUI Tool
27
Converting to Argos from SQL
28
Converting to Argos

• Either way will work for you, but you still
  need to know the Banner Record Selection Criteria

29
Banner Record Selection
30
Banner Record Selection
-- names_create.sql Current Records VIEW from
TABLE SPRIDEN-SPBPERS CREATE OR REPLACE VIEW
NAMES ( PIDM, ID, NAME, LEGAL_NAME, SORT_LAST )
AS SELECT SPRIDEN_PIDM, -- PIDM,
SPRIDEN_ID, -- ID,
SUBSTR(DECODE(SPBPERS_NAME_PREFIX,'Mr',NULL,'Mr.',
NULL,'Miss',NULL,'Mrs',NULL, 'Mrs.',NULL,'Ms',NU
LL,'Ms.',NULL,NULL,NULL, SPBPERS_NAME_PREFIX'
') RTRIM(DECODE(NVL(SPBPERS_PREF_FIRST_NAME,'X
'),'X',spriden_first_name,spbpers_pref_first_name)
)' ' RTRIM(spriden_last_name),1,25), --
Name, SUBSTR(RTRIM(spriden_last_nam
e)', 'RTRIM(spriden_first_name)'
'RTRIM(spriden_mi),1,25), -- Legal_Name,
SUBSTR(spriden_last_name,1,15) --
Sort_Last FROM SPRIDEN, SPBPERS WHERE
SPRIDEN_PIDM SPBPERS_PIDM () AND
SPRIDEN_CHANGE_IND IS NULL AND
SPRIDEN_ENTITY_IND 'P'
31
Banner Record Selection
With Current Record Oracle Views anyone can
quickly create error free results.
32
Banner Record Selection
Now a Quick Example
33
Banner Record Selection
34
Banner Record Selection
35
Banner Record Selection
36
Banner Record Selection
37
Banner Record Selection
Look for Current Record Set or Special Views  
in my scripts repository http//betwinx.com/Bann
erScripts.htm This is password protected and if
you need the scripts password, just ask me for it.
38
Banner Record Selection
You should find these and many
other Views Active_Employees Active_Jobs
Age FTVFUND_V FTVORGN_V FTVPROG_V
FTVACCT_V FTVLOCN_V GOREMAL_V
Names http//betwinx.com/BannerS
cripts.htm
39
Argos Training
40
Argos Training Many Options

• Free On-Line Recorded Training
• Free On-Line Live Training
• On-Site Training (Consulting and Development)

41
Argos Training
42
Argos Training
43
Recorded Training for Designer
44
Argos Training
Could it be easier?
45
Recorded Training for Designer
46
Overcoming Inertia
47
Overcoming Inertia

• Designers are the hardest to move
• Give them a Fast Path
• Give them Obvious Improvements
• Give them Examples

48
Programmers or Designers

• These help
• Folders for each Application or Functional Area
• A Connection for any Shared ID/pw
• Use a Banded Report Standard
• Scheduled Reports can be Direct to Printer
• Reports via http// Links using the API

49
Programmers or Designers
50
Programmers or Designers
51
Programmers or Designers
52
Programmers or Designers
53
More Argos Resources
54
More Argos Resources Argos Training
55
Knowledge Base, Listserv, Help Desk,
56
Examples Apps
57
We have these non-Banner Apps

• HelpDesk
• Publications
• Irrigation
• Wildlife
• AIMS

58
Banner Support Apps

• Administrative Support
• Cash Management
• Spot (Luminis)

59
Report Viewers

• Need very little help
• They already know Windows

60
Argos Training Report Viewers
61
Report Viewers

• Just give them something useful

62
Report Viewers
63
Report Viewers
64
Report Viewers
65
Report Viewers
66
Summary

• Download and Try It!
• Argos is the Web Based Ad Hoc Reporting Tool for
  Banner
• Go to the Argos Community for Free Code and Help

67
Questions???Bruce Knox at bknox
_at_uaex.eduwww.uaex.edu/bknox/
68
More Argos Resources

• http//www.evisions.com/products/argos/index.asp
  Argos
• http//betwinx.com/BannerArgos.htm BannerArgos
  
• http//www.uaex.edu/bknox/ Banner
  Reporting Solutions