Opened 7 years ago

Last modified 3 years ago

#12813 closed defect

TypeError: unsupported operand type(s) for -: 'unicode' and 'datetime.datetime' — at Version 1

Reported by: sandeep.nadkarni@… Owned by: Jun Omae
Priority: normal Component: TicketImportPlugin
Severity: major Keywords:
Cc: sandeep.nadkarni@… Trac Release: 1.0

Description (last modified by Jun Omae)

Getting unicode and datetime.datetime error while importing from xls/csv 

Trac - 1.0.10.
TicketImport Plugin - ticketimportplugin-15601 
python 2.7.5
Centos 7.2

File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 554, in _dispatch_request
File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 247, in dispatch
File "build/bdist.linux-x86_64/egg/talm_importer/importer.py", line 86, in process_request
File "build/bdist.linux-x86_64/egg/talm_importer/importer.py", line 130, in _do_import
File "build/bdist.linux-x86_64/egg/talm_importer/importer.py", line 401, in _process
File "build/bdist.linux-x86_64/egg/talm_importer/processors.py", line 153, in end_process_row
File "build/bdist.linux-x86_64/egg/talm_importer/processors.py", line 122, in _save_ticket
File "/usr/lib/python2.7/site-packages/trac/ticket/model.py", line 306, in save_changes
File "/usr/lib/python2.7/site-packages/trac/ticket/model.py", line 376, in _to_db_types
File "/usr/lib/python2.7/site-packages/trac/util/datefmt.py", line 186, in to_utimestamp

Change History (1)

comment:1 Changed 7 years ago by Jun Omae

Component: SELECT A HACK → TicketImportPlugin
Description: modified (diff)
Owner: set to Jun Omae
Priority: high → normal
Status: new → assigned

time and changetime columns cannot be imported from Excel/CSV file.

Please provide how to reproduce and Excel/CSV file if you don't use time and changetime columns.

Note: See TracTickets for help on using tickets.