can't import time, changetime
|Reported by:||Owned by:||François Granade|
i'm trying to switch from spiceworks (ew) to trac (yay) and trying to get our old tickets out of it. i know this isn't the goal of this plugin but that its purpose has veered more towards this over time. i finally got some nice xls files ready to go with proper time, changetime fields. however, no matter what i do to the format in either the xls file or in trac.ini, i am faced with an error.
from what i gather by mousing over datetimes in trac, it appears that the standard format is %m/%d/%Y %H:%M:%S, so i edited my datetimes in the xls and get an error: ValueError: invalid literal for int() with base 10: '02/11/13'
so then i tried to stick with the native format from spiceworks, e.g. 2013-11-02 @ 05:15 pm so i edited trac.ini as such:
[importer] datetime_format=%Y-%m-%d %I:%M %p
same problem, more or less: ValueError: invalid literal for int() with base 10: '2013-02-11 @ 05:28 pm'