SupportSuite reporting.

byronsmith · **SupportSuite reporting. -** 01-08-2007, 10:30 PM

Good evening,

We're looking at purchasing your product however we've noticed a very important part of the the product is lacking which is reporting.

Being a helpdesk, reporting to me is crucial as I need to make reports for billing purposes.

Before I purchase your product can you tell me when reporting will be improved? If it's going to take a while is it possible to query the database myself with a few SQL queries and gather the data myself and is there any documentation on the database schema? Or are there any scripts that you know that people have developed to help in this area?

Basically I need reports for billing purposes, and this is the only thing that is putting me off.

Thank you and good night.

craigbrass · 02-08-2007, 08:09 AM

It would be possible to do this with a database query yes. If you are not able to do this yourself, I suggest you look in the Marketplace board (http://forums.kayako.com/f76/) and choose a developer to assist you. I recomend SoftAir.

richm · 02-08-2007, 02:44 PM

I'm only just exploring this, but I think you can use an ODBC connection from within excel to pull data from the DB. You may need to google to get the connector for MySQL.

Having said that, my limited testing has produced mixed results (fields come back with junk sometimes... which may be something I'm doing wrong, but I haven't had time to debug)

I'm no expert in this at all so I can't offer much more ATM, hopefully someone in the community who is more skilled with this kind of thing (cough ...Sheep) will take on reporting

If you figure it out, please share.

HTH,

Rich

byronsmith · 03-08-2007, 09:14 PM

Well, I bit the bullet and bought the software. I'm fairly efficient with SQL queries to hopefully with a few inner joins etc I'll be able to gather the stats I need. If I figure it out to a point where I can supply a script I will be sure to share it, no problems.

Take care and thanks for the replies.

Regards
Byron

richm · 03-08-2007, 09:30 PM

Thanks Byron!

I'm sure the community would appreciate it tremendously (as current reporting is simply not useful at all)

Rich

craigbrass · 04-08-2007, 08:45 AM

Yes, please post it in the developers forum if you manage to work something out. Therer are many users who would find this useful.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SupportSuite Owned License Inquiries	bmc2010	Presales Questions	3	27-08-2006 07:58 PM
Showcase: SoftAir & DemoWolf partner for complete SupportSuite customizations	demowolf	Marketplace	0	21-03-2006 01:09 PM

craigbrass Offline Senior Member Posts: 5,552 Join Date: Jun 2005 Location: Cumbria, UK	02-08-2007, 08:09 AM It would be possible to do this with a database query yes. If you are not able to do this yourself, I suggest you look in the Marketplace board (http://forums.kayako.com/f76/) and choose a developer to assist you. I recomend SoftAir. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

byronsmith Offline New Member Posts: 4 Join Date: Aug 2007	03-08-2007, 09:14 PM Well, I bit the bullet and bought the software. I'm fairly efficient with SQL queries to hopefully with a few inner joins etc I'll be able to gather the stats I need. If I figure it out to a point where I can supply a script I will be sure to share it, no problems. Take care and thanks for the replies. Regards Byron

craigbrass Offline Senior Member Posts: 5,552 Join Date: Jun 2005 Location: Cumbria, UK	04-08-2007, 08:45 AM Yes, please post it in the developers forum if you manage to work something out. Therer are many users who would find this useful. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger