GetImportCombinedLog Method

Retrieves the combined validation error messages Microsoft Excel Log file associated with a request for importing exposure data in Touchstone. The MS Excel Log file consists of four sections: Data Errors, Error Summary, Import Statistics, and Options. The Excel Log file consist of four sheets, and each sheet contains the validation message section in the following order:

Data Errors: Provides granular validation error messages with the error code for each contract, location, reinsurance, and the corresponding error message description.
Error Summary: Provides aggregate summary of the Data Errors with the total count of errors, Business errors, Reinsurance errors, and Data errors (location-wise).
Import Statistics: Provides detailed log of the import activity including general statistics, geocoding statistics, summary of the user-provided geocode match level mapping sets, and summary of the imported and not imported records at various levels such as contract, location location details, sublimits, layers, treaty, facultative, and location groups.
Options: Provides import configuration options such as header information, data source information, and the imported log details.

You can use the validation messages file in many ways, for example:

Integrate with programs to automate error handling when importing exposures into Touchstone.
Evaluate and improve the quality of exposures before importing into Touchstone.
Integrate with an external software for reporting errors in the Data Import operation.

Syntax

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

Public Function GetImportCombinedLog( _
   ByVal request As GetImportCombinedLogRequest _
) As GetImportCombinedLogResponse

Dim instance As ActivityManagementServiceClient
Dim request As GetImportCombinedLogRequest
Dim value As GetImportCombinedLogResponse
 
value = instance.GetImportCombinedLog(request)

public GetImportCombinedLogResponse GetImportCombinedLog( 
   GetImportCombinedLogRequest request
)

Parameters

request

Return Value

A GetImportCombinedLogResponse containing the Import Statistics, Geocoding errors, and Error Summary for the exposures imported in Touchstone.

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.

Related request: GetImportCombinedLogRequest XML
Related response: GetImportCombinedLogResponse Class

Example

The following example shows how to submit a request to obtain validation log for imported exposures in Touchstone using the GetImportCombinedLog() method:

using AIR.Services.ActivityManagement.Api;
using AIR.Services.Common.Data;
using System;
            
class SnippetGetImportCombinedLogRequest
{
    private static void GetImportCombinedLog(int businessUnitSid, int sqlInstanceSid, int activitySid)
    {
        ActivityManagementServiceClient activityClient = new ActivityManagementServiceClient();
        GetImportCombinedLogRequest request = new GetImportCombinedLogRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ActivitySid = activitySid;
        GetImportCombinedLogResponse response = activityClient.GetImportCombinedLog(request);
        if (response.Status.Code == StatusCode.Success)
        {
            Console.WriteLine("General Statistics");
            foreach (var e in response.ImportStatistics.GeneralStatistics)
            {
                Console.WriteLine("Statistics: " + e.Statistics + " Data: " + e.Data);
            }
            
            if (response.BusinessErrors != null)
            {
                Console.WriteLine("Business Errrors");
                foreach (var e in response.BusinessErrors)
                {
                    Console.WriteLine("Code: " + e.Code + " Message: " + e.Message + " ContractId: " + e.ContractId + " LocationId: " + e.LocationId);
                }
            }
            
            if (response.DataErrors != null)
            {
                Console.WriteLine("Data Errrors");
                foreach (var e in response.DataErrors)
                {
                    Console.WriteLine("Code: " + e.Code + " Message: " + e.Message + " ContractId: " + e.ContractId + " LocationId: " + e.LocationId);
                }
            }
        }
    }
}

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

ActivityManagementServiceClient Class
ActivityManagementServiceClient Members