Transcript Step 1
Jonathan Vester, Director of Institutional Technology
Nash Community College
Creating a real-time class schedule and availability
report for different course types
Using Saved Lists for Input and Output
Retrieving Unique Values with Select/Returning
Using Live Excel Files
Simplified Net Price Calculator
Using Calculated Fields
Custom report values
Error checking
Create the report once and give all Informer
users access
Place the report on a schedule for all faculty
Reduce the workload of Administrative
Assistants
Video Example
PDF Example
All Sections:
All Sections With
An Online
Component:
1. Create your list of values…
2.Click Export Results…
3. Tell Informer what to name your list.
Create your list using Colleague mnemonics,
and use GET.LIST to retrieve your list of values
for use in other reports.
•Requires links between the tables
•Replaces needing SAVING UNIQUE in TCL/ECL statements
Setup queries once, and skip the Informer step
afterwards
Distribute data tools to non-Informer users
Use PivotTable and PivotChart features for
deeper analysis
Keeps leading zeros
Using the structure
provided by the June
2011 System Office
guide, you can
replicate the output
in Informer
Using a Live Excel sheet, it is possible to
calculate the Net Price data automatically
Step 1 – Create the data feed
Step 2 – View the results
Step 3 – Setup the
PivotTable and analysis
Useful when creating:
Virtual Computing Lab (VCL) Accounts
Moodle Accounts
Blackboard Accounts
Publisher Web-Supplement Accounts
Anything you want a custom field for
Hidden Fields
${secCourseName}-${secNo}-${secTerm}
Custom Field Template
= MAT-060-01-2011FA
‘Add Calculation’ allows you to do
more than just arithmetic.
Informer understands JavaScript
and HTML (even if you don’t).
You can create if/then statements
which modify your output based
specific criteria.
var txt = person_to_Student_assoc_students_to_Person_assoc_id.toString();
var a;
Find out the length of the string
if (txt.length == 7){
a = txt;
Do this if true
}
else if (txt.length == 6){
If it is not seven characters long, try this test
a = '0'+txt;
Do this if true
}
else if (txt.length == 5){
If it is not seven or six characters long, try this test
a = '00'+txt;
Do this if true
}
If it meets none of the above, tell me there is a problem
else{
a = "<div style='text-align:center;height:100%;font-weight:bold;color:red'>ERROR</div>"
}
a;
In a web report
In a Live Excel
worksheet
Import/Export of reports coming in R4.3
(2012 Q1)
Common (shared) library in the discussion
phase
Common Informer linkages a must – using
standardized fields
Conversion to SQL version of Datatel
Informer Users Group
Questions/ Discussion