Unable to import CSV to Calendar

[joeg1484]

Hello, I am trying to import a CSV from Evolution but get the following error:

Check line 1 of file /home/jgiles/Downloads/evolution-calendar-20220404.csv
Aborting import```

I am using version 2.0.1

here is the head of the file if this helps.

```BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
PRODID:-//SabreDAV//SabreDAV//EN
X-WR-CALNAME:Joes Calendar
X-APPLE-CALENDAR-COLOR:#248EB5
REFRESH-INTERVAL;VALUE=DURATION:PT4H
X-PUBLISHED-TTL:PT4H
BEGIN:VTIMEZONE
TZID:America/Denver```

Im using this on a fully updated version of Pop_OS.

Let me know if you need any more info.
Thanks!
Joe

[joeg1484]

Also tried an Addressbook CSV and got the same error. Is this feature not working?

I can import text files it appears. Thanks! Joe

[juddmon]

The above file is in VCalendar or Ical format. You can export in CSV format and see what jpilot expects the file to look like.

[joeg1484]

Hi, thanks for the reply... Im sorry, I copied from the wrong file.

Here is a couple lines from the Evolution calendar export to CSV:

` $ head Evolution.csv

bbd05147-9962-49de-a5ff-b92e3b35bac6, Massage with Tammy, , , , , 2022-03-07 04:09:40, , 2022-04-11 17:00:00, 2022-04-11 18:00:00, 2022-04-11 18:00:00, , , , , , 2022-03-07 04:09:56 861A0952-74AD-4250-910D-C3361F555708, Dentist appointment, , , , , 2022-01-27 18:27:43, , 2022-04-13 16:00:00, 2022-04-13 17:00:00, 2022-04-13 17:00:00, , , , , , 2022-01-27 18:27:43 298703bc-66f0-4a4b-8abc-e419a4a34c0e, David Vigil Birthday, , Birthday, , , 2020-01-06 01:38:40, , 2020-03-05 00:00:00, 2020-03-06 00:00:00, 2020-03-06 00:00:00, , , , , , 2020-01-06 01:39:14 007b1873-c357-4bb2-8721-84c5978f083b, Joey's Birthday, , Birthday, , , 2012-04-18 00:04:37, , 2012-04-17 00:00:00, 2012-04-18 00:00:00, 2012-04-18 00:00:00, , , , , , 2021-04-11 17:28:02 F4A2D537-B276-43D6-A31F-B87DE4AEB641, Massage Envy, , , , , 2022-01-21 01:25:36, , 2022-02-16 19:30:00, 2022-02-16 20:30:00, 2022-02-16 20:30:00, , , , , "Massage Envy 4229 Crestview Dr SE, Rio Rancho, NM 87124, United States", 2022-02-17 02:20:51 96B1E9EF-039C-4373-984E-4B31485FDD28, Miles’ Birthday, , , , , 2021-04-25 14:35:33, , 2021-04-24 00:00:00, 2021-04-25 00:00:00, 2021-04-25 00:00:00, , , , , , 2021-04-25 15:07:10 `

That is just a couple records... Same error from Jpilot... Is there a log file I can look at?

Incorrect header format for CSV import Check line 1 of file /home/jgiles/Downloads/Evolution.csv Aborting import

Thanks! Joe

[juddmon]

If you do a CSV export from jpilot and see the first line, it expects that line to be there for the import and the records to be in the same order. You could write a simple program to re-order the Evolution export using bash/awk, perl, ruby, etc.