|
John at TRC
|
December 29, 2015 at 3:54 pm
We download registration reports and format them in an excel workbook for our clients.
I’ve set up preformatted report templates so that we can just copy the data over and paste in a page in the workbook, which then uses that data to create a nice clean report our clients can use.
I’d like to take advantage of the Excel feature that allows you to do an online web query from within a workbook by connecting it to data on a webpage, but when I try this, I run into an error when I try to connect (I right-click on the CSV report button and choose “save link location”).
Is there a better way to do this?
|
|
Lorenzo Orlando Caum
|
December 29, 2015 at 5:57 pm
Hi John,
I’m not familiar with the web query option but in the latest version of Event Espresso 4, the CSV is built in background with a smaller set of records.
This reduces the likelihood of a timeout issue when there are thousands of registrations for a single event.
I think you are needing something like a static link that has the information already populated in an existing file. The other thing is that the URLs use a WP nonce (http://codex.wordpress.org/WordPress_Nonces) which means that they change on each page visit.
—
Lorenzo
|
|
John at TRC
|
December 30, 2015 at 10:24 am
“I think you are needing something like a static link that has the information already populated in an existing file.”
Yes, that would be best. There are also options for directly accessing a database via SQL, an OData data feed, and an XML import.
“The other thing is that the URLs use a WP nonce (http://codex.wordpress.org/WordPress_Nonces) which means that they change on each page visit.”
We added the line of code shown here (https://eventespresso.com/topic/csv-reports-not-appearing-or-downloading/) to revert to the old system since the new system interfered with some custom coding we had done and didn’t display correctly in html. (So this wouldn’t be an issue for us.)
Any other ideas?
|
|
Lorenzo Orlando Caum
|
December 30, 2015 at 12:32 pm
Hi, unfortunately, I don’t have any other ideas as the nonce is going to change the actual URL each time and that is for security reasons. Those are used through Event Espresso and WordPress.
I’ll ask to see if anyone here has a workaround in mind.
—
Lorenzo
|
|
Lorenzo Orlando Caum
|
December 30, 2015 at 12:34 pm
Actually, I did have another question. On the reports that is being built. Is that pulling out select information?
Would it help if you could get a registration csv report that includes certain columns of data but not all of them?
—
Lorenzo
|
|
John at TRC
|
December 30, 2015 at 1:24 pm
The CSV report is all data per client per event (in our case it’s actually per “tour”). The excel report formats that data into different reports on separate worksheets within a workbook.
If we could do that within EE on a static link, that would be even better and open up the possibility of developing html reports on a kind of dashboard page.
|
|
Lorenzo Orlando Caum
|
December 30, 2015 at 6:19 pm
Alright, I thought you may be removing some of the information and then loading that into Excel. There are some filters that will let you limit the information that is used for the csv report:
https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/tw_registration_report_exclude_fields.php
However, there isn’t a way to get a “static link.” The nonces are used through Event Espresso 4 so that isn’t something that can be turned off.
—
Lorenzo
|
