Stratus Municipal Import

An ASCII file, which is used to import premiums and other data into the Stratus Municipal input schedules, may be created using one of the two following methods.

  • Create an ASCII file according to the specifications contained in this appendix.
  • Export data from Premium Pro Allocator. Allocator creates an ASCII file that can be imported into Municipal.  

The ASCII File Import Method

Two different layouts can be followed when creating an ASCII file.  The first layout is By Municipal Name.  Each line of the ASCII file lists the municipality name, followed by other data to be imported.

The second layout is By Municipal Code. Each line of the ASCII file lists the municipal code of each city, followed by other data to be imported.    

Importing an .imp file from Allocator

Allocator allocates insurance policies to the correct municipality.  After allocation, you may create an ASCII file with an extension of. imp.  Like the ASCII file created by the Annual Software, the .imp file is already in a file format that can be imported into Municipal.  Allocator allows you to create an ASCII file in either layout (By Municipal Code or By Municipal Name).

ASCII File Format

Each line contains all the information of one municipality and must end with a carriage return line feed. Negative numbers are designated by placing a minus sign immediately preceding the number.  No null characters are allowed. For Kentucky, the first two fields of each line have a specific starting position and length. The premiums are split into seven premium types.

All items in a list must be assigned a value.  If premiums have not been written in a municipality, a zero must be assigned to the item. Otherwise, the next item in the list will be imported to the wrong column in the input schedule.

The city assigned code is any alphanumeric string that may be assigned to your company by the city.

Refer to Input Schedule to obtain a valid list of taxable municipalities and municipal codes. Invalid names and codes will be imported to the input schedule as “9998 Other Municipalities.”

Kentucky

Picture 1

Louisiana

drawing

drawing