|
britorthopaedic
|
September 25, 2015 at 8:16 am
Hi
When I try to run the event registrations to CSV report the browser just goes round for a long time and then goes to a page not found message. It might be the amount of data I have in the event with over 3000 registrations. I have tried the workaround stated in the link below but even limiting to 100 doesnt seem to work.
https://gist.github.com/lorenzocaum/8e9f047e533248153a38
I need to access this report to get the PayPal Id from the registrations if you can let me know which field this is stored in on the database I can retrieve it directly from there.
Thanks
Melanie
|
|
britorthopaedic
|
September 25, 2015 at 8:16 am
Hi
When I try to run the event registrations to CSV report the browser just goes round for a long time and then goes to a page not found message. It might be the amount of data I have in the event with over 3000 registrations. But I need to access this report to get the PayPal Id from the registrations.
Thanks
Melanie
|
|
Tony
|
September 25, 2015 at 2:07 pm
Hi Melanie,
Its sounds like the query for the registrations is timing out before all of the information is pulled. This is common for large volumes of registration within a single request as there is a lot of information to pull in.
The work around this you will need to break down the export into smaller sections and then combine the export when finished.
So basically you’ll run the export for registration rows 0 to 400, then 401 to 800, 801 to 1200 and so one. Between each section you save the file then when finished manually combine those files together for a full export.
We have a small plugin available here:
https://gist.github.com/Pebblo/976ed35816bd3b9a6d03
Which allows you to set the limit for the registrations on each of those exports by changing the values set within the array( 0 , 400 )
We are working on a solution to allow larger volumes of exports to work without needing to manually break down each section using the method above.
|
|
britorthopaedic
|
October 1, 2015 at 6:44 am
Hi
I finally got the query to run only though after taking the order by clause out! The main reason I wanted this was to find the paypal transaction ID, which I still cant find, the only id code I can find is the Reg_code but this doesnt match with the paypal transaction ID, I am using Paypal standard, is this stored somewhere?
Melanie
|
|
Lorenzo Orlando Caum
|
October 1, 2015 at 10:23 am
Hi Melanie,
The transaction ID for PayPal will be stored in dbprefix_esp_payment (e.g. wp_esp_payment) in the PAY_txn_id_chq_nmbr column.
—
Lorenzo
|
