Hi All, Look into this plugin it will help you a lot to upload a bunch of tickets form excel or csv.
http://trac-hacks.org/wiki/TicketImportPlugin. Regards vela.velappan On Aug 18, 4:55 pm, tex <[email protected]> wrote: > Table for links between nodes is agilo_link so i_links and o_links > must be something else. > > On Aug 18, 1:44 pm, tex <[email protected]> wrote: > > > Hello. I have managed toimportstory 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 inimport) > > 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: > > - firstimportall tickets > > - group ticket ids that belong to same story > > - add custom field i_links or o_links (I am not sure) to story csv > > -importall 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 -~----------~----~----~----~------~----~------~--~---
