Setting the Timezone of metadata during import

Setting the Timezone of Metadata During Import

Whether you are adding the time zone in ESI Analyst or is in your load file, the proper timezone is very important. ESI Analyst standardizes all timestamps for searching to UTC ("Coordinated Universal Time" - However, to ensure this adjustment is correct, you must provide the original timezone of the metadata being imported. 

This can be done in two ways:
  1. Designating the timezone for all data being imported using the Timezone input
  2. Having a column in your load file with the designated timezone or offset

Designating Timezone on Import

When importing metadata for which a timezone is required the first screen (step 1) will present you with an input labeled "Timezone". This input will accept timezone abbreviations or an offset and perform the necessary timezone lookup according to the accepted database values for timezones ( When the lookup is successful, the field will change to the standardized database timezone name (e.g. EDT will update to America/New_York).

Depending on the current date, your timezone offset may vary (as the system performs a realtime lookup). For example, if the current date falls during Daylight Savings Time ("DST"), your offset may be reduced by one hour. For example, when not in DST the offset for US Eastern time to UTC is -5, but when in DST the offset from UTC is -4. 

Input Example:
If you wanted Eastern Time, you can input -4 into the TIMEZONE field in your Import Metadata screen

Click anywhere off of the box and the time zone will automatically update

If you wanted Eastern Time, you can input edt into the TIMEZONE field in your Import Metadata screen

Click anywhere off of the box and the time zone will automatically update

When leveraging the Timezone input during import, this value will apply to ALL metadata within the load file. If you do not input a value into this field, a timezone column is required in your load file. 

Designating Timezone in Your Load File

If you do not designate a timezone in the Timezone input field during step 1 of your import, you will be required to map a timezone column within your load file. This allows for import of multiple varied timezones within a single set of metadata (if required). 

By skipping the Timezone input, during step 2 of your import a Timezone column will be noted as a required field:

This column within your load file can be provided as an offset from UTC (e.g. "-4") or a timezone abbreviation ( 

Date and time stamps provided will be adjusted according to their date for the proper DST adjustments automatically. 

    • Related Articles

    • How To Set Your Timezone

      Many of the displays in ESI Analyst provide an adjusted time stamp so that a user can see time stamps relative to their own timezone. This is useful in investigations to see realtime activities as they correlate to a specific timezone and useful ...
    • How to Import Communications and Attachments Through ESI Analyst

      Communications encompass a variety of communications. The system accepts the following load file formats: CSV, Pipe, Tab or DAT delimited files. Depending on how the data was collected or produced, you may not have a UFDR where you could use ESI ...
    • Date Time Stamp Formatting

      Date time stamps are at the heart of any investigation. They are critical component to knowing when something occurred, and no investigation is complete without them! Having the proper time stamp formats in your load file is critical to ensure ...
    • Understanding the Available Fields for Communications

      When importing communications data like text messages, chat messages, emails etc. you will have a list of fields that are available for your import. Generally, it is easiest to match closely the titles in ESI Analyst to your load file. Your load file ...
    • How to Import Electronic Files of Any Type into ESI Analyst

      Electronic files of any type are always an important part of any investigation. You can easily load any type of electronic file or media through ESI Analyst's import system. To import files and media you will want to select Computer Activity under ...