On May 5, 6:08 am, "Mihamina Rakotomandimby (R12y)" <[email protected]> wrote: > Hi all, > I want to add ticket in a mass way. > We have a project with something like... 1.5 thousand of HTML pages, with > crappy HTML. > I would like to loop (with BASH or any langage not choosen yet) on all > those files with "tidy" and, on the fly, create a ticket with the output of > tidy. > > My first idea is to directly talk to "db/trac.db" and insert the tickets > into the sqlite3 DB-file. > I know notifications wont work, but it's not a real problem for that case. > > What SQL request have I got to perform in order to INSERT that kind of > tickets in the cleanest way? > > Milestone, ticket owner, priority are already ready. > > -- > Chef de projet chez Vectoris > Phone: +261 33 11 207 36 > System: xUbuntu 8.10 with almost all from package install > http://www.google.com/search?q=mihamina+rakotomandimby
There is a csv import script out there in the wild. Can search this group for import or csv probably to find the thread about it. Might be on trac-hacks or the contrib folder, I forget. between that, and parsing the html, you should be able to build good to go. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. 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/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
