- Posts: 647
- Thank you received: 31
Event Registrants Export Date Time fields + Monetary fields exported incorrectly
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
2 years 6 months ago #158488
by David Unwin
Event Registrants Export Date Time fields + Monetary fields exported incorrectly was created 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.
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
-
Less
More
- Posts: 647
- Thank you received: 31
2 years 6 months ago #158504
by David Unwin
Replied by David Unwin on topic Event Registrants Export Date Time fields + Monetary fields exported incorrectly
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
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
-
Less
More
- Posts: 647
- Thank you received: 31
2 years 6 months ago #158506
by David Unwin
Replied by David Unwin on topic Event Registrants Export Date Time fields + Monetary fields exported incorrectly
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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.