搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信,及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

Importing a csv calendar into Lightning messes up the imported data

  • 1 个回答
  • 1 人有此问题
  • 5 次查看
  • 最后回复者为 gsoulis

more options

I have a set of events that repeat over time, but in a way that can not be represented with the repeat options available in Lightning, so I thought I could create a csv file and import it.

Unfortunately this failed in 2 major ways: 1. The descriptions of the events are in Greek and when imported they become jiberish. 2. The dates of the events change and the events become "all day events" (no starting or ending time)

Note: I am posting my question here because importing a calendar seems like a tool someone might use migrating to Thunderbird and not in the way I have in mind.

I tried several encodings, in order to solve the 1st problem with out success. Using UTF-8 without BOM allows the file to be imported, but the problem remains. In any other format the import fails.

I tried to solve the second problem by using a 4digit year in the date, but even then the problem remains. With a 2digit year the date is changed to the 1900s. In the calendar tab the date appears in the 2000s (i.e. 1/8/2018=Aug 1, 2018), but in the Edit event window is different (1/8/1918=Aug 1, 1918) (see attached screenshot) with a 4digit year the date changes in a way I do not understand (30/8/2018=Aug 30, 2018 becomes 8/6/2020=June 8, 2020)

To simplify thing I tried exporting the 2 events already in Lightning into a csv file and re-importing them. Both problems ocurred as shown in the attached screenshot.

I have a set of events that repeat over time, but in a way that can not be represented with the repeat options available in Lightning, so I thought I could create a csv file and import it. Unfortunately this failed in 2 major ways: 1. The descriptions of the events are in Greek and when imported they become jiberish. 2. The dates of the events change and the events become "all day events" (no starting or ending time) Note: I am posting my question here because importing a calendar seems like a tool someone might use migrating to Thunderbird and not in the way I have in mind. I tried several encodings, in order to solve the 1st problem with out success. Using UTF-8 without BOM allows the file to be imported, but the problem remains. In any other format the import fails. I tried to solve the second problem by using a 4digit year in the date, but even then the problem remains. With a 2digit year the date is changed to the 1900s. In the calendar tab the date appears in the 2000s (i.e. 1/8/2018=Aug 1, 2018), but in the Edit event window is different (1/8/1918=Aug 1, 1918) (see attached screenshot) with a 4digit year the date changes in a way I do not understand (30/8/2018=Aug 30, 2018 becomes 8/6/2020=June 8, 2020) To simplify thing I tried exporting the 2 events already in Lightning into a csv file and re-importing them. Both problems ocurred as shown in the attached screenshot.

所有回复 (1)

more options

Here is the screenshot, which did not make it in the original post. P.S.: I tried, but the upload took for ever.