How to import crime data files and other file types into global locations

This topic describes how to import files containing locations, such as crime data files and hotels, which can help you identify potential suspects.

Use the following graphic for a quick reference or refer to the steps below for additional details.

  1. On the main menu click Search, then click Global Location Management.

    The Global Location Management screen opens.

  2. On the Global Locations tab, click .

    The Global Locations Upload screen opens.

  3. In Account, either leave it set to the default of your account, or if you want to share the global location with other accounts you can change it to System.

  4. In Location type, select the file type you are importing.

    Note, if you want to add or delete file types you can use .

  5. Click Select. Windows Explorer opens. Navigate to the folder and select the required .xlsx or .csv file. The file uploads and a green circle alongside the file name indicates when the upload is complete.

  6. If your file does not use the Gladiator Forensics supplied template then you must define which columns in your uploaded identifier file map to each of the OSS-ESPA settings (Agency name, Report number, Crime type, Contact, Street, Zip code, City, State, Lat/Lon, Latitude, Longitude, Description, From date/time and To date/time). Only Street is mandatory but the more you set the more useful the data is to you once imported. OSS-ESPA automatically suggests the best mapping but you can change that if required.

    You can also save this mapping as a template for future use so that you do not need to define this mapping each time you import the same file type. To do this, beside Templates click , enter a new template name then click OK. Now each time you import that file type you only need to use Templates to select the mapping you saved. You can save changes to these templates in the future using and delete them using .

  7. Click Save.

  8. Click Exit to return to the Global Location Management screen where the new locations are now listed on the Global Locations tab.

  9. Using the filters on the right-side of the screen, select Yes in Action required. If any results are displayed it indicates that OSS-ESPA was unable to identify the address because there was more than one location with the specified address.

    You must resolve the issue before the location can be analyzed. To resolve it:

    1. Click or the location's street address.

      The Location information window opens.

    2. Click Locate, select the correct address from the list shown, then click Save.

  10. After importing your file you can: