knowIT

Oracle and ID Works Set Up Process

ID Works Setup for UBCO Overview
Datacard ID Works is the desktop application used to create, issue, and print UBCcards. The ID Works app utilizes different project templates, called "Projects", to reference different card types. These Project files connect to separate databases on the back-end, depending on the type of card being produced (e.g. Student, Employee).
The setup of the application is a bit different on UBCO workstations, with the main differences being the database they connect to and the location of the project files.


Pre-Requisites:
i. The application installers reside within the UBCV Parking Services Teamshare. A ServiceNow ticket can be submitted (https://it.ubc.ca/got-question-about-it-products-and-support) to request a copy of the files
ii. The workstation will need a static or DHCP-reserved IP address, so it can be authorized access to the Oracle database residing on bis-oracard-prd.bis.it.ubc.ca, which is behind the firewall managed by UBC IT BIS.
iii. The account used to complete the setup needs to have local administrator access to the workstation
iv. “UBCO ID Works files.zip”, which contains a couple Oracle .ORA files and a .INI file for importing into the registry
v. The end user has access to network share where ID Works project templates reside (K:\)


Setup Instructions
Install Oracle Client 11GR2.
1. The installer resides within the UBCV Parking Services Teamshare. Run “setup.exe” within the following directory: \\files.ubc.ca\team\PASS\UBC IT\! Current\2 - Oracle\p10404530_112030_WINNT_3of6\client Choose Administrator Installation


2. Choose Skip Software Updates

If the following error pops up, just click Yes to continue


3. Keep English as selected Language


4. For UBCO, change the Oracle Base directory to C:\app


5. Review settings and proceed with Install


6. Copy the contents of the following folder: \\files.ubc.ca\team\PASS\UBC IT\! Current\2 - Oracle\OPatch_11.2.0.1.9
into C:\app\product\11.2.0\client_1\OPatch
7. Copy the following folder: \\files.ubc.ca\team\PASS\UBC IT\! Current\2 - Oracle\p16803774_112030_WINNT (patch 22) into C:\Windows\temp
8. Patch Oracle by launching Command Prompt as Administrator and running the following commands:
Set ORACLE_HOME=C:\app\product\11.2.0\client_1
Set Path=%PATH%;C:\app\product\11.2.0\client_1\OPatch
CD C:\Windows\temp\
CD “p16803774_112030_WINNT (patch 22)\16803774”
opatch apply
If the last command fails or errors out, you may need to copy the opatch folder within UBCO ID Works files.zip into c:\app\product\11.2.0\client_1\cfgtoollogs first, the run the last command again.
When prompted for email address/user name, type in a random email address and press Enter
When prompted for password (optional), just press Enter
If prompted for URL and/or Proxy, just type in NONE and press Enter
When prompted if local system is ready for patching, type “y” (without quotes) and press Enter
9. Copy sqlnet.ora and TNSNAMES.ORA from within UBCO ID Works files.zip
into c:\app\product\11.2.0\client_1\network\admin, overwrite any existing files
10. Double-click odbc.ini.reg from within UBCO ID Works files.zip to import its content into the registry. This will auto-create all the ODBC System DSN’s.


Install ID Works
Please ensure that you have a ID Works USB dongle handy in order to complete this setup.
1. The installer resides within the UBCV Parking Services Teamshare. Run “setup.exe” within the following directory: \\files.ubc.ca\team\PASS\UBC IT\! Current\6 - ID Works\ID Works 6.0


2. Follow the instructions accordingly


3. Enter ES65010056 as the product serial number


4. Choose Typical Installation


5. Choose to restart computer later and proceed with installation


6. Upgrade ID Works to 6.5 by running the installer found within \\files.ubc.ca\team\PASS\UBC IT\! Current\6 - ID Works\ID Works 6.5 upgrade


7. Confirm and proceed with Setup


8. When installation menu appears, choose Install Products


9. Click on Install ID Works software


10. Follow the instructions accordingly


11. Enter ES65010056 as the product serial number


12. Choose Typical Installation


13. Choose to restart computer now


14. After ID Works 6.5 has been installed, uninstall Sentinel Protection 7.3 and restart computer


15. After restart, install Sentinel Protection 7.5 from installer found within the UBCV Parking Services Teamshare:
\\files.ubc.ca\team\PASS\UBC IT\! Current\6 - ID Works


16. Update the permissions to the folder C:\Program Files (x860\Datacard\ID Works so that local users have Modify access to it

17. Launch ID Works Enterprise Administrator and log in


18. Go to System > Set System Paths

and update the Project Path to the following directory: K:\ADM\AVP Students\Shared\Student Services\Photo ID\IDWorks\Projects


Click OK and Exit out of ID Works Enterprise Administrator *NOTE* K:\i is where ID Works project templates reside for UBCO

 

Install Zebra Printer

  1. Launch the installer within the following directory in the UBCV Parking Services Teamshare: \\files.ubc.ca\team\PASS\UBC IT\! Current\7 - UBCcard_Printer

     


    2. Note: Make sure to pick the USB Printer Driver option then click Next


    3. Turn off Zebra printer before proceeding

     


    4. Enter UBC IT and UBC in the corresponding fields

     

     


    5. Turn printer on. Windows should automatically detect the device and install the drivers accordingly.

    If no printer installation prompt appears, you may need to manually remove USB Printing Support from Device Manager first (highlighted below). After that, unplug and plug the printer back into the PC and it should trigger the printer installation. The end goal is to have a Zebra ZXP Series 7 USB Card Printer entry appear under the Printers section (also highlighted below).


    Carding Office URL:
    https://carding-office.ubccard.ubc.ca/index
Attached Files (2)
Related Articles RSS Feed
How do I obtain access to the Microsoft Home Use Program (HUP) software?
Viewed 31653 times since Mon, Jun 8, 2015
How Do I Install Accuro for the DRC?
Viewed 9368 times since Thu, Oct 29, 2015
What is the process for replacing Xerox Copier Staples?
Viewed 10156 times since Fri, Nov 20, 2015
How do I check what my Copy/Long Distance PIN is?
Viewed 5263 times since Fri, Mar 4, 2016
Why is Backing up my Data Important?
Viewed 8232 times since Mon, Apr 18, 2016
How can I find the status of a Xerox printer repair?
Viewed 7486 times since Mon, Mar 12, 2018