January 22, 2017 at 4:23 am #11711
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…)
I created a pdf using pdfescape with just 2 fields: name and surname, just for test purposes, and I uploaded it here:
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:
These are the settings
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”
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.
form‘ at line 1 for query SELECT w.*, f.
wp_frm_formsf WHERE w.
ID= AND f.
formmade 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
LeonardoJanuary 22, 2017 at 8:30 am #11712
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.January 22, 2017 at 9:40 am #11713
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!January 22, 2017 at 9:57 am #11714
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.