Schedule export for Google calendar

in
Category: 
Workflow

This report is specifically built to generate a CSV file that can be imported into a Google calendar (ie you can print the output but it is not intended that you do). This report has no parameters. It dumps a specific schedule for the date range today to today+31 days (actually +32 but seeing the time is 00:00:00 then its really for 31 days). The schedule dumped is that named "Dr Gething" - you will obviously want another schedule. To change this edit the .jrxml file (using a simple text editor like notepad) and find line 37 which will be:

and sd.name = 'Dr Gething'

Change the 'Dr Gething' to whatever your schedule name is and save the file and import it into document template.

When you run the report, simply press the Export button and save the .csv file. Then in Google calendar, click the pull-down arrow to the right of 'Other Calendars' (see snippet below) and click the 'Import calendar' option.

Note that when your appointments secretary makes a new appointment and wants to update your calendar, the imported items will override the previous entries. This means that if you have been making notes by editing the calendar entries, these notes will be lost. If you do want to do this (ie make visit notes in the google calendar) then you should be using a second calendar to do this, so that the next import from your appointment secretary does not wipe out your updates.

Note also, that this export to Google calendar is simply a workaround for the 'I don't want to use OPV while I am driving around, I like google calendar on my iPhone' problem.

Thanks to Ben C for his schedule print report which I cloned to make this one.

Regards, Tim G

 

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Schedule export for Google calendar

Thanks for sharing this Tim. I have modified it to have an input parameter for the schedule name so the schedule to be exported can be entered by the user.

I also had to change the font to arial so I could use it on my server.  

AttachmentSize
Appointments-Export-V2.jrxml 12.34 KB
Syndicate content