Wednesday, November 24, 2004

Wanted

1. How to create new subproject
2. how to setup Tool in application

Thursday, November 04, 2004

First DB of Oracle

DB creation completed. see C:\oracle\admin\test\create\createdb.log for details.

DB Info:
global db name:test
db system identifier(SID): test
INTERNAL account password:
SYS account password: change_on_install
SYStem account password:manager

Tuesday, November 02, 2004

WO- New Main Menu on the top(ToyotaNet)

CMS:
1. New role for Trainingnet (SIBUser and SIBRole)
2. Dynamic Menu -- SIBDynMenuType ---- TrainingNet
3. Primary Section --- TrainingNet
4. Story type ---- TrainingNet, SIBStory – nameForTrainingNetNews setup the welcome story first.
5. TrainingNet title image SIBPCImagetype
6. From All main Page:
TrainingNet link - >TrainingNetMain - >Story Editor and DynMenu Editor

ToyotaNet:

0. P_NavBar, Application event
1. TechTrainingAuthorisedComponent
2. TechTrainingNetDA( secondary,mainmenu, sub, tertiary, story,storyList)
3. TechTrainingNavBar
4. TechTrainingMain(Home)
5. TrainingNetNewsDisplay and TrainingNetTertiaryMenuList

WO -SIBDB-BrainsDealer changed SQL

For some reason they (re)create new dealer, need run this sql for some data

select sibid, dealerid from csifile where dealerid=38168672570002 or dealerid=36427939879009;
update csifile set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, dealerid from RingAroundReportData where dealerid=38168672570002 or dealerid=36427939879009;
update RingAroundReportData set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, brainsDealerCode, fullName, usercode from SIBUser where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update SIBUser set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;




select sibid, brainsDealerCode from DealerWiseLocation where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update DealerWiseLocation set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;

select sibid, brainsDealerCode from LexusDealer where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
no change