Showing posts from April, 2021

Import Data into Siebel via CSV file

  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 butto