Event Registrants Export Date Time fields + Monetary fields exported incorrectly

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 6 months ago #158488 by David Unwin
This is a problem that keeps re-appearing for us and not sure if there is an answer at the Moment
In our Config setting we set export as XLS and our date fields set as format l, jS F, Y  g:i a so our dates display like this Wednesday, 31st May, 2023 18:00. 
When we export our registrants data the Date fields are exported as text fields ie  'Monday, 15th May, 2023  07:43:44' 
Also all the monetary fields also get exported with a quote mark (') before the number.
This means 2 things
1. we can't analyse or sort date on our  registrations by Date 
2. We can't analyse revenue as the fields are classed as text.
We can get around the 2nd problem by exporting the data as CSV , then the monetary fields are number fields, but that does not help with Problem 1.

I just hope you can find a fix for this some time.
I have attached a xls file in zip format to show you the problem.
 

Please Log in or Create an account to join the conversation.

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 6 months ago #158504 by David Unwin
On another related point. 
Looking at the documentation on Export
eventbookingdoc.joomservices.com/plugins/spout
I don't see the Events Booking - Spout (XLSX/CSV Handle) plugin on our list of plugins????
See list of Events Booking plugins on our site
David

Please Log in or Create an account to join the conversation.

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 6 months ago #158506 by David Unwin
Forget my last comment, it looks like Spout facility has been archived and no longer used See github.com/box/spout

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc