Command Line Parameter for Siebel Application

/c : Configuration file

/h : Debugger mode

/d : Default database.

/s : Spool

/u : UserId

/p : Password

Show More Button on List & Form Applets

Use the following Properties to Configure the Show More buttons on List and Form Applets :

Add the HTMLMinibutton on Applet and Configure the properties and you are done.

List Applet Show More Button
 -------------------------------------------------------
HTML Bitmap          : BTTNS_MORE
HTML Icon Map      : ToggleListRowCount
HTML Type              : Link
Method Invoke          : ToggleListRowCount
Name                        : ToggleListRowCount


Form Applet Show More Button
-------------------------------------------------------
HTML Bitmap          : BTTNS_MORE
HTML Icon Map      : ToggleLayout
HTML Type             : Link
Method Invoke         : ToggleLayout
Name                       : ToggleLayout

Increase User Connection on IIS Server

What is IIS Server ?

It is used to host webpages. When you type www.dotnetfunda.com, IIS is giving you those pages. it serves the pages you requested. So IIS is a webserver because it host and serve webpages.

Different Versions Of IIS Server :

Operating System	IIS Version
Windows Server 2008	IIS 7.0
Windows Vista - Home Premium/ Ultimate	IIS 7.0
Windows Server 2003	IIS 6.0
Windows XP Professional	IIS 5.1
Windows 2000 Server IIS 5.0	IIS 5.0

How to Increase the No Of Connections on IIS Server ?
Answer : Use the following command to increase the by 100 users.

C:\Inetpub\AdminScripts\adsutil   set    w3svc/MaxConnections 40

External Business Component Complete Integration

White Paper for External Business Component (SQL Server 2005)

1.  What is External BC and Its use?

External Business Component represents the Database Table structure of the other application into Siebel Application Architecture. External Business Component (EBC) is another way of integrating Siebel with External Applications. It is another tool available at your disposal to achieve integration.

EBC is one of the easiest ways to integrate your Siebel Application with External Database. Integration steps can easily remember on the finger tips.

There are three main steps to integrate your Siebel apps with External DB.

1)  Get the DDL File (Not mandatory) you can connect to database and import the table schema.

2) Import the Table Structure into Siebel Tools with (External Table Schema Import)

3) Create the New Data source in configuration file and Profile Parameter.

Steps:

• Get the DDL file containing the create table query of your external database table.

• Save this to text file and (Customers.txt)
• Import the Table structure into Siebel Tools.

Click Ok

Enter the Details as Mentioned in the Image

Select the details as above.

Click the finish button

Now create a Data Source for your table to point to External System.

Now Map the Siebel System ID field to External System ID field to maintain the integrity issue.

(Note: Considering all of you know how to create a BO, BC, Applet and View)

1) Now Create the Business Component on this Table our normal BC using the wizard.

2) Create the Applet On Newly Created Business Component.

3) Create a New BO and add the BC to it and configure the new View on this BO and applet.

%Siebel Installation Directory% BIN/ENU/uagent.cfg and add following section.

1)     Edit the uagent.cfg file to define your external Data Source

2)     Now configure your Server Data Source to define it.

3)     Login to Siebel Server with SADMIN/SADMIN

4)     Goto Administration - Server Configuration - Profile Configuration

5)     Query in a Subsystem name field  = InfraDatasources

6)     Copy record by Ctrl + B

7)     Enter the Following Details

Enter the New Record Details As follow

TestDS

TestDS

TestDS

TestDS

Change the following parameter values.

DSConnectString	TestDS
DSDLLName	Sscdms80.dll
DSPassword	[sql server password]
DSTableOwner	Dbo
DSUserName	[Sql server user name]
Click on Advance Button and Query
DSSQLStyle	MSSqlServer

Now Goto following View

Administration - Server Configuration – Component Definition – Parameter Configuration

Step1

Step2

Now Click the Synchronize button.

Restart the Siebel Server.

Open Database Connectivity Configuration with SQL Server

Step1

 Step2

      

Step3

Step4

Step5

Now finally Test all the changes.

SetNamedSearch Method

SetNamedSearch Method

How to use SetNamedSearch method in the Siebel eScript ?

Example:

If the Siebel Administration logs into Siebel application and click on the Contact Screen. It should only show the contacts who’s contact method is E-mail.

For this requirement we can use SetNamedSearch method in Business Component script.

Note:  This requirement is only for [Visible Contact List View].

1. Login into Siebel Tools with SADMIN/SADMIN connecting for Sample database.
2. Click on the Business Component in the Object Explorer.
3. Query for a Contact Business Component and Lock the project.
1. Use [ Alt + L ] to lock the project.
4. Right click on the Business Component and Click on the Edit Server Script.
5. Locate the following method. [BusComp_PreQuery ]
6. Now write the following script to implement this requirement.

function BusComp_PreQuery ()

{

        TheApplication().TraceOn("D:\Setname.txt","Allocation","All");

       

        if(TheApplication().GetProfileAttr("Position") == "Siebel Administrator")

        {

                        TheApplication().Trace("Inside f Block");

                        this.SetNamedSearch("EmailContacts" , "[Preferred Communications] = 'E-Mail'")

        }

        TheApplication().Trace("View Name : " + sActiveViewName);

        TheApplication().Trace("Position Name : " + TheApplication().GetProfileAttr("Position") );

       

        TheApplication().TraceOff();

        return (ContinueOperation);

}

Explanation:

This.SetNamedSearch(ExprName, “[fieldname] optr ‘value’ ”);

7. Compile the BC and Test.

Default Focus User Property in Siebel

Default Focus user property is used to put  default focus on specific column of an list applet. We recommend reading article  Introduction of Default Focus user property before going through the details of three user properties under DefaultFocus Applet user property in Siebel.
There are three user properties to set the default focus in siebel.


1. DEFAULTFOCUS_EDIT              
2. DEFAULTFOCUS_NEW           
3. DEFAULTFOCUS_QUERY

Hide an Applet through Personalization

1. Requirement

Hide the Account List Applet & Account Entry Form Applet based on the user’s responsibility.

2. Login into Siebel Application and Navigate to Administration - Personalization > Applets

3. Create a New Record in the List Applet Window with following details :

            Applet Name: SIS Account List Applet

Conditional Expression: InList("Business Analyst", GetProfileAttr("User    Resposibilities"))

Applet Name: SIS Account Entry Applet

Conditional Expression: InList("Business Analyst", GetProfileAttr("User    Resposibilities"))

4. Click Applet Menu to Reload the Personalization.

5. Now Login and Test the Personalization settings.