Extracting Data

sandrod · **Extracting Data -** 14-12-2007, 10:03 AM

Hi there,
I am wondering if it is possible to extract data from support suite on a weekly basis.
If so, would it be in csv format?
Thanks

craigbrass · 14-12-2007, 10:49 AM

Which sort of data are you wanting to extract? Tickets? Users?

sandrod · 14-12-2007, 12:37 PM

Hi Craig,
mainly would be tickets (i.e. closed weekly; opened weekly; opened/closed by who; time/date opened/closed; etc).
Users extraction is my second concern.
Thanks

craigbrass · 14-12-2007, 01:28 PM

You would be able to do this by querying the MySQL database. There is no current functionality to do it although reporting to do this is planned for V4.

sandrod · 14-12-2007, 03:42 PM

Sorry to ask but how do I access MySQL?
Thanks

craigbrass · 14-12-2007, 04:25 PM

You use a tool such as phpMyAdmin.

**Jamie Edwards** · 14-12-2007, 06:49 PM

Quote:

Originally Posted by sandrod

Sorry to ask but how do I access MySQL?
Thanks

This would be something to ask your web host. If you are using cPanel or Plesk to manage your hosting account, then it is likely you will use phpMyAdmin (via Plesk or cPanel) to manage your databases.

Timetabler · 16-12-2007, 05:58 PM

How would I do this with a 'Hosted' version of Kayako?

**Jamie Edwards** · 16-12-2007, 06:03 PM

Hi Timetabler,

Direct access to your hosted account is not available on hosted services, I am afraid.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to generate a new auto-increment primary key in Data Transformation Service	winnie	SupportSuite, eSupport and LiveResponse	0	17-10-2007 03:32 AM
Update LoginShare data in SupportSuite?	reDDevil	How do I?	2	03-09-2007 06:24 AM
Teamwork - Data Transformation Service for 3rd Party Database	webcast_guy	Wont Implement / Already Implemented	1	09-08-2007 07:57 PM
connection problem	inteltechs	InstaAlert	5	27-04-2006 01:23 AM

sandrod Offline New Member Posts: 3 Join Date: Dec 2007	Extracting Data - 14-12-2007, 10:03 AM Hi there, I am wondering if it is possible to extract data from support suite on a weekly basis. If so, would it be in csv format? Thanks

craigbrass Offline Senior Member Posts: 5,740 Join Date: Jun 2005 Location: Cumbria, UK	14-12-2007, 10:49 AM Which sort of data are you wanting to extract? Tickets? Users? Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

sandrod Offline New Member Posts: 3 Join Date: Dec 2007	14-12-2007, 12:37 PM Hi Craig, mainly would be tickets (i.e. closed weekly; opened weekly; opened/closed by who; time/date opened/closed; etc). Users extraction is my second concern. Thanks

craigbrass Offline Senior Member Posts: 5,740 Join Date: Jun 2005 Location: Cumbria, UK	14-12-2007, 01:28 PM You would be able to do this by querying the MySQL database. There is no current functionality to do it although reporting to do this is planned for V4. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

sandrod Offline New Member Posts: 3 Join Date: Dec 2007	14-12-2007, 03:42 PM Sorry to ask but how do I access MySQL? Thanks

craigbrass Offline Senior Member Posts: 5,740 Join Date: Jun 2005 Location: Cumbria, UK	14-12-2007, 04:25 PM You use a tool such as phpMyAdmin. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

Timetabler Offline Member Posts: 50 Join Date: Nov 2007	16-12-2007, 05:58 PM How would I do this with a 'Hosted' version of Kayako?