Import locations from file screen

This topic provides an overview of the Import locations from file screen, all the settings and buttons on it and explains what must be contained in the file. However if you require a step-by-step procedure on importing a file containing locations refer to To import a file containing new locations.

Overview

The Import locations from file screen allows you to import a file containing locations for use in the case.

Although locations can be entered manually using the Locations of interest screen (Case management) you can also select to upload a file containing locations from both the Locations of interest screen (Case management) screen, the Manage case screen and the Manage files screen. This is useful if you already have a file containing multiple locations of interest, possibly from surveillance videos or credit card transactions. If the file also includes event times then an event is also automatically created on the Event timeline screen. Locations can also be created automatically by OSS-ESPA, for example when you upload geofence, tower dump or subscriber information files, and they can also be created manually in the ESPA analysis center and Sentinel screens.

The location file must either be either a .csv, .xls, or .xlsx file format, or a .zip file containing one of these file types. For the information in the file to import correctly, you must include the column headings in the first row of your file; refer to the following list for details of the column headings and content requirements, both of which are case insensitive. Alternatively click here to download an .xlsx template file provided by Gladiator Forensics.

name (mandatory)

This setting is mandatory. Once imported, the contents of this column are used to populate the location's Name setting.

description, desc (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Details tab setting.

type (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Location type setting. The allowed values are:

business
cell tower
crime scene
frequented area
manufacturing location
meeting area
other
residence
sales location
seizure location

If no type is specified then "other" is used.

color, colour (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Marker icon setting. The allowed values are:

default
red
dark red
green
dark green
blue
dark blue
magenta
cyan
orange
yellow
purple

If no color is specified then the default markers are used.

icon text, marker text, marker label (optional)

This setting is optional. You can enter up to two characters. Once imported, the contents of this column are used to populate the location's Marker label setting.

latitude, lat (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Latitude setting.

If no latitude is specified but the address is, then OSS-ESPA automatically determines the latitude from the address.

longitude, long, lon, lng (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Longitude setting.

If no longitude is specified but the address is, then OSS-ESPA automatically determines the longitude from the address.

location buffer (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Location buffer setting.

If no location buffer is specified, then OSS-ESPA uses the default value of 2.

location buffer unit (optional)

This setting is optional. Once imported, the contents of this column are used to populate the units that are used in the location's Longitude setting. The available units are:

MI: miles
M: meters
Y: yards
K: kilometers

If no location buffer unit is specified, then OSS-ESPA uses the default value of miles.

address, addr (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Street address setting.

city (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's City setting.

state, county, province (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's State setting.

zip, postal code, post code, zip code, postal, post (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Postal code setting.

country (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Country setting.

start time, start (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Event start setting. If an event start and end time are entered then an event is also automatically created on the Event timeline screen.

end time, end (optional)

This setting is optional. Once imported, the contents of this column are used to populate the location's Event end setting. If an event start and end time are entered then an event is also automatically created on the Event timeline screen.

If you require information on uploading locations from a file refer to To import a file containing new locations.

Settings and buttons

Select

This setting is mandatory. Click Select to upload a location file. Windows Explorer opens. Navigate to the folder and select the required location file then click Open.

The location file must either be either a .csv, .xls or .xlsx file format, or a .zip file containing one of these file types.

Import

Click to import the location file.

Exit

Click to close the screen and return to the Manage case screen.