You can import log or audit trail files exported from the SiPass or SIPORT subsystem into Security Manager.

For SiPass, the log files up to 10 MB are supported.

For SIPORT, the log files up to 30 MB are supported.

  • For SiPass, the log files are available in XLSX or XLS format.
  • For SIPORT, the log files are available in HTML or HTM format.
  • For SiPass, the log files need to contain the following information: Date Occurred, Time Occurred, Location, Message, Card Number. Keep in mind the capitalization of the column name.
  • For SIPORT, the alarm log files need to contain the following information: Datum/Uhrzeit (tt.MM.jjjj HH:mm:ss) (Date/Time (dd.mm.yyyy hh:mm:ss)), Datenpunktname (Gerätename) (Data Point Name (device name)), Alarmtext (Ereignistyp) (Alarm Message (event type)). Keep in mind that the Datenpunktname (Data Point Name) and Alarmtext (Alarm Message) columns cannot be empty. Additionally, a specific order of the columns is required to be followed. For example, the Datum/Uhrzeit (Date/Time) attribute is expected to appear in the first column, the Datenpunktname (Data Point Name) attribute in the fourth column, and the Alarmtext (Alarm Message) attribute in the fifth column.
  • For SIPORT, the access log files need to contain the following information: Datum/Uhrzeit (tt.MM.jjjj HH:mm:ss) (Date/Time (dd.mm.yyyy hh:mm:ss)), Ort (Gerätename) (Location (device name)), Ausweisnummer (Card ID). Keep in mind that the Ort (Location) and Ausweisnummer (Card ID) columns cannot be empty. Additionally, a specific order of the columns is required to be followed. For example, the Datum/Uhrzeit (Date/Time) attribute is expected to appear in the first column, the Ort (Location) attribute in the third column, and the Ausweisnummer (Card ID) attribute in the sixth column.
  • A dashboard of the Monitoring module is displayed.
  1. In the dashboard, click the Import button.
  1. Click Browse files and select the file.
  1. Click Open.
  1. Click Upload.
  1. If necessary, repeat the import for all audit trail files.
  • A summary is displayed indicating the number of events skipped or successfully imported.