Database Related
Lead Programmer Analyst in Denver Colorado
Title of Position: Lead Programmer/Technical Analyst
Position Number: 299030
The Colorado Community College System is the state’s largest system of higher education, comprising 13 state
community colleges, career/technical programs in more than 150 school districts, and program oversight for seven other
post secondary institutions. Each college offers a blend of core courses for the university-bound as well as career
programs that meet local employers’ needs. Our high school programs are designed to increase the number of qualified
Luminis Banner Channels prompting for User ID and PIN
We have had a few users who are prompted for their User ID and Pin when they try to access the Banner Channels within Luminis. Some of them are on Military bases and some of them are not, I have seen where access from military bases is sketchy.
Has anyone encountered this issue recently and is there a fix for this. We opened a ticket with Sungard and since we were not able to consistenly reproduce this issue we could not proceed. This is frustrating for our users and we not able to nail the problem down, any suggestions would be welcome. Thanks
group statistics
I am being asked to provide statistics on how much use is going on in our group shells, for example, how many course shells have been used in a specific term, how many links have been posted, documents posted, threads posted, etc,
has anyone got any suggestions for how to gather this data in a useful and meaningful way? I know I can pull how many groups have been created and last accessed but true activiy within the groups might be a bit cumbersome.
thanks.
Portlet Database Connectivity - Pooled Connection?
Can someone tell me how to get a pooled connection from within my portlet in Luminis IV?
java:/comp/env/jdbc/uPortalPooled ?
java:/comp/env/jdbc/campuspipeline ?
java:/comp/env/jdbc/sct ?
my tables are in the same database Luminis'
Thanks!
Person Event: SQL Trigger Code to fire
I need Banner to fire person events for some updates that it is currently not programmed to do. I've attached one of the triggers that I'm analyzing in order to figure out how to do this.
The logic makes sense to me, but I don't know what all the called stored-procedures actually do. Is this portion at the end:
icspkldi.p_save_person (pidm, action);
what actually fires the person evenet?
I'm going to run tests, but if any of you have done this before, please advise if this is correct, or if I'm leaving parts out.
GORRSQL - Validate Button
Adding a new role and my SQL performs great in Toad, but when I put it into GORRSQL and press the validate button, nothing happens (it will accept other sql though).
Somehow it doesn't like the sql, any idea on how I can get an error message so that I can actually see what it isn't liking?
thanks
How to Set Up a Luminis Automated Notification for the Group Request Queue: A Recipe
I just wrote a post on my personal blog about how to implement an automated notification system for use with the “Group Request Queue”.
Here's a snippet of that post (click on the link at the bottom to read the full post.):
JNDI
Does anyone have documentation on creating jndi connection pools in luminis 4.2. I have a number of channels that I would like to implement to pull data from banner and various other datasources.
Thanks in advance,
Brandon Farmer
Pop Cell Advice
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
Banner Channel Data
We have started to make many modifications to Banner channels (.car files). One in particular is the Time Reporting channel, as we are implementing Web Time Entry on our campus. Throughout the .car files for the Banner channels, there are references to '/CHANNELDATA/TXT'. Such as:
<xsl:variable name="time_sheet_txt" select="/CHANNELDATA/TXT/TIME_SHEET_TXT"/>
Can anyone here shed some light on where this actual CHANNELDATA can be found?
Thanks in advance.

Recent comments
3 hours 11 min ago
3 hours 14 min ago
16 hours 56 min ago
18 hours 19 min ago
1 day 16 hours ago
1 day 22 hours ago
1 day 22 hours ago
1 day 23 hours ago
2 days 16 hours ago
2 days 16 hours ago