ticket,summary,type,release,owner,status,created,modified,_description,_reporter
10188,simple import failed,defect,0.12,François Granade,reopened,2012-07-26T11:27:46+02:00,2017-07-12T09:05:49+02:00,"The file is the attached .xls one. The callstack here is:
{{{
Traceback (most recent call last):
  File ""build\bdist.win32\egg\trac\web\api.py"", line 440, in send_error
    data, 'text/html')
  File ""build\bdist.win32\egg\trac\web\chrome.py"", line 868, in render_template
    stream.render(method, doctype=doctype, out=buffer)
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 183, in render
    return encode(generator, method=method, encoding=encoding, out=out)
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 58, in encode
    for chunk in iterator:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 339, in __call__
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 826, in __call__
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 670, in __call__
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 771, in __call__
    for kind, data, pos in chain(stream, [(None, None, None)]):
  File ""build/bdist.macosx-10.6-i386/egg/genshi/output.py"", line 586, in __call__
    for ev in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build\bdist.win32\egg\trac\web\chrome.py"", line 981, in _strip_accesskeys
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build\bdist.win32\egg\trac\web\chrome.py"", line 970, in _generate
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 605, in _include
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/markup.py"", line 378, in _match
    ctxt, start=idx + 1, **vars):
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/markup.py"", line 378, in _match
    ctxt, start=idx + 1, **vars):
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/markup.py"", line 327, in _match
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 545, in _flatten
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/path.py"", line 588, in _generate
    subevent = next()
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 605, in _include
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/markup.py"", line 316, in _strip
    event = next()
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 545, in _flatten
    for kind, data, pos in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/core.py"", line 288, in _ensure
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/path.py"", line 588, in _generate
    subevent = next()
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 605, in _include
    for event in stream:
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/markup.py"", line 316, in _strip
    event = next()
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 565, in _flatten
    result = _eval_expr(data, ctxt, vars)
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/base.py"", line 277, in _eval_expr
    retval = expr.evaluate(ctxt)
  File ""build/bdist.macosx-10.6-i386/egg/genshi/template/eval.py"", line 178, in evaluate
    return eval(self.code, _globals, {'__data__': data})
  File ""d:/trac/test_devel\.egg-cache\Trac-0.12.2-py2.5.egg-tmp\trac\templates\error.html"", line 165, in <Expression u'shorten_line(repr(value))'>
    <td><code>${shorten_line(repr(value))}</code></td>
  File ""build\bdist.win32\egg\mastertickets\model.py"", line 118, in __repr__
    (self.tkt.id, l(getattr(self, 'blocking', [])), l(getattr(self, 'blocked_by', [])))
  File ""build\bdist.win32\egg\mastertickets\model.py"", line 115, in l
    return '[%s]'%','.join(arr2)
TypeError: sequence item 0: expected string, int found
}}}

It's Trac-0.12.2 on Windows, TicketImportPlugin is the latest from SVN, TracMasterTickets-3.0.2-py2.5.egg is the latest available.",falkb
5504,importing new tickets with arbitrary pre-defined number rejected by trac,enhancement,1.0,François Granade,reopened,2009-07-13T17:51:32+02:00,2018-04-14T03:43:57+02:00,"Error: Ticket 1540 found in file, but not present in Trac: cannot import.

Trying a simple one ticket import file.  It seems to be trying to work but instead of adding it is failing out because it can not find the ticket.

perhaps there is a setting somewhere I am missing?",trac@…
12781,Allow field's labels and names in first line of csv file,enhancement,,Jun Omae,assigned,2016-05-21T04:46:14+02:00,2016-05-21T06:14:38+02:00,"After trac:#11762, csv/tsv export couldn't be used for this plugin. Also, field's label doesn't not have uniqueness. It should reject a file with such labels.

For this plugin, csv/tsv file always should use field's names, should not use field's labels.",Jun Omae
4783,"import preserving historic time stamps, needed i.e. for legacy projects",defect,0.11,François Granade,new,2009-03-13T17:03:10+01:00,2014-11-24T23:01:01+01:00,"Hello,
We started using a project using Excel to maintain a log of tasks and the remaining time (on a daily basis)
Is it possible to import tasks such that this information is updated in the ticket_change table so that the past dates are added. 

For example:

||Task||Date||Rem time||
||1 ||   1/1/08 ||   80||
||1  || 1/2/08 || 76||

Now I want this information to get into the ticket and ticket_tables on the past date - not today's date. 

Thoughts?

Thanks!
",anonymous
8722,Sample worksheet to download,enhancement,0.11,François Granade,new,2011-04-20T10:06:44+02:00,2011-04-20T10:06:44+02:00,It would be nice if there was a button to download an empty excel worksheet that contains only header with field names,wrobel@…
8777,Provide a way to import CVS with multi-line fields,enhancement,0.11,François Granade,new,2011-05-09T17:04:17+02:00,2011-08-20T22:42:21+02:00,"Comments and Description can have multiple lines but there is no way to put a line break in a CSV value.  It would be nice if the import looked for ""\n"" (or something) and made a link break there.",Chris Nelson
8778,Provide a way to override the unique Summary requirement,enhancement,0.11,François Granade,new,2011-05-09T17:06:15+02:00,2017-08-28T04:21:28+02:00,"I have a list of tickets that I create for every new developer (read our Coding Standard, etc.).  The limitation to unique summaries makes me put ""1Read this Spec"", etc. in the CSV and increment the leading number each time.  It would be nice to have a checkbox to override the uniqueness limitation and create new tickets.  Or maybe a ""Create / Update"" radio button.",Chris Nelson
11343,Modify imported fields only,defect,0.12,François Granade,new,2013-10-09T10:54:03+02:00,2013-10-09T10:54:03+02:00,"This Tool is very helpful. But I have one problem with it.

If I want just modify tickets in several fields this tool want all fields which are not presentet in the import modify with default values.

In my point of view makes this sense during adding of tickets. During modifying of tickets would it very helpful fields are not presented in import to leave untouched. 

",didley@…
6034,"imported milestone column not handled, if no milestone present",defect,0.11,François Granade,new,2009-10-26T17:37:56+01:00,2010-04-23T20:14:43+02:00,"Summary pretty much says it all - if there are no components, the milestone column will not be handled. (As if it was not present in file). 

Trac 0.11.5stable-r8357
",terje
6070,Notification are not sent when tickets are imported (was: Email addresses as Usernames),defect,0.11,François Granade,new,2009-10-29T18:32:11+01:00,2014-08-17T02:37:55+02:00,"Our trac installation uses email addresses as usernames, and for some reason the TicketImport fails to recognise these as valid usernames when importing either the xls or csv, and therefore doesn't send out any email alerts.

Trac does however manage to assign the tickets to the correct users - any ideas?  Maybe I've missed something.

Thanks for your help",anonymous
7770,Match on custom field - Request,enhancement,0.11,François Granade,new,2010-10-04T18:48:22+02:00,2010-10-04T18:48:22+02:00,"Hi, 

Would it be possible to extend this plugin to match on Ticket or ID, Summary '''OR user defined field? ''' ''(as an override to Summary)''

I am syncing two systems, and unfortunately trac is the slave.  When I export from the Master system, I preserve the original system's ticket it into a custom field in trac.  I would like to ''update'' based on that field, instead of Summary.  I'd like to use ""custom field"" exactly the same way summary is used now, in this case, I would like to ignore the Summary duplicate checking and use my field.  (yes, I have identical summaries on initial import for many tickets, gotta love ""clone"",sigh)

Logic becomes : if (ticket or ID)...else if (Custom field and Unique) else if (Summary and Unique) else....errors, or similar.

I may try to make this mod myself, but really like your plugin and don't want to kludge it!
Thanks.",Jay