Would like to import our athletic schedules to the Entourage Calendar,
then post to the web.
When using the Script "Calendar Import to X", I get an error message
that
You have either not selected your Calendar Export file or you have
changed its name.
What name/format should the file I want to import (using the script)
be named???
Really strange and disappointing that Entourage Calendar cannot easily
import from an excel file.
I don't think anyone other than I (who wrote the script) would or should
know the answer to this question. It makes more sense for you to write the
author of the script (me again, at the email address specified in the
ReadMe) than to ask on this newsgroup.
The answer is in the ReadMe that comes with the script. The Calendar Import
to X script can only import a text file with specific fields in the right
order, as well as the file named correctly (that's a safety precaution).
Read the "Excel" section of the ReadMe: many features have been provided
with the Excel scripts in the "Xcel Extras" folder.
You should run the "Excel Import Adaptor X" script once. That will insert a
header line with the correct headers. Then you need to move the columns
around (removing your original header line now in Row 2) underneath the
appropriate header, leaving in place any (empty) columns you don't need but
the script does, and deleting any extra columns you may have that the script
doesn't want. Most likely you will also need to use the "Excel Merge Columns
X" script too to merge separate Date and Time columns you might have for
Start Time and End Time. When everything's all ready, run the "Excel Import
Adaptor X" script again - it will save the worksheet as a text file that
"Calendar Import to X" can import.
One important thing: I have received some reports that AppleScripting of
Excel 10.1.5 is broken. If you get errors such as "Can't get «class XLUR» of
class «XLAS»" , you'd need to Remove Office, and reinstall Office, then
apply Office 10.1.2 and 10.1.4 updaters but not 10.1.5.)
You can possibly avoid all this activity in Excel if you have a text file in
the first place, by running the "Other Calendar to EvX" script in "Other
Converters X" subfolder instead. It can do all these manipulations for you.
It's in the ReadMe too, in "Other Programs" section.
