Support

October 29, 2015 at 2:22 pm

Great article. I’d like to take it a step further to automate the process. (the customer wont want to get the limits after each round) Essentially break down the exports still but loop until an upper limit say 5000 total.

I threw some code together but I’m not too well versed in PHP. Maybe you could help?

I attempted to take your code and loop it out. Basically break down the exports in parts of 900 and then loop all the way to an upper limit of 5000. If my math is right it should loop around 6 times.

Side note, I tested it out and surprise it did NOT work. Think you can help? See the (sloppy) modified code below.

add_filter( ‘FHEE__EE_Export__report_registration_for_event’, ‘ee_custom_export_limits’, 10, 1 );

function ee_custom_export_limits($current_query) {

// The query limit is set here.
$x = 1;
$a = 0;

while ($x < 2){
if ($a <= 5400) {
$current_query[‘limit’] = array($a,900);
$a = $a + 900;
return $current_query;
}
else {
$x = 3
}
}
//array({offset}, {limit})
//Offest = the row to start from
//Limit = the amount of rows to pull in, starting from the offset value.
//So to export 1200 registrations you can break this down into:
//array(0,400); (then run the export and save the file)
//array(400, 400); (again run the export and save the file)
//array(800, 400); (run the final export and save the file)
}

November 3, 2015 at 2:00 pm

Tony,

I appreciate the response! I see exactly what you are saying and it makes total sense, I guess I was not even close hah. It is not part of another function. You said you have an open ticket for a batch system? any way I follow that or see what’s going on with that?