MOSS 2007: Post Reminder

Sorry...just need a place to remind myself to post some few stuffs out:

1. Lookup - calling data from other site's list. e.g: dropdown list.
2. Inner Join lists by using SharePoint Designer.
3. Creating Data View.
4. databinding when saving by using SharePoint Designer.
5. Linked Source in SharePoint Designer.
6. Insert data view in web part
7. Installing SQL Report Services

MOSS2007: Backup and Restore Web App

Backup

1. Start > run > cmd

2. cd "C:\Program Files\Common Files\Microspoft Shared\web server extensions\12"

3. stsadm -o backup -url http://sharepoint2007:115/ -filename c:\backupssp115.dat

4. If successful this message will appear: Operation completed successfully.

Restore

1. goto Central Administration > Application Management > Create or Extend Web Application > Create A New Web Application > .....

2. After webapp being created goto Start > run > cmd

3.cd "C:\....12..hives"

4. stsadm -o restore -url http://sharepoint2007:115 -filename c:\backupsp115.dat -overwrite

5. If successful this message will come out: Operation completed successfully.

MOSS 2007: 10 New Themes From Microsoft

http://www.sharepointhq.com/

http://bloggingabout.net/blogs/bas/archive/2009/03/24/10-new-sharepoint-themes-released-by-microsoft.aspx

http://blog.drisgill.com/2009/03/microsoft-released-10-new-sharepoint.html

MOSS 2007: Installing Helpdesk Template

I tried to install this few times and finally I got the idea of installing it...

1. We have to install: ApplicationTemplateCore.exe to your sharepoint server. You may download it here. Click the exe file and extracted the file to a respective folder. A file called ApplicationTemplateCore.wsp will be extracted to that folder. You may refer to the visual steps from my previous post.

2. Open command prompt and do this:

• stsadm -o addsolution -filename \ApplicationTemplateCore.wsp
• stsadm -o deploysolution -name ApplicationTemplateCore.wsp -allowgacdeployment -local
• stsadm -o copyappbincontent

...it should appear like this...

3. Next we install: HelpDesk.exe that can be downloaded from here. Again click the exe file and extracted the file to a respective folder. A file called HelpDesk.wsp will be extracted to that folder. You may refer to the visual steps from my previous post.

4. Open/Proceed with the command prompt and do this:

• stsadm -o addsolution -filename \HelpDesk.wsp
• stsadm -o deploysolution -name HelpDesk.wsp -allowgacdeployment -local
  

5. How to check whether the files have been deployed?

• goto Start > All Programs > Microsoft Office Server >Sharepoint 3.0 Central Administration
• Click the Operation Tab
• Click Solution Management under global configuration.
• Check under Deployed To header. If it states Globally Deployed...then type iisreset in your command prompt.
• close your Central Administration Page..then reopen it back.
  

Oracle 10g: New Instance.

After creating a new instance into our machine. Below basic items must be done before data can be stored.

1. Create Tablespace

• create tablespace [tablespacename] datafile [path] size [size];
  

2. Create User

• create user [username]
  identified by [password]
  default tablespace [tablespace]
  temporary tablespace temp;
  

3. Granting Rights

• grant create session to [user];


• grant create table to [user];


• grant create view to [user];


• grant create sequence to [user];


• grant create procedure to [user];
  

4. Grant All Privileges..[make sure to connect as the sysdba of the instance]:

• conn system/system as sysdba;
• grant all privileges to sa;

Oracle 10g: Database Connection via SQL*PLUS

1. Open a command prompt.
2. To open SQL*PLUS console..do this..:

• set oracle_sid=[instance/database]
• sqlplus /nolog
  

3. Then...[I just created my table ..therefore I am logging in as sysdba]:

• conn [username]/[password] as sysdba
  

4. There you go..You are connected!

MOSS 2007: Installing Templates

Where to start? I started by downloading a MOSS template called SiteAdminTemplate from this site.

A. Uploading templates to your server.

...unzip downloaded EXE file to any folder...

...2. u'll see a lot of *.stp files and *.wsp files

3. goto Start > All Programs > Microsoft Office Server >
Sharepoint 3.0 Central Administration...goto Site Actions > Site Settings..

..4. click Site Templates from Galleries..

..5. Click Upload > Upload Multiple Documents..

..6. Select All downloaded files [stp and wsp]..

..7. Progress bar will pop up...

..8. All selected files will be appeared as Site Template Gallery..

B. Create New Project By Using Templates

..1. goto Site Actions > Site Settings..

..2. goto Sites and Workspaces under Site Administration..

..3. Fill up New Site information...
After files being uploaded a new tab called 'Custom' will be appeared...
..Choose any template that you reckon..

...4. Automatically files being created...

ok guys..that will be the 'GUI' way of doing it..I shall test out the command prompt installation any sooner than today....

I went speechless

Damn...as I arrived at the training center..plus felt so DBA at that time...sweating..but yet excited...someone reached me..saying...- 'I'm so sorry..but your name is not in the list..you are not being registered'...WHAT??????

waited for nearly 45 minutes...sweating...tensed...I just went speechlessss...yup there we go again...my excitement flushed into the toilet!....

called the HR manager..and he said..the company is pulling back the budget for the oracle training..and they are planning to send me for the .NET certification...oh god..oh dear...not again..my body shivered..this happened last year..and its happening again...

started googling...i kept on thinking...and searching...don't we have good market for oracle here in Malaysia?...OR...am i wanting it so much...that makes it real hard to get?

Today Will Be IT!

...today will be my first day of attending the Oracle 11g administration class..Mind setting of the day: I AM A SPONGE....Talked to some experts on this matter...no matter how many courses we attend...the experiences and the skills are so needed in this field rather than a piece of paper..

Okay..got if chief!

Today I Learn MOSS 2007

..Next..I present you...the 'Search Page'...Built in less than 15 minutes!...