Better report writing with the Appy framework

Awhile ago I mentioned using openoffice’s pyuno to create reports. I wanted to insert some variables right in a word file so that end users could customize reports themselves. Well it seems Appy POD does just this. While it doesn’t support ods as my little project does it’s far better in every other way. For one it doesn’t require openoffice.org unless you want to convert the document, making it way faster. It also pushes a lot of report writing work to openoffice (or any office program that can do track changes). This makes for more end user flexibility, at the expense of ease of use. I can easily pass pod Django model instances and pod will render them. In my word document I can just add

student.fname

to render some student instance’s name. You can even put python code in the document for loops and such (do row for x in many_xs can make a new row for each of your objects). Of course with such flexibility comes a sharper learning curve. You have to put python code in track changes, comments, or fields. While it looks nice to view, making the report can be frustrating. I made an openoffice extension to make it easier to add fields, just install then click tools, addons, insert field. One could also place this in a toolbar or keyboard shortcut for even easier access.

Insert Field Openoffice Extension

Appy POD is certainly worth looking into for anyone looking to do customizable report writing. It’s like Django’s templating system but for the word processor.

By David

I am a supporter of free software and run Burke Software and Consulting LLC. I am always looking for contract work especially for non-profits and open source projects. Open Source Contributions I maintain a number of Django related projects including GlitchTip, Passit, and django-report-builder. You can view my work on gitlab. Academic papers Incorporating Gaming in Software Engineering Projects: Case of RMU Monopoly in the Journal of Systemics, Cybernetics and Informatics (2008)

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: