|
FASeminars
|
October 4, 2022 at 1:20 pm
Hello,
We are still using EE3 as we work through a large migration to EE4 as our site is heavily customized.
We need to export invoices generated by EE3 for attendees (accounting purposes). Currently, the attendees can login to their account and download but it appears the only method for admin is to download manually per attendee within an event?
Are the invoices stored somewhere in a folder in the plugin where I could bulk export them? We have thousands upon thousands of attendees as we’ve been using EE3 since 2015. Download 1-by-1 is counter productive for time efficiency.
Thanks,
Andreo
|
|
Tony
|
October 5, 2022 at 3:47 am
Hi Andreo,
Are the invoices stored somewhere in a folder in the plugin where I could bulk export them?
No, they are generated on the fly when the link is clicked and sent to the browser to download.
We have thousands upon thousands of attendees as we’ve been using EE3 since 2015. Download 1-by-1 is counter productive for time efficiency.
We’ve never had an option to download all Invoices from within Event Espresso so currently there isn’t a bulk download solution for this.
With EE3 the part of the link that changes is the Reg ID, so you could use a script to loop over all of the reg ids in the database and load the link… or use a bulk download add-on for you browser and merge the Registration CSV into that using the same link but we don’t have an option to do this within EE itself currently.
|
|
FASeminars
|
October 13, 2022 at 1:12 pm
This reply has been marked as private.
|
|
Tony
|
October 14, 2022 at 3:58 am
So the link for the invoice does not change other than the REG ID (registration ID) here, so a quick example could be:
http://example.com/?download_invoice=true®istration_id=2077-613f308adb131
So a really basic method of doing this would be to export the CSV report for an event and build a script to loop over each of the registration ID’s in that CSV and generate the above links.
You could stream the downloads to a location on the server (say a directory in /wp-content/uploads/ and then zip up the directory for a single download of all of the Invoices for that specific event. Repeat for each event to get all invoices.
Or pull all of the attendee records from the DB (likely in batches) via code and basically do the same thing as above. Without sitting and writing out the code to do this I can’t really show you much more, unfortunately.
—
The browser add-on option is basically the same without the need to write a custom script for the download part. Find a browser add-on that is capable of taking a CSV and using values from that CSV to generate links and download them on the fly.
One that I’ve used before to do something similar (unrelated to Event Espresso) is DownloadThemAll… however, I used that within Firefox a few years ago when it was much more capable of that the current version are (Firefox change the integration method).
So it’s a case of finding a download add-on which can either generate, or allow you to add multiple links to download so you can pull them all in at once from a list of links you’ve generated etc.
|
