Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About

Users of Alma and Primo need accounts set up in the system to perform tasks.  This project will create an automated process to export new, updated, and expired users from PeopleSoft to Alma on a regular basis.  Doing this systemwide allows us to streamline the process and standardize the data as much as possible.  It also allows us to coordinate this work with the related task of setting up authentication in Alma and Primo.

The Chancellor's Office CMS group has developed an app engine (read: batch script) that campus PeopleSoft groups can enable to automate the extract of user data from PeopleSoft to Alma

.  

Considerations for libraries

Meet with your campus PeopleSoft group

Libraries should meet with their campus PeopleSoft contacts to go over the various configuration options in the app engine.

User Identifiers

Every campus Student Information System (SIS) and HR System (for employee data) is set-up slightly differently in PeopleSoft. Although there is a great deal of standardization, especially around basic contact information (EmplID, name, email, address, etc.), some pieces of data, such as campus username and barcode, are not standardized across the CSU.

The script developed by the Chancellor's Office accounts for all of the standardized data elements.  However, campuses that want to include a non-standard element, such as campus username or a barcode, will need to enter a COMR exception (read: customization) to account for this local data

.  

Note that this will not be necessary for most libraries.  Campus username is not necessary for authentication for the vast majority of libraries, and at most campuses the PeopleSoft EmplID is the campus barcode number, and is already included in the basic export.

Testing with Alma

All campus Alma instances have been configured to pick-up the patron load file from your campus' PeolpeSoft dev/test FTP server location.  Once your PeopleSoft group has configured the app engine on their dev/test PeopleSoft instance and produced a test file, you can go into Alma and run an import test.

From the main menu go to: General Configuration > Configuration Menu > Integration Profiles > Student Information System

Go to the ‘Actions’ tab and in the ‘Synchronize’ section you can click ‘run.’

Once you hit run, that will produce an import job. To see the results of that test, from the main menu go to: Manage Jobs and Sets > Monitor jobs.  Your job will be here, either under the 'Running' tab, or, if not there, then check under 'History'.

It's also possible to run the test under the 'Import' section.

Here’s the difference between the two: "The import mode is a one-time load, used to initially create new external users. It is intended to be used only when you have a file of users you know are new, such as during the migration process, when you want to load users from your legacy system into Alma. The synchronize mode is an ongoing load, used to update external users and add new ones."

Switching to production

On the PeopleSoft side, your PS group should know the steps for actually putting the app engine into production. 

On the Alma side, we just need to update the SFTP definition to point at the production FTP server instead of the development server.  That is under Administration > [General Configuration] > Configuration Menu > [External Systems] > S/FTP definitions.

 Edit the entry ‘CALS SFTP’.  

Change ‘Server’ from:

   sftpdev.sldc.calstate.edu

 to:

   sftpprd.sldc.calstate.edu

 Change the last part of the 'UserName' from:

******dv

to:

******pd

Where the asterisks here are the first part of your username.

That should be it.  The public key and everything else should be the same.

Scheduling

The first time you run an import from production, you will be doing a full import of all users – just as most of you did during testing.  After that, you'll want to set up a schedule for fully automated imports.

To do that, first work with your campus IT group so that they schedule an appropriate time for the PeopleSoft export to run – this will typically be nightly.  You'll then want to configure Alma to import the file after the scheduled PeopleSoft export.  We recommend giving ample time between the two processes – at least two to three hours.

To set the schedule in Alma go to:

Administration > [General Configuration] > Configuration Menu > [External Systems] > Integration Profiles.  

Select 'Student Information System' and click on the 'Actions' tab.

In the 'Synchronize' block, choose the desired schedule from the drop-down.

Image Removed

Known Issues

See Known Issues for common problems.

Major Milestones

StageComplete ByStatusMeet with CO CMS and Identity Management group to discuss project

 

StatuscolourGreentitleCompletedMeet with vanguard campuses (Fresno, San Jose, Northridge) to discuss project

 

StatuscolourGreentitleCompletedVanguard campuses create sample scripts to inform CMS design

 

StatuscolourGreentitleCompletedReview survey of libraries' needs regarding parton load

 

StatuscolourGreentitleCompletedDeliver draft requirements document and sample code from vanguard campuses to CMS

 

StatuscolourGreentitleCompletedCreate Access Services taskforce to standardize patron types and expiry date

 

StatuscolourGreentitleCompletedFinal requirements document delivered to CO CMS

 

StatuscolourGreentitleCompleted

CO CMS develops initial export process

 

StatuscolourGreentitleCompletedBegin testing of CO-developed patron extract with pilot (= vanguard) campuses

 

StatuscolourGreentitleCompletedTesting and feedback

 

StatuscolourGreentitleCompletedCMS Development updates 
StatuscolourGreentitleCompletedGeneral release to campuses

 

StatuscolourGreentitleCompletedAll Alma instances configured to pick up files (test)

 

StatuscolourGreentitleCompletedAll Alma instances configured to pick up files (prod)

Status
colourYellow
titleIn progress

Campuses complete configuration and testing of app engine

 

Status
colourYellow
titleIn progress

All Alma instances scheduled for daily pick-up

 

Status
colourYellow
titleIn progress

PeopleSoft Guides

ALMA Unified Library Interface User 2015-12-08 Meeting notes (w/CO)

Meetings

  • 2016-12-07 Delivery & Q&A webinar (chat)
  • SSO / PeopleSoft Discussion (w/CO)
  • 2015-11-04 Meeting notes
  • Project Team


    RoleName
    Project
    leadsIan Chan (Unlicensed); Chancellor's Office
    Other Contacts

    Darlene Daclan (AA Business Sys Dir)
    ddaclan@calstate.edu

    John Horton (Stdnt Admin Sr Tech Dev)
    mtrullinger@calstate.edu

    Barbara Gal (Project Manager)
    bgal@calstate

    .eduEx Libris Contacts

    Dolph Chaney (Project Manager)
    Dolph.Chaney@exlibrisgroup.com

    Informed / Other Stakeholders

    Campus contact

    CampusPS AreaContactEmailTelephoneBakersfieldBrian Chenbchen@csub.edu661-654-2538Channel IslandsShawn Bochatshawn.bochat961@csuci.edu805-4373224ChicoBeth Kissingerbkissinger@csuchico,530-898-5007Dominguez HillsBill Changbchang@csudh.edu310-243-2369East BayKent McKinneykent.mckinney@csueastbay.edu510-885-3574FresnoJohn Wagenleitnerjohnwa@csufresno.eduFullertonRamesh Purohitrpurohit@fullerton.eduHumboldtMelinda SwankMelinda.Haynes.Swank@humboldt.eduLong BeachNadia Vargo Nadia.Vargo@csulb.edu562-985-8715Los AngelesHRMJerry WongJWong4@cslanet.calstatela.eduLos AngelesRegistrarLai Leunglleung@calstatela.eduMaritime AcademyGopaal Chandrasevkarangopaal@csum.edu707-654-1729Monterey BayIN-PROCESSMoss LandingN/ANorthridgeSondra BaierSondra.baier@csun.eduPomonaPeopleSoftPatricio Beltranpbeltran@cpp.edu9098692238PomonaIdentity Management David Drivdahldavidd@cpp.edu9099796372SacramentoMarc Foxfoxm@skymail.csus.eduSan BernadinoHRMRon Rodriguezrrodrigu@csusb.edu9095377261San BernadinoRegistrarLenora Rodgerslenora@csusb.edu9095377264San DiegoN/ASan FranciscoBernie Brownbbrownsf@sfsu.edu4153382449San JoseYogalakshmi(Yoga) Periasamyyogalakshmi.periasamy@sjsu.edu4089242305San Luis ObispoIN-PROCESSSan MarcosMichael C. Sullivanmsulliva@csusm.edu7607504711SonomaErica Klaftererica.klafter@sonoma.eduStanislausCorey Cardozaccardoza@csustan.edu2096673731

    Possible Future Enhancements

  • Skip students with multiple plans that have the same sequence number and log the error.

  • Better mapping for non-state-side employees

  • Expiration dates for faculty/staff, when known (particularly for visiting scholars)

  • If a student shows enrollment and has a future effective dated program stack, then exclude the student from the extract