Lightning: Importing “Tasks” from Outlook

importlightningtasksthunderbird

The Problem:

I am trying to migrate user from Outlook 2003 to Mozilla Thunderbird w/ Lighting extension.

User kept important data stored as Tasks. While I can easily export Tasks from Outlook 2003 to it's default CSV format, I found so far no way to import the CSV into Lightning.

The Research:

So far I have found no out-of-the-box solution.

In fact, the only solution I can actually think of would be to manually prepare and inject CSV data into the SQLite database storing Lighting data (<profile_dir>\calendar-data\local.sqlite).

That solution needs quite a lot of work, though. The single task data is stored among several tables, I'd have to manually match columns, find some solution to recalculate date values etc.

Attempted solutions:

  1. Tried to export data from Outlook to .ics using Outport as @Randolph West suggested. When ordered to import that file, Lightning did nothing.
  2. Attempted to build an .ics myself, basing on a template task exported from Lightning (so that I could be sure the format itself is not an issue). Same result as with attempt #1.

The Question:

I am looking for some out-of-the-box solution, or at least a near one. A solution that could be comfortably used by some less-than-skilled users.

Best Answer

I've been looking at this and can't find an easy solution.

However, I plan to try the following steps tomorrow, unless someone has a reason why it won't work:

PLAN:

  1. Export all Outlook TASKS to csv
  2. Edit the csv to look like Lightning EVENTS
    (this will lose some data and looks like the most difficult step as Lightning is very fussy about importing csv's. I think all fields have to be quoted, and dates without centuries will appear in the 1900's if you aren't careful)
  3. Create a new calendar and import all the EVENTS
  4. Select all the EVENTS and convert them to TASKS
    (this involves reviewing all the entries manually, but is better than having to retype them all!)
  5. Select all the TASKS and move them to another calendar (if you don't want them in a separate calendar)

Anyone who knows this won't work, please let me know. Otherwise I'll report back if it is successful.

Mark

Related Question