Post #1 by Henry Weismann

Henry Weismann — Sat, 14 Aug 2010 06:32:40 CDT

I need a module that allows me to set up email reports for existing activecollab time reports. The module will allow me to select from existing time reports in active collab and choose to have an email sent to me with a pretty report in the email, and optionally as an attached excel file with the data. I can also have relative time period reports sent to me which active collab doesn't support yet. ie last week, 2 weeks ago, 3 weeks ago, last month, last year. I have added this to my AC but I would prefer to keep it contained in the module. Finally I can schedule the frequency of the report.

Here is the data to be shown:

Employee Hours
-employee
-hours worked this period
-days worked this period
-number of tickets worked this period

Hours spent by ticket for the time period
-ticket number
-ticket title
-this periods hours
-hours to date
-number of employees

Hours spent by project for the time period
-project
-this periods hours
-hours to date
-number of tickets closed
-number of tickets opened
-total tickets
-number of employees

Employee report section
Separate Time Report for each employee in this report
-date
-day name
-week number
-project
-ticket number
-ticket title -tasks w/ task time itemized below it
-hours

Remember an AC report can include one to many employees or one to many projects. I would prefer all this functionality stay in the module and no need to hack the core. I imagine you only need a simple user interface to set up the email reports, query the database to get the data, transform it to a pretty email and a csv, so this should be possible as a stand alone module. I am on a very tight budget and price will be a big factor in moving forward.

Finally I must own all rights to the code as I will be offering it to the community as a module.

Please email henry@weismannweb.com your quotes and delivery date.

aC forum: Email Time Reports

Post #1 by Henry Weismann