1 / 17

So you have Informer… now what?

Jonathan Vester, Director of Institutional Technology Nash Community College. So you have Informer… now what?. Topics. 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

dougal
Download Presentation

So you have Informer… now what?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Jonathan Vester, Director of Institutional Technology Nash Community College So you have Informer… now what?

  2. Topics • 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

  3. Creating a real-time class schedule • 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

  4. Similar, but different All Sections: All Sections With An Online Component:

  5. Using Saved Lists for Input and Output 1. Create your list of values… 2.Click Export Results… 3. Tell Informer what to name your list.

  6. Using Saved Lists for Input and Output Create your list using Colleague mnemonics, and use GET.LIST to retrieve your list of values for use in other reports.

  7. Retrieving Unique with Select/Returning • Requires links between the tables • Replaces needing SAVING UNIQUE in TCL/ECL statements

  8. Using Live Excel Files • 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

  9. Using Live Excel Files Example 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

  10. Using Live Excel Files Example Step 1 – Create the data feed Step 2 – View the results Step 3 – Setup the PivotTable and analysis

  11. Using Calculated Fields:Custom Report Values Useful when creating: • Virtual Computing Lab (VCL) Accounts • Moodle Accounts • Blackboard Accounts • Publisher Web-Supplement Accounts • Anything you want a custom field for

  12. Using Calculated Fields:Custom Report Values Custom Field Template Hidden Fields = MAT-060-01-2011FA ${secCourseName}-${secNo}-${secTerm}

  13. Using Calculated Fields:Error Checking ‘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.

  14. Using Calculated Fields:Error Checking Example var txt = person_to_Student_assoc_students_to_Person_assoc_id.toString(); var a; if (txt.length == 7){ a = txt; } else if (txt.length == 6){ a = '0'+txt; } else if (txt.length == 5){ a = '00'+txt; } else{ a = "<div style='text-align:center;height:100%;font-weight:bold;color:red'>ERROR</div>" } a; Find out the length of the string Do this if true If it is not seven characters long, try this test Do this if true If it is not seven or six characters long, try this test Do this if true If it meets none of the above, tell me there is a problem

  15. Using Calculated Fields:Error Checking Example In a web report In a Live Excel worksheet

  16. The future • 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

  17. Thank you! Questions/ Discussion

More Related