Welcome, User

Ticket Status

Open

0

In Progress

0

On Hold

0

Escalated to OEM

0

Closed

0

SLA Metrics

Near Breach

0

Breached

0

SLA Compliance

0%

AMC / PMC

Total Active AMCs

0

Overdue PMCs

0

Expired AMCs

0

Expiring Soon (30d)

0

Engineer Workload Overview

Engineer Open Tickets Overdue Tickets Active PMCs

Tickets by Status

AMC Expiries (Next 6 Mo)

Recent Activity

ID Subject Priority SLA Status
Ticket ID Customer Subject Priority SLA Status SLA Resolution Due Status Assigned Created Acknowledgment Actions

Description

Email History

Ticket Info

Status
Priority
Customer
Assigned To
PMC Date

Attachments

Activity Timeline


Customer SO Number Site AMC Start AMC End Frequency PMC Count PMC1 PMC2 PMC3 PMC4 AMC Value Engineer Engineer Email Support Head Email AM/PM Email SLA Profile Status Remarks Actions Send Reminder

Step 1: Download Template

Download the latest Excel template. It carries the same 24 columns as Export All and Export Selected, so an exported file can be edited and imported straight back:

  • PMC Number — leave blank to create a new record; fill it in to update an existing one
  • Customer Name, Site, AMC Start Date, AMC End Date — required for new records (dates as YYYY-MM-DD); together they also act as the fallback match when no PMC Number is given
  • PMC Count — required for new records: 0 (No PMC), 1 (Yearly), 2 (Half-Yearly) or 4 (Quarterly)
  • Frequency — derived from PMC Count
  • First PMC Date, PMC1–PMC4 and their Status columns — only the positions within the PMC Count are used
  • AMC Value — optional, zero or greater
  • AMC StatusActive, Expired or Cancelled
  • Engineer Name / Engineer Email — must match an active user, otherwise the record is left unassigned
  • Support Head Email, AM/PM Email, SLA Profile, Remarks — optional

Step 2: Upload Excel File

You can upload a full sheet or just the columns you want to change — a column that is not in the sheet keeps its stored value, while a column that is present but blank clears it. The whole workbook is validated before anything is saved: if any row fails, the entire import is rolled back and the exact error is shown below — no silent or partial imports.

ID Name Email Role Status Created At Actions
Timestamp User Action Details IP Address
Customer ID Name Email Company AMC Active SLA Profile Actions
ID Profile Name Tier Template Type Working Type Actions

Tickets Report

SMTP Configuration

Configure Gmail app password for system notifications.

Email Integration Status

Current configuration based on system environment variables.

Integration Status Checking...
Active Provider ...
Sync Status Running Normally

To modify these settings, update the EMAIL_INTEGRATION_ENABLED and EMAIL_PROVIDER environment variables on the server.