Still Baffled that Importing data to Calendar

J

Jack McDonald

Why is it that when I try to import data from Execl (Date-Event-Time)
to the Calendar in Entourage there is no corresponding fields in
Entourage.

There must be an easy way. if not why?????
 
P

Paul Berkowitz

Why is it that when I try to import data from Execl (Date-Event-Time)
to the Calendar in Entourage there is no corresponding fields in
Entourage.

There must be an easy way. if not why?????
Click to expand...

Because there isn't ANY way except by AppleScript. You can only import
contacts from built-in menu items.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
J

Jack McDonald

Paul,

I tried all the scripts...no luck..

Cannot believe that Entourage Calendar has an import feature and there
is not even a "Date" or "Time" Mapped field to import too!

I know you have many good scripts (band-Aids), but I am shocked that
MS Office 2004 does not have a date or time field to import calendar
schedule info to.

reason for my e-mail was more as a suggestion to the MS folks.

Thx

Jack
 
P

Paul Berkowitz

Calendar Import into X script in my Export-Import Entourage X package
imports calendars from tab-delimited text files, but they have to be
formatted in a specific way first. There are two ways:

1. Make sure you have an intelligible header (field names) row 1. Save the
Excel worksheet as Text (Tab-Delimited). Use the "Other Calendar to EvX"
script in the Other Converters package to map fields on this .txt file, if
you can. Then run the Calendar Import into X script.

2. If there's some reason why that doesn't work (just maybe there's an
incompatible date format), use the Excel Import Adapter script first . You
might also need some of the other Excel scripts in the Xcel Extras subfolder
- see the ReadMe "Excel" section. After manipulating the columns as
directed, run Excel Import Adapter again, then run the Calendar Import into
X script.

Method 1 is a lot simpler, if there's no problem with the formats.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
Top