Home
Import data from external sources
You can import exposure data, map layers, projects, and reinsurance packages from external sources into Touchstone databases.
ImportExpress
Use ImportExpress to import contract and exposure data from external sources into Touchstone databases, regardless of the format of the source.
ImportExpress reference
This topic provides a reference for ImportExpress fields used to import exposure data into Touchstone.
Exposure fields for import
In ImportExpress, you map columns in .csv import files to valid Touchstone fields.
Location fields for import
In ImportExpress, you map columns in .csv import files to valid Touchstone location fields.
Location basic building fields for import
In ImportExpress, you map .csv import data to valid Touchstone fields for location basic building fields.

Using Touchstone online Help
You can access the top-level or context-sensitive Touchstone online help from within the application or from the Client Portal. You can then search for content, bookmark pages, and generate output to other formats.
Import data from external sources
You can import exposure data, map layers, projects, and reinsurance packages from external sources into Touchstone databases.
- Differences between property and workers' compensation exposure data
  Workers' compensation policies and certificates require special consideration at the policy/certificate and location levels.
- About aggregating similar risks
  Aggregating similar risks can reduce import and analysis times, as well as reducing disk space requirements, while still maintaining the validity of loss estimates.
- ImportExpress
  Use ImportExpress to import contract and exposure data from external sources into Touchstone databases, regardless of the format of the source.
  - ImportExpress reference
    This topic provides a reference for ImportExpress fields used to import exposure data into Touchstone.
    - Exposure fields for import
      In ImportExpress, you map columns in .csv import files to valid Touchstone fields.
      - Primary property or workers' compensation contract fields for import
        In ImportExpress, you map columns in .csv import files to valid Touchstone primary property or workers' compensation policy fields.
      - Facultative property or workers' compensation contract fields for import
        In ImportExpress, you map columns in .csv import files to valid Touchstone facultative or workers' compensation contract fields.
      - Location fields for import
        In ImportExpress, you map columns in .csv import files to valid Touchstone location fields.
        Location policy fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location policy fields.
        Location address fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location address fields.
        Location platform fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location platform fields.
        Location values fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location values fields.
        Location basic building fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location basic building fields.
        Location terms fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location terms fields.
        Location building detail fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location building details fields.
        Location roof detail fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location roof detail fields.
        Location wall detail fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location wall detail fields.
        Location connection detail fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location connection detail fields.
        Location surrounding detail for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location surrounding detail fields.
        Location platform details for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location platform detail fields.
        Location builder's risk fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location builder's risk fields.
        Location user-defined fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location user-defined fields.
        Location non cat fields for import
        In ImportExpress, you map .csv import data to valid Touchstone fields for location non-catastrophe-related fields.
      - Workers' compensation fields for import
        In ImportExpress, you map workers' compensation fields in .csv import files to valid Touchstone fields.
      - Reinsurance fields for import
        In ImportExpress, you map columns in .csv import files to valid Touchstone reinsurance fields.
      - Step function fields for import
        In ImportExpress, you map columns in .csv import files to valid Touchstone step function fields.
    - Minimum required fields for import
      ImportExpress requires a minimum set of fields in exposure data import files.
    - ImportExpress default values
      You can specify import defaults so that ImportExpress automatically fills in blank fields in your import files.
    - Column heading automapping for .csv file imports
      During import of .csv files, ImportExpress initiates automatic mapping of certain columns in the source files to expected Touchstone columns (fields).
    - Fields that support value mapping for import
      ImportExpress ImportExpress value mapping helps you to complete imports successfully by mapping custom, user-defined terms in fields in your import files to valid Touchstone values.
- About importing exposure data
  You import exposure data into a Touchstone exposure database and into an exposure set.
- Import a project
  Touchstone enables you to import a project that another Touchstone user previously exported.
- Importing map layers into Touchstone
  Use Map Layer Import to import map layers (custom GIS data) from raster or vector files into Touchstone.
- View import logs
  Import logs provide useful information, especially if you need to troubleshoot an import.
- About verification, import logs, and rejection files
  When you submit a .csv file for import, ImportExpress validates the contract, location, and reinsurance exposure data to see whether the exposure data is acceptable for import.
- About verifying import and mapping data
  The verification process validates contract, location, and reinsurance exposure data to see whether the data is acceptable for import. It does not import data automatically after the process is complete.
Projects and exposure views
Projects are a useful way to organize your data. They contain exposure views that contain the data that you want to focus on.
Geospatial analysis
Geospatial analysis enables you to perform a deterministic risk analysis with your own view of risk on accumulations of property exposures and workers' compensation information in given areas exposed to natural and man-made catastrophes.
Exposure data validation
Verisk provides a reference containing information about Touchstone exposure data.
Data Quality analysis
The most effective way to assess and enhance portfolio-level or contract-level catastrophe exposure data is to use Touchstone's Data Quality diagnostics. These diagnostics enable you to determine the strengths and weaknesses of the exposure data you are using for analyses and supplement that data when it is missing or weak.
Hazard analysis
Hazard analysis enable you to identify the relevant catastrophe hazards for locations in your exposure data.
About loss analyses
Touchstone enables you to model catastrophic (CAT) events to estimate property and workers' compensation losses.
Reinsurance
The Reinsurance Program Manager enables you to create, import, and manage reinsurance programs.
Touchstone data export types
Touchstone enables you to export different types of data.
Activity Monitor
The Activity Monitor displays the status of all activities.
Managing data sources
Use Data Source Management to manage Touchstone databases.
User model management
Use User Model Management to build custom non-Verisk models and seamlessly integrate them into Touchstone.
Model Builder
Administration Console
User interface
Reference: Common Help topics

Location basic building fields for import

In ImportExpress, you map .csv import data to valid Touchstone fields for location basic building fields.

This table lists the import field and the Touchstone user interface location field and database field that correspond to each location basic building import field, for primary or facultative property locations. Import fields are in italic font because the field name is variable.


Import field	User interface field	Database field	Required
Construction Code Type	Construction Code Type	tLocation.UserConstructionSchemeCode
Construction Building	Construction Building	tLocation.UserConstructionCodeA
Construction Other Structures	Construction Other Structures	tLocation.UserConstructionCodeB
Occupancy Code Type	Occupancy Code Type	tLocation.UserOccupancySchemeCode
Occupancy Code	Occupancy Code	tLocation.UserOccupancyCode
Year Built	Year Built	tLocation.YearBuilt
Stories	Stories	tLocation.Stories
Gross Area	Gross Area	tLocation.GrossArea
Gross Area Unit Code	Gross Area Units	tLocation.GrossAreaUnitCode
Territory	Territory	tLocation.Territory
Building Height	Building Height	tLocation.BuildingHeight
Building Height Unit Code	Building Height Units	tLocation.BuildingHeightUnitCode
ISO Occupancy Code	ISO Occupancy Code	tLocFeature.ISOOccupancyCode
ISO Construction Code	ISO Construction Code	tLocFeature.ISOConstructionCode

Note: If you want to import the Construction Building field and the Construction Other Structures fields in your locations import file, do not map the Construction Other Structures field to a Touchstone field during the import process.

Note: Touchstone also supports non-AIR construction and occupancy class codes, although we always recommend translating non-AIR codes to Touchstone codes wherever possible before importing your data. For more information, see "Non-AIR Construction Class Codes" and "Non-AIR Occupancy Class Codes" in the Help provided with your licensed Touchstone Client.