How to Import CSV data in Siebel

Import CSV data in Siebel as following:-
To add data from menu item
Popup applet should browse for csv file
Popup Applet will pass csv file path to business service. Which will call the workflow
to Create IO. Workflow will call read csv BS and then insert data using EAI siebel adapter business service

1.Create popup applet of class CSSWEFRImpExp.
Create Applet method menu item on applet where import option should be available
Command : Import
Menu Text:Import
Create new command with following properties :-
Name:Import
Method:GotoApplet
Method Argument:Name of popup applet
2.Use following applet user properties of popup applet :-
Property Name :Import business service; Value:Copy of Workflow Process Manager Business Service(ref step 3)
Property Name :Import Method ; Value: RunProcess
3.Make Copy of Workflow Process Manager Business Service
Add Business service user prop
ProcessName : Name of workflow which will make use of read csv BS
4.Create Integration Object and Integration Component Corresponding to entity being imported
5.Give appropriate user key
6.Create Workflow
7.Add start step
8.Add new step for Business service Name:Read CSV File Method:CsvToPropSet
Input Property :FileName
Output Property :SiebelMessage
Note that filepath will be transferred from popup applet to business service to workflow user property with name "FileName"
9.Add new step for Business service Name:EAI Siebel Adapter Method:Insert
Input Property:SiebelMessage
10.Add new step for end
11.Make suitable provision for error handling.

Note : CSV file should be in the following format
Line 1 : # Integration Object Name
Line 2 : # "Integration Component Name.Column Name1",Integration Component Name.Column Name2 and so on
Line 3 : data 1
Line n : data n

Now you are ready to import records in siebel from csv file that too without writing single line of script

Automation Anywhere : How to send Auto Email

Automation Anywhere Application: The following configuration required to send Email.  The is only for knowledge purpose only.


1. Go to 
               Tools > Options

2. Go to
              File> New > Task Editor

Place the following code in Task Editor

for testing purpose we can hard code the values like:

Signature Capture in Siebel

Below are the steps

1.       Unzip the file iTools.cab present in the folder - e.g: C:\Siebel\15.0.0.0.0\Client\PUBLIC\enu\23048\APPLETS and extract cicink.ocx file.

2.       In the cmd prompt, run the command regsvr32 e.g: C:\Siebel\15.0.0.0.0\Client\PUBLIC\enu\23048\APPLETS\cicink.ocx

3.       We will get a message as file registered successfully

4.       Created the applets “Account Signature Capture Applet” and “Account Signature Render Applet” based on the specialized class.

5.       Created a field “Signature” of type DTYPE_CLOB in Account BC and same was mapped in the applets

6.       Modified the view “Account List View” to add the Account Signature Capture Applet and created new view “Account Signature Display View” with applet Account Signature Render Applet. This is for rendering purpose only.

7.       Add the new view to the Accounts screen. Add responsibilities to the new view in the application.

8.       Navigate to Appln-Admin - >Manifest Administration. Create new entries as below

9.      For each applet entry, the bottom applets should have below entries. (If the fields are read only, import the attached sifs for Manifest, where the Read Only properties are inactivated.)

10.   Clear browser cache and re-login. Navigate to Account List View and Signature applet is displayed.

Also Attached Objects for quick reference.   Link:

Siebel_Signature_Objects

For Chrome browser : Open Chrome browser and type about://flags in place of URL. Set following value to Enabled instead of Default.
Enable display list 2D canvas  : Enabled instead of Default for chrome browser.
Restart Browser.