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

[anonymous]

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!

[Steffen Hoffmann]

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

[François Granade]

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

[Jun Omae]

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.

[Steffen Hoffmann]

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

[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/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.7/site-packages/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.7/site-packages/trac/ticket/web_ui.py", line 179, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.7/site-packages/trac/ticket/web_ui.py", line 528, in _process_ticket_request
    ticket = Ticket(self.env, id, version=version)
  File "/usr/lib/python2.7/site-packages/trac/ticket/model.py", line 82, in __init__
    self._fetch_ticket(tkt_id)
  File "/usr/lib/python2.7/site-packages/trac/ticket/model.py", line 127, in _fetch_ticket
    self.values[field] = from_utimestamp(value)
  File "/usr/lib/python2.7/site-packages/trac/util/datefmt.py", line 113, in from_utimestamp
    return _epoc + timedelta(microseconds=ts or 0)
TypeError: unsupported type for timedelta microseconds component: unicode