How to Import CSV data in Siebel - Scriptless Solution

Import CSV data in Siebel with following options :-
Ability to add data from menu item
Popup applet should browse for csv file
Popup Applet will pass csv file path to business service which in turn will call the workflow
Create IO for corresponding to entity for which data is being imported
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!!

Pragmasys Consulting LLP Hiring 2009/2010 BE/BTECH Pass Outs from Pune University

Company: Pragmasys Consulting LLP (http://www.pragmasys.in) is a startup consulting organization focusing on providing business solutions to its Customers in the Enterprise Solutions space.  With strong partnership with Oracle and Microsoft, Pragmasys provides services such as – Implementation Advisory, Solution Architecture consulting, Enterprise Design consultancy, end to end product implementation, performance tuning. To fuel our growth, we are looking for strong expertise in the Enterprise solutions space currently in the areas of Siebel CRM, MS CRM and OBI. 

Why should you join? If you want to gain hardcore consulting experience on your profile and gain new skills and abilities, this is a right opportunity for you.

Location: Pune

You should be willing to travel to client locations in India- metro cities, IT Centres according to need, monthly 15 days travel involved. Company takes care of accommodation and other expenses. 

1. Designation: Siebel developers  
Experience: Freshers

Desired Profile:

• Strong programming background
• Good background of database concepts – PL/SQL.
• An exposure to UNIX/Shell scripting will be an advantage.
• Good exploring capability and very fast learning curve

Eligibility Criteria :

• B.Tech/B.E.(2009/2010 Pass Out)
• An aggregate of 60 % in Std X, XII, & Graduation(all semesters including optional subjects).
• Less than 2 years of gap in academic career.

"GOD" Sachin Tendulkar

सचिनच्या ‘ रेकॉर्डब्रेक ’ आयुष्याचा

शोध घेणारी ही फोटोबायोग्राफी

घसरगुंडीवर खेळणा-या या सचिनच्या करिअरला कधी खाली घसरत येणे माहितच नव्हतं













शाळकरी सचिनचे आंतरशालेय सामने..

बाळाचे पाळण्यात दिसणारे पाय दिसतात, असे म्हणतात ते चूक नाही..

आपला सवंगडी अजित रानडेसह...

















डॉन बॉस्कोसोबतची खेळी पाहून सचिन भारतासाठी खेळणार असे भाकीत गोंधळेकर पंचांनी वर्तवले होते

गुरुवर्य आचरेकर सरांच्या तालमीत...

स्पर्धात्मक सामन्यात झळकावलेल्या शतकाचा आनंद

गोर्धनादास शिल्ड विजेता संघ- वयाच्या बाराव्या वर्षी सचिन सिनिअर्सच्या बरोबरीने खेळला

सोळाव्या वर्षी पदार्पणाच्या सामन्यातच इराणी करंडक स्पर्धेत सचिनने शतक झळकावले

सचिनचे आंतरराष्ट्रीय पदार्पण- १९८९, कराची....

Siebel - Unique Constraint Violation Error On Check In ,Check Out,Get

There are several reasons for Unique Constrain Violation error on check-in/check-out/get operations:
I]If you are using your own ODBC datasource to connect to the Oracle database,there are chances that hidden parameters are not set properly.
To solve this error please follow steps given below :-
1.Go to start->Run
2.Type regedit,press enter
3.Go to following path :-
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\]
where is your ODBC Connection name
4.Set following keys if there is mismatch :-
PacketSize = 0
EnableScrollableCursors = 0
ColumnsAsChar = 1
ColumnSizeAsCharacter = 1
II]If you re-initialize local database without re-extracting you will get same error.You have to extract local database before reinitializing it.
III] If you use one db extract for multiple developers unique constraint will be violated. The Siebel check in/out process relies on unique row ids. If you are reusing the local database for multiple developers the row ids can not be unique.