Contents

Overview

VueMinder Calendar can import events from a Microsoft Excel workbook, provided the workbook data is compatible with VueMinder Calendar's requirements. The file should be formatted with a header row followed by event rows (one event per row). This feature requires Excel 2003 or later to be installed on the system.

The following header column labels are required. These can be in any order:

  • Title - Event title
  • Start - Event starting date/time
  • End - Event ending date/time, required only if Duration is not specified
  • Duration - Event duration, required only if End is not specified

The following header column labels are also supported, but not required:
  • Location - Event location
  • Calendar - Event calendar name
  • Category - Event category, separate multiple categories semicolons
  • Description - Event description

 

This information is also displayed in the import window.

The import calendar window.

Settings

If there are duplicate events already present in VueMinder Calendar, you can choose to overwrite these when importing from Excel, rather than creating duplicate copies. Event duplicates are detected based on the event title, owning calendar, and the date and time that the event begins. You can also chose to apply the destination calendar's default event settings to any new events that are imported. Note, to prevent the possibility of a large number of reminders from being displayed after importing, events that occur in the past will not have their reminders enabled, even if the default calendar settings specify a reminder.

You can choose to overwrite any duplicate events that are detected.

Importing

After you've selected an Excel workbook to import, click the Import button. If the workbook does not contain a "Calendar" column, the imported events will be assigned to the active calendar. Otherwise, the imported events will be assigned to calendars matching the calendar names specified in the Excel workbook. Any calendars that don't exist will be created automatically. The import results will be updated after all events from the workbook have been imported. If there are many events in the workbook, this could take several seconds. After the import completes, the Calendar View and Event List will update to show the newly imported or updated events.

The import calendar window will update as the import is processed.

Have a Question?

Your email address:

Question/comments:

Copyright © 2009 VueSoft. All rights reserved.