Data is saved into the table “tx_thmailformplus_log” having the following fields:
uid : unique ID of the record
pid : Typo3 pageID from which the form was submitted
submittedfields : data definition plus the values are saved here **
date : the date+time when the record was saved
**... because the form can change (by adding, deleting or renaming an input field) the structure is saved with every record followed by a line break and the data the user submitted.
Example:
id;L;SUBMITTED;name;email;address
400;;1;peter;netdog@typoheads.com;vienna
Tip:
If you think some fields saved in the log-table are useless or you don't need them, use the TypoScript functionality described in the “Configuring the log-table” chapter:
plugin.tx_thmailformplus_pi1.saveLog.exclude = x,y, id
The “x”,”y” and “id” fields are no longer saved into the log-table anymore after adding this to the TypoScript setup.
New in 3.5.0:
Exported records are marked and not shown anymore in the list of records by default. If you want to see all records (also the ones that have been exported) you have to check the field “show also exported records” in the configuration box.
New in 3.4.0:
added a “raw export” checkbox: check if you don't want the form fieldnames to be exported as first row in the csv file. If there are records stored with different data structures (e.g. you renamed the inputfield “first_name” to “firstName”) you would normally get a alert-message that the exported records have different data structures. Check “raw export” to export the records with no regard to the data structures.
added a “convert UTF-8 to ISO-1” checkbox: If you have configured your Typo3 installation as multilanguage site, the input fields and the values are also saved in this UTF-8 format. Unfortunately when exporting data as CSV file you can't tell excel that the CSV file is in UTF-8 format. So check this field if you want the data to be converted into ISO-1 format.
Attention:
If you use checkboxes, the “structure” of each submitted form looks different (depending on how many checkboxes the user has checked).
You can solve the problem by using the TypoScript functionality described in section "TypoScript: Configuring the log-table (csv export via backend module)”.
If you need to save the submitted fields to the Database, please use the TypoScript specifications for that as shown in section “TypoScript: Saving the submitted values into a DB table of your choice”.
When you try to export records that were saved from different forms (meaning the fields in the form were not the same) you will get a warning showing the different definitions.
Still you have the possibility to export records that are based on different forms (but at your own risk). This was done because if you rename a input field from “tel” to “phone”, it makes sense to give you the possibility to download the “old” data saved with the field name “tel” and the “new” data saved with the field name “phone” in one .CSV file.
Attention: if records are deleted, you can not recover the data anymore (it's really deleted from the database!)
To use upload fields within your form, you have to:
add enctype="multipart/form-data" to your <form ..> tag
specify the folder, allowed file size, allowed file types via TS (see TypoScript sections)
To be able to jump from one step to the next (or previous) step, the form has to be submitted via JavaScript setting the correct hidden values. This JavaScript is added automatically to the template by the marker ###ADDITIONAL_MULTIPAGE### which has to be inserted in each step-template between the <form> and </form> tags. All you need to do is using the following markers as wraps around the text or image you want to be linked:
###link_nextStep_start### / ###link_nextStep_stop###
###link_prevStep_start### / ###link_prevStep_stop###
###link_reload_start### / ###link_reload_stop###
Since your original <form...> tag is replaced automatically with a predefined <form...> tag by mailformplus, you have to ensure that
each form has a form-start-tag beginning with "<form" or "<FORM"
each form has a form-end-tag "</form>" or "</FORM>"
field names are enclosed by " eg. <input type="text" name="email">
Q: What if you want your own JavaScript error check function to be called before the form is submitted?
A: You can define your own JavaScript function calls via TypoScript. Your user defined JS functions are called before the automatically generated “form-submit” JS function by mailformplus.
Look at the plugin.tx_thmailformplus_pi1.multiPage TS settings to find out more.
