Pennsylvania banner users group 2006
Download
1 / 17

Pennsylvania BANNER Users Group 2006 - PowerPoint PPT Presentation


  • 63 Views
  • Uploaded on

Pennsylvania BANNER Users Group 2006. Staff Directory on the Web. General Announcements:. Please turn off all cell phones/pagers If you must leave the session early, please do so as discreetly as possible Please avoid side conversations during the session

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Pennsylvania BANNER Users Group 2006' - kuame-hancock


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Pennsylvania banner users group 2006

Pennsylvania BANNER Users Group2006

Staff Directory

on the

Web


General announcements
General Announcements:

  • Please turn off all cell phones/pagers

  • If you must leave the session early, please do so as discreetly as possible

  • Please avoid side conversations during the session

  • Questions will be answered at the end of the session

    Thank you for your cooperation


Contact informatin
Contact Informatin


Primary goal
Primary Goal

  • To provide a comprehensive staff directory with photographs.


Issues
Issues

  • What data to display?

  • Storage vs. Speed

  • What language to use?

  • What framework to use?


Accomplished so far
Accomplished So Far

  • Created a view to supply the data elements

  • Use of Oracle Intermedia 10g

  • Opted for speed

  • Language – Java

  • Framework – Struts


What happened
What Happened

  • Had base code written in Banner6/Oracle 9

  • Tried to import images in Oracle 10 – errors

  • Oracle 10 does not seem to handle BLOBs

  • Needed to migrate everything to Ordimage


Data supplied via view
Data Supplied via View

  • Column Name ID Data Type Null

  • STAFF_PIDM 1 NUMBER (8) N

  • STAFF_ID 2 VARCHAR2 (9 Byte) Y

  • STAFF_NAME_LFMI 3 VARCHAR2 (120 Byte) Y

  • STAFF_NAME_FMIL 4 VARCHAR2 (120 Byte) Y

  • ROOM 5 VARCHAR2 (30 Byte) Y

  • CAMPUS 6 VARCHAR2 (20 Byte) Y

  • PHONE_NUMB 7 VARCHAR2 (8 Byte) Y

  • PHONE_EXT 8 VARCHAR2 (4 Byte) Y

  • ECLS_CODE 9 VARCHAR2 (2 Byte) Y

  • DIVISION 10 VARCHAR2 (30 Byte) Y

  • DICD_CODE 11 VARCHAR2 (3 Byte) Y

  • TITLE 12 VARCHAR2 (30 Byte) Y

  • PREF_EMAIL 13 VARCHAR2 (90 Byte) Y

  • HACC_EMAIL 14 VARCHAR2 (90 Byte) Y


Image xfr table
Image_Xfr_Table

  • Column Name ID Pk Null? Data Type

  • ID 1 1 N VARCHAR2 (20 Byte)

  • IMG 2 Y ORDIMAGE

  • PIDM 4 Y NUMBER


Gztpoto table
GZTPOTO Table

  • Column Name ID Pk Null? Data Type

  • GZTPOTO_PIDM 1 1 N NUMBER

  • GZTPOTO_IMAGE 2 Y ORDIMAGE

  • GZTPOTO_ACTIVITY_DATE 3 N DATE

  • GZTPOTO_USER 4 N VARCHAR2

  • GZTPOTO_THUMB 5 Y ORDIMAGE

  • GZTPOTO_STATUS 6 Y VARCHAR2


Processing steps
Processing Steps

  • Copy images to UNIX directory

  • Java code to read the file names into a table

  • Procedure to load images & set image properties

  • Procedure to resize images & store

    • fixedscale= 192 240

    • fixedscale= 96 120

  • Cleanup


The java code
The Java Code

  • CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED HACCINST1."DirList“ AS

  • import java.io.*;

  • import java.sql.*;

  • public class DirList

  • {

  • public static void getList(String directory)

  • throws SQLException

  • {

  • File path = new File( directory );

  • String[] list = path.list();

  • String element;

  • for(int i = 0; i < list.length; i++)

  • {

  • element = list[i];

  • #sql { INSERT INTO DIR_LIST (FILENAME)

  • VALUES (:element) };

  • }

  • }

  • }


Loading the images
Loading the images

  • INSERT INTO IMAGE_XFR_TABLE VALUES(

    image_id,

    ORDSYS.ORDIMAGE.init('FILE','IMAGEDIR',filename),

    NULL);

  • SELECT img INTO myImage FROM IMAGE_XFR_TABL

  • WHERE ID = image_id FOR UPDATE;

    --- we import the image into the table using a buffer (ctx).

  • myImage.import(ctx);

    --- we do a setproperties on the object which sets the

    --- attributes of the object such as mimetype from the metadata in

    --- the image file.

  • myImage.setproperties();

  • UPDATE IMAGE_XFR_TABLE

  • SET img=myImage WHERE ID=image_id;


The move code
The Move Code

  • PROCEDURE move_photo(pidm in number, initialImage in ORDSYS.ORDImage)

  • IS

  • myNewImage ORDSYS.ORDImage;

  • myThumbnail ORDSYS.ORDImage;

  • tempImage ORDSYS.ORDImage;

  • BEGIN

  • INSERT INTO gztpoto(gztpoto_pidm,gztpoto_image,gztpoto_activity_date, gztpoto_user, gztpoto_thumb, gztpoto_status)

  • VALUES(pidm, ORDSYS.ORDIMAGE.init(), trunc(sysdate), USER, ORDSYS.ORDIMAGE.init(),NULL);

  • SELECT gztpoto_image, gztpoto_thumb

  • INTO myNewImage, myThumbnail from gztpoto

  • WHERE gztpoto_pidm = pidm

  • FOR UPDATE;

  • tempImage := initialImage;

  • tempImage.processcopy('fileFormat=JFIF fixedscale= 192 240', myNewImage);

  • tempImage.processcopy('fileFormat=JFIF fixedscale= 96 120', myThumbnail);

  • UPDATE gztpoto SET gztpoto_image = myNewImage,

  • gztpoto_thumb = myThumbnail

  • WHERE gztpoto_pidm = pidm;


Needs to be done
Needs to be done.

  • Figure out how to display the images

  • Finalize new code

  • Migrate JSP’s to Struts

  • Migrate Guard-Card database to Oracle

    • Create triggers to move information

    • Create Scripts to copy & resize photos

  • Archiving images(5 year plan)


Pennsylvania banner users group 20061

Pennsylvania BANNER Users Group2006

Questions?


Pennsylvania banner users group 20062

Pennsylvania BANNER Users Group2006

Have a great day!


ad