Siebel eService Administration Guide Addendum for Industry Applications > Siebel eBanking and Siebel eBrokerage >

About Account Download in Siebel eBanking and Siebel eBrokerage

The preconfigured Siebel eBanking and Siebel eBrokerage applications allow your customers to download account information to a comma-separated values (CSV) file that they can open in a spreadsheet application. If you want your customers to be able to download account data to other file types, then you must configure Siebel eBanking.

This topic explains how account download works in the preconfigured Siebel eBanking and Siebel eBrokerage application. Understanding account download, helps you to design your configuration.

Overview of Downloading an Account

The method that the customer follows to initiate an account download is slightly different for brokerage accounts and other accounts.

• Brokerage Accounts. The customer selects a brokerage account in Siebel eBrokerage and clicks the Download button on the Investment Transactions applet. A File Download dialog box opens asking whether the customer wants to open or save the file. The customer selects Save this file to disk, clicks OK, and completes the information in the Save As dialog box to download a comma-separated values (CSV) file containing investment transaction records.
• Other Accounts. The customer selects a non-brokerage account in Siebel eBanking or Siebel eBrokerage and clicks the Download button on the Recent Transactions applet. In the Account Download applet, the customer enters the starting and ending dates for the transaction data and selects the CSV file format. The query uses the selected dates for the search specification. If the customer performed an account download on this account before, then the start date defaults to the end date of the last download. If no dates are selected, then all of the transaction data is downloaded for the account period between the last time data is downloaded and the present. If no file format is selected, then the data output appears as a Siebel message, which is XML-formatted and describes Siebel data. When the customer clicks the Download button, the search specification is sent to the FINS eBanking Account Download Outbound workflow, which then begins.

During the workflow process, a query is used to export the requested data to an instance of a source integration object that uses Siebel format. The Data Transformation Engine converts the data to a format that is consistent with the CSV format and stores it in an instance of a target integration object. The workflow passes the data back to the Account Download applet as a text string. The applet then prompts the Web browser of the user to save the text string as a file on the user's computer.

Workflow Details

Figure 2 shows the FINS eBanking Account Download Outbound workflow.

Figure 2. FINS eBanking Account Download Outbound Workflow

If the selected file format is CSV, then the lower path of the workflow is followed. If the selected file format is not CSV, then the upper path of the workflow is followed. If the Download button is clicked with no active record (no row Id for the primary business component for the business object), then the workflow ends.

The preconfigured Siebel eBanking application does not use the upper path in the workflow, which includes the Get Acct Txn Info and Convert to XML Document steps. However, you can configure the Siebel eBanking application so that the workflow is triggered in a way that does not eliminate the possibility that no active record is selected. In this case, the upper path is used to bypass steps that might cause unwanted behavior.

Workflow Description. This workflow performs the following actions:

1. Prepare CSV. This step specifies FINSAcctDlCSVMapOut as the data map that the Data Transformation Engine uses to map Siebel data to the target data format. This step also specifies FINS eBanking Account Download CSV Interface as the target integration object that stores the data after data transformation.
2. CSV - Get Acct Txn Info. This step uses the EAI Siebel Adapter to find the transaction data between the starting and ending dates that the customer specifies. The data is stored in memory as an instance of the FINS eBanking Account Download Internal source integration object in Siebel format.
3. CSV - DTE. This step invokes the Execute method of the EAI Data Mapping Engine business service to move the data in the FINS eBanking Account Download Internal integration object to the FINS eBanking Account Download CSV integration object, according to the mapping in the FINSAcctDlCSVMapOut data map.
4. CSV - IntObj To XML Hier. This step uses the EAI Integration Object to XML Hierarchy Converter to convert the Siebel format to XML by flattening the data hierarchy and removing unneeded metadata tags.
5. CSV - Convert to Document. This step uses the FINS EAI Free Format Hier Converter to convert the XML data to the text string that is returned to the Account Download applet.

   Input arguments in this step are selected to define the format of the output. Optionally, the administrator can add an input parameter to set the XMLFormatting user property of the FINS EAI Free Format Hier Converter business service. By default, this property is False, which means that text is retained in its original format. When set to True, XML conventions for text handling are used; for example, apostrophes are encoded as &apos; and < is replaced with &lt;.