Is it possible to export events from the Calendar to an excel document based on a date range or a single day?
Support Forum
It's not yet supported but we have this ticket open to look into it! https://github.com/bryntum/support/issues/1567
That would be fantastic!
The tricky issue is dealing with the recurring events since the calendar handles all the calculations for that. Being able to export the events with the recurring events already handled would be ideal.
Is there an estimate for when that release might be happening?
And if it is going to be a while, is there a way that we could handle parsing the recurrenceRule that would allow us to build our own export file?
Is there an estimate for when that release might be happening?
Currently we don't have this on the roadmap, backlog is pretty full until 5.0. That said, we're open for feature sponsorship if you need this urgently.
And if it is going to be a while, is there a way that we could handle parsing the recurrenceRule that would allow us to build our own export file?
Yes you could handle this yourselves by using https://bryntum.com/docs/scheduler/#Scheduler/data/mixin/EventStoreMixin#function-getEvents to grab the relevant events in a time span
The list
mode
is a Grid
https://www.bryntum.com/docs/calendar/#Calendar/widget/EventList
There is an (experimental) export feature which is available on an unsupported basis in the Grid package.
Docs: https://www.bryntum.com/docs/calendar/#Grid/feature/experimental/ExcelExporter
Demo of how to use it: https://www.bryntum.com/examples/grid/exporttoexcel/
So you have to include zipxls as described
<script src="zipcelx.js"></script>
Then in your app configure your Calendar
:
modes : {
list : {
features : {
excelExporter : true
},
columns : [... your extra columns]
}
},
tbar : {
items : {
export : {
type : 'button',
text : 'Export',
onClick() {
calendar.modes.list.features.excelExporter.export();
}
}
}
},
And the list view can show a range. Right click on its headers (it is also configurable):