valousal

Hi,

The last link https://monosnap.com/file/YvdjHM9Xim1fnCsJaibfETXkhRcB4 not working.

However, parameters are correctly configured and it doesn’t work.

https://postimg.cc/gallery/FLcBBp0

Kind Regards,

disable fields in csv export

• This reply was modified 4 years, 4 months ago by valousal.

Yes !!!

Hi @doekenorg ,

We have the entries of the first form but not the others (4 in total).

We have forms without entries yet. Maybe because of that?

Results : https://file.io/mwVSv3

It’s correct ?

// include : https://gist.github.com/doekenorg/b7fdfca59a98e2d36ebca0785d333976
require 'MultiFormSingleSheetRenderer.php';

// Quick and dirty, but does the trick.
use GFExcel\GFExcel;
use GFExcel\GFExcelOutput;
use GFExcel\Renderer\PHPExcelMultisheetRenderer;

add_action('request', function ($query_vars) {
    // only respond to a plugin call
    if (!array_key_exists(GFExcel::KEY_ACTION, $query_vars) ||
        !array_key_exists(GFExcel::KEY_HASH, $query_vars) ||
        $query_vars[GFExcel::KEY_ACTION] !== GFExcel::$slug) {
        return $query_vars;
    }

    // Set this super secret key to something only u know.
    $secret = 'super_secret';
    if ($query_vars[GFExcel::KEY_HASH] !== $secret) {
        return $query_vars;
    }

    // instantiate multi sheet renderer and push all forms to it.
    // $renderer = new PHPExcelMultisheetRenderer();
    $renderer = new MultiFormSingleSheetRenderer();
    foreach (GFFormsModel::get_form_ids() as $form_id) {
        $output = new GFExcelOutput((int) $form_id, $renderer);
        $output->render();
    }

    // start the rendering and the download.
    $renderer->renderOutput();
    exit;
}, 9);

Regards,

• This reply was modified 5 years, 5 months ago by valousal. Reason: fix markdown
• This reply was modified 5 years, 5 months ago by valousal. Reason: fix markdown

That’s great !!

Hi @doekenorg,

Sorry to bother you again…

Is it possible to extract in a Excel single sheet?

Thanks !!

Hi @flowingweb,

Did you find a solution ?

We have the same problem.

Thanks.

Hi @doekenorg,

Great.

Thanks a lot for your help !!

Hi @doekenorg,

Thank you.

Most important. We need to access the export with a URL;)

Hi @doekenorg ,

Thank you for your reply.

We understand perfectly why you are not keen on implementing this in your project.
However, we need this export temporarily.

We are developer, we can implement this feature in our project.

Example URL: https://www.mysite.com/gf-entries-in-excel/{token}?forms=all

Regards,

Thanks !

Did you find a solution ?

Hello.

Is this feature available in the latest version?

Thank you,
Regards,

Great !!

Thank you for your prompt response