Event column header change in TSV export in Bookings

%3CLINGO-SUB%20id%3D%22lingo-sub-2156732%22%20slang%3D%22en-US%22%3EEvent%20column%20header%20change%20in%20TSV%20export%20in%20Bookings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156732%22%20slang%3D%22en-US%22%3E%3CP%3ESeems%20like%26nbsp%3B%20a%20column%20header%20of%20the%20TSV-export%20file%20had%20a%20change%3A%20column%20%22Type%22%20changed%20to%20%22Event%20Type%22.%20In%20this%20colum%20you%20will%20find%20the%20values%20%22Single%22%20or%20%22Group%22%20reservations.%3C%2FP%3E%3CP%3EOur%20staff%20is%20working%20with%20an%20Excel-file%20which%20uses%20an%20embedded%20Power%20Query%20to%20show%20them%20the%20hourly%20updates%20in%20the%20reservations%20and%20provides%20them%20with%20a%20printer-friendly%20report.%3C%2FP%3E%3CP%3ESuddenly%20Friday%20afternoon%20February%2019th%20CET%20the%20Power%20Query%20showed%20errors%20because%20of%20the%20name%20change%20of%20that%20column.%3C%2FP%3E%3CP%3ENot%20sure%20if%20Microsoft%20gives%20a%20head%20up%20for%20such%20changes%20...%20%3F%3C%2FP%3E%3CP%3EWe%20use%20Power%20Query%20to%20split%20the%20Date%20Time%20field%20and%20filter%20out%20the%20group%20Bookings.%20In%20our%20case%20the%20single%20Bookings%20are%20the%20dates%20of%20closure.%3C%2FP%3E%3CP%3EWe%20chose%20this%20solution%20while%20awaiting%20a%20full%20adoption%20of%20group%20reservations%20in%20the%20Bookings%20web%20application.%20Till%20today%20this%20has%20a%20lot%20of%20limitations.%3C%2FP%3E%3CP%3EAttached%20is%20the%20Excel-file%20we%20use%20to%20get%20the%20detail%20from%20our%20group%20reservation%20services%20in%20Bookings.%20Just%20as%20an%20example.%3C%2FP%3E%3CP%3EIf%20you%20put%20this%20Excel-file%20in%20c%3A%5Ctemp%20together%20with%20the%26nbsp%3BBookingsReportingData.tsv%20file%20you%20download%20from%20your%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Foutlook.office.com%2Fbookings%2Fhomepage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Foutlook.office.com%2Fbookings%2Fhomepage%3C%2FA%3E%26nbsp%3Bit%20should%20give%20you%20the%20same%20detail.%20This%20is%20without%20the%20info%20from%20custom%20fields%20or%20even%20notes%20(special%20request)%20field.%20These%20fields%20are%20simply%20not%20in%20the%20TSV-file.%20To%20avoid%20misunderstanding%20with%20our%20customers%20we%20don't%20use%20custom%20or%20notes%20fields%20in%20our%20reservations%20services.%3C%2FP%3E%3CP%3EThe%20imported%20data%20is%20shown%20by%20means%20of%202%20very%20simple%20pivot%20tables%2C%20reservations%20today%20and%20reservations%20next%207%20days.%20This%20can%20be%20easily%20adapted%20in%20the%20power%20query.%3C%2FP%3E%3CP%3EUpon%20opening%20the%20power%20query%20will%20update%20the%20Excel-file%20with%20the%20data%20of%26nbsp%3BBookingsReportingData.tsv%20%2C%20which%20must%20also%20be%20placed%20in%20c%3A%5Ctemp.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2156732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBookings%20TSV%20export%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20power%20query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2207120%22%20slang%3D%22en-US%22%3ERe%3A%20Event%20column%20header%20change%20in%20TSV%20export%20in%20Bookings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207120%22%20slang%3D%22en-US%22%3E%3CP%3EMore%20changes%20to%20BookingsReportingData.tsv%20reported%20here%26nbsp%3B%3CA%20title%3D%22New%20columns%20added%20in%20Bookings%20TSV-export%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-bookings%2Fnew-columns-added-in-bookings-tsv-export%2Fm-p%2F2207095%2Fhighlight%2Ftrue%23M2308%22%20target%3D%22_blank%22%3ENew%20columns%20added%20in%20Bookings%20TSV-export%3C%2FA%3E%3C%2FP%3E%3CP%3ETherefore%20I%20updated%20the%20sample%20Excel-file%20in%20the%20original%20post%3A%26nbsp%3BMS%20Bookings%20reservations%20v4.xlsx%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Seems like  a column header of the TSV-export file had a change: column "Type" changed to "Event Type". In this colum you will find the values "Single" or "Group" reservations.

Our staff is working with an Excel-file which uses an embedded Power Query to show them the hourly updates in the reservations and provides them with a printer-friendly report.

Suddenly Friday afternoon February 19th CET the Power Query showed errors because of the name change of that column.

Not sure if Microsoft gives a head up for such changes ... ?

We use Power Query to split the Date Time field and filter out the group Bookings. In our case the single Bookings are the dates of closure.

We chose this solution while awaiting a full adoption of group reservations in the Bookings web application. Till today this has a lot of limitations.

Attached is the Excel-file we use to get the detail from our group reservation services in Bookings. Just as an example.

If you put this Excel-file in c:\temp together with the BookingsReportingData.tsv file you download from your https://outlook.office.com/bookings/homepage it should give you the same detail. This is without the info from custom fields or even notes (special request) field. These fields are simply not in the TSV-file. To avoid misunderstanding with our customers we don't use custom or notes fields in our reservations services.

The imported data is shown by means of 2 very simple pivot tables, reservations today and reservations next 7 days. This can be easily adapted in the power query.

Upon opening the power query will update the Excel-file with the data of BookingsReportingData.tsv , which must also be placed in c:\temp.

Update 13 March:  new sample Excel-file "MS Bookings reservations v4.xlsx" because of 8 added columns by Microsoft.

1 Reply

More changes to BookingsReportingData.tsv reported here New columns added in Bookings TSV-export

Therefore I updated the sample Excel-file in the original post: MS Bookings reservations v4.xlsx