Modify

Opened 4 years ago

Closed 4 years ago

Last modified 3 years ago

#8357 closed defect (fixed)

Cannot import date correctly from excel by using TicketImportPlugin

Reported by: farialima Owned by: farialima
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords:
Cc: chohsei@… Trac Release: 0.11

Description

from http://groups.google.com/group/trac-users/browse_thread/thread/4980c112b534bbef :

(sorry I had hadn't seen that before -- seems like a real bug)

I'm trying to import some tickets information to Traclightning from excel.
But it seems that the date information(ticket's due_assign, due_close)
cannot be imported correctly, they are imported as text.
The other fields can be imported correctly.

I've installed the TicketImportPlugin and xlrd library like the
following link's description.

Maybe this is a very simple question,
Could someone tell me how to resolve this? Please help me.
Thank you very much.

Attachments (0)

Change History (5)

comment:1 Changed 4 years ago by farialima

ticket's due_assign, due_close

I suppose these fields were coming from another plugin. Could you tell me what plugin it was ?

comment:2 Changed 4 years ago by chohsei@…

Thank you very much for your comment, farialima.
I think due_assign, due_close are coming from tracganttcalendarplugin 0.2.

Here is the information.


tracganttcalendarplugin 0.2
Provide calendar and ganttchart.

プラグイン作者: okamototk@user.sourceforge.jp
ホームページ: http://sourceforge.jp/projects/shibuya-trac/
ライセンス: New BSD

comment:3 Changed 4 years ago by farialima

  • Status changed from new to assigned

comment:4 Changed 4 years ago by farialima

  • Resolution set to fixed
  • Status changed from assigned to closed

Fixed in [9736]. There now an option:

[importer]
datetime_format=....

that will be used to format the dates when importing. The format is the Python fstrtime, see http://docs.python.org/library/time.html#time.strftime

comment:5 Changed 3 years ago by hasienda

Just a hint, that import of real time (stamps) as in #4783 is related, but certainly not the same as with the strings coming from current plugins (including DateFieldPlugin).

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from farialima. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.