|
navycoat
|
June 30, 2014 at 3:14 pm
Hi,
I need to create a custom printable “report” that shows the attendee name and company name. I have brainstormed several options. The person who will be logging in needing this information will have full administrative rights in WordPress as well.
1. From the WordPress page: Event Overview > Event #1234 > Attendees, I see you can “Filter: Show / Hide Columns” but I need to show the Company Name (which is a custom question for me) and that is not an option.
https://eventespresso.com/wiki/attendee-reports/
2. From the WordPress page: Event Overview > Event #1234 > Attendees, they can export the data to Excel but it’s still rather messy. The person needing this information literally wants just the attendee name and company name printable on a sheet of paper per event. If worse comes to worse, I can write a macro in Excel to create a printable view. I was just hoping for a more “native to Event Espresso” option
3. I thought about building a custom webpage (password protected) with the customer data using the short codes but I don’t see how I can include the company name. Short codes found here:
https://eventespresso.com/wiki/shortcodes-template-variables/
Do you have any other suggestions on how I can build this report and make it user friendly for someone to get? We offer weekly training classes and the teacher wants this printout before each class like:
Event #1234
John Doe – ABC Company
Jane Doe – DEF Company
Thank you!
Caroleen
Wordpress 3.9.1
Event Espresso 3.1.36.5.P
New installation
Site is online but password protected and in development
|
|
Sidney Harrell
|
June 30, 2014 at 7:53 pm
The easiest thing is going to be to do an export, then import the data into a spreadsheet, rearrange the columns the way you want them, then print the report from there.
If you really want to build a tool within the WordPress admin that will do a custom report from a button, then you would need to have some custom code written. It’s not a hard task, but it will take several hours.
|
|
Sidney Harrell
|
June 30, 2014 at 8:00 pm
PS. If you want to take a stab at it, I would just override the existing export button. All the data is there, you can see it getting output starting on line 517 of includes/functions/export.php. You would just need to rearrange the header above that, and the output of each line.
|
|
navycoat
|
July 3, 2014 at 9:16 pm
Thanks for the reply! I decided to just go with the Excel export. I don’t have enough technical knowledge to hack the export button (right now). Maybe one day!
Thank you!
Caroleen
|
