Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - nexxer

Pages: [1]
Feature requests / Re: Custom reports (Tasks) feature request
« on: June 23, 2009, 10:23:41 am »
I'll second that.

Right now you have to add a condition for "Completed On" to be less than a day in the past (before you started using Opengoo). This is because the date field will not let you enter 0 or leave it empty, to indicate a task that hasn't been completed.

Showing the Workspace column in Task reports would be useful too.

In case someone finds this useful, what I am using right now to get a customized tasks report is the following query:

SELECT AS Project,
IF( is not null,, '') AS Milestone,
IF(tasksParent.title is not null, tasksParent.title, '') AS ParentTask,
tasks.title AS Task,
users.username AS 'User',
(CASE tasks.priority WHEN 300 THEN 'High' WHEN 200 THEN 'Medium' WHEN 100 THEN 'Low' END) AS Priority,
IF(tasks.due_date <> '0000-00-00 00:00:00', tasks.due_date, '') AS 'Due Date'
FROM opengoo_project_tasks AS tasks
LEFT JOIN opengoo_project_tasks AS tasksParent ON tasks.parent_id =
LEFT JOIN opengoo_projects AS projects ON tasks.project_id =
LEFT JOIN opengoo_users AS users ON tasks.assigned_to_user_id =
LEFT JOIN opengoo_project_milestones AS milestones ON tasks.milestone_id =
WHERE tasks.completed_by_id = 0 /* incomplete tasks */
AND tasks.project_id NOT IN (SELECT id FROM opengoo_projects WHERE name LIKE '%personal') /* no personal tasks */
AND tasks.priority > 100 /* no low priority */
ORDER BY ASC, ASC, ParentTask ASC, tasks.priority DESC;

You'll need to run this directly in your database client program, while having selected the opengoo database.
It won't show low priority or personal workspace tasks.

Feature requests / Default task assignee = self
« on: March 23, 2009, 11:05:28 am »

I find that I add alot of tasks that I assign to myself. It could be convenient to have "Me" as the default setting in the task combobox instead of "Don't assign", which also promotes better project management practices by not having unassigned tasks and making you think about who should do something the moment you add it.


Getting Started / Re: I need to compile on my own?
« on: March 19, 2009, 04:47:00 am »

It's a web-based tool. It doesn't need compilation but it will need a web server and a database server. In order for people to collaborate with it the web server should be accessible by all of them.

The easiest way to set up a web and database server on a Windows machine is via a package such as xampp . It has an installer and sets everything up. After it's set up you'll have to unzip the opengoo files into xampp's apache root directory.

However, I suggest that before you get into all that, take a look at the demo that's hosted at to make sure opengoo suits you :)

Announcements / Re: Procedure for joining the localization efforts
« on: March 13, 2009, 08:09:56 pm »
I'd like to do the Greek (el_gr) localization.

Installation problems / Re: can not login
« on: March 12, 2009, 06:29:00 am »
Perhaps the login form should warn users that cookies are required, either always or after checking if the user has cookies disabled.

Right now when you try to login with cookies disabled it just reloads the form. Without looking at the code my guess is it  tries to setup session variables, the lack of which upon checking for them take you to the login prompt.

1.3-beta / Calendar import/export button title
« on: February 28, 2009, 03:31:32 pm » "Contacts import and export"

This is because the entry in lang.js:

'import - export': 'Contacts import and export'

is used as the tooltip in both ContactManager.js and CalendarToolbar.js

   imp_exp: new Ext.Action({
      text: lang('import/export'),
           tooltip: lang('calendar import - export'),

This is fixed by adding a new entry in lang.js,

'calendar import - export': 'Calendar import and export',

and using that as the tooltip in CalendarToolbar.js.


Feature requests / Re: UI issue: Pending Tasks
« on: February 28, 2009, 03:08:38 pm »
I too noticed some confusion over this when I first introduced a co-worker to opengoo tasks.

Why not mimic the display in the Tasks tab, with the checkbox icon on the left with the "Complete" word? It gives an extra hint of what's going to happen.

To make it clearer and avoid confusion on whether it's a verb or adjective, perhaps substitute "Complete" with "Finish", "End", or "Close"?

On the other hand, well selected icons are known to convey such common actions effectively on their own. Why not simply remove the word and leave an icon in its place? The only drawback I can think of is making the click target shorter, which hampers usability (Fitt's Law).

1.2 RC2 / typo "file fize" in ImageChooser.js
« on: February 16, 2009, 11:14:44 am »
line 105 in public/assets/javascript/og/ImageChooser.js

data : [['name', lang('name')],['size', lang('file fize')],['lastmod', lang('last modified')]]

should be "file size" not "file fize". It can't find that string in lang.js so it shows an error in the imagechooser filter dropdown.


Pages: [1]