petermity <[EMAIL PROTECTED]> wrote: > >I would like to export from Trac in a similar format as I >imported to it. I used a hand-created CSV file and the script: > http://trac.edgewall.org/attachment/wiki/TracSynchronize/csv2trac.2.py > >I defined three custom fields (cross_references, meeting_discuss, >current_status). The CSV header line and one record sample: > >type,cross_references,time,changetime,component,reporter,cc,url,version,milestone,status,resolution,keywords,meeting_discuss,priority,severity,owner,summary,description,current_status >task,XR-37512,,,,,,,,,new,,,Maybe,1,1,John,"Issue sample","Description >line 1 >Description line 2: Issue discussed at meeting 'Big Issues', last Wed. >Description line 3 >","Awaiting TIB" > >This imported fine and works. But I can find no report or query >method for exporting to the same kind of CSV format. Choosing >the CSV export link at the end of a report or query does not >include the Description. > >Playing with sqlite3.exe on trac.db and the ticket and >ticket_custom tables, my newbie SQL non-skills are apparent; a >join of, or trying to select fields from, both tables gives >duplicate ticket records. What I want is a single record for >each ticket, with the three custom field values included. (I >don't really care what the field order is, just want all fields >of each ticket).
OP here - no suggestions? I'm getting tired of manually keeping my original CSV file and Trac in sync - without the ability to export what I imported, I'm hesitant to rely on Trac, not enough experience with it yet. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
