NSO checklist

 Problem Description : 

nso setup

 

 

 Resolution : 

 

 

NSO Crystal Reports 

slbevnt (table) – in toad (select * from slbevnt) to get the CRN for the NSO for that week 

Search HelpStar for NSO and select the Crystal Report Setup (Best Solutions)

 

Event ID – the CRN for that week’s NSO 

Term Code – term they are registering for (Ex: 201408)

 

In the crystal management console (web) 

 

First Report

Folders -> enrollment services -> NSO scripts -> RSVP NSO summary (right click schedule)

Recurrence – week before event (Daily) and until the day of the event (7am) End time: 7:10am

Database login- check to see if password is shown

Prompts- event ID and term code

Formats- PDF

Destination – Email – get information from help star best solutions

Use specific name –title.datetime.pdf

From: me

To: nso_notification@gordonstate.edu

Subject: NSO RSVP Summary

Add Message to email 

 

 

Second Report

Folders -> enrollment services -> NSO scripts -> Scanned Summary (right click schedule)

Recurrence – once on the day of NSO,at 9:30AM

Database login- check to see if password is shown

Prompts- event ID and term code, NSO date (date of NSO) Format: DD-MON-YY (Month has to be all caps)

Formats- PDF

Destination – Email – get information from help star best solutions

Use specific name –title.datetime.pdf

From: me

To: nso_notification@gordonstate.edu

Subject: NSO Scanned Summary

Add Message to email 

 

 

Additional Reports

1.Activate (Not in Helpstar)

1.Heron-> NSO Tasks (delete  duplicate scans )

1.Right Click Properties

2.Triggers then edit

3.Change start date

2.Update package in Toad

1.Schema Browser -> My Schema -> Packages -> HTML_REGIS

1.Right click load in editor, load in both

2.Type SET SCAN OFF; in the beginning

3.Edit body, only one term

Update term on \\falcon\d\inetpub\appsroot\SACheckin\idvalidate.asp (in Dreamweaver)  

 

 

 

 

 Revision Date : 5/25/2018

 

 

 

 Related Solutions : 

Printing Academic Summaries for NSO - Admissions

Crystal Reports schedule setup for NSO

SQL Script setup for NSO