1. How to create new subproject
2. how to setup Tool in application
Wednesday, November 24, 2004
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
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
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
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
Subscribe to:
Posts (Atom)