Questions and ideas - while evaluating agilo42

[Thomas Lehmann]

Hi all,

we are currently evaluating agilo42 and it is looking very good. I
myself like the idea to have a scrum layer above trac being written in
Python.

Here are some notes and maybe anybody can give some comments on this:

- At the taskboard at the wall we are using colored post-it's shipped
with four colors in a package. Yellow for stories and story tasks,
orange for bugs, green for dependencies and pink for impediments. Is
this somehow supported or planned by the tool?

- Dots: we have learned to place dots on post-it's as an indicator
that we have worked last day on it (daily scrum). If you have some
more dots on a task then a ScrumMaster can ask the team member whether
it is possible to split the task to reflect that some work has been
done. The remaining task has no dots anymore then. The idea behind ...
can this be checked somehow with the actual version? Or is this
planned to be supported?

- Splitting tasks: Is this possible somehow?
- The estimation meeting is not yet part of the tool, right?
- The sprint planning one with the "committment" is not yet part of
the tool, right?

- I tried a little to avoid that a product owner can assign anything
to a given sprint; but I failed. Can somebody give a hint please?

- We know, management is doing micromanagement, often. However being
somewhere in the world traveling with smart phones they would like to
have an overview about what is going on. I have seen that there is
support for RSS. However this means having many entries in a "mail
folder" to navigate through; you can not see states like "todo", "wip"
or "done". Sending one mail the day about the status of all teams
might be a better help to have a rough overview. The wiki of agilo
does support reports but I can not send them as one mail nor is this
configurable. Can this be supported in near future?

- Printing: Does anybody have an example on how to provide stories in
printed form for a team estimation meeting using agilo?

Many things, sorry...

Thanks in advance
Thomas

[jmb]

On Jul 27, 1:16 pm, Thomas Lehmann <t.lehm...@rtsgroup.net> wrote:
> - Printing: Does anybody have an example on how to provide stories in
> printed form for a team estimation meeting using agilo?
>

You can define a report using the following SQL query:

==============================8<------------------------------
SELECT
p.value AS __color__,
id as ticket,
summary,
t.type as type,
coalesce ((SELECT cst.value
FROM ticket_custom cst
WHERE cst.name = 'rd_points'
AND cst.ticket = id),
(SELECT SUM (cst.value)
FROM ticket_custom cst
WHERE cst.name = 'rd_points'
AND EXISTS (SELECT *
FROM agilo_link
WHERE src = t.id
AND dest = cst.ticket)),
'')
as complexity,
ifnull ((SELECT cst.value
FROM ticket_custom cst
WHERE cst.name = 'businessvalue'
AND cst.ticket = id),
'')
as value,
status
FROM
enum p,
ticket t
WHERE
p.name = t.type
AND p.type = 'ticket_type'
AND (t.type = 'requirement' OR t.type = 'story')

ORDER BY
coalesce ((SELECT pos
FROM agilo_backlog_ticket
WHERE ticket_id = id),
(SELECT pos
FROM agilo_backlog_ticket,
agilo_link
WHERE dest = id
AND name = 'Product Backlog'
AND ticket_id = src),
99999999),
(CASE
WHEN t.type = 'requirement' THEN 0
ELSE ifnull ((SELECT pos
FROM agilo_backlog_ticket
WHERE ticket_id = id),
99999999)
END),
id
------------------------------>8==============================

Then save it as CSV. I have an Excel file which can import the CSV and
format it nicely. The report only includes requirements and user
stories since management shouldn't need to bother with tasks, but it
wouldn't be difficult to add the tasks.

Jerome

PS: How can I attach the Excel file?

[Robert Buchholz]

On Wednesday 28 July 2010, jmb wrote:
> PS: How can I attach the Excel file?

I think you can just post an attachment to the list. I've seen it work
for images and text files, I would be surprised of Google rejected excel
files.

Robert

[jmb]

On Jul 28, 10:33 am, Robert Buchholz <robert.buchh...@agile42.com>
wrote:

Except that I don't see a button nor a link to attach a file to a
message in the Google groups interface.

Jerome

[Robert Buchholz]

On Wednesday 28 July 2010, jmb wrote:
> Except that I don't see a button nor a link to attach a file to a
> message in the Google groups interface.

Oh well. That's a proposed feature for Google then. You could just send
a mail to ag...@googlegroups.com via your regular email interface
though.

Robert

[jmb]

On Jul 28, 12:19 pm, Robert Buchholz <robert.buchh...@agile42.com>
wrote:

OK, then you can find the Excel file here: http://jeberger.free.fr/public/AgiloBacklog.xls

You will need to enable the macros. In order to use it, click on the
big "Update" button to the right of the headers, choose the CSV file
you exported from the above SQL report and you should see the backlog
appear with different colors for the requirements and user stories.

Jerome

[Dean M]

Has anyone created a similar report like this for the Sprint backlog?