SubmitExportProgramDlfCsv Method

Submits a request to export a set of program 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 SubmitExportProgramDlfCsv( _
   ByVal request As SubmitExportProgramDlfCsvRequest _
) As SubmitExportProgramDlfCsvResponse

Dim instance As DataExportServiceClient
Dim request As SubmitExportProgramDlfCsvRequest
Dim value As SubmitExportProgramDlfCsvResponse
 
value = instance.SubmitExportProgramDlfCsv(request)

public SubmitExportProgramDlfCsvResponse SubmitExportProgramDlfCsv( 
   SubmitExportProgramDlfCsvRequest request
)

Parameters

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

Return Value

A SubmitExportProgramDlfCsvResponse 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 program aggregate loss analysis job, see the SubmitPortfolioAggregateLossAnalysis() method.

Example

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

using AIR.Services.Common.Data;
using AIR.Services.DataExport.Api;
using AIR.Services.DataExport.Data;
using System;
            
class SnippetSubmitExportProgramDlfCsv
{
    private static void SubmitExportProgramDlfCsv(int businessUnitSid, int sqlInstanceSid, int analysisSid, string exportBasePath)
    {
        DataExportServiceClient client = new DataExportServiceClient();
        SubmitExportProgramDlfCsvRequest request = new SubmitExportProgramDlfCsvRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ExportOptions = new AggregateLossAnalysisDlfExportOptions()
        {
            AnalysisSid = analysisSid,
            GeographyLevel = GeographyLevel.Subarea,
            CurrencyCode = "USD",
            DestinationFileName = "DLF_Export_Program_Csv",
            DestinationFolder = exportBasePath,
            FinancialPerspective = ReinsuranceFinancialPerspective.Contract,
            Participation = ReinsuranceParticipation.Gross,
            Comments = " Export submitted at " + DateTime.Now.ToString("dd MMM yyyy HH:mm"),
        };
        SubmitExportProgramDlfCsvResponse response = client.SubmitExportProgramDlfCsv(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