Transcript Argos - Moving Quickly into the Community

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 @uaex.edu
ABUG 2009 Arkansas Tech University Russellville
May 28, 2009
Introduction
Purpose:
• Discuss the Argos User Community
• Converting to Argos
• Overcoming Organizational Inertia
Benefits:
• Free Software
• Conversion Tips
• Tools for Ad Hoc Banner Reporting
Agenda Slide
•
•
•
•
•
•
•
•
What’s an Argos?
Trying the Product
The Argos Community
Converting to Argos
Banner Record Selection Criteria
Argos Training
Overcoming Inertia
Example Apps
What’s an Argos?
What’s an Argos?
•
•
•
•
Argos is a Web Based
Evisions
Ad Hoc Reporting Tool
Designed for Banner
A.R.G.O.S. Ad hoc Report Generation and Output Solution
• Easy to Use
• Fast
• Secure
Argos, in Design Mode looks a lot like MS Access
What’s an Argos?
MS Access++ Built for the SQL Database
Trying the Product
Trying the Product: Get a Password
Trying the Product: Download and Install
Trying the Product: DBA and SysAdmin
You will need IT for early parts of the Server Install
Trying the Product: Download
Trying the Product: Install
Trying the Product: Import Sample DataBlocks
Trying the Product: Client Written Query
Trying the Product: Note the Credit Given
Trying the Product: Visual Design
The Argos Community
The Argos Community
• Community is a big part of Argos
• Sharing in Argos’ secured repository is
encouraged.
The Argos Community
The Argos Community
The Argos Community
The Argos Community
Converting to Argos
Converting to Argos from a GUI Tool
Converting to Argos from SQL
Converting to Argos
Either way will work for you, but you still need
to know the Banner Record Selection Criteria
Banner Record Selection
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',NULL,'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_name)||', '||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'
;
Banner Record Selection
With Current Record Oracle Views anyone
can quickly create error free results.
Banner Record Selection
Now a Quick Example
Banner Record Selection
Banner Record Selection
Banner Record Selection
Banner Record Selection
Banner Record Selection
Look for:
Current Record Set or Special Views
in my scripts repository http://betwinx.com/BannerScripts.htm
This is password protected and if you need the scripts password,
just ask me for it.
Banner Record Selection
You should find these and many other Views:
Active_Employees
Active_Jobs
Age
FTVFUND_V
FTVORGN_V
FTVPROG_V
GOREMAL_V
Names
http://betwinx.com/BannerScripts.htm
FTVACCT_V
FTVLOCN_V
Argos Training
Argos Training: Many Options
• Free On-Line Recorded Training
• Free On-Line Live Training
• On-Site Training (Consulting and Development)
Argos Training
Argos Training
Recorded Training for Designer
Argos Training
Could it be easier?
Recorded Training for Designer
Overcoming Inertia
Overcoming Inertia
•
•
•
•
Designers are the hardest to move
Give them a Fast Path
Give them Obvious Improvements
Give them Examples
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
Programmers or Designers
Programmers or Designers
Programmers or Designers
Programmers or Designers
More Argos Resources
More Argos Resources: Argos Training
Knowledge Base, Listserv, Help Desk, …
Examples Apps
We have these non-Banner Apps
•
•
•
•
•
HelpDesk
Publications
Irrigation
Wildlife
AIMS
Banner Support Apps
• Administrative Support
• Cash Management
• Spot (Luminis)
Report Viewers
• Need very little help
• They already know Windows
Argos Training: Report Viewers
Report Viewers
• Just give them something useful
Report Viewers
Report Viewers
Report Viewers
Report Viewers
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
Questions???
Bruce Knox at bknox @uaex.edu
www.uaex.edu/bknox/
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