SubmitImportCsvFacultative Method

Imports Facultative property data in comma-separated values (CSV) format into Touchstone.

Additionally, you can create user-supplied geocode match level codes using the MappingSetID and UserGeocodeMatchMappingSet properties defined in the ImportOptionsCsv class when importing exposure data into Touchstone.

Syntax

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

Public Function SubmitImportCsvFacultative( _
   ByVal request As SubmitImportCsvFacultativeRequest _
) As SubmitImportCsvFacultativeResponse

Dim instance As DataImportServiceClient
Dim request As SubmitImportCsvFacultativeRequest
Dim value As SubmitImportCsvFacultativeResponse
 
value = instance.SubmitImportCsvFacultative(request)

public SubmitImportCsvFacultativeResponse SubmitImportCsvFacultative( 
   SubmitImportCsvFacultativeRequest request
)

Parameters

request: Contains a SubmitImportCsvFacultativeRequest that identifies the Business Unit SID and SQL Instance SID to associate with the CSV file(s) to import.

Return Value

A SubmitImportCsvFacultativeResponse that contains the Activity SID which uniquely identifies the asynchronous web service call that you made to initiate the import 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.

Example

The following example shows how to import CSV data into Touchstone and enable the auto-mapping feature using the SubmitImportCsvWithAutomap() method:

using AIR.Services.Common.Data;
 using AIR.Services.DataImport.Api;
 using AIR.Services.DataImport.Data;
 using System;
            
 class SnippetSubmitImportCsvFacultative
 {
    private static void ImportFacultativeCSV(int businessUnitSid, int sqlInstanceSid, int dataSourceSid, int exposureSetSid, int mappingSetSid,
        string contractsFilePath, string locationsFilePath)
    {
        DataImportServiceClient importClient = new DataImportServiceClient();
        SubmitImportCsvFacultativeRequest request = new SubmitImportCsvFacultativeRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ImportOptions = new ImportOptionsCsv()
        {
            Currency = "USD",
            CurrencyExchangeRateSid = 3,
            DataSourceSid = dataSourceSid,
            ExposureSetSid = exposureSetSid,
            MappingSetSid = mappingSetSid,
            ContractsFilePath = contractsFilePath,
            LocationsFilePath = locationsFilePath,
            DateTimeFormat = "MM/DD/YYYY",
            HasHeaders = true,
            Delimiter = ',',
            TextQualifier = AIR.Services.DataImport.Data.TextQualifier.DoubleQuote,
            DuplicateContractBehaviour = DuplicateContractsOption.Replace,
            Geocoder = BaseGeocoder.AIRGeocoder,
            PreserveGeocode = true,
            VerifyOnly = false,
            
        };
        SubmitImportCsvFacultativeResponse response = importClient.SubmitImportCsvFacultative(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

DataImportServiceClient Class
DataImportServiceClient Members