[Solved] Registrant export columns shift from the header

More
4 years 1 month ago - 4 years 1 month ago #142043 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.
 

File Attachment:

File Name: Ebooking_R...ist.xlsx
File Size:12 KB

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.
Last edit: 4 years 1 month ago by Ed.

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

More
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

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

More
4 years 1 month ago #142054 by Ed
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!

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

More
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

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

More
4 years 1 month ago #142072 by Ed
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!

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

More
4 years 1 month ago #142085 by Tuan Pham Ngoc
Great. Thanks McDermott for sharing solution back to other customers in this forum

Tuan

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

Moderators: Tuan Pham Ngoc