This project involved the development of a browser extension for Chrome and Firefox that displays specific data from the ERP system Vertec in Atlassian Jira. Vertec is used by IT service providers to record services, whereby Jira ticket numbers (e.g. PROJEKT-12345) are often used to assign bookings. The browser extension makes it possible to display Vertec bookings that are assigned to a Jira ticket number directly in the respective Jira ticket. In this way, the time and activity recordings that have been booked on a Jira ticket can be displayed directly in Jira, grouped by agent, which creates a seamless and transparent overview of the recorded activities.
Functionalities in detail
- Display Vertec bookings in Jira:
- The browser extension enables the display of Vertec bookings linked to the specific Jira ticket number directly in the respective Jira ticket.
- All Vertec bookings are matched with the relevant Jira ticket number, grouped by editor, totaled and prepared for a clear display.
- Automatic query via Node.js backend:
- When a Jira ticket is loaded, the extension sends the ticket number to an internal Node.js application.
- This application performs the query in Vertec via its XML interface, prepares the data accordingly and makes it available for display.
- Data preparation and display in Jira:
- The retrieved data is processed in the Node.js backend and then displayed in the Jira ticket via an embedded iFrame. This allows users to see all relevant information at a glance without leaving Jira.
- The data includes the hours worked, grouped by agent, as well as a total for the respective ticket.
- Grouping and totaling by agent:
- Vertec bookings are grouped and totaled by agent for a better overview. This means that all recorded services per ticket and employee can be displayed transparently and clearly.