Trac tab-delimited Export

[anonymous]

I am trying to export my trac tickets-change history with following SQL-Query:

SELECT DISTINCT
t.id AS Ticket, 
t.description as Description,
group_concat ( tc.author, '; ') AS Author,
group_concat ( tc.field, '; ') AS Field
/*group_concat ( tc.oldvalue, '; ') AS Comments_Old */
group_concat ( tc.newvalue, '; ') AS Comments_New
FROM ticket t
LEFT JOIN ticket_change tc ON ( t.id=tc.ticket )
GROUP BY t.id, t.summary

Problem is that he puts a linebreak at the field 'Comments_New' like seen on the screenshot

[Jun Omae]

Not a bug.

The newlines can be contained using double-quotes.

>>> import csv
>>> import sys
>>> writer = csv.writer(sys.stdout, delimiter='\t', quoting=csv.QUOTE_MINIMAL)
>>> writer.writerow(['abc', 'abc\ndef'])
abc     "abc
def"

[anonymous]

ok thank you very much for your quick answer.

I am new to trac, so can I integrate the double-quotes to my SQL-Query?

[anonymous]

I replaced my single quotes with double quotes but it didn't worked, there are still newlines

[Jun Omae]

No, no. The tsv format allows that newlines can be contained in each field.

[Jun Omae]

If you dislike newlines in your tsv export, you can use REPLACE() function to remove newlines.

MySQL

GROUP_CONCAT(REPLACE(tc.newvalue, '\n', ''), '; ') AS Comments_New

SQLite

GROUP_CONCAT(REPLACE(tc.newvalue, CHAR(10), ''), '; ') AS Comments_New

InstallationIssue. Support and installation questions should be asked on the mailing list or IRC channel.

[anonymous]

Thank you i tried your suggestion, we use MySQL, but the line breaks are still there it didn't worked..