Jump to content


Member Since 20 Jun 2013
Offline Last Active Sep 01 2014 10:27 AM

#13469 Export reports to PDF

Posted by Rinck on 04 April 2014 - 07:43 AM

I just stumbled upon an interesting method of generating PDF's with the Yii framework:



This is a Yii module for the PDFWkHtmlToPdf (composer) package. The latter is a wrapper function for the wkhtmltopdf library which uses Webkit to render HTML pages to convert HTML to PDF. From what I've read, this is a very clean method to do the conversion and it renders the pages beautifully as webkit is obviously a very mature engine.


The library can be used on a headless server and also provides statically linked libraries which should allow people to use this even on (some) shared hosting platforms.


If you're running multiple Zurmo installations on 1 server (which I assume Zurmo is doing with the Pro edition), you can use a single wkhtmltopdf instance for all HTML2PDF conversions, which seems efficient! :)


As a bonus, the amount of code required to convert to PDF is only a few lines. For Zurmo I could see you being able to re-use (partial) views, send them to PDF and done! 


And, last but not least: all components are open source and can be freely integrated into open souice and commercial software!


Of course there are alternatives such as TCPDF, which is a powerful PDF package, but also quite cumbersome to use (I've used it in a bunch of projects and the HTML rendering is very limited and it takes a lot of coding and fine-tuning to get the output just right).


Just thought I'd share this with you, hoping this may speed up the process of implementing this feature!


- Rinck

#13417 Override locale settings

Posted by Rinck on 27 March 2014 - 11:44 AM

Although it is officially correct to use thousand separators in numbers in The Netherlands, it is also not very common; people only tend to do this when the number start getting really large (think 1 million+) and when talking about currencies.


So in many cases, having Zurmo display a regular number such as 123456 as 123.456 feels unnatural to Dutch people.


It seems as if Zurmo derives these locale settings directly from the Yii framework, so I can obviously edit the file directly.


However, it would be cleaner and more update-proof if these settings could be overwritten from within Zurmo for each installed language.


So if the Languages section in the Admin area could have a "Configure" button for all installed languages, allowing you to select the preferred thousand separators, delimiters, etc. etc., that would increase flexibility for the end user.


If you want to go even further, you could make a distinction between currencies and regular numbers, but I'm not sure if the extra work associated with this would be worth it.


Hope to see this in a next version of Zurmo! :)

#13399 Time-based workflow enhancement

Posted by Rinck on 25 March 2014 - 08:34 PM



with Zurmo 2.6.5 it is possible to create a time-based workflow based on a certain time before or after a specific record field. Example: 1 day after the creation date of a record, perform action X.


What I would like to see added to it is the possibility to run periodic workflows without specifying a time trigger, but just selecting a regular trigger/filter.


Example use case: I have a custom opportunity identifier (let's just call this opportunity ID for now) which I have added as a custom field. Now, I want to copy this custom identifier to all related projects.


The problem is that when I use the existing functionality, the time based trigger is executed only once, so when I create a new project after the workflow has executed, it will no longer copy the ID to the project, unless I edit/save the opportunity once again or add an infinite amount of time triggers.


Basically, I'm looking for a way to run workflows periodically regardless of any time based triggers, just regular filters.


Different use case: sending task due date reminders. With the current functionality you would have to create a new workflow/time trigger for each reminder (7 days in advance, 6 days in advance, etc). If it would be possible to just select a trigger/filter, you could have reminders sent untill the task is actually closed/completed, without creating a bunch of workflows and time triggers.

#6394 Installation error: Table 'zurmo.notification' doesn't exist

Posted by Rinck on 20 June 2013 - 01:10 PM



I was just trying to install the latest stable version of Zurmo and ran into some issues.


I followed the installation instructions and have all the right permissions and file ownership set (running on Ubuntu Server 12.04 LTS, Apache2, PHP5, MySQL5).


After going through the installation process, I get the following error:

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zurmo.notification' doesn't exist
The reference id for this error is 3c8a08af82ff4ec08e09b7d6517145ca.

The message is valid; when checking the database the table in question really does not exist! :)


The detailed log show a bunch of errors as well, in the form of:

Error - The attributes that did not validate probably need more rules, or are not deletable types.
Error - *** Saving the sample ContactWebFormEntry failed.

Error - The attributes that did not validate probably need more rules, or are not deletable types.
Error - *** Saving the sample ContactWebForm failed.


Is this because I did something wrong or is there a bug in the setup somewhere?


Hope you can help!