Preparing Winprism for New Semester
Title : Preparing Winprism for New Semester
Location : Gordon College
Category : Gordon College\Banner
Problem Description :
Steps to setup Winprism/Bookstore Interface to Banner for new semester
Resolution :
Near end of semester, Bookstore & Business Office will request that the Winprism Interface be setup to handle Financial Aid disbursement for upcoming semester. The interface can only handle one semester at a time so be sure all transactions for current semester are complete (charging, book buy back, etc.).
1) Send in ITS ticket to helpdesk@usg.edu when bookstore requests to have it stopped. Below is a sample email...
Subject: Banner/Bookstore Interface Set up for Upcoming Semester (B760)
Description: Please stop the Banner/Winprism cron job for Gordon State College so that our Bookstore can close out the semester and set up the upcoming semester. After confirmation that the process has been stopped, I will let our bookstore know and then will send the new parameters for the upcoming semester. If you have any questions please let me know.
2) Bookstore side on POS server (WINPRISM) should be running. Do not have bookstore stop it.
3) Check the USG MFT site (https://files.usg.edu) under /ManagedServices/Gordon/Banner/B760/userdata/winprism for the Banner Winprism files named customer.dat and balance.dat. You will need to wait for POS server to download these files and remove them before proceeding to next step. Wait about 45 minutes after ITS stops the cron job to make sure these files are processed and removed. Then log into WINPRISM as NbcSupp user (168.26.240.22) via VMware console . Go to C:\transport. Find the latest receipt.dat file. Make a backup copy of it and rename .dat.old in C:\transport. then delete everything out of receipt.dat and save it,
4) After ITS stops the interface and the bookstore has completed the close out and set up the next term, reply back to the ITS ticket created in step #1 and ask them to edit the bookstore_parm.sql file and change the term and term_balance to the upcoming term. Also, ask them to change the start_date and end_date to dates given by bookstore. NOTE: The start_date MUST be after prior semester's end_date that was set for the inferface in bookstore_parm.sql!!! They also need to edit the insert_tbraccd.sql file to the new term in the “insert into tbraccd” section. The term is set in one place in that file. After these changes are made, they can start up the cron job again.
NOTE: copies of the 2 files are located on the network share at N:\csd\BANNER\Banner Hosting documents\bookstore-cron.
-----------------------------------------------
Example Email to helpdesk@usg.edu :
Subject: Banner/Bookstore Interface Set up for Upcoming Semester (B760)
The bookstore has now completed the Summer 2019 close out and the opening of Fall 2019 in Winprism.
Before starting up the Cron job for the Bookstore interface again, we will need to update the bookstore_parm.sql file parameters and one term code in the file insert_braccd.sql to reflect the Fall 2019 term.
Please replace the current bookstore_parm.sql and the insert_braccd.sql files used for the cron job with the attached files.
After these changes are applied, the cron job can be started again.
Let me know if you have any questions.
-----------------------------------------------
5) Once ITS starts the interface back with the new dates/term, check the USG MFT site (https://files.usg.edu) under /ManagedServices/Gordon/Banner/B760/userdata/winprism and see if the balance.dat file appears once cron job runs. You likely will need to refresh for several minutes before it appears.
Download the balance.dat before it gets picked up by WINPRISM.
You can also log into the WINPRISM server and locate the balance.dat file under c:\Transport. Copy it to the desktop and open it.
Open and write down a few students that have a balance.
6) Send them to the Bookstore manager to check them out in Winprism. You can also log intoWinprism as NbcSupp and then login as IT user to the Winprism admin console and check a few students yourself - go to Navigator- Accounting- Receivables- Customer Maintenance
OLD STEPS WHEN BANNER WAS NOT HOSTED
1) Login to pebbles as Banmgr . Go to the $BANNER_HOME/local/winprism directory and remove the file named process_all.lck. (rm process_all.lck) After running and sleeping for 10 minutes, the interface script checks for this file. If it exists, it runs again. If it doesn't exist, it does not run and exits. If it ask you a question about the empty file Y to proceed. LL to be sure it is gone.
2) Bookstore side on POS server should be running. Do not have bookstore stop it.
3) Check the /home/winprism directory for the Banner Winprism files named customer.dat and balance.dat. You will need to wait for POS server to download these files and remove them before proceeding to next step. Then Log into TWEETY via RDP (168.26.240.22) Go to C:\transport. Find the latest receipt.dat file. Make a backup copy of it and rename .dat.old in C:\transport. then delete everything out of receipt.dat and save it,
4) Remove ALL of the files from the /home/winprism/work directory . (Rm all files)
5) CD to $BANNER_HOME/local/winprism
6) Run the SQL script bookstore_cust_file2.sql as baninst1. (sqlplus baninst1/(password) enter then (start bookstore_cust_file2.sql) to create file c0000002.001 which is the list of bad check students. Creates file in
/home/winsprism/work
7) Copy file - cp c0000002.001 /home/winprism/customer.dat - cd up a directory /home/winprism and check that new customer.dat file is there.
8) Login as root and cd to /home/winprism (chown winprism:ban customer.dat) set owner to winprism and group to ban.
9) chmod 770 customer.dat (Set permissions to 770). LL to check to see when it is removed. Wait for POS server to process and remove the customer.dat file.
10) Exit back to banmgr user and then from $BANNER_HOME/local/winprism Edit the bookstore_parm.sql file and change the term and term_balance to correct term. Change the start_date and end_date to dates given by bookstore. NOTE: The start_date MUST be after prior semester's end_date that was set for the inferface in bookstore_parm.sql!!! Make these changes in VI
11.) In same place Edit the insert_tbraccd.sql file to correct term in the “insert into tbraccd” section. (use VI) Edit the term in one place
12) SU to root and run crontab -e to edit root's crontab list. Locate command where /gdn01/prodhome/local/winprism/process_all.shl is executed. Change the #sign entry - remove the # to turn it on entry to re-kick off command.
Example to run at 10:55 on 5/12: 55 10 12 5 * /gdn01/prodhome/local/winprism/process_all.shl
13) CD to /home/winprism and check for balance.dat file once cron job runs. Do a more on balance.dat and write down a few students that have a balance.
14) Log in to Tweety and then login as IT to Winprism admin and check a few students - go to Navigator- Accounting- Receivables- Customer Maintenance15) Let it run through cycle and have bookstore check their system.
Revision Date : 12/11/2019
Keywords : banner, winprism, bookstore, interface