Home » forums » SCT Banner Integration

Pop Cell Advice

Submitted by yeah on Tue, 2009-12-01 14:17

does anyone have some general pop cell advice for me?  searching the documentation on them hasn't yielded me very good results.

Basically my questions are:

  • How do I make pop cells? (popcel?)
  • How do I import them into Luminis?
  • Is there a way to automate their creation and Luminis importing?
  • Is there a way to have a pop cell fire off a lot of icgorodm events for the people my SQL is searching on?

thanks

‹ Question about Replacement methodology for Banner Channels Student Body Elections ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Population Selection

Submitted by julied on Tue, 2009-12-01 15:30.

PopSel information is in the Banner General User Guide. We haven't gotten to the point in our implementation of using them with luminis yet, but my plan is to use AppWorx to automate it if we have one that we use on a regular basis.

I have step by step instructions I wrote for our users during our training for popsels. I can email those to you or if someone will tell me how to upload files I can post it here. I'm not seeing or just overlooking a way to attach files to a comment.

thanks

Submitted by yeah on Tue, 2009-12-01 17:31.

thanks, I'd like to see what you have.  I can be reached at:

email removed

I'll remove my email after I recieve the files.

thanks -- I think to post files on here you have to create a new post -- not sure if its only blogs that do it or if you can do it in forums as well.

Copy

Submitted by ma_isaura on Tue, 2010-04-06 14:15.

Can you please share with me your instructions on how to create population selections?... my email isaura.lopez@tamucc.edu

Thank you!!

Really appreciate your help :-)

PopSel information

Submitted by Billsch on Tue, 2011-10-25 22:18.

Would love to have those step by step instructions too. Can you forward them to me?
schuetzb@lanecc.edu

Differnent Route

Submitted by marlena.brown@s... on Wed, 2011-10-26 13:54.

I by-passed the popsel and just wrote sql that created the xml and for imported groups. We also have code that extracts the information, gets the uid and then loads the information right into the luminis tables.

Automating the importing of icgorgmk_*.xml files

Submitted by hallinl on Wed, 2011-10-26 14:25.

On Banner the users run a popsel and create a icgorgmk_*.xml file in a "export" directory.

I have a cron job that wakes up every 10 minutes starting on the hour looking for icgorgml_*.xml files in the "export". When found, they are sftp'd to Luminis.

On Luminis, I have a similar cron job that wakes up every 10 minutes starting at :05 (in theory 5 minutes after Banner exported the file to Luminis). If file(s) are found, they are imported into Luminis via a "cptool import segment filename" command. I have various error checking that is done both on the Banner server and the Luminis server. Once the import has been run, an email is sent to the user that created the popsel indicating that the import succeeded or failed.
Note: This email function is possible, in part, by [simple] changes we made to gjajobs.shl that captures (into a file) a one line record of information from each jobsub use.

This method, in theory, insures that the .xml file from a given popsel will get imported into Luminis within 5-15 minutes of it's creation.

The cron jobs also append to a log file indicating what happened during the process (export or import).

If anyone is interested, I can "sanitize" the scripts and email them to you. All together, with comments, they are 400-500 lines long so a bit too long for a post here.

Script for automating groups

Submitted by rbean on Wed, 2011-10-26 20:07.

Lee,
I would be very interested in seeing what you've done. Can you email it to me at rbean@mtsac.edu?
Thanks.

Syndicate content