Touchstone 11.0 API Reference
Sorted Property


Air.Services.Proxy Assembly > AIR.Services.DataImport.Data Namespace > ImportOptionsCsv Class : Sorted Property
Indicates whether the data is sorted within the comma separated values (CSV) files that you are importing.
Syntax
Public Property Sorted As Boolean
Dim instance As ImportOptionsCsv
Dim value As Boolean
 
instance.Sorted = value
 
value = instance.Sorted
public bool Sorted {get; set;}
Remarks
If the records are in the proper order, the import can take less time because AIR ImportExpress™ can skip the step of sorting the records. Pre-sorting records is especially important if you are importing large files (over one million Locations). AIR recommends that you sort records before importing them. If you specify "True" for this property, but the records that you are importing are unsorted, errors may occur during the import process.

By default, ImportExpress assumes that the records are not sorted.

Sorting requirements include the following:

Import File Type Sorting Requirements
Contract files Sorted by Contract ID and Layer ID
Location files Sorted by Contract ID and Location ID
Reinsurance files Sorted by primary Contract ID, Exposure ID, Exposure type, Reinsurance type, Reinsurance certificate ID, and Reinsurance Layer ID
Step Function files Sorted by primary Contract ID, Step Function type, and Step index
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

See Also

Reference

ImportOptionsCsv Class
ImportOptionsCsv Members

 

 

Verisk Analytics Client Confidential

© 2023. Extreme Event Solutions is now a Verisk business. Touchstone is a registered trademark of AIR Worldwide.

Please contact Extreme Event Solutions with questions or comments. For API questions. For documentation comments.