import iteration

[Josh Kidd]

Hi all,

I've been trying to figure out the new import iteration feature
without much success. What form does the data need to be in for it to
work?

Thanks for any help.

Josh

[Emiliano Heyns]

On Apr 28, 9:56 pm, Josh Kidd <k...@stwing.upenn.edu> wrote:
> Hi all,
>
> I've been trying to figure out the new import iteration feature
> without much success. What form does the data need to be in for it to
> work?

My word, an honest-to-god second user! ;)

When you click "import" you're presented with an edit box with some
text in
it; copy the contents of that box in its entirety and paste it in cell
A1 of
an empty spreadsheet (Excel or Openoffice will do; haven't tested any
others).

You then fill out the sheet; fill in IDs if you're editing existing
iterations/stories/tasks (this has not seen extensive testing, just
light
use), or leave the IDs empty to create a new iteration/stories/tasks.

The upper "Name" is the name for your iteration. Start and end dates
*must*
be in YYYY-MM-DD notation.

For the lower part, You basically fill out your task info. Tasks that
have
the same story name get rolled up into one story with that name.
Priorities
are in order stories are found in the sheet. If the owner is filled
in, it
must be an existing username for the current project (the import will
complain if it isn't). Tags are optional.

I implemented this because I couldn't keep up clicking around in
agilito
during our planning sessions, so I have a dump of the product backlog
in
Excel and use that during planning, and import it. It's nowhere near
perfect, but it's been useful to us.

When done, select and copy the data in your spreadsheet and paste it
back
into the edit box, and press Save. The checkboxes are there so you
don't
inadvertently create iterations/stories.

Regards,
Emile

[Josh Kidd]

Thanks Emiliano. I actually work for ifPeople, so I probably don't
count as a new user.

In any case, this explanation was exactly what I needed.

Thanks again.

Josh