New columns added in Bookings TSV-export

%3CLINGO-SUB%20id%3D%22lingo-sub-2207095%22%20slang%3D%22en-US%22%3ENew%20columns%20added%20in%20Bookings%20TSV-export%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207095%22%20slang%3D%22en-US%22%3E%3CP%3ESeems%20Microsoft%20is%20speeding%20up%20developments%20related%20to%20the%20TSV-export%20functionality.%203%20weeks%20ago%20I%20reported%26nbsp%3B%3CA%20title%3D%22Bookings%20TSV%20export%20now%20requires%20start%20and%20end%20date%20selection%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-bookings%2Fbookings-tsv-export-now-requires-start-and-end-date-selection%2Fm-p%2F2156837%2Fhighlight%2Ftrue%23M2263%22%20target%3D%22_blank%22%3EBookings%20TSV%20export%20now%20requires%20start%20and%20end%20date%20selection%3C%2FA%3E%26nbsp%3B%20and%26nbsp%3B%3CA%20title%3D%22Event%20column%20header%20change%20in%20TSV%20export%20in%20Bookings%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-bookings%2Fevent-column-header-change-in-tsv-export-in-bookings%2Fm-p%2F2156732%2Fhighlight%2Ftrue%23M2260%22%20target%3D%22_blank%22%3EEvent%20column%20header%20change%20in%20TSV%20export%20in%20Bookings%3C%2FA%3E%26nbsp%3B.%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20morning%20our%20staff%20reported%20errors%20when%20opening%20our%20Excel-query-report%2C%20which%20uses%20the%20TSV-export%20as%20source%20file.%3C%2FP%3E%3CP%3ETurns%20out%20Microsoft%20suddenly%20expanded%20the%20TSV-export%20file%20from%2010%20to%2018%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdated%20list%20of%20columns%20in%26nbsp%3BBookingsReportingData.tsv%20%3D%20TSV%20export%20file%20%3A%3C%2FP%3E%3COL%3E%3CLI%3EDate%20Time%3C%2FLI%3E%3CLI%3ECustomer%20Name%3C%2FLI%3E%3CLI%3ECustomer%20Email%3C%2FLI%3E%3CLI%3ECustomer%20Phone%3C%2FLI%3E%3CLI%3ECustomer%20Address%3C%2FLI%3E%3CLI%3EStaff%3C%2FLI%3E%3CLI%3EService%3C%2FLI%3E%3CLI%3ELocation%3C%2FLI%3E%3CLI%3EDuration%20(mins.)%3C%2FLI%3E%3CLI%3EPricing%20Type%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3EPrice%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3ECurrency%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3ECc%26nbsp%3B%26nbsp%3BAttendees%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3ECount%26nbsp%3BSigned%20Up%20Attendees%20Count%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%26nbsp%3B%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3EText%20Notifications%20Enabled%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3ECustom%20Fields%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3CLI%3EEvent%20Type%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20formerly%20named%20%22Type%22%20dd.%2019%20February%3C%2FEM%3E%3C%2FLI%3E%3CLI%3EBooking%20Id%26nbsp%3B%20%26nbsp%3B%3CEM%3E%23%20new%20dd.%2013%20March%3C%2FEM%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20in%20all%20this%20is%20good%20news%2C%20but%20I%20would%20appreciate%20a%20heads%20up.%3C%2FP%3E%3CP%3ENow%20each%20change%20in%20TSV-export%20results%20in%20an%26nbsp%3Binterruption%20for%20our%20staff%20at%20the%20public%20swimming%20pool.%20It%20breaks%20down%20our%20print-reports%20in%20Excel%20Power%20Query.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2207095%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
Occasional Contributor

Seems Microsoft is speeding up developments related to the TSV-export functionality. 3 weeks ago I reported Bookings TSV export now requires start and end date selection  and Event column header change in TSV export in Bookings . 

This morning our staff reported errors when opening our Excel-query-report, which uses the TSV-export as source file.

Turns out Microsoft suddenly expanded the TSV-export file from 10 to 18 columns.

 

Updated list of columns in BookingsReportingData.tsv = TSV export file :

  1. Date Time
  2. Customer Name
  3. Customer Email
  4. Customer Phone
  5. Customer Address
  6. Staff
  7. Service
  8. Location
  9. Duration (mins.)
  10. Pricing Type   # new dd. 13 March
  11. Price   # new dd. 13 March
  12. Currency   # new dd. 13 March
  13. Cc  Attendees   # new dd. 13 March
  14. Count Signed Up Attendees Count   # new  dd. 13 March
  15. Text Notifications Enabled   # new dd. 13 March
  16. Custom Fields   # new dd. 13 March
  17. Event Type   # formerly named "Type" dd. 19 February
  18. Booking Id   # new dd. 13 March

 

All in all this is good news, but I would appreciate a heads up.

Now each change in TSV-export results in an interruption for our staff at the public swimming pool. It breaks down our print-reports in Excel Power Query.

0 Replies