Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Trying to import calendar data - Lightning ignores the import attempt

  • 3 replies
  • 1 has this problem
  • 2 views
  • Last reply by christ1

Kirbo
Kirbo
more options

Attempting to migrate calendar data from Time & Chaos personal information manager into Lightning. I can export data to .csv .ixp or .vcs formats.

I've attempted using Lightning's import with .csv , and with .vcs files (by changing the file extention to .ics).

In either case, I identify the file to Lightning import, click "ok," but nothing happens - no displays indicating Lightning is considering the file, no error messages, and after waiting several minutes, no change to the calendar display which would demonstrate it accepted the file.

My data files contain about 6200 records. Each record contains four fields: Data, Start Time, End Time, Description

Data in the description field have contained multiple lines.

When I open the files in Excel, they look clean. I don't see data fragments in unexpected places.

Suggestions on how I might massage the data so Lightning will import?

Thanks!

Attempting to migrate calendar data from Time & Chaos personal information manager into Lightning. I can export data to .csv .ixp or .vcs formats. I've attempted using Lightning's import with .csv , and with .vcs files (by changing the file extention to .ics). In either case, I identify the file to Lightning import, click "ok," but nothing happens - no displays indicating Lightning is considering the file, no error messages, and after waiting several minutes, no change to the calendar display which would demonstrate it accepted the file. My data files contain about 6200 records. Each record contains four fields: Data, Start Time, End Time, Description Data in the description field have contained multiple lines. When I open the files in Excel, they look clean. I don't see data fragments in unexpected places. Suggestions on how I might massage the data so Lightning will import? Thanks!

All Replies (3)

amanchesterman
amanchesterman
more options

In an effort to help you I've just exported my Thunderbird calendar data to a csv file. The fields are (left to right): subject (text - description of the event), start date (mm/dd/yy), start time (hr:min:sec), end date, end time, all day event (boolean), reminder on/off (boolean). The column headings come from the Thunderbird export function I assume. I don't know about the date and time formats or whether they are crucial anyway. All the 'subject' entries are short text descriptions (just a few words at most) but that's how I keep my diary. I hope that gives you something to work on.

Kirbo
Kirbo Question owner
more options

I'm embarrassed I didn't think of that!

Thank you for the suggestion. I will export some Tbird contacts, see if the resulting file looks as you describe, and structure the export file accordingly from Time&Chaos.

Best! Kirbo

christ1
christ1
  • Top 25 Contributor
more options

You'd need to export your Time & Chaos calendar to a format Thunderbird can import. That's the .ics format. Changing the file extension doesn't change the format.