You are here: Home / administrative-computing / documentation / Work Requests / Campus Community Projects / WR_CC052 / IMC Employee Email Extract

IMC Employee Email 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 employees to provide the information needed to IMC to send them newsletters.  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 and campus email address for each person.

Transfer the file to the IMC directory in Exchange Data.

Operation:

 From the menu, select:

Main Menu > UWO Campus Community > IMC Extract > IMC Employee Email Extract

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

IMC Employee Email Extract 

Enter:
 FTP Application:  z_cca052a_01 
 Retrieving File: zcca052a_imc_employee_email.csv
 Storing File: zcca052a_imc_employee_email.csv

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

Ensure the Process Scheduler Request page has these values:

  • Server Name is PSUNX.
  • The box is checked in the Process List by IMC Employee Email Extract, ZCCJ052A

  • Type is Web and Format is PDF.

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

When the process is finished, the zcca052a_imc_employee_email.csv file will be avaialbe in the S:\Exchange_Data\IMC folder.

Additional Information:

See the system instructions -- IMC Extract

This process combines writing the file and transferring it to Exchange Data.  There is also a process that writes the file without transferring it, which would usually only be done for testing. -- IMC Empl Email - No Transfer