Home › Hardcore Luminis › Chapter 7 : Channel Hacks

Dumb question - Course calender content from Banner

Wed, 2005-08-24 13:31 — bayrock

Newbie question 43122 (and counting)...

Is there a way for the indivudual course calendars in Luminis to become populated using data found in Banner. Banner _knows_ when the class starts, ends, what days it's on - all that stuff. But, when I look at the course's calendar in Luminis, there is nothing.

As an extension, when students register for classes, can the class information be automagically loaded into the student's calendar too?

Have we missed a trigger? Or is this another great idea that should become an enhancement request?

TIA

Michael

0
No votes yet
‹ Targeted Announcements and email on Exchange servers Luminis IV upgrade/migration ›
‹ Chapter 7 : Channel HacksupChapter 8 : Statistics ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 2005-08-24 16:07 — Dan Schwartz

Course Calendar import from Banner

Hi Michael - The old way of doing it is to find the icsorspf sql job on the banner side and generate an xml file, move that xml file to your portal server and import it. I usually have to modify this file fairly significantly before importing it, but once thats done and the import is run (cptool import file 200540.xml) all the calendars are populated.

I believe that the LDI stuff with banner 7 implements something that is more event driven, and perhaps theres an even newer way to do it.

-- Dan

Wed, 2005-08-24 17:45 — dwisehaupt

Possibly Useful

I just got a message from one of our DBA's yesterday pertaining to this.


SSASECT must have a meeting type of CLAS for the meeting times to be picked up by the extracts. The course that XXXX is taking does not have this meeting type. The defect that SCT provided did not do anything for us. After looking at the extract file which was loaded, there are meeting times for courses - I checked out a couple of these courses and they have meeting type of CLAS.


CLAS is defined on GTVSDAX - if needed we can probably add additional meeting types to GTVSDAX.

I'm not totally sure if that is useful to you. We are running III.2 with Banner7 in the back.

I'm not quite sure about the course trigger info, but I believe we had some of that working in test. I could ask and get more info if you are interested.

Dallas

Fri, 2005-08-26 13:17 — grayematter

check banner setup

We are currently implementing luminis III.2 based on our banner 6.x system.

  1. make sure you are sync'ing an active and sync'able term.
  2. make sure you have the proper GOREQNM settings (LDIENROLL enabled for LDI target)
  3. make sure you have the proper GTVSDAX entries (ICMEETTYPE record for each meeting type from GTVMTYP that you want to sync)
Fri, 2005-08-26 13:51 — bayrock

Checking, ...

Thanks for the suggestions, guys!

Our investigation shows that we've processed triggers for meeting times for many of these classes, but the meeting time that was passed through was "NONE". It appears that this happens when the trigger can't find an appropriate record on the GOBTERM table.

But, if may also be something to do with GTVSDAX too...

Watch this space for new developments

-- Michael

Tue, 2007-04-10 14:09 — tkowal

Course Calendar Content from banner

I've read through Michael's thread on this topic, and see it is fairly old, but we have the same question here... We are at PROD Banner 7.2 and Testing Luminis 3.3 and we also are not seeing any of the student courses showing up in calendar for student in Luminis. That would be nice to have. Implication in the thread is that they should show up provided that we have the setup data described in the thread as noted. We do, but still no dice. Also, looks like SunGard elimininated the batch process icsorspf.sql. Does anyone know any updated information on this? Thanks!