1 / 8

Background

Using the Princeton Information Warehouse (Cognos) to Automatically Populate a Princeton Listserv List. Background.

drea
Download Presentation

Background

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. Using the Princeton Information Warehouse (Cognos) to Automatically Populate a Princeton Listserv List

  2. Background A Princeton Listserv list must contain all of its current constituents’ EMPLIDs. Email addresses are only needed if the list is being populated initially through the listserv’s bulk operation subscriber management facility. Once scheduled, the list is overwritten with a new set of EMPLID. Listserv will match the EMPLID with a valid Princeton email address, derived from the Sun Directory (LDAP). To use a Cognos Report to populate a Listserv list with current constituents and their EMPLIDs, two things are needed: Ownership of an active Listserv list (see steps 1 thru 2). A scheduled Cognos report whose output is sent to the Listserv application (see steps 3 thru 15).

  3. Create a Listserv Address If you already own an active Listserv address, skip to step 3. Open a browser and navigate to https://lists.princeton.edu Click on www.princeton.edu/oitforms and follow the instructions provided. Make sure the name of the list matches the name of the Cognos report.

  4. Schedule a Cognos Report • Please contact the Information Warehouse Team (information-warehouse@princeton.edu) for assistance. • Open a browser and navigate to the Information Warehouse. • http://www.princeton.edu/iw - “Enter the Information Warehouse” • Navigate to the report which should be scheduled • This report should be a list-formatted report and must only contain the EMPLID. All other fields are optional. If they are included as part of the report for verification, they must follow the EMPLID in order. • A filter can be placed in the report to provide the correct list of constituents. • Click on the “New Schedule” button, to the right of the report’s name, to create a new schedule.

  5. Schedule a Cognos Report Set the Frequency of the Schedule to run daily, between 8:00am and 12:00am. Choose the “Override the default values” Option. Chose the “Delimited Text (CSV)” format. Be sure this is the only format chosen. Check “Save to the file system”. Click “Edit the options” to go to the next screen.

  6. Schedule a Cognos Report In the new window, under “Name”, make sure the report name is the same as the list name. Select “listserv” under “Location”. Under “Conflict resolution”, select “Replace existing files”. Click “OK” to return to the previous window.

  7. Schedule a Cognos Report Click “OK” in this Schedule window to set the Schedule.

  8. Questions? Questions concerning the Listserv email should be addressed to the Princeton Support and Operation Center, 609.258.HELP Questions concerning scheduling reports in the Information Warehouse should be addressed to information-warehouse@princeton.edu

More Related