Understanding Verification, Import Logs, and Rejection Files


When you submit an import of CSV and UPX files, AIR ImportExpress validates the contract, location, and reinsurance exposure data to see whether the exposure data is acceptable for import. If the exposure data is not acceptable, it displays an error message and does not submit the import job for processing. The error message provides information to help you fix the problem.

If the source UPX files contain invalid reference codes, AIR ImportExpress continues the import process, while writing information to the import log file and, where appropriate, creating rejection files. If the source CSV files contain invalid values, AIR ImportExpress highlights those values during the Scan Mappings process and will not continue the import process until you map incorrect values to valid Touchstone value.

AIR ImportExpress includes a Verify button that you can use to validate the exposure data and fix any errors before submitting the import.

  Since Verify essentially performs an import without saving it to a Touchstone database, it takes almost as long as if you had submitted the import.

After successfully submitting an Import job for processing, you can monitor the status in the Activity Monitor. Here are some guidelines for understanding and using the information in the Activity Monitor:

         When you see an import whose status is “Completed with Exceptions”, always view the import log. To view the log, select the activity and then click View Log on the ribbon or right-click the activity and then select View Log. For each type of import, AIR ImportExpress creates log files that summarize information about the job, including the number of records successfully processed, and about errors that occurred during import as a result of validation rule violations. The import log also includes a detailed list of errors by location or by contract.

  To view logs in Touchstone, you must first configure Notepad or WordPad as the default application for opening text files on your computer.

         Sometimes AIR ImportExpress creates rejection files for imported contracts, locations, and reinsurance files that contain invalid data. These files are useful because you can save the files, correct the invalid exposure data, and then reimport them. AIR ImportExpress may have created rejection files even when the status is “Completed”; therefore, AIR recommends that you always review both the log and any rejection files. You can see that an import has rejection files when you highlight an Import activity and the View Log icon displays a drop-down arrow. When you click the down-arrow (or right-click the selected activity), a list of rejection files appears. Clicking a file opens it in a spreadsheet application; you can save the file and edit it as needed.

         AIR ImportExpress rejects exposure data with retired or expired currencies. It sends appropriate error messages to the log file and adds the locations to the rejection file.

         Each import job has its own set of criteria that determines the success or failure of the import.

       In general, if AIR ImportExpress is able to import some contracts and locations, the status is likely to be “Completed”. However, even though the job has successfully completed, there may be problems with some of the data, and so AIR ImportExpress may generate rejection files.

       A job fails only when it cannot be completed at all.

       A job completes with exceptions if the job completes but something is not correct, for example, if a detailed loss analysis does not have any results for the intersection of the model with the data. For example, if you run an analysis with a model for California earthquakes, but you only have Florida exposure data, the job is likely to complete with exceptions.



© 2016 AIR Worldwide. All rights reserved.

Click here for information about AIR Worldwide, including copyright, trademarks, confidentiality, and contact information.

Touchstone V3.0 Updated December 01, 2016