|
|
Quick install Guide to Desktop Tools (GODDTOP) & Spreadsheet Budgeting
Views: 9184 Created: 2017-01-28 03:41 Last Updated: 2019-03-22 20:27 |
|
|
Update Banner forms Grant modify access to Banner form GODDTOPGORDSEC - Needs Add in Code 'Budget' for each Wizard Name requested. DOWNLOAD, VALIDATION, and DOWNLOAD. Finance department should approve.
Ellucian: 000022323 - CMS-4712:
Quick install guide to Desktop Tools (GODDTOP) and Spreadsheet Budgeting
Enhancement
Issue: Quick install guide to Desktop Tools (GODDTOP) and
Spreadsheet Budgeting Enhancement
-----------------------
Resolution: FAQ #1-6BF-794 - #4712 -
This FAQ is designed to provide a quick reference guide and steps to installing
Desktop Tools (GODDTOP) and Spreadsheet Budgeting Enhancement.
For more detailed instructions and debugging info please see FAQ 1770 posted to
ActionWeb
"How can I learn about (GODDTOP) Desktop Tools Application and Spreadsheet
Budgeting Enhancement?"
First obtain latest BANNER_HOME/general/desktop/goddtop.exe (~15M) install
software
Banner 7.x/6.x - goddtop.exe 5.4.0.1 - Deliver with Gen60 release
Steps to install on DBA machine
-------------------------------
1. Install Visual Basic v6.0, Excel, and SQL*NET (configured to access Banner
database) on DBA machine
2. Copy latest BANNER_HOME/general/desktop/goddtop.exe to c:\sct_temp
3. Launch c:\sct_temp\goddtop.exe
4. Click Next
5. Destination folder = C:\sct\banner\goddtop and click next
6. Check both
- GODDTOP Setup Application
- GODTTOP Source
7. Click next to install
8. Click Finish
9. Open c:\sct\banner\goddtop\source\GODDTOP.vbp in Visual Basic
10.Within Visual Basic locate Modules -- modSecurityRoutines
11. Find line
'g_objSecurityCollection.AddSecurityString "database name",
G_DESKTOP_NAME,
G_DESKTOP_VERSION, "SEED1", "SEED3"
12.Add a line like this under the above line
g_objSecurityCollection.AddSecurityString "PROD",
G_DESKTOP_NAME, G_DESKTOP_VERSION, "12345678", "87651234"
Where
database name is the TNS Connect string from TNSNAMES.ORA
SEED1 is the BANSECR.GUBIPRF_SEED1
SEED3 is the BANSECR.GUBIPRF_SEED3
Special note: a line starting with single quote ' is a comment line in Visual
Basic.
You must remove the single quote from the line in order to use Role Level
Security.
You can add as many database names and seed numbers as needed for your site
(SEED,PROD,TEST)
13.File--Save Project
14.File--Make goddtop.dll (Save goddtop.dll to C:\sct_temp)
15.Exit Visual Basic.
16.Open c:\sct\banner\goddtop\source\ToolsUpdate.vbp in Visual Basic
17.File--Make ToolsUpdate.exe (Save ToolsUpdate.exe to C:\sct_temp)
18.Exit Visual Basic
19.Move these 3 files to a file sever (Example \\server1\goddtop_install) to
allow
for future client machine installs
- C:\sct_temp\goddtop.dll
- C:\sct_temp\ToolsUpdate.exe
- C:\sct\banner\goddtop\setup\goddtop-setup.exe
20.You have finished DBA install of SCT Desktop Tools.
Steps to install on client machine
----------------------------------
1. Install Excel and SQL*NET (configured to access Banner database) on client
machine
2. Copy these 3 files from server (Example \\server1\goddtop_install)
to c:\sct_temp
- C:\sct_temp\goddtop.dll
- C:\sct_temp\ToolsUpdate.exe
- C:\sct_temp\goddtop-setup.exe
3. Run goddtop-setup.exe
4. Click next
5. Click yes
6. Destination folder = C:\sct\banner\goddtop and click next
7. Select "No" to dialog box "Do you want to update SCTDesktopTool.dll?
8. Select "Yes" to restart your computer.
9. Manually run C:\sct_temp\ToolsUpdate.exe
Target Directory= C:\sct\banner\goddtop\GODDTOP.DLL
New DLL Path= c:\sct_temp\goddtop.dll
Click OK
Special note: Error running ToolsUpdate.exe not finding DLL defect 70146
Additional steps to test client install
---------------------------------------
10. Create a user (TEST_GODDTOP) in GSASECR
- default role=BAN_DEFAULT_CONNECT
- enroll them in the BAN_GENERAL_C class (GODDTOP with BAN_DEFAULT_M)
11.Open Banner and go to form GORDSEC
- UserID = TEST_GODDTOP
- Add-In Code Wizard Name
BUDGET DOWNLOAD
BUDGET UPLOAD
BUDGET VALIDATION
- Save changes and exit form and Banner
12.Launch C:\sct\banner\goddtop\DesktopTools.xla
13.Excel should open and you want to enable Macros
14.From File menu select Banner -- Connect to Database
- User Name: test_goddtop
- Password: u_pick_it
- Database: PROD
15.It should connect with no errors and state in title bar
"Microsoft Excel - Connected to Banner: test_goddtop@PROD(1)"
16.You have now confirmed Desktop Tools can connect to Banner database
Steps to deinstall
------------------
1. Go to Start--Settings--Control Panel--Add/Remove Programs
2. Locate program "SCT Desktop Tools" and click
"Add/Remove"
3. Answer "Yes" to dialog box "Are you sure you want to
completely
remove 'SCT Desktop Tools' and all of its components?"
3. Delete the C:\SCT directory and anything inside.
4. Go to Start--Run = regedit
5. Locate HKEY_LOCAL_MACHINE -- SOFTWARE -- SCT and manually delete it
if it still exists.
6. Reboot machine and SCT Desktop Tools should now be removed.
Special Note:
If after deinstalling Desktop Tools you still have an "SCT Desktop
Tools"
entry in Start--Settings--Control Panel--Add/Remove Programs then please do
this
1. Go to Start--Run = regedit
2. Locate entry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\goddtop]
and manually delete it
3. Locate entry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\SCT
Desktop Tools]
and manually delete it
4. Reboot and you should no longer see the entries in Add/Remove Programs
===================
mtytler 13-FEB-2007
Last updated: 07/17/2009
Type : Solution
|
|
|