- Posts: 20
- Thank you received: 0
[Solved] Registrant export columns shift from the header
- Ed
- Topic Author
- Offline
- Junior Member
-
Less
More
4 years 1 month ago - 4 years 1 month ago #142043
by Ed
Registrant export columns shift from the header was created by Ed
We have almost 40 custom fields in our registration form that when exported in Excel format, shift from five to eight columns to the right and become mis-aligned from the header. I haven’t found anything I can configure to correct this, so I’m wondering if there isn’t a glitch in the output program? I've attached a sample export file with the errors illustrated.
Also, It would be a great feature if each field could be selectable for inclusion in the registrants export file similar to the field selections for events. That way export reports could be tailored for the output required instead of including unneeded columns.
Also, It would be a great feature if each field could be selectable for inclusion in the registrants export file similar to the field selections for events. That way export reports could be tailored for the output required instead of including unneeded columns.
- Tuan Pham Ngoc
- Offline
- Administrator
-
4 years 1 month ago #142044
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registrant export columns shift from the header
Hello
What version of the extension you are using? If you are using latest version and still have this issue, please submit a support ticket sending us super admin account of your site so that we can check it directly on your site to see what's wrong and get it sorted
Regards,
Tuan
What version of the extension you are using? If you are using latest version and still have this issue, please submit a support ticket sending us super admin account of your site so that we can check it directly on your site to see what's wrong and get it sorted
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Ed
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 20
- Thank you received: 0
4 years 1 month ago #142054
by Ed
Replied by Ed on topic Registrant export columns shift from the header
I am using the latest versions of Event Booking, 3.14.2 and Joomla, 3.9.25. There is an error thrown when I open the export file in Excel:
Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 10299.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part
Repaired Records: Cell information from /xl/worksheets/sheet1.xml part
This may give you an indication of the problem.
I will open a support ticket.
Thank you!
Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 10299.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part
Repaired Records: Cell information from /xl/worksheets/sheet1.xml part
This may give you an indication of the problem.
I will open a support ticket.
Thank you!
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
4 years 1 month ago #142056
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registrant export columns shift from the header
Thanks. We will check and reply you via support ticket
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Ed
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 20
- Thank you received: 0
4 years 1 month ago #142072
by Ed
Replied by Ed on topic [Solved] Registrant export columns shift from the header
Configuration/Other Settings/Export Data Format was set to Excel 2007 (XLSX) which produced the shifted output. Changing to either Excel 2003 or CSV produced the correct output.
Thank you Tuan!
Thank you Tuan!
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
4 years 1 month ago #142085
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic [Solved] Registrant export columns shift from the header
Great. Thanks McDermott for sharing solution back to other customers in this forum
Tuan
Tuan
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.