Crystal Reports schedule setup for NSO

 Problem Description : 

Instructions for various Crystal Reports that need to be setup for NSO

 Resolution : 

All setup is done through the Crystal Management Console logged on as Administrator and all reports are under All Folders->Enrollment Services Reports->NSO Scripts

One week prior to NSO:

Right click on Report and choose schedule

* RSVP NSO Summary - sends a daily email of RSVPs for particular NSO

-- Reccurance -Schedule to run daily at 7:00am beginning at least 1 week prior to NSO End Time 7:10 day of Registration

-- check database login - make sure password is shown

-- Prompts- Parameters required are NSO Event CRN and term for NSO

-- format - PDF

-- Destination - Email From(me) to nso_notifications@gordonstate.edu Subject: NSO RSVP Summary - Add message to email Check Use Specific Name box and choose add a placeholder - choose title and then date and time then add.pdf

-- Below is example of Schedule Setup

* RSVP Registration Problems - emails PDF of NSO RSVPs with potential registration problems (holds, checklist items, academic standing, etc).

-- Schedule to run daily at 7:00am beginning at least 1 week prior to NSO End time 7:10 day of NSO

-- format - PDF

-- Parameters required are NSO Event CRN, NSO Date9DD-MON-YY) and NSO term

-- Destination Set to email from (me) to: admissions@gordonstate.edu cc: csd-l@gordonstate.edu Add a Message Check Use Specific Name box and choose add a placeholder - choose title and then date and time then add.pdf

-- Below is example of Schedule Setup

Day of NSO:

* Scanned Summary - sends PDF email of NSO attendees scanned in during check-in in gym

-- Recurrance - Schedule to run every 3 hours from 8:30am to 11:30 :2:30 and 5:30

-- Databse Login - Check for password

-- format - PDF

-- Destination Email to nso_notification@gordonstate.edu 

-- Prompts: Parameters required are NSO Event CRN, NSO date (dd-MON-YY) and NSO semester (USE 2 digit YEAR ) Check Use Specific Name box and choose add a placeholder - choose title and then date and time then add.pdf

* Potential Registration Problems - sends PDF email of check-in NSO attendees that have possible issues with their application, hold, academic standing, etc. that would prevent them from registering.

-- Recurrance- Schedule to run hourly from 8:30am to 5:30pm

-- Destinaton - Email to admissions@gordonstate.edu and csd-l@gordonstate.edu

-- Parameters required are date of NSO (dd-MON-yy) and NSO semester Check Use Specific Name box and choose add a placeholder - choose title and then date and time then add.pdf

DAY BEFORE NSO:

Update Date on Immune_extension_update.sql - See Helpstar ticket on this - Admissions should notify you of Date

Go to Vulture and Start NSO Tasks - change start date

Got to Toad - Schema Browser - Packages - HTML_REGIS

right click and load in Editor - load both

Type SET SCAN OFF at top of sql

edit the term in the body

execute

 Revision Date : 4/28/2016