Import Excel-file to calender?
Verfasst: Mi 14. Jan 2009, 08:26
I need to find a way to import an excelfile (or excel supported file) to my calender. Anyone know what fileformat to use and in what order the fields shall be in?
Seite 1 von 1
Verfasst: Mi 14. Jan 2009, 17:52
Not possible. Calendar-Imports are possible from vcs, ics and xml-files.
Verfasst: Mi 14. Jan 2009, 19:21
Does anyone know if there are any way top convert excel-files to vcs, ics or xml? As it is a table and can be converted to tabed files etc, I think it should be possible to do quite easy, but how...
Verfasst: Mi 14. Jan 2009, 21:17
Save the Excel-Table as csv, Import it to Outlook and then export it from Outlook as iCalendar or vCalendar
Verfasst: Mi 14. Jan 2009, 22:26
Ok, have to install Outlook then, frell 
... thanks...
... thanks...Verfasst: Di 20. Jan 2009, 18:38
Now I have tried it... It did almost work...
Outlook supports imported excels if you know the magic way it shall be formated. If anything is wrong (for example forgot a magic special character in any cell) nothing happens. No error messages or anything... Go Microsoft. They ahve no specification how they shall be formated either it seems... But still after some time I got this step to work.
Step 2, export. They claim to support ical and csv export. In reallity this only works for an appointment at the time (atleast in Outlook 2003).
I solved this with a macro written by some person that was as annoid as I was.
In the end all these steps are unacceptable... So I'm back to square one after 2 h work...
FJ: Have you ever thougth of adding support for imports of tab-separated lists or ;-separated lists??
Anyway, thanks for the support I have gotten, seems like it is back to manual labour and cursing the University in Umeå, Sweden which lives in the stone age... How can you claim to be a university for the future whsn you can't produce schedule that is importable to calender software....
Outlook supports imported excels if you know the magic way it shall be formated. If anything is wrong (for example forgot a magic special character in any cell) nothing happens. No error messages or anything... Go Microsoft. They ahve no specification how they shall be formated either it seems... But still after some time I got this step to work.
Step 2, export. They claim to support ical and csv export. In reallity this only works for an appointment at the time (atleast in Outlook 2003).
I solved this with a macro written by some person that was as annoid as I was. In the end all these steps are unacceptable... So I'm back to square one after 2 h work...
FJ: Have you ever thougth of adding support for imports of tab-separated lists or ;-separated lists??
Anyway, thanks for the support I have gotten, seems like it is back to manual labour and cursing the University in Umeå, Sweden which lives in the stone age... How can you claim to be a university for the future whsn you can't produce schedule that is importable to calender software....
Verfasst: Di 20. Jan 2009, 21:15
CSV-Import for calendar was planned, but the problem is that you have some must-have-fields in an appointment (Begin-Time, body,...). CSV-Format is too flexible for this job. f.e. Outlook saves StartDate and StartTime in seperate fields.
MPE does already support CSV-Import for contacts - but in your position i'm afraid this will not help you.
MPE does already support CSV-Import for contacts - but in your position i'm afraid this will not help you.
Verfasst: Di 20. Jan 2009, 21:59
Thanks anyway.