IMPORTANT UPDATE: Please DOWNLOAD and update the Formidable PRO2PDF to the Latest Version!

This form does not contain datasets

Home Forums How to This form does not contain datasets

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #11711 Reply
    Leonardo
    Participant

    Hi, I have purchased your plugin yesterday, it seems good but I’m still learning how to use it.

    However, I have created a basic form here using formidable forms (it’ll become more and more complex in the very near future…)

    http://impara.biz/eabhes2

    I created a pdf using pdfescape with just 2 fields: name and surname, just for test purposes, and I uploaded it here:

    http://impara.biz/help/eabhes.pdf

    I’d like to map the form entries First Name and Last Name into pdf entries name and surname. I create the map like this:

    http://impara.biz/help/map.jpg

    These are the settings
    http://impara.biz/help/settings.jpg

    But seems like there are no datasets because from the dropdown menu I can only see the default option “this form does not contain datasets”

    http://impara.biz/help/dataset.jpg

    I even tried to deactivate the plugin, uninstall, reinstall, switching to php7, but the error is always here.

    Checking at php_logs, here it is:

    [22-Jan-2017 11:58:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘AND f.id = w.form‘ at line 1 for query SELECT w.*, f.form_key as form FROM wp_fpropdf_layouts w, wp_frm_forms f WHERE w.ID = AND f.id = w.form made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/oneup/page.php’), PeThemeContent->content, the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, FrmFormsController::get_form_shortcode, FrmFormsController::show_form, FrmFormsController::get_form, FrmFormsController::get_form_contents, include(‘/plugins/formidable/classes/views/frm-entries/new.php’), require(‘/plugins/formidable/classes/views/frm-entries/form.php’), FrmFormsHelper::get_custom_submit, FrmFormsHelper::replace_shortcodes, do_shortcode, preg_replace_callback, do_shortcode_tag, formidable_shortcode_download, wpfx_readlayout

    It should be WHERE w.ID = 3 instead…

    Could you please let me know? Please note I cannot even use Demo: Mapping Formidable Fields to PDF Fields

    Thank you
    Leonardo

    #11712 Reply
    admin
    Keymaster

    It appears there are not entries in the form. We just entered data into your form, try the merge now. If it is still not working, please use this form to allow us to login to your installation if possible.

    If not possible, then let us know if forms show data when selected in the Field Map Layout.

    We remain at your service.

    #11713 Reply
    Leonardo
    Participant

    Hi and thank you for your help.

    There’s something I still can’t catch right now.

    You simply entered all the data in the form, and then I received an email with PDF attached (with correct fields filled, though).

    But I still don’t understand if the plugin fills correctly a PDF template wihtout submitting a form. I replicated your view example and I created a thank you page with the link for the download. It’s working fine but in this case it works only after the form has been submitted… I cannot use [id] as the ‘dataset’ variable straightforward because I get error.

    Could you please clarify this?
    Thank you!

    #11714 Reply
    admin
    Keymaster

    PRO2PDF was not designed to work with draft forms or draft entries, this is our first request for such functionality. A work around is to submit the entry and provide the user the ability to edit the entry.

    Please complete this form if you require customization support.

    We remain at your service.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Reply #11712 in This form does not contain datasets
Your information: