Bookshelf v7.5.3: About Account Download in Siebel eBanking and eBrokerage

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

About Account Download in Siebel eBanking and eBrokerage

The preconfigured Siebel eBanking and eBrokerage applications allow your customers to download account information to a comma-delimited file that can be opened in a spreadsheet application. If you want your customers to be able to download account data to other file types, you will need to configure Siebel eBanking.

This section explains how account download works in the preconfigured application. Understanding this will make it easier for you to design your configuration.

Overall Process

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 follows the Save As dialog box to download a CSV file containing investment transaction records.

Other Accounts. The customer selects a nonbrokerage 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 selected dates are used as the search specification for the query. If the customer has performed an account download on this account before, the start date will be predefaulted to the end date of the last download. If no dates are selected, all of the transaction data is downloaded for the account period between the last time data was downloaded and the present. If no file format is selected, the data output is in the form of a Siebel message, which is an XML-formatted message that 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 in the form of a text string. The applet then prompts the user's Web browser to save the text string as a file on the customer's computer.

Workflow Details

The FINS eBanking Account Download Outbound workflow is shown in Figure 2.

Figure 2. FINS eBanking Account Download Outbound Workflow

The actions performed by the workflow are summarized in Table 17.

Table 17. FINS eBanking Account Download Outbound Workflow Actions
Step	Action
Start	If the Download button is clicked with no active record (no row Id for the business object's primary business component) the workflow ends. If the selected file format is CSV, the lower path of the workflow is followed. If the selected file format is not CSV, the upper path of the workflow is followed.
Prepare CSV	Specifies FINSAcctDlCSVMapOut as the data map used by the Data Transformation Engine to map Siebel data to the target data format. Specifies FINS eBanking Account Download CSV Interface as the target integration object that stores the data after data transformation.
CSV - Get Acct Txn Info	EAI Siebel Adapter queries the database for the transaction data between the starting and ending dates specified by the customer. The data is stored in memory as an instance of the FINS eBanking Account Download Internal source integration object in Siebel format.
CSV - DTE	The Execute method of the EAI Data Mapping Engine business service moves 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.
CSV - Convert to Document	The FINS EAI Free Format Hier Converter converts 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 may add an input parameter to set the user property XMLFormatting of the business service FINS EAI Free Format Hier Converter. By default, this property is False, which implies 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 `'` and < is replaced with `<`.

The upper path in the workflow, which includes the Get Acct Txn Info and Convert to XML Document steps, is not used in the preconfigured Siebel eBanking application. However, you could configure the 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 top path would be used to bypass steps that might cause unwanted behavior.