Import Excel-file to calender?
Import Excel-file to calender?
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?
... thanks...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....
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.