Export to PDF directly from database?

Spreadsheet
#1

Hello

I need to export directly from the database to a PDF file…
The included PDF-export function work like… Get json from data.php, somehow convert it to xml and send it to generate.php…

I did find someone, on the forum with the same problem… But that was all for the “grid module”… I’m really unsure how to do it…

viewtopic.php?f=23&t=22095
viewtopic.php?f=23&t=27332
viewtopic.php?f=23&t=23136

Can anyone help?

Regards Kristian

#2

The existing export functionality

docs.dhtmlx.com/connector__php__ … xport.html

generates XML from database, sends it to export point and receives the file back. There is no need for json-to-xml conversion

While documentation states that it is “grid related”, this technique can be used with any table in DB.

#3

It seems like I can’t answer with quote…

But that export library, it don’t seems like it can limit to a sheetid?

#4

It looks like I can use render_sql… But that not exactly what I want, as the database contain colum_id and rowid, and so on…

#5

Export is quite simple, it export only one page (sheet) of data.

Yep, export expects that you have structure of table similar to the structure of the export sheet ( one record in table - one row in the export file )