Opened 7 years ago

Last modified 18 months ago

#4783 new defect

import preserving historic time stamps, needed i.e. for legacy projects

Reported by: anonymous Owned by: farialima
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords: create_time change_time
Cc: Trac Release: 0.11


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:

TaskDateRem 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.



Attachments (1)

t4783-support-time-field.diff (13.0 KB) - added by jun66j5 5 years ago.

Download all attachments as: .zip

Change History (7)

comment:1 Changed 6 years ago by hasienda

#5564 requested import of ticket (updates) with historic time stamps too, was closed a duplicate of this ticket, but there's no progress or solution so far.

comment:2 Changed 6 years ago by hasienda

  • Summary changed from Importing legacy projects to import preserving historic time stamps, needed i.e. for legacy projects

comment:3 Changed 5 years ago by farialima

see also comment:ticket:5564:4 and comment:ticket:5564:6 for the exact scope of this problem

comment:4 Changed 5 years ago by jun66j5

I worked the issue and attached the patch, t4783-support-time-field.diff.

The values in time column of your uploading file is used for the ticket creations. However the values is NOT used for the ticket modifications.

Changed 5 years ago by jun66j5

comment:5 Changed 5 years ago by hasienda

  • Keywords create_time change_time added

#8357 has been fixed, adding ability to import date/time information for custom date/time fields as string. This is certainly not the same but a related issue.

comment:6 Changed 18 months ago by anonymous

Unfortunately, although an import with a changetime column is successful, it is then impossible to view the ticket, and the following traceback is produced:

Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/trac/web/", line 497, in _dispatch_request
  File "/usr/lib/python2.7/site-packages/trac/web/", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.7/site-packages/trac/ticket/", line 179, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.7/site-packages/trac/ticket/", line 528, in _process_ticket_request
    ticket = Ticket(self.env, id, version=version)
  File "/usr/lib/python2.7/site-packages/trac/ticket/", line 82, in __init__
  File "/usr/lib/python2.7/site-packages/trac/ticket/", line 127, in _fetch_ticket
    self.values[field] = from_utimestamp(value)
  File "/usr/lib/python2.7/site-packages/trac/util/", line 113, in from_utimestamp
    return _epoc + timedelta(microseconds=ts or 0)
TypeError: unsupported type for timedelta microseconds component: unicode
Last edited 18 months ago by jun66j5 (previous) (diff)

Add Comment

Modify Ticket

as new The owner will remain farialima.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.