welcome! using argos for letter generation presented by jim ollerhead banner & argos support...
TRANSCRIPT
![Page 1: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/1.jpg)
Welcome!
Using Argos for Letter Generation
Presented By
Jim OllerheadBanner & Argos Support Team Leader
University of Salford, England, UK
![Page 2: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/2.jpg)
Please remember to silence your telephone
Thank You!
![Page 3: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/3.jpg)
A bit about me…1995 – 2001
Banner Developer
2001 – 2004
Various Other
Oracle Roles
2004 onward
Banner Support
Team Leader
![Page 4: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/4.jpg)
The University of Salford is in the North West of England close to Manchester
The University was founded in 1896 and has a student population of approximately 19,000
SunGard HE products (Banner Student, Financial Aid and Accounts Receivable) have been in use at the University of Salford to hold information about our students since 1999
We began trialling the use of Argos at the beginning of 2007
University of Salford, England, UK
![Page 5: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/5.jpg)
The Joy of Banner Letter Generation…
Before you begin….Find the User Guides!
(General, Chapters 3, 5 and 6)
Learn about the Banner ‘mark-up’ language
Teach yourself SQL
![Page 6: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/6.jpg)
Finding the User Guides
Open up the Banner Bookshelf
Index the PDF’s if necessary
Perform an advanced search for ‘Letter’
Find the relevant sections from the 2884 hits
Read them!
![Page 7: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/7.jpg)
Learn the Banner ‘Mark-up’ Language
23 ‘tags’ some of which have a multiple parameter format (e.g. tables)
Complex syntax needed for simplest things, e.g:
#CONCAT x Concatenate — Place x next to the preceding word without inserting a space between them. Frequently used to place punctuation after a variable
Note: A backslash (\) is required to concatenate a period (.), for example:*VARIABLE#CONCAT ,*VARIABLE#CONCAT !*VARIABLE#CONCAT \.
Note: A trailing space is required after the #CONCAT command and before the x string.
![Page 8: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/8.jpg)
Teach yourself SQL for
368 Pages
0.66kg
![Page 9: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/9.jpg)
Teach yourself SQL for
432 Pages
0.54kg
![Page 10: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/10.jpg)
Building your Letter (1)
Create anApplication in
GLRAPPL
![Page 11: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/11.jpg)
Building your Letter (2)
CreateVariables inGLRVRBL
![Page 12: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/12.jpg)
Building your Letter (3)
Create aLetter Code in
GTVLETR
![Page 13: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/13.jpg)
Building your Letter (4)
CreateParagraphCodes in
GTVPARA
![Page 14: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/14.jpg)
Building your Letter (5)
CreateParagraphs in
GUAPARA
![Page 15: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/15.jpg)
Building your Letter (6)
AssembleLetter in
GUALETR
![Page 16: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/16.jpg)
I can print my letter now, Yes?
Dear Sir…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yours,
~~~~~~~~~~
![Page 17: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/17.jpg)
NON, NEIN, NADA, NOPE!
Dear Sir…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yours,
~~~~~~~~~~
![Page 18: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/18.jpg)
Deciding who to send your Letter to (1)
Create aPopulation Selection inGLRSLCT
![Page 19: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/19.jpg)
Deciding who to send your Letter to (2)
CheckPopSel is OK in
GLIEXTR
![Page 20: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/20.jpg)
NOW I can print my letter, Yes?
Dear Sir…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yours,
~~~~~~~~~~
![Page 21: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/21.jpg)
NON, NEIN, NADA, NOPE!
Dear Sir…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yours,
~~~~~~~~~~
![Page 22: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/22.jpg)
Running the built-in processes (1)
Run the Population
ExtractGLBDATA
![Page 23: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/23.jpg)
Running the built-in processes (2)
Run the LetterExtract
GLBLSEL
![Page 24: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/24.jpg)
Running the built-in processes (3)
Run the Letter Print
ProcessGLRLETR
![Page 25: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/25.jpg)
Finally – Do I get my Letter now???
Dear Sir…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yours,
~~~~~~~~~~
![Page 26: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/26.jpg)
OUI, JA, SI, YES, AT LAST!
Wasn’t that fun?
![Page 27: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/27.jpg)
Pre-Argos Solution
Use 3rd-party
Reporting tool
To build list
of recipients
Extract
Into
Excel
Mail-merge
Into Word
![Page 28: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/28.jpg)
Drawbacks with MS solution
Users must have (and be able to use!) MS Office
Only addresses are extracted – other data will
require additional programming
Ownership and uniformity of template letters
Data can be changed after letter production
No record of letters sent/produced
held within Banner
![Page 29: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/29.jpg)
Argos in France
![Page 30: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/30.jpg)
Argos in Greece
![Page 31: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/31.jpg)
Argos in the UK
![Page 32: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/32.jpg)
USA on trial in the UK
Another Acronym!
P roblem
I n
C hair
N ot
I n
C omputer
B eyond
A ny
N ormal
N eed for
E ducation
R ecords
A nother
R eason for
G oing
O ff
S ick
A d-Hoc
R eport
G eneration and
O utput
S olution
![Page 33: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/33.jpg)
Up-front advantages
Web interface – no installation needed
Training? What training?
Control over who can change what
Central store for letters facilitates good CM
PDF Output = no post-production changes
User empowerment ( = less work for IT support!)
![Page 34: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/34.jpg)
How we implemented Argos at Salford
Initial decisions:
Single user sign-on to the Banner database
All Argos-specific objects held in the
ARGOS_USER schema
Setting up of Argos key-users
Creation of a BI Data Dictionary
![Page 35: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/35.jpg)
Single-User Sign-on
All users connect as ARGOS_USER
ARGOS_USER given full query-only access
Access to individual Banner tables controlled by
BI Data Dictionary views (mostly!)
No impact from Banner upgrades
![Page 36: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/36.jpg)
Advantages of Argos-specific objects
No impact from Banner upgrades
Facilitates ‘soft parameter’ reporting
Objects created so far:
6 Business Intelligence Views
GYRSIGN table for recording signatories
Argos package containing 5 functions
![Page 37: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/37.jpg)
BI Data Dictionary (Views)
Evolving with time and usageSix objects so far (roughly chronological order):
SYRAPPL - ApplicationsSYRDEMO - (Person) DemographicsSYRSTPR - Students against ProgramsSYRMODL - Academic History Module MarksSYRINTR - Interruptions to StudySYRSTOU- Learning Outcome
![Page 38: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/38.jpg)
Example BI View: SYRSTPR
Students against ProgramsJoins 16 tablesUses library functions to look up coded values
Adobe Acrobat Document
Additional User-friendly definition document
Microsoft Excel Worksheet
![Page 39: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/39.jpg)
New table for Signatories of letters
![Page 40: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/40.jpg)
Connect in seconds
![Page 41: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/41.jpg)
First Version of Offer Letter Parameters
![Page 42: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/42.jpg)
Second Version of Offer Letter Parameters
![Page 43: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/43.jpg)
Quickview for record of sent letters
![Page 44: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/44.jpg)
Users Q & A on Argos…
Q. Can we have separate letters for overseas?
A. No.
Q. Can we have separate letters for conditional offers?
A. No.
Q. Can we have different letters for different signatories?
A. No.
Q. Can we have a separate report for Address Labels?
A. No
![Page 45: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/45.jpg)
Why Not???
Because
we don’t
need them!
![Page 46: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/46.jpg)
Sample Output from Offer Letter
Three Samples, One Letter!
‘Home’ Student, Unconditional Offer
‘Home’ Student, Conditional Offer
Overseas Student, Conditional Offer
Adobe Acrobat Document
Adobe Acrobat Document
Adobe Acrobat Document
![Page 47: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/47.jpg)
Mailing Labels from same Datablock
![Page 48: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/48.jpg)
But what if the wording isn’t right…
Is it the wording, conditions or the source data?
Wording: Change it but be aware that we only
version control the Master Copy
Conditions: Speak to business process owner
then Key User to change it
Source Data: Speak to IT support
![Page 49: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/49.jpg)
![Page 50: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/50.jpg)
![Page 51: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/51.jpg)
![Page 52: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/52.jpg)
![Page 53: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/53.jpg)
![Page 54: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/54.jpg)
Pictorial
Class List
using same
Datablock
as for
Letters
and Report
![Page 55: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/55.jpg)
Overall Argos User Experience
Log in (Double-click Icon) < 1 minute
Choose the letter to run < 1 minute
Enter parameters < 1 minute
Run preview 1-3 minutes
Print Done!
![Page 56: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/56.jpg)
Difference to User Community
Banner MS Merge Argos
![Page 57: Welcome! Using Argos for Letter Generation Presented By Jim Ollerhead Banner & Argos Support Team Leader University of Salford, England, UK](https://reader035.vdocuments.us/reader035/viewer/2022081421/56649ccd5503460f94996f61/html5/thumbnails/57.jpg)
Thank you for your Attention!
Any
Questions?