Ticket #278 (closed enhancement: fixed)

Opened 3 years ago

Last modified 3 years ago

Allow alternative data/time formatting during import

Reported by: e.vansomeren@… Owned by: e.vansomeren@…
Priority: minor Milestone: 0.8.1
Component: Import wizard Version: 0.6.3
Keywords: Cc:
Product: Operating system:
URL: Hardware:

Description

When importing date/time information, imported values may not always follow the required formatting. Some flexibility would be nice to have.

In our case, we have recorded the timestamp as (this is generated by from Google Docs):
12/2/2010 12:07:30
should be translated to (I'm not sure what other formatting you accept)
2010-12-02 12:07:30.0

We should also think about month/day vs day/month issues?

Attachments

NTC_Experiment_test4.xls Download (31.5 KB) - added by e.vansomeren@… 3 years ago.
Compared to test3, I changed date format in column A (and some text in column F)

Change History

Changed 3 years ago by e.vansomeren@…

Compared to test3, I changed date format in column A (and some text in column F)

Changed 3 years ago by e.vansomeren@…

I've tried to change the date formatting in my import file to suit yours, however this file is no longer accepted (it does not react anymore when I click next, while if I upload NTC_Experiment_test3.xls it goes to the next step) (See attached file NTC_Experiment_test4.xls).

Changed 3 years ago by work@…

  • status changed from new to assigned
  • owner changed from business@… to t.w.abma@…
  • milestone set to 0.7

Changed 3 years ago by work@…

  • component changed from Unknown to Import wizard

Changed 3 years ago by work@…

  • milestone changed from Should have to 0.8.1

The problem here is that you can only make this smart to some extent, as you do not know which part is day and which part is month, unless either one of them is larger than 12.

However, perhaps it would be possible to ask the user what the format of a particular date field is (e.g. specify 'dd/mm/yyyy' or 'dd-m-yy' etc)?

Changed 3 years ago by t.w.abma@…

  • owner changed from t.w.abma@… to e.vansomeren@…

Added dropdown in the import wizard which lets you choose the kind of date format the importer can expect. Please test again.

Changed 3 years ago by work@…

  • status changed from assigned to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.