HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Print entire Knowledge Book


#1

Is there an easy way to print an entire Knowledge Book? My boss want us to keep a hard copy of each one. Our Helpspot is installed on a Linux server running MySql. Thanks for any help!


#2

Hi Chris,

For public KB’s there’s a print view full list at the bottom of the TOC in the portal. For private books there isn’t such a page. You could build one with the API or direct query of the database though.


#3

Thanks for the reply! Can you give me an example of a MySQL query? I’m wanting to make sure of the tables and fields involved.

Thanks,

Chris


#4

It’s probably better to use the API because you’ll be able to have all the proper page titles, etc. The SQL is a little complicated because you have to drill down and get all the chapters for a book and then all the pages for a book. If you can’t use the API let me know and I’ll build you a sample query, but the API is better if possible.


#5

Hi All

So how do we build a API so we can print the private books?

Regards