• Resolved freelancejose

    (@freelancejose)


    Hello!

    I need to receive every form submission with data in attached csv file. For the moment, I can receive all the submission using schedule option, but it only give the possibility to send it every hour. So that:

    Is possible to change schedule time to send the csv every minute?

    Is there another option to do this?

    Please, can you help me?

    Thank you.

Viewing 15 replies - 1 through 15 (of 18 total)
  • Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @freelancejose ,

    I’m afraid there is no option to do that now in the Forminator.

    Also, generating CSV every minute could “kill” your site.

    Just so we are on the same page – when you would need to have every submission have a CSV file attached with that 1 entry?

    kind regards,
    Kasia

    Thread Starter freelancejose

    (@freelancejose)

    Hi Kasia,

    Thenk you for your answer.

    I want to receive the submission form also with values in csv file attached to it or other way, but all the submited fields values in csv format.

    Is that possible?

    Thank you.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    I hope you are doing well.

    I am afraid it isn’t possible, the only alternative to receive on each submission is a PDF file using the E2Pdf integration: https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#e2pdf

    Best Regards
    Patrick Freitas

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    Had you tested the Google sheet integration?

    https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#google-sheets

    It will update the sheet file for each submission, unfortunately won’t be an attached file.

    Best Regargs
    Patrick Freitas

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudevsupport12 @wpmudev-support2

    I’ll check those two options.

    Thank you very much for your help.

    Best regards!

    • This reply was modified 3 years, 5 months ago by freelancejose.
    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudevsupport12 @wpmudev-support2,

    I want to show some form data in a table using select option, but I don’t know how to do it using Select and because the values aren’t in columns, just in rows. I mean that I have:

    meta_key is date-1 and which meta_value is 2021-06-22. I need to extract date-1 and its corresponding value in meta_value column.

    Please, can you help me?

    Best regards.

    Have read an answer here: https://wordpress.org/support/topic/how-to-select-two-meta_value-wp_postmeta/

    Thank you very much.

    Plugin Support Predrag – WPMU DEV Support

    (@wpmudev-support1)

    Hi @freelancejose,

    Could you elaborate a bit more how the data is supposed to be extracted and where is about to be shown?

    Also, have you check our Forminator API Docs to see if that can help you out with setting this up?
    https://wpmudev.com/docs/api-plugin-development/forminator-api-docs/
    https://wpmudev.com/blog/how-to-build-custom-forminator-add-ons-using-the-developer-api/

    Cheers,
    Predrag

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support1,

    First, sorry for my english. I’ll try to explain better I can.

    I need to receive every submitted form data like csv file. I use that csv to print labels and insert the information in other app I have.

    What I’m trying is to select data (using SQL) from database, make csv file and send it every x time. Only with the new forms received from the last time, this is do this every 15 minutes.

    I asked this befor, because Forminator has a schedule option to send csv, but only once a day. I need more times in a day.

    I have read the those links. It looks that is what I need.

    Thak you very much for your help.

    Best regards.

    Plugin Support Predrag – WPMU DEV Support

    (@wpmudev-support1)

    Hi @freelancejose,

    I was chatting about this with our devs in the meantime and they suggesting trying out something like this to see if it helps:

    global $wpdb;
    		$field_id = 'date-1';
    		$date     = '06/23/2021';
    		$query = "
    			SELECT 
    				fm1.entry_id, 
    				MAX(CASE WHEN fm2.meta_key = 'date-1' then fm2.meta_value ELSE NULL END) as date_field,
    				MAX(CASE WHEN fm2.meta_key = 'name-1' then fm2.meta_value ELSE NULL END) as name_field,
    				MAX(CASE WHEN fm2.meta_key = 'email-1' then fm2.meta_value ELSE NULL END) as email_field
    			FROM {$wpdb->prefix}frmt_form_entry_meta fm1
    			LEFT JOIN {$wpdb->prefix}frmt_form_entry_meta fm2 ON ( fm2.entry_id = fm1.entry_id)   
    			WHERE fm1.entry_id IN ( SELECT entry_id FROM {$wpdb->prefix}frmt_form_entry_meta WHERE meta_key=%s AND meta_value=%s )
    			GROUP BY fm1.entry_id
    			LIMIT 2";
    		$result = $wpdb->get_results( $wpdb->prepare( $query, $field_id, $date ) );

    Cheers,
    Predrag

    Thread Starter freelancejose

    (@freelancejose)

    Hi @wpmudev-support1,

    I’ll try it. Thank you!

    Really, what I need is to schedule autosend csv one time every hour with all data submitted by form during that time.

    The Forminator schedule only lets to send it at determinated time once every day? Is this possible to change?

    Thank you for your help.

    Best regards.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    The Forminator schedule only lets to send it at determinated time once every day? Is this possible to change?

    I pinged the developers to verify if there is any filter available for this, we will keep you posted.

    Best Regards
    Patrick Freitas

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    I hope you are doing well.

    Could you please try this workaround?

    Install the WP Control plugin, find the forminator_send_export event and remove it.

    Configure a new “forminator_send_export” event, passing the True as a parameter for every hour.

    https://monosnap.com/file/51AkboD2l33NwBf77HMJacUbZJ5l3f

    Some important notes.

    This will force any CSV file to send every hour.

    Let us know if this workaround worked for you.

    Best Regards
    Patrick Freitas

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freelancejose

    I hope you are doing well and safe!

    We haven’t heard from you in a while, I’ll mark this thread as resolved.

    Feel free to let us know if you have any additional questions or problems.

    Best Regards
    Patrick Freitas

    Thread Starter freelancejose

    (@freelancejose)

    Hello!

    I’m back!

    I have testing options:

    – Configure a new “forminator_send_export” event, passing the True as a parameter for every hour. –> I receive the csv file not every hour, maybe two or three times in a day.

    I think this is because any server configuration. Is it?

    Still working on this.

    Thank you very much!

    Plugin Support Predrag – WPMU DEV Support

    (@wpmudev-support1)

    Hi @freelancejose,

    It’s possible that it happens based on the times when cron jobs are running on your server. Have you tried using a plugin like WP Crontrol, as Patrick suggested above, to check at which times the cron jobs are running?

    Cheers,
    Predrag

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Every submission sen in csv’ is closed to new replies.