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