Conditional export csv

  • ranell

    (@ranell)


    11 years, 1 month ago

    Hello,

    I want to export my table which is constituted by :
    Submitted | your-email | checkbox-36 | Submitted Login | Submitted From

    My checkbox-36 can have one of the two values, or both, so three possibility :
    1) subscribe to newsletter
    2) receive additional offer
    3) subscribe to newsletter, receive additional offer

    I want to export my cqv only if checkbox-36==subscribe to newsletter

    What is the simpliest way to do this ?

    https://ww.wp.xz.cn/plugins/contact-form-7-to-database-extension/

    Thanks a lot !

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    11 years, 1 month ago

    In the short code builder page, create an export link with a filter.

    Choose your form, and Export File type CSV.

    In “filter” put
    checkbox-36=subscribe to newsletter

    or if you want submissions with that selected or both, put

    checkbox-36~~/.*subscribe to newsletter.*/

    Thread Starter ranell

    (@ranell)

    11 years, 1 month ago

    Oh thanks ! I’ve tried something similar but it do not work. i’m wondering if accent and special char could be probleme in this case ?

    I’m writing my choice in french which give me :
    checkbox-36=s’inscrire à la newsletter

    which, in the url bar is transformed into something like :
    action=cfdb-export&form=Contact&filter=checkbox-36%3Ds%27inscrire%20à%20la%20newsletter&content=&enc=HTML

    my table is empty unfortunately, thanks a lot !

    Plugin Author Michael Simpson

    (@msimpson)

    11 years, 1 month ago

    Try replacing à with %C3%A0 (the url-encoded version of the character)

    Thread Starter ranell

    (@ranell)

    11 years, 1 month ago

    I’ve tried both in the url bar and in the filter
    checkbox-36=s’inscrire %C3%A0 la newsletter

    my tables are still empty unfortunately

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Conditional export csv’ is closed to new replies.

Tags