1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Kayako Integration [Deleted]

Discussion in 'Add-on Releases' started by Mike2020, Oct 13, 2014.

  1. Mike2020

    Mike2020 Well-Known Member

    Mike2020 submitted a new resource:

    Kayako Integration - Kayako Integration

    Read more about this resource...
     
    Dan Hawkins and Alfa1 like this.
  2. Dan Hawkins

    Dan Hawkins Active Member

    FINALLY!!!!! :D <3

    Will give this a whirl and let you know.
     
  3. Dan Hawkins

    Dan Hawkins Active Member

    Quick question.... Can this do Logins from Kayako > XenForo? Rather than XenForo > Kayako

    Reason I ask, we have all clients in Kayako atm, but none in XF.
     
  4. Alfa1

    Alfa1 Well-Known Member

    This is very useful. Thanks!

    Feature requests:
    1. Show tickets on xenforo user profile
    2. Show xenforo account in Kayako tickets
    3. Show open tickets in XF moderator bar

    This would make life much easier.
     
  5. Mike2020

    Mike2020 Well-Known Member

    sadly the loginshare only works one way, the members that are signed up in your kayako would have to signup in your xenforo system as well.
    They would have to use the same username email and password or the loginshare would create a new account for them in the kayako system.

    I might be able to make a import script to import the users from kayako to xf but that is only a might would have to have a look into this for you.

    Will see what i can sort out.
     
    Rob, Alfa1 and Dan Hawkins like this.
  6. Mike2020

    Mike2020 Well-Known Member

    Alfa1 likes this.
  7. Alfa1

    Alfa1 Well-Known Member

    That looks great. How about showing the number of open support tickets? Or is that the same as new support tickets?
     
  8. Mike2020

    Mike2020 Well-Known Member

    same as new tickets
     
    Alfa1 likes this.
  9. kontrabass

    kontrabass Well-Known Member

    I'm assuming that this only works with an in-house installation of Kayako, and not their hosted solution?
     
  10. Mike2020

    Mike2020 Well-Known Member

    you have to have this installed on your server.
     
    kontrabass likes this.
  11. kontrabass

    kontrabass Well-Known Member

    @Mike2020 Is the xml missing a table? Getting this error after installed:

    Code:
    An exception occurred: Mysqli prepare error: Table 'xenforo3.swtickets' doesn't exist in /home/talkbass/html/library/Zend/Db/Statement/Mysqli.php on line 77
    
    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in KayakoSupport/Model/KayakoSupport.php at line 105
    KayakoSupport_Model_KayakoSupport->GetNewSupportTickets() in KayakoSupport/Listener/KayakoSupport.php at line 14
    KayakoSupport_Listener_KayakoSupport::navigationTabs()
    call_user_func_array() in XenForo/CodeEvent.php at line 90
    XenForo_CodeEvent::fire() in XenForo/Dependencies/Public.php at line 495
    XenForo_Dependencies_Public->_getNavigationContainerParams() in XenForo/Dependencies/Public.php at line 371
    XenForo_Dependencies_Public->getEffectiveContainerParams() in XenForo/FrontController.php at line 616
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/talkbass/html/index.php at line 13
    
     
    Last edited: Nov 12, 2014
  12. Mike2020

    Mike2020 Well-Known Member

    this integration does not add any tables to the database it uses the kayako database
     
  13. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    By looking at the error log I think you have to install both kayako and XenForo on the same database...
     
  14. Mike2020

    Mike2020 Well-Known Member

    thats right you do have to have both on the same database
     
  15. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    I don't think that's a good idea... why not create a new Zend_Db instance for the kayako database?
     
  16. kontrabass

    kontrabass Well-Known Member

    Without knowing any technical details behind the reason, I would just rather keep things separate... @Mike2020 if we can help out with a donation etc to allow use of a separate kayako DB, please do let me know.
     
    Alfa1 likes this.
  17. Mike2020

    Mike2020 Well-Known Member

    i will work on this again soon and see if i can sort this out.
     
    kontrabass and Alfa1 like this.
  18. kontrabass

    kontrabass Well-Known Member

    Bump (y) Let me know if we can help out in any way. :D
     
    Dan Hawkins likes this.
  19. kontrabass

    kontrabass Well-Known Member

    @Mike2020 Are you still interested in exploring use of a separate kayako database? If not I'll bark up another tree ;) Thanks much!
     
    Dan Hawkins likes this.
  20. Mike2020

    Mike2020 Well-Known Member

    yes this is something thats still in plans to sort out.
     
    kontrabass and Alfa1 like this.

Share This Page