SubmitExportPortfolioDlfCsv Method

Submits a request to export a set of portfolio aggregate loss analysis results to a detailed loss file (DLF) in commma-separated values format.

DLFs contain area, subarea, and line of business information in binary or comma-separated values (CSV) format. Touchstone Re can create a DLF from an aggregate loss analysis that a user ran against a reinsurance program or a portfolio of reinsurance treaties (or layers). You can use DLFs in binary format in both Touchstone Re and CATRADER.

When submitting the request, you specify the sequential identifier of the analysis that generated the results to export, the destination of the DLF, the currency to include in the DLF, and so on.

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Function SubmitExportPortfolioDlfCsv( _
   ByVal request As SubmitExportPortfolioDlfCsvRequest _
) As SubmitExportPortfolioDlfCsvResponse

Dim instance As DataExportServiceClient
Dim request As SubmitExportPortfolioDlfCsvRequest
Dim value As SubmitExportPortfolioDlfCsvResponse
 
value = instance.SubmitExportPortfolioDlfCsv(request)

public SubmitExportPortfolioDlfCsvResponse SubmitExportPortfolioDlfCsv( 
   SubmitExportPortfolioDlfCsvRequest request
)

Parameters

request: Contains a SubmitExportPortfolioDlfCsvRequest that specifies the Business Unit SID and SQL Instance SID associated with the portfolio aggregate loss analysis results to export, as well as the ExportOptions object that enables you to configure the export job.

Return Value

A SubmitExportPortfolioDlfCsvResponse that contains the Activity SID that uniquely identifies the asynchronous web service call that you made to submit the export job.

Remarks

To find the Business Unit SID to pass into this method, call the GetBusinessUnits() method.

To find the SQL Instance SID to pass into this method, call the GetSqlInstances() method.

To find the Analysis SID to pass into this method, use the GetActivities() method.

For information about submitting a portfolio aggregate loss analysis job, see the SubmitPortfolioAggregateLossAnalysis() method.

Example

The following example shows how to submit a request to export portfolio aggregate loss analysis results to a DLF in CSV format using the SubmitExportPortfolioDlfCsv() method:

using AIR.Services.Common.Data;
using AIR.Services.DataExport.Api;
using AIR.Services.DataExport.Data;
using System;
            
class SnippetSubmitExportPortfolioDlfCsv
{
    private static void SubmitExportPortfolioDlfCsv(int businessUnitSid, int sqlInstanceSid, int analysisSid, string exportBasePath)
    {
        DataExportServiceClient client = new DataExportServiceClient();
        SubmitExportPortfolioDlfCsvRequest request = new SubmitExportPortfolioDlfCsvRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ExportOptions = new AggregateLossAnalysisDlfExportOptions()
        {
            AnalysisSid = analysisSid,
            GeographyLevel = GeographyLevel.Subarea,
            DestinationFileName = "DLF_Export_Portfolio_Csv",
            DestinationFolder = exportBasePath,
            FinancialPerspective = ReinsuranceFinancialPerspective.Contract,
            Participation = ReinsuranceParticipation.Part4,
            Comments = " Export submitted at " + DateTime.Now.ToString("dd MMM yyyy HH:mm"),
        };
        SubmitExportPortfolioDlfCsvResponse response = client.SubmitExportPortfolioDlfCsv(request);
        if (response.Status.Code == StatusCode.Success)
        {
            Console.WriteLine("Submitted Successfully to HPC with Activity SID: " + response.ActivitySid);
        }
    }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DataExportServiceClient Class
DataExportServiceClient Members