vrijdag 15 juli 2016

Power BI to create reports for ProjectHours

I am looking for a way to provide extended reporting for Project Hours data. It should be possible for users to use some predefined reports or explore project and activity data and create reports themselves. Microsoft's Power BI solution offers this:  Azure and Power BI

I think even the free options in Power BI suffice to provide nice reports. And Power BI is available on mobile phones too..

dinsdag 5 juli 2016

Adding project archiving and filtering for reports

Today I worked on adding an archiving option and a report filter to project and activities in ProjectHours. Users can set set projects to 'inactive'. Inactive projects or activities are read-only. Project without displayInReports set will not be availabe in overviews and reports:

This feature is not availabe live yet, will come soon.

zaterdag 2 juli 2016


I am looking into using a captcha to make it safer for users to sign up to Project Hours Time Tracking.  This component voor MVC will do the trick: https://github.com/tanveery/recaptcha-net

CAPTCHA stands for Completely Automated Public Turing test to tell Computers and Humans Apart  and is designed to determine if it is a human or a bot that is trying to logon (only humans allowed of course)..

Google's reCAPTCHA is easier  for users than the old images with distorted characters..

The user only has to tick the box to verify she/he is not a robot. How does that work? Robots can also very easily tick boxes, automated UI tests do this every day. Apparantly, Google analyzes the user's behaviour, i.e. the way the cursor moves, and is able to determine whether it concerns  a human or robot. More explanation in this stackoverflow thread: How does the new reCAPTCHA work