Bulk Data – Update Coverage Service Area (CSA) Table Specification

Summary

This article provides the necessary information when importing files to create and modify coverage service area records using the Bulk Data application.

File Format

General Format

The following general characteristics apply to create and modify coverage service area import files:

• File naming convention must be *.csv

• A header is required

• The header must be followed by one or more comma-delimited detail records

• Empty (non-required) fields are acceptable.

• The columns are not required to appear in a specific order.

• You do not have to include all columns in an import file.

Import Identifier

The import identifier is optional if you import files via the Bulk Import web module. The correct identifier is automatically applied by selecting the type of import.

If you import using the file automation method by uploading files and placing them on the file server, the first row of the file must have the file format identifier, starting in the first position of the first row.  For the cover service area file the identifier is:

FORMAT:IDI/CostGuardBulkData/CoverageServiceArea

Note:

“Format:” is part of the identifier and must be included.

Header Record

The import file must contain the appropriate column names. This is typically the first row if you use the Bulk Import module. It will be the second row if you use the file automation method. The column names can be found in the Record Layout section of this document. The columns do not need to appear in a specific order. Import files do not need to include all of the columns, only the columns that contain data to be imported are necessary.

Clear Values

The coverage service area import file supports clearing the RegionID value of an existing record by specifying the matching Zip, CSA and CoverageIndicatorID of the record and a blank RegionID value. Refer to Record Layout section for required fields for create and modify.

Update Values

The coverage service area import file supports updating the CSA, CoverageIndicatorID and RegionID value of an existing record by specifying the matching Zip of the record. The CSA, CoverageIndicatorID and RegionID values specified in the import file will replace the current values stored in the existing record for the matching Zip. Refer to Record Layout section for required fields for create and modify.

Remove Values

The coverage service area import file supports removal of an existing record by specifying the matching Zip of the record and the value of 1 for Remove. Refer to Record Layout section for required fields for create and modify.

Record Layout