INSPECTION_RESULT_CSV_FORMAT

Product

Civic Platform and Citizen Access

Type

System Switch

Description

This Standard Choice defines the format of an inspection result CSV file. The Standard Choice value specifies the columns in the CSV file. Make sure you enter the value exactly as Table 1 listed.

The value description defines attributes for a given column. Use any of the following attributes and separate attributes with semicolons (;).

  • COLUMN=<Column Heading. Replace the attribute value with the actual column heading that you want.

  • REQUIRED=Y. Add this attribute if you require inspectors to enter information in the given column.

  • TYPE=<Type of Column Value. To require inspectors to enter a specific type of value in the given column, add this attribute and set the attribute value to Date, Number, or Integer.

  • FORMAT=<Date Format>. Replace the attribute value with the actual format of the date and time. For a list of attribute values that you can enter, see Table 2. For a description of format specifiers, see Table 3.

  • ORDER=<Integer. Add this attribute to define the order of columns in a list.

    Note: If you do not enable or define the Standard Choice for your agency, Citizen Access applies the default CSV format as Table 1 defines.

Table 1. INSPECTION_RESULT_CSV_FORMAT Standard Choice Values
Standard Choice Value Example Value Description
ADDRESS COLUMN=Address
INSPECTION CONTACT NAME COLUMN=Contact Name
INSPECTION CONTACT PHONE COLUMN=Contact Phone
INSPECTION DATE COLUMN=Inspection Date *; TYPE=Date; FORMAT=MM/dd/yyyy;REQUIRED=Y
GRADE COLUMN=Inspection Grade
INSPECTION SEQUENCE NUMBER COLUMN=Inspection ID*; Type=NUMBER;REQUIRED=Y
REQUEST COMMENT COLUMN=Request Comments
RESULT COMMENT COLUMN=Result Comments
SCHEDULED DATE COLUMN=Inspection Schedule Date; TYPE=Date; FORMAT=MM/dd/yyyy
SCORE COLUMN=Score; TYPE=INTEGER
STATUS COLUMN=Status *;REQUIRED=Y
INSPECTION TYPE COLUMN=Inspection Type
ALTERNATIVE ID COLUMN=Permit ID *;REQUIRED=Y
Table 2. Supported Date and Time Formats
Supported Format Example Date and Time
yyyy-MM-dd hh:mm:ss aa 2013-9-11 11:26:30 am 2013-9-11 11:26:30 pm
yyyy-MM-dd HH:mm:ss 2013-9-11 11:20:302013-9-11 20:18:59
MM/dd/yyyy hh:mm:ss aa 09/11/2013 11:26:30 am 09/11/2013 11:26:30 pm
MM/dd/yyyy HH:mm:ss 09/11/2013 11:26:3009/11/2013 21:26:30
dd/MM/yyyy 11/09/2013
yyyy/MM/dd 2013/09/11
dd-MM-yyyy 11-09-2013
MM-dd-yyyy 09-11-2013
Table 3. Date and Time Format Specifiers
Format Specifier Description
yyyy Year
MM Month
dd Date of month
HH Hour in a 24-hour clock
hh Hour in a 12-hour clock
mm Minute
ss Second
aa AM/PM