Siebel eMail integration : Part Four, Reading a SR Number from Email Subject

In previous Post we read subject of Mail using Inbound Email Manager GetTokens methood and sent Help Template in return,
In this post we will configure our process to read Subject and perform certain Operations.

• Status(Query)
• Submit(Create)
• Update
• Delete

lets take example for Searching a Service Request.

Let us suppose the sample subject is on format,

Subject : STATUS SR#

Approach : since we have to read the subject that has status keyword and SR# we need to get the fetch their values. We will use BS Inbound Email Manager and GetTokens method, since there are two words in Subject we will have to pass NumOfToken as 2 in input and get SR number in Output

Output,

here Service Request Number process property will contain the value of SR Number. Which we will pass further to query SR in database.

Query SR,

only task now left is sending Mail with the required details we fetched using above step.

For more details refer workflow  "eMail Response - SR Status"

sample Email, 

Template can be modified as per requirement ..Hope this was helpful .

<--Previous Post-->                                       <--Next Post-->

Siebel eMail integration : Part Three, Reading a Mail and sending reply

In this Post i will explain setup of Response Mail in reply to an incoming mail.

Goal : Configure a Template to return the user with the Help template listing the right steps of using the Functionality and correct template syntax.

We can use the Vanilla workflow eMail Response - Process Service Request for configuring this ..

Some Important BS used in the Process:

More details about the BS is available on Bookshelf

• First step is to read the workflow and understand what does we require from it, it contains certain validations and checks on Email , Organization.

• Extract the required fields using Workflow Utility BS, we require these fields for further processing.

Sender's Email

Subject

Body

Receiver's Profile

Time etc..

• Call Sub Process based on subject keyword, In this case we are calling HELP sub process to send us help template.

Finally define the action to be done in Sub Process.

Here we are sending back mail to the recipient from which we received mail. Refer this to understand how to send mail using workflows.

Working Sample Mails :

Incoming Mail: 

Response Mail :

Hope this was helpfull,,, keywords can be setup as per your choice... 

<--Previous Post-->               <--First Post-->         <--Next Post-->

How to enable Server Component in Siebel

Hello All,

Many times we have to enable particular server components which we generally do not use. Recently was setting up Siebel Email Inegration but Siebel Communication components were not enable on Server.
So i had to enable the component Group and Synchronize it to make them available for use.

1. Navigate to Admin Server - Configuration

2. In component group search for the particular component group










Click on Enable Button and verify the state is Enabled

3. Under components verify for each components Enabled on Server flag is checked in Component Assignment Group Applet.

4. Once Verified, Navigate to Synchrionize Tab and select the required component and click Synchronze button

Restart Siebel Enterprise Server and Gateway Name Server ... Components will now be available under component view in Administration - Server Management.

Siebel eMail integration : Part Two, Monitoring a Mailbox

for better understanding of siebel email integration lets know some important server components.

Siebel Communication Components

Communications Session Manager (CommSessionMgr): Used with CTI/Voice Integration

Communications Configuration Manager (CommConfigMgr): Used with CTI/Voice Integration

Communications Inbound Receiver (CommInboundRcvr): Receives inbound work items and, in some deployments, queues them for processing by Communications Inbound Processor. Work items can include email messages (for Siebel Email Response).

Communications Inbound Processor (CommInboundProcessor): For deployments of Siebel Email Response supporting nonreal-time work items, this component processes inbound work items that were queued by Communications Inbound Receiver.

Communications Outbound Manager (CommOutboundMgr): Processes outbound communications, for email, fax, wireless messages, or page channels. Supports communication requests, whether directly or through Siebel Workflow. Responsible for Sending Mails Notification

Page Manager (PageMgr): Used to send pages by the Send Page command.

Email Manager (MailMgr): Used to send email by some workflow processes in Siebel Workflow.

these components are a part of Communications Management component group, for Siebel Email Integration we require these components to be online.

First step is to enable the Communications Management component group ,synchronize the components, restart Siebel servers(Enterprise and gateway both) and verify the components are Online. Please refer the post to enable these components

Next step is Configuring Siebel to Monitor a Mailbox,

In this setup we require

1. Mailbox (POP Enabled)
2. CIP (Communication Inbound Processor)
3. CIR (Communication Inbound Receiver)
4. Response Group 
5. Communication Profile (already created in Previous post)

Response Group, is responsible for defining the Mailbox to monitor and the workflow to call that will read and process the mails.

1. Navigate to Administration -- Communication, All Response Group and provide the Name, Service Name as workflow Process Manager and Status as Active.

     2. Define the Profile we created in Previous step and verify Mailbox details

    3. Provide Input arguments, Generally the name of workflow that reads and processes the mails.

after defining the Response group Active it and Submit Response Group Changes.

Now verify the configuration by sending Test mail to mailbox, it should be read by CIR, and should be automatically removed from mailbox.
This can also be verified from /SBA_81/siebsrvr/bin/incoming folder where the processed emails are temporarily stored.
Hope this was helpful, comments are always welcome :-).

<-- Previous Post -->                                                   <--Next Post-->

Siebel eMail integration : Part One, setting communication profile

Hello All,

In this series i will explain Siebel Email Management and related concepts, Profiles, Outbound Components, Inbound Requests.

Siebel Supports 3 types of communication. 

1. Session-based or interactive communications. Through Siebel CTI and CTI middleware products. 

2. Inbound communications. Supports integrating to third-party email servers and processing

inbound email, for Siebel Email Response deployments. For more information, see Siebel Email

Administration Guide.

3. Outbound communications. Supports integrating to a variety of third-party communications

systems such as email servers to send outbound communications. For more information, see

Siebel Email Administration Guide.

we will cover the 2nd and 3rd section in this series.

Defining/Setting Communication Profile, 

The first step to setup any commuication process is defining a communication profile, where we provide POP, SMTP, Port details.

POP :Post Office Protocol version 3 (POP3) is a standard mail protocol used to receive emails from a remote server to a local email client

IMAP :The Internet Message Access Protocol (IMAP) is a mail protocol used for accessing email on a remote web server from a local client. 

While the POP3 protocol assumes that your email is being accessed only from one application, IMAP allows simultaneous access by multiple clients. This is why IMAP is more suitable for you if you're going to access your email from different locations or if your messages are managed by multiple users.

SMTP :Simple Mail Transfer Protocol (SMTP) is the standard protocol for sending emails across the Internet.

Ports :Port on which SMTP, POP listen the incomming/outgoing requests

110, POP

995 , POP (SSL/TLS)

25, SMTP

587, SMTP(SSL/TLS)

Steps to setup communication profile

1.Navigate to Administration -- Communication , Communication Profile view 

2.Under Profile View Provide the required Details 

deafult port for SMTP is 25 and POP is 110, so you do not need to explicitly provide those unless mailbox is some addition configuation of TLS or SSL.

3.POP server is required when you require inbound communication i.e. Monitor a mailbox 

for outbound communication only SMTP server is required i.e. server to send emails

4.After the details are provides Reload Communication Profile and test.

Hope his was helpful... In next post i will explain how to read a Particular Mailbox using siebel communication components i.e. CIP (Communication Inbound Processor) and CIR (Communication Inbound Receiver). 

Any suggestions are always welcome :-) ..

                                                                                                       <-- Next Post -->

Error when trying to Change Login from Employee Screen,operation is not supported by your security adapter (SBL-DAT-00567)

Hello All,

One of my colleague recently showed me a strange error "The requested operation is not supported by your security adapter. Please contact your system administrator if you feel the operation should have been supported.(SBL-DAT-00567)" , he got the error when trying to change login Name in employee screen for a user.

At first i was clueless about what this error could be then i delineate the behavior and analysed why was it appearing.

The reason is very clear, There are two type of authentication in Siebel, Database and LDAP with LDAP authentication this issue was not observed. This was appearing for Database only, the reason is setting of database security adapter(DBSecAdpt) PropagateChange parameter to TRUE.

PropagateChange parameter when set to true propagates the changes to Database as we have functionality to change password for Siebel directly from Profile option (http://www.siebelfoundations.com/2015/08/changing-login-password-in-siebel.html).
So when this parameter set to true and user tries to change the Login Name it tries to Propagate the changes to database or basically it tries to alter the user name which is not allowed.
Hence the error pops up.

This is my understanding of the behavior, any clarification welcomed :-) ...

Automating User Creation in Siebel

Hello All,

This is very basic requirement where you want some process to create users in Siebel directly and you do not have to create them manually in database.

Let me describe the working scenario for this.

There are two types of Authentication in Siebel

• Siebel Database Authentication 
• Siebel LDAP/ADSI Authentication 

for LDAP authentication user need not to be present in siebel database only a record in Employee screen with a Login name is sufficient to access siebel but for Database authentication user has to be there in siebel database (DBA_USER) also along with Employee table.

So creating a user for DB based Access requires two steps configuration, creating user in Employee screen and other in Database.

Recently i had this requirement to automate the User Creation so that each time  need not create the user in database it is created automatically when entered in application.

Approach is pretty simple, combination of  Run Time Event and Script served my purpose.

Steps:

• Create a RTE base on User/Employee Business Component on WriteRecord event
• Create a Action Set to call Business Service, passing Current Record's Id as input 
• Write a Server Side BS (Why not client side? because of changes in Siebel Security model read this for more details http://www.siebelfoundations.com/2016/05/unable-to-access-file-system-using.html)

RTE :

Create a Event based on Employee BC

Set ID of the record as Profile attribute to be used in Business Service

Call Business Service

Sample Business Service Code ;

This Code creates the user and password with LOGIN NAME in Database by calling shell file.

shell file code :

echo "In Shell File"

sqlplus SIEBEL/SIEBEL@DATABASE @/u01/SBA_81/siebsrvr/UserCreation/User.sql $1

exit;

this shell file in turn calls User.sql file to run create user command.

Sql Code :

create user &1 identified by &1;

grant sse_role to &1;

commit;

exit;

Hope this was helpful .. for any queries or script please contact me ..

Referal opening for web developes in top IT companies

Hello All,

please share it with your colleagues/friend/contacts with experience in web developement.

Referal opening for web developes in top IT companies ,please inbox me your updated profile and contact details at rahulymca007@gmail.com

Web Developer Job Duties - Web developer responsibilities include building our website from concept all the way to completion from the bottom up, fashioning everything from the home page to site layout and function.

 Responsibilities

 1. Write well designed, testable, efficient code by using best software development practices
 2. Create website layout/user interface by using standard HTML/CSS practices
 3. Integrate data from various back-end services and databases
 4. Gather and refine specifications and requirements based on technical needs
 5. Be responsible for maintaining, expanding, and scaling our site
 6. Stay plugged into emerging technologies/industry trends and apply them into operations and activities
 7. Cooperate with web designers to match visual design intent

 Requirements

 1. Proven working experience in web programming
 2. Top-notch programming skills and in-depth knowledge of modern HTML/CSS
 3. Familiarity with at least one of the following programming languages: PHP, ASP.NET, Javascript or HTML
 4. A solid understanding of how web applications work including security, session management, and best development practices
 5. Aggressive problem diagnosis and creative problem solving skills
 6. Strong organisational skills to juggle multiple tasks within the constraints of  timelines and budgets with business acumen
 7. Ability to work and thrive in a fast-paced environment, learn rapidly and master diverse web technologies and techniques.

 please inbox me your updated profile and contact details at rahulymca007@gmail.com