How to create an e-Mail PDF Survey Form
|Installation • Usage • PDF issues • Imposition • Other|
The demonstration form however uses an online server which is complicated and expensive to setup.
A far simpler way is to use e-mails to exchange the data and the form can be easily modified to change the way the data is transferred. The setup of the Submit Button is all that needs to be changed. Instead of the data being sent as HTML to a web address, the “mailto:” command is used. By using the “mailto:” command, Adobe Acrobat Reader automatically attaches data in a FDF file to an email. This command works with most mail clients used in Windows and Linux. You can test your system by clicking on “mailto:”.
Creating a e-Mail PDF form
In the document “Your first PDF form with Scribus” you are shown how to create a PDF form to submit data to a server. A copy of the example file can be downloaded from a link on that page.
Click OK. Now save your document as a PDF and view it with Adobe Acrobat Reader.
Testing your PDF form
Notice the difference in the file size between the FDF and PDF.
How to use FDF files
There are two options that I can think of -
1. Dump the data back into the form and print it, or
2. Extract the data into a spreadsheet or database
While Adobe would prefer you to purchase the full version of Acrobat, you can still do a lot with the free Scribus and Acrobat Reader software.
If you use the example, you will see amongst other words and characters, the following words
Country Komentarz Miasto Name No Street Submit Telefon Zip
AName BStreet CNo DZip EMiasto FCountry GTelefon HKomentarz Submit
An example of a script to process FDF files into MS Excel
Links are BROKEN
openfdf.zip contains a MS Excel spreadsheet with a macro that allows you to extract data from FDF files. The macro is heavily commented to show what each line of code does.
For those without Excel who would like to have the script, openfdf.txt is the macro script in a text file. The macro code should be easily converted for use in other applications.
An example of code to process FDF files into MS Access
FDFdataImport.mdb contains a MS Access file with functions that allows you to extract data from FDF files. The functions are heavily commented to show what each line of code does.
There are two functions:-
This module displays creates an dialog box that lets the user specify the drive, directory, and the name of a FDF file to open. The data fields are extracted and a table called "tblFDFImport" is created with the appropriate field names.
The table can be manually adjusted to change the field types and sizes. The default field type is Text with a size of 200 characters.
This module displays creates an dialog box that lets the user specify the drive, directory, and the name of a FDF file to open. The data is extracted into the table called "tblFDFImport".
Possible Uses for this System
Club membership applications / database
Client information database
Electronic Survey forms