Url not working after a while (or never working)

Can you try to save permalinks again? Maybe disable and enable plugin again. This repersists the permalinks.

Please don’t share your urls. As it is avaible to everyone!

Hello, I just saved my permalinks again then diable/enable your plugin and now I’ve got a blank page:

https://www.snudifo93.net/gfexcel/+PExBWlkwwoLI4osN0TNLUGN14XRyC79FC6Rv1TP2E4=

Regards,

• This reply was modified 7 years, 2 months ago by guilamu.

Would you be able to enable wp_debug in wp-config.php, and then post the actual error? The 500 error is probably just because wp_debug = false.

The title of your form is to long for PHPExcel to handle. I’ll add this to the fix-list. As a temporary fix, you can add this to your functions.php

add_filter("gfexcel_renderer_title",function($title) {
    return substr($title,0,30);
});

Thanks you for sharing this bug!

• This reply was modified 7 years, 2 months ago by SQUID Media.

Oh, that’s great!

Thanks a lot for this quick fix, the url works now.

• This reply was modified 7 years, 2 months ago by guilamu.

Okay, another bug now:

https://www.snudifo93.net/gfexcel/+PExBWlkwwoLI4osN0TNLUGN14XRyC79FC6Rv1TP2E4=

I’m missing half of the entries. Here’s a full export:

https://37.187.22.6/owncloud/index.php/s/Zqu0j3sXWNlolJO

43 lines, not 21.

• This reply was modified 7 years, 2 months ago by guilamu.

Hmm, thats not quite supposed to happen. But easy enough to fix.

(Something like) This will be in the next update, but to help you out right now;
Edit the file GFExcelOutput.php
and replace line 117

$this->entries = GFAPI::get_entries($this->form_id, $search_criteria, $sorting);

with:

$total_entries = GFAPI::count_entries($this->form_id, $search_criteria);
$paging = array("offset" => 0, "page_size" => $total_entries);
$this->entries = GFAPI::get_entries($this->form_id, $search_criteria, $sorting, $paging);

Should fix your problem.

GFApi limits the default result to 20 entries (+ 1 header row = 21 rows).
I’ll see if I can make the code a bit prettier. But for now this should work. Sorry for the inconvenience.

Thanks for the support.

However, I just updated the code as requested and now the url is bronken again, 404.

https://www.snudifo93.net/gfexcel/+PExBWlkwwoLI4osN0TNLUGN14XRyC79FC6Rv1TP2E4=

Repeat the re-activate thing.

Indeed, work has intended now.

Great work!

Any ETA on the update? (so I can clean my files)

• This reply was modified 7 years, 2 months ago by guilamu.

Think it might be this week. Otherwise next week. I’ll give you a heads up in this thread. But WordPress will notify you of the update.

Ps. You really should remove the links to the excel from your messages. It’s public this way! For privacy reasons.

You’re right, but I cannot edit my messages anymore…

Maybe you can?

Or is there anyway to “refresh” the url and change it?

(Custom urls would be nice too)

• This reply was modified 7 years, 2 months ago by guilamu.
• This reply was modified 7 years, 2 months ago by guilamu.
• This reply was modified 7 years, 2 months ago by guilamu.

That’s on the roadmap for a next version. Check out our git repo for open issues.

https://github.com/squidmedia/gf-entries-in-excel

For now you can change the NONCE_SALT in your wp config to update the url.

• This reply was modified 7 years, 2 months ago by SQUID Media.