Architecture / Installation

Architecture / Installation

Re: How to convert Tracker items into regular SQL table with field names as columns

posts: 1797 Catalan Countries
grg111 wrote:


I'd like to use a report generator we have in the workplace (Crystal Enterprise) to dig into our Tracker data and send pdf reports to people (who are not tiki conversant) after joining the data from several linked Trackers.

To help with this I wanted to create a MySQL View that refactors a given Tracker's data with its various field names as the table columns and the item_field values as the values in those columns. The query would essentially return a recordset of all of that Tracker's items, with all fields having a value in each row. It is then relatively straightforward from here to get the desired report.

If anyone knows how to do this as a query in MySQL, if it is possible, or has some other suggestion to achieve the desired outcome, please let me know.


Hi Gary:

Send this question to the tikiwiki-devel list instead, I could say (see Lists for link, if needed).

Afaik, Robert Plummer is working towards a report generator from trackers to do exactly this (and Robert had that working on his own custom Tiki 6.x, even if they are porting it to Tiki trunk).

See this as example:

Good luck.

Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.