Hello. I have managed to import story into agilo from csv.
story-template.csv:
sprint,rd_points,drp_resources,story_priority,htd,type,summary,description,milestone,created,changetime,owner,status,businessvalue,remaining_time,reporter
S1 - project1,5,user1,Mandatory,How to demo custom field,story,Story
summary,Story
description,milestone1,2009-08-18T00:14:05+0200,2009-08-18T00:14:05+0200,user2,new,
100,4,user3
command:
python csv2trac.2.py story-template.csv /usr/share/trac/projects/agilo
changes of csv2trac to support mysql:
#old return statement of method addTicket
return self.db().get_last_id(c, 'ticket')
#new return statement of method addTicket
return self.getMaxTicketId()
# added method getMaxTicketId (original version of addTicket() allways
returned 0 and custom fields were skipped in import)
def getMaxTicketId(self):
c = self.db().cursor()
c.execute('''SELECT max(id) FROM ticket''')
return int(c.fetchall()[0][0])
As you can see also custom fields are supported. I my case I added how
to demo text field to story. I think linking between stories and tasks
should not be a problem: i_links and o_links custom fields (see
trac.ini [ticket-custom]). But procedure should be the following:
- first import all tickets
- group ticket ids that belong to same story
- add custom field i_links or o_links (I am not sure) to story csv
- import all stories
br
On Aug 18, 12:28 pm, Kumar <[email protected]> wrote:
> Thanks all for the help...I'll try some of these options.
>
> On Aug 18, 5:39 am, Garbrand van der Molen <[email protected]> wrote:
>
> > Hi Tex,
>
> > I missed an Agilo trick: you canimporton the Dashboard.
>
> > As Admin, go to Dashboard -->importfrom .csv
>
> > The best way to see what can be done is to make an export to .csv of
> > an existing backlog so you see the columns and their values.
>
> > Regards,
> > Garbrand
>
> > On Aug 18, 2009, at 01:55, tex wrote:
>
> > > Hello. I would like to add some comment on this and ask some specific
> > > questions (supported complexity ofimport, linking support):
>
> > > I.importcomplexity
> > > If you export active tickets, you get following columns:
> > > __color__
> > > ,ticket
> > > ,summary
> > > ,component
> > > ,version
> > > ,milestone
> > > ,type,owner,status,created,_changetime,_description,_reporter
>
> > > Some fields like time remaining/total time, reesources are missing. Is
> > > csv2trac.2.py is smart enough toimportdata from any report, witch I
> > > find it very hard given all possible sql joins. Where is its limit?
>
> > > II. linking support
> > > Is it possible to add links between stories and tasks duringimport.
> > > Our current scrum backlog/tasklist are in excel and it would be really
> > > good if it would be possible toimportall history in agilo. Manual
> > > set of links is not really an option and in such case we will not
> > > enter history data into agilo. But it would be interesting for the
> > > statistic reports.
>
> > > Thanks,
>
> > > On Aug 17, 5:44 pm, Garbrand van der Molen <[email protected]> wrote:
> > >> Hi Kumar,
>
> > >>> Is there a way toimporta set of stories/requirements from say
> > >>> excel?
>
> > >> Yes, the easiest way to do this is to first make a 'template' to use
> > >> in Excel.
>
> > >> Go to View Tickets -> Active Tickets -> Download Comma-delimited Text
> > >> (all the way at the bottom, maybe you need to be an admin to see
> > >> these
> > >> links)
>
> > >> Now you have a template you can use in Excel to make sure the data is
> > >> in the right columns.
>
> > >> Then you can
> > >> usehttp://trac.edgewall.org/attachment/wiki/TracSynchronize/csv2trac.2.py
> > >> for instance toimportthe data,importit directly into your
> > >> database.
>
> > >> Regards,
> > >> Garbrand
>
> > >> smime.p7s
> > >> 3KViewDownload
>
> > smime.p7s
> > 3KViewDownload
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---
