Forum Discussion
Bookings - No data available
Hi there,
I raised this as a support ticket with MS through O365 and had a few phone calls with an 'O365 Ambassador'. He didn't have any answers, just said it looked like the data had become corrupted?? His solution was just to create a new calendar. So this is an operation issue with MS, but no answers or solutions.
Thanks
Alan
ercwebdevThen how all of my bookings are still present in the backend calendar? More a question for MS and other readers; Thank you for taking the time to reach out to MS and report back here.
In our situation, people are able to make bookings on the public/published bookings page, and they all appear in the calendar just fine, it's only the homepage-dashboard and that TSV file that are having an issue.
Is the idea that if I were to start a new calendar and reschedule all the appointments from the prior calendar, the TSV file would export properly on the new calendar? And what's to prevent this from happening again, Microsoft?
Our board of directors would already like to switch from Office 365 to G-Suite, and this is not helping my case.
We have ditched it and went with another supplier. Not a good product, it was taking double, triple bookings for slots and resulted in over bookings (https://answers.microsoft.com/en-us/msoffice/forum/msoffice_o365admin-mso_other-mso_o365b/overbooking-problem-in-ms-bookings/4cb141a3-9943-4d10-8869-15d2e789e8af?tm=1592560256922)
This perhaps might have been the reason why the dashboard and TSV file were empty. Seems it can't handle volume. Also no one from Microsoft seems bothered. I reported it to MS and spoke to a help person, they don't even have a communication channel to report this kind of stuff back to the developers. Very disappointing.
ercwebdevThank you for your follow-up. I am sorry to hear the direction this has gone for your organization.
I also ended up reaching an O365 Ambassador and spoke with his supervisor, both of whom took the time to remote in and take a look at my situation. Ultimately, it was suggested that if I unpublish the calendar and then republish it, which would kind of refresh it and make the TSV file contain data again.
The only problem being the risk of losing our current bookings, of which we have many, so a secondary option was to create a new calendar, which we have opted for as we don't want to risk losing the appointments. It's a super long process of recording our current appointments in Excel and then manually adding them back to the new calendar in Bookings.
They did suggest using PowerShell to export a list of our current bookings, but couldn't give me any commands to enter per Microsoft's policy (not allowed to suggest PowerShell scripts/commands/etc). And unfortunately I am too unskilled in PS, and on too much of a deadline to give that a go safely.
Mind if I ask which booking solution you ended up utilizing?
OVA-CJ Once you got it all copied over did you find that un-publishing and republishing resolved the TSV issue? (We have it with a few of our bookings calendars).
As per saving the data, if you open Microsoft excel and go to the Data Tab, I did find that I can connect to the "Microsoft Exchange" data source for that e-mail address and download all of the sent messages. The data attached to that excel download when worked with properly can reveal all the appointment data from the calendar. You will have to have appropriate permissions to that exchange account, but i'm assuming as a tenant administrator you have those permissions.
