Banner External System Username Length
Thu, 2007-04-05 12:07 — christittle
Our school is fairly new to the banner environment. We're having problems with Banner external system username max length being 8 characters mainly because we're populating Luminis with that username and it needs to be more like 30 characters. Could someone give me a detailed explanation as to how to increase the maximum length of the external system username in Banner?
Thanks!
Christopher Tittle
Cleveland State Community College
We wanted the same thing -
We wanted the same thing - here's what we did. Since the external user name is generated in goktpt1.sql in function F_Generate_External_User, we modified the sql code in F_Generate_External_User from (not sure what version of Banner this came from .. 7 something)
WHILE new_userid = F_CHECK_EXTERNAL_USER(pidm, new_userid)
LOOP
counter := counter + 1;
if counter < 10 then
new_userid := substr(orig_userid,1,7)||TO_CHAR(counter);
elsif counter < 100 then
new_userid := substr(orig_userid,1,6)||TO_CHAR(counter);
elsif counter < 1000 then
new_userid := substr(orig_userid,1,5)||TO_CHAR(counter);
elsif counter < 10000 then
new_userid := substr(orig_userid,1,4)||TO_CHAR(counter);
else
new_userid := substr(orig_userid,1,3)||TO_CHAR(counter);
end if;
END LOOP;
and modified it to
WHILE new_userid = F_CHECK_EXTERNAL_USER(pidm, new_userid)
LOOP
counter := counter + 1;
if counter < 10 then
new_userid := substr(orig_userid,1,28)||'0'||TO_CHAR(counter);
elsif counter < 100 then
new_userid := substr(orig_userid,1,28)||TO_CHAR(counter);
elsif counter < 1000 then
new_userid := substr(orig_userid,1,27)||TO_CHAR(counter);
elsif counter < 10000 then
new_userid := substr(orig_userid,1,26)||TO_CHAR(counter);
else
new_userid := substr(orig_userid,1,25)||TO_CHAR(counter);
end if;
END LOOP;
just increasing the number of characters the substr() function looks at. This gives us a 30 character userid in Luminis.
Usernames
Where are you storing your usernames? If you are storing them as alternate ID's in spriden you will be very limited. We opted not to store them there. gobtpac_external_user (Third party ID on banner forms GOATPAC/GOATPAD) stores the name that is used for Luminis integration via the LDI. Its limit is 30 characters. It looks like Banner is moving towards using a new fiewld--gobtpac_ldap_user which is 255 characters--but they are not quite there yet.
Banner External User Length
Function F_Generate_External_User in Package GOKTPTY needs to be customize for your instituiton.