Home
Import
Import exposure data from external sources into Verisk databases.
Exposures
Import exposures.
Import India crop exposures
Handling India crop exposures.

Introduction
Introduction to the Touchstone Re application.
Companies
A company is unique entity in Touchstone Re.
Company data (exposures)
Companies are associated with exposure data.
Programs
A program is integral to a company and it's exposure data in Touchstone Re.
Portfolios
A portfolio is a group of treaties selected from across companies.
Import
Import exposure data from external sources into Verisk databases.
- Exposures
  Import exposures.
  - Import UNICEDE2 data
    Import UNICEDE/2 exposure data.
  - Import exposures from CEDE databases
    Clients can import aggregated exposure data from CEDE databases into Touchstone Re company Exposure Sets.
  - Import India crop exposures
    Handling India crop exposures.
    - Exposure source file: India crop
      Format details for India crop exposures.
    - Exposure data and format validation
      Guidelines for India crop exposure import validation.
    - More on India crop
      India crops by season.
- Import company loss file
  The default import type is "Company Loss File (CLF)".
- Import a company
  You can import a company or set of companies to a shared network location that is accessible to Touchstone Re.
- File types
  You can import a number of file types into Touchstone Re.
- China disaggregation
  Use the China Disaggregation tool to import exposures and programs for mainland China.
- AM Best premiums
  AM Best premiums can be imported into Touchstone Re as a single data file.
- Import ALERT data
  Import ALERT data into Touchstone Re.
Export
Export exposure data, results, reports, and companies out of Touchstone Re.
Loss results
The Loss Results pane for a company lists all loss analyses that have been executed for the company.
Analysis
An analysis in Touchstone Re is a probabilistic analysis of your aggregated loss or exposure data.
Tools
Tools to manage Touchstone Re and its data.
Administration console
The Administration Console enables authorized users to manage a suite of administrative tasks.
Reference
Supporting information on various topics associated with Touchstone Re.

Import India crop exposures

Handling India crop exposures.

Import > Exposure > India Crop

Touchstone Re's native geography for the India Crop model is State > District. Clusters (a group of districts within a state) are handled by Touchstone Re only during import.

If exposure is imported at the cluster level, it is then disaggregated to the district level during the import.

Procedure

Select Import > Exposure > India Crop.

In the Import dialog box, Import Type will be set to Exposure - India Crop. Note that exposures for both crop seasons are included in the import.
Select an input file to import; this must be from a UNC folder.

This input file is a CSV file containing valid fields: state name, cluster assignment, 3-letter currency code, units (ones, thousands, millions, billions), crop-specific LOB columns (season and crop type).

The next fields (Peril, Data Type, and Currency & Units) are disabled and have default settings.
Enter or select a company name to import the exposure into.
Enter or select an exposure set to assign the exposure to; overwrite or append as appropriate.
Select an import year.
Click Verify.

If a warning message appears, click the message for information.
Click Import to import the data. If there is a problem, click the warning message for details.
If applicable, click Close to exit ImportExpress.

Results

The task appears in the Activity Monitor queue. After the activity is complete, Touchstone Re opens the exposure set.