Exporting Notes Calendar entries to Google Calendar


 Product:
 Export Utility for Lotus Notes / Domino > Export to Google Calendar > Version All

 Platform(s):
 All

 Edition(s):
 All

 Doc Number:
 1000088
Published 29-Mar-2016

 General Information

This support notes provides information on how to setup the export items for exporting Lotus Notes Calendar items to a comma delimited file which can then be read and imported into Google Calendar.

 Solution

The information below outlines the steps to perform to export your Lotus Notes Calendar items to a Comma Delimited (CSV) file. You can then use the import feature in Google Calendar to import the entries.

Create a new view in your mailfile
The first step is to create a new view in your mailfile. This view will contain all calendar entries sorted and displayed in a specific format for exporting. Please refer to the attached Excel file (CalendarEntries View Columns.xlsx) for the columns to add to the view and the formatting / formulas for each column.

The view selection formula should be: SELECT @IsAvailable(CalendarDateTime) & !@IsAvailable($Conflict)

If you're familiar with importing Lotus DXL content into databases or editing design elements using the DXL Editor you can import the DXL code contained in the attached 'CalendarEntries.dxl' file. An easy way to do this is to create a new view called 'Calendar Entries' in your mailfile using the Lotus Designer client. There is no need to add any columns or format it in any way. Save & close the view and have it selected in the Designer client. Click 'Tools' on the Lotus Designer client menu then select 'Edit with DXL'. Completely clear all the DXL code from the view then copy / paste the DXL code from the attached file into the DXL Editor. Save and close the editor. To ensure the signature on the view is correct double-click on it to open it, make a dummy change (such as adding / removing spaces to a view column) then save it.

Create a new Comma Delimited Export
Create a new export with the following settings:
  • Under the 'Export Options' section of the export profile set the output file format to Comma Delimited.
  • Under the 'Database' section select the database / mailfile you just created the new view in.
  • Under the 'View' section select the new view you created (ie. Calendar Entries)
  • When prompted to add all view columns to the export items section click the 'Yes' button.
  • Select the 'Export Items' section. Ensure all view columns have been added. If no view columns have been added click the 'Add' button then select 'All View Columns'.
  • Click the 'Add' button and select 'Field'. The field name to add is 'Body' and the target export field name should be 'Description'. Ensure the field type is set to 'Rich Text'.
  • The Export Items section should now contain 14 items - 13 view columns and 1 field.
  • Under the 'Output File' section specify the path / filename of the CSV file to create (eg. c:\Export\CalendarEntries.csv)

Run the Export
Now that you've created the view and setup the export you can click the 'Export' button at the top of the export profile then select 'In Foreground'. The export will immediately run and output all calendar information to the specified CSV file.

You can now use the appropriate Google Calendar import feature to import the calendar information.



CalendarEntries View Columns.xlsxCalendarEntries View Columns.xlsx CalendarEntries.dxlCalendarEntries.dxl



  Related Attachments


© 2016 AGE Computer Consultancy. All rights reserved.
Material may not be reproduced or distributed in any form without permission.