Emergency Alert Extract

by vandberg published Feb 28, 2012 11:30 AM, last modified Jun 23, 2017 02:36 PM
Run Instructions

Function:

Write an extract file of all active students and employees to provide the information needed to contact them with the emergency alert system.  Students are included if they are enrolled in the current semester or any future semester.  Employees are included if they have an active appointment (job) on the current date or any time in the future.

The extract file includes UW Oshkosh EMPLID, name, campus email address and NetID for each person.

Transfer the file to Rave, the emergency alert vendor.

Operation:

 From the menu, select:

Main Menu > UWO Campus Community > Emergency Alert Interface > Emergency Alert Ext Transfer 

Select a Run Control ID or create a new one.  -- See Using Run Control ID

Emergency Alert Ext Transfer 

Enter:
 FTP Application:  z_cca051a_02 
 Retrieving File: zcca051a_rave_people.csv
 Storing File: rave\-people.csv

The backslash (\) is necessary to transfer a file with a hyphen in the name.  The file will be named rave-people.csv when it is stored.  The z_cca051a_02 application transfers the file directly to Rave. The z_cca051a_01 application that transfers it to Exchange Data is also available.

Run the process using the Process Scheduler.  -- See Using Process Scheduler

Ensure the Process Scheduler Request page has these values:

  • Server Name is PSUNX.
  • Recurrence is ZCCA051A_WEEKDAYS_0440PM
  • The box is checked in the Process List by Emergency Alert Ext Transfer, ZCCJ051A

  • Type is Web and Format is PDF.

Use the Process Monitor to view the output of the process.  -- See Using Process Monitor 

Additional Information:

See the system instructions -- Emergency Alert Interface

This process combines writing the file and transferring it to Rave.  There is also a process that writes the file without transferring it, which would usually only be done for testing. -- Emergency Alert - No Transfer