Import Data into Siebel via CSV file

By

 


Siebel Tidbits - Import Data into Siebel using a CSV file


Starting this month, we will blog about small requirements that can be easily achieved with Siebel and provide details on how to achieve it. To start off, there was a small requirement for a customer to provide an import option in Siebel to import data on a daily basis into Siebel using a CSV file.


Requirement:  Create a button on Siebel application screen/view that provides an option to browse a csv file and import data into Siebel maintaining referential integrity

Solution: The following approach can be taken to achieve this requirement:

Configuration:

Business Service: Create a Business Service which takes input as a file name and ensure that Business Service method argument is 'FileName'. Create the business service method such that given a filename (csv file), the method does the required processing of reading from the file and writing to the required Business Component, e.g., Contact

Base Applet: Create a button called Import on the required list applet e.g., Contact List Applet. When this button is clicked, the File browse popup applet will be displayed

Popup Applet:  

  • For the file browse option, create a new PopUp applet and ensure class is 'CSSSWEFRImpExp'. As an example, you can refer to the vanilla applet 'ISS Promotion Import Popup Applet'.
  • Change the following Applet User Properties in the copied applet
    • Property Name: Import Business Service; Value should be the same Business Service created in the first step to import data
    • PRoperty Name: Import Method; Value - Created Business Service method name
Fig: Applet User Properties for Popup Applet

  • In the base applet use this popup applet for the button by creating the following Control User Properties:
    1. Popup -> Name of the popup applet that was created
    2. Mode -> Mode of the applet, which is Base/Edit/Edit List
    3. Popup Dimension -> Dimensions of the pop up window. The format is Height x Width. E.g., 500 x 800
Fig: Configuration of popup Applet on Control

  • Upon configuration, this might fail with the error "Custom File Upload Applet Based on Class CSSSWEFRImpExo Fails with Error SBL-UIF-00152 (Doc ID 1581777.1)". To resolve the above issue, the following additional repository changes needs to be done
  • Add new Control User Properties to the below controls:
    • For Control "Browse"
      • Name = ClientPMUserProp; Value = UploadTriggerControl
      • Name = UploadTriggerControl;  Value = Import
Fig: Control User Properties for control Browse


    • For Control "Import"
      • Name = ClientPMUserProp; Value = FileUploadControl
      • Name = FileUploadControl;  Value = Browse
Fig: Control User properties for control 'Import'


This completes the required configuration. Deliver the workspace with the above changes.

  • When the button is clicked, the popup applet to browse file comes up. Once the required file is selected, the business service method with argument 'FileName' created in the first step is invoked. The popup applet passes the filename automatically to the method.
For more details, please reach out to us at the contact information below

Dymensions Perspective 

At Dymensions, we believe that most of Siebel customers want to not only get more value out of their existing investment but also use Siebel as a key aspect of their CRM strategy and potentially use other cloud based software services. We also believe that automated DevOps will bring customers business agility and also bring modern developer experience to its developer community. 

Dymensions has been innovating using the modern tools and technologies to build  solutions that will greatly benefit CRM customers and help them get more value out of their existing investment. We are committed to providing these solutions that will maximize the investment Siebel customers have already made in the product. For a demo of our solutions and for additional details, contact us using the information below.

Dymensions, Inc
                                                                                 +1.925.302.9610
                                                                                 info@dymensions.io





Comments

Post a Comment

Popular posts from this blog

Siebel Workflow Process with Workspaces - Parallel Development & Deployment (20.7 and later)

By
Image
Siebel 20.7 New Feature - Parallel Development/Deployment of Workflows Continuing the monthly updates release model, Siebel CRM team released 20.7 earlier this week but is available as Controlled Availability (CA) release. CA release means customers would have to request access to download this release via support request. As part of this update, Siebel has moved Workflows to use workspaces completely, both for Design time as well as for Run time. This is a significant and much needed feature that helps make parallel development for Siebel much more seamless and agile. In summary, Workflow processes can be developed, tested, delivered and migrated to higher environments like any other repository objects e.g., Applets, Views, Business Components etc. This blog provides a detailed overview of the feature with its stated benefits. Feature Details & Benefits Parallel Development/Deployment of Workflows is part of a new framework for management of workflow processes. This app
Read more

Siebel 20.10 Update

By
Image
  Siebel 20.10 Update  Continuing the monthly updates release model, Siebel CRM team released 20.10 last week. On first glance at the update notes from Oracle, the update didn't appear to have any new features except for certification of Linux version 8 and quite a few bug fixes. On closer look at the various documentation guides, it dawned on us that there were quite a few enhancements released by Siebel CRM team. These should have been called out in the update guide as these are some key enhancements that will help customers. So let's take a look at what these enhancements are: Siebel Migration Enhancements As of Siebel 20.10, Siebel has removed the requirement of direct database connectivity for migration application. That essentially means: Removal of dependency on JDBC  Removal of network dependency -  Thereby also eliminating any requirement that both migration app and Siebel database be in the same internet zone or require port to be open between two zones The removal of
Read more