kyleladd / osticket-trello-plugin Goto Github PK

View Code? Open in Web Editor NEW

18.0 5.0 4.0 44 KB

Integrate Trello into OSTicket -Demos: https://youtu.be/czVOCC8ZfBE https://youtu.be/BZwlHGoZ3to

PHP 100.00%

osticket trello

osticket-trello-plugin's Introduction

OSTicket Trello Plugin

The goal of this plugin is to be able to sync your OSTicket tickets with a Trello Board.

Requirements

OSTicket v1.10 - slightly modified https://github.com/kyleladd/osTicket/commits/OSTicketTrello
- Support coming soon for unmodified OSTicket v1.9.14, v1.9.15 installs
Guzzle's Requirements: V6 (see composer.json) http://docs.guzzlephp.org/en/stable/overview.html
- PHP 5.5

Installation

Note: For now, this plugin depends on OSTicket having an api which has not been merged in yet (PR #2947) as well as a PUT endpoint that I created. To see the modifications: https://github.com/kyleladd/osTicket/commits/OSTicketTrello

composer install
Copy Repo to OSTicket's plugin directory (include/plugins/)
Add New Plugin: [OSTICKET_URL]/scp/plugins.php
Select the OSTicket Trello Plugin
Enable the plugin within OSTicket
Configure the plugin via the plugin's form. Note: This must be completed after the plugin is enabled because Trello verifies the url is a 200 status code in order for the webhook to be created. Enabling the plugin first allows the plugin/OSTicket to answer the request with a 200 status code when configuring the plugin. When enabled, the plugin hooks into the url dispatcher and creates the api endpoints for Trello within OSTicket. "The provided callbackURL must be a valid URL during the creation of the webhook. We run a quick HTTP HEAD request on the URL, and if a 200 status code is not returned in the response, then the webhook will not be created." - https://developers.trello.com/apis/webhooks
The webhook field will be automatically filled when the webhook is successfully created.

Additional Configuration

Updating ticket status

Updating the ticket status is done by matching the name of the list (in Trello) to the name of the status (in OSTicket)

Adding ticket statuses in OSTicket

Admin Panel->Manage->Lists->Ticket Statuses->Add New Item

Value: Match the name of the list in Trello
Item Properties: Set the state of the ticket when it is (this status - OSTicket)/(in this list - Trello)

Functionality

Events triggered by Trello

Creating a card in Trello creates a ticket in OSTicket
Moving a card between lists in Trello updates the ticket status in OSTicket
Updating a card's description in Trello updates the ticket's description

Events triggered by OSTicket

Creating a ticket in OSTicket creates a card in Trello

Ticket Creation - Fields

Action initiated in OSTicket -> Trello

Action	Create
Title	X
Description	X
Status	X
Due Date
Attachment

Action initiated in Trello -> OSTicket

Action	Create
Title	X
Description	X
Status	X

Syncing

Action initiated in OSTicket

Action	Create	Update	Delete
Ticket	X	NA
Title	NA
Description	NA	X
Status	NA	X	NA
Due Date
Public Comment	X
Internal Comment
Attachment
Tasks

Action initiated in Trello

Action	Create	Update	Delete
Ticket	X	NA
Title	NA		NA
Description	NA	X	NA
Status	NA	X	NA
Due Date	NA
Public Comment	X
Internal Comment
Attachment
Tasks

osticket-trello-plugin's People

Contributors

Stargazers

Watchers

Forkers

noelbradford nestorwheelock facundocerezo atulmahankalsfork

osticket-trello-plugin's Issues

Plugin won't work with OsTicket v1.14

Chose to install Osticket mainly because of this plugin and wanted a kanban layout instead of list, but I couldn't get the plugin to work. Osticket just goes into 500 internal server error when I do. Will you be contributing time on this project anymore?

Thanks :)

Can't configure Plugin

Hi there,
Found this plugin - it could well be the solution I have been looking for but it won't let me configure it even after I have enabled it.

Generates :-

[DELETE ost_lock.* FROM ost_lock WHERE ost_lock.expire
---- Backtrace ----
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1175', '[DELETE ost_lo...') #1 (root)/include/class.orm.php(3133): db_query('DELETE ost_loc...', true, true)
#2 (root)/include/class.orm.php(1296): MySqlExecutor->execute()
#3 (root)/include/class.lock.php(147): QuerySet->delete()
#4 (root)/include/class.cron.php(33): Lock::cleanup()
#5 (root)/include/class.cron.php(101): Cron::TicketMonitor()
#6 (root)/include/api.cron.php(19): Cron::run()
#7 (root)/include/api.cron.php(40): CronApiController->run()
#8 (root)/api/cron.php(23): LocalCronApiController::call()
#9 {main}

What did i miss?

Czy projekt jest nadal rozwijany?

Czy projekt jest dalej rozwijany? Potrzebuję integrację osTicket w wersji 1.12 do Trello

Feature request(s)

This plugin looks awesome and just what I'm looking for.. I Would request a few features though:

Add link to the ticket from Trello to the ticket in osticket (I could probably do this myself 🤓 )
Make note in osTicket of the Trello user who modified the status or moved the ticket on Trello (maybe even this one)
Probably getting a bit harder: Make Trello and osTicket sync the ticket thread with comment thread, thus allowing communication from Trello to the ticket owner / creator
Add attachments that are added to osticket to trello and vice-versa (Make kanban visual as it is supposed to be 👍 )
Add tickets to Trello based on email fetching (don't know if it already does this..)
Create a card in Trello -> Create ticket in Osticket (info could be laid in description using keywords like department#Maintenance email#[email protected]) -> Update the created card in Trello with information from osticket
Make the plugin work based on queues/departments and not status (status with keywords, eg status#1=Open, status#2=Inprog, status#3=done). This would just change the philosophy around and Make trello control queues... You could still have a done-list in Trello, which would change the ticket status to done as well