Aaron Ware

Realized this data was just serialized. utilized the maybe_unserialize method and it worked liked a charm

Actually realized I was going against the database submit_time not the Submitted variable within the object.

But I did notice that it wouldn’t compare the time stamps properly. So I made a slight change to compare the values as (int) for now.

My time was 1307123123 for example vs your time of 1307123123.2343 and it wouldn’t compare the 2 values properly.

Doing a quick filter based on what’s in the shortcode examples I received an error.

Looked through your code and saw support for comparisons in your filter classes.

Maybe I am implementing it incorrectly. I figured it was a pretty simple one.

$exp->export( $form_name, array('filter'=>"submit_time>=$time"));

This worked out for me. Thanks Michael. I see how there is ‘search’ and filter. Let’s say I wanted to get the submit_time for the last month based on timestamp. Does the filtering support this?

Thanks again for this awesome plugin.

Hey guys thanks for the responses.

@michael yeah after some further reading I found it wasn’t the backticks that were my issue.

I wrote a separate plugin to be able to email out a report of the data stored by your plugin monthly using wp_cron, it emails out a table of the results similar to the shortcodes as well as an attached csv file.

I wasn’t too overly worried about the performance of it. Because I wasn’t expecting hundred of records and I am also splitting the records up based on timestamp.

While I was in the process of researching I actually put it in as a feature request on your site. I kept mine as a separate plugin rather than editing anything you had going on in your plugin.

BTW the link you sent is throwing a 500

Thanks again

@kostas123 If you are running on xampp you may want to go into your form and add in the setting

demo_mode:on within the “additional settings” of your form(s). You probably cannot sent out smtp over port 25 is my guess by either your local firewall or by that port being blocked by almost all ISPs

Thanks for the push in the right direction Alex. Also thanks for the quick response.