CTdeveloping - PDF Creation, Editing, Form, Markup, and Security Software
Contact Us Contact CTdeveloping
Customer Login Log In
Products Services Downloads Support News Online Store
Desktop Products PDFtypewriter Overview Features Pricing Download Documentation PDF Printer Doc
Buy Now
CTdeveloping RSS Feed

PDFtypewriter Help Files

Mapping Fields to Database

Mapping Fields to Database

This tool can be used to map PDF form fields to values in a database. Once a database has been loaded, entries (rows or records) from this database can be chosen for export by checking them in the Database View. PDF form fields can then be mapped to database fields by clicking the MAP TO DB FIELD button. This will bring up a list of the database field names next to the PDF form field. Simply select the database field name to map it to, and move on to the next PDF form field.

 

Click Export DB Compiled PDF to start the export process. Select a file to save to. The software will go through each checked entry and input the selected database values into the mapped field creating a PDF file which corresponds to the form field entry. If the Flatten Form Fields option is checked, the form fields will be removed and simply the text put in their place. If the Compile Into Single File option is checked, all of the resulting PDF files will be compiled into a single file will all filled out forms together.

 

1 . Form Field Name Form Field Name

Form Field Name

Here the name of the form field is displayed.

 

2 . Find Next Instance Button Find Next Instance Button

Find Next Instance Button

Click Here to find the next instance of a form field by that name. When found in the currently open file, it is highlighted by selecting it.

 

3 . Form Field Checkbox Form Field Checkbox

Form Field Checkbox

This checkbox shows and allows the user to change the checkbox field from checked to unchecked.

 

4 . Mapped to Field Mapped to Field

Mapped to Field

Select the database field that this form field should map to. This drop down will show the field names (column headers) of the loaded database. In the case of checkboxes, if the database value is "true" yes" "on" or "1" the value will map as checked, otherwise, it will map as unchecked.

 

5 . Map to DB Field Button Map to DB Field Button

Map to DB Field Button

Click Here to designate this form field as being one that is mapped to a field in the database instead of just having a static value.

 

6 . Auto Map Button Auto Map Button

Auto Map Button

Click Here to automatically map the form fields in the PDF file to the fields in the database. This mapping simply maps fields of the same name together.

 

7 . Un Map All Button Un Map All Button

Un Map All Button

Click Here to Un Map all fields so that all fields once again hold a static value.

 

8 . OK Button OK Button

OK Button

Click Here to set the static form field values to the new values. This will clear all database mapping and close the database file.

 

9 . Cancel Button Cancel Button

Cancel Button

Click Here to close this tool without any changes to the file.

 

10 . Show Database Tools Show Database Tools

Show Database Tools

Click Here to show or hide the database field mapping tools.

 

11 . Load CSV Button Load CSV Button

Load CSV Button

Click Here to load a CSV file into the Database view. This will allow you to start mapping form fields to database field values.

 

CSV, comma separated values, files are documents formatted to contain tabular data. The data is delimited with commas between fields/columns and new line characters between records/rows.

 

CSV is a very old file format supported by almost all programs which contain data in a tabular format. CSV files can be saved from MS Excel, MS Access, and most data basing software. For more information on CSV files, see Wikipedia

 

We plan to add support for SQL statements and connections as well as other tabular file formats in the near future.

 

12 . Unload File Button Unload File Button

Unload File Button

Click Here to unload the current CSV file and unmap all database fields.

 

13 . Database View Database View

Database View

Here the list of database entries (rows) are displayed, the value of each field is shown in the columns, the header denoting the field name. Check a form field entry (row) to select it for exporting.

 

14 . Check All Button Check All Button

Check All Button

Click Here to check all items in the database view for exporting.

 

15 . Uncheck All Button Uncheck All Button

Uncheck All Button

Click Here to uncheck all database entries (rows) and select none for export.

 

16 . Flatten Form Fields Option Flatten Form Fields Option

Flatten Form Fields Option

Check this option to flatten all form fields in the exported file. This is recommend for the most compatible files. Checking this also enables the option to compile all output files into a single file.

 

17 . Compile Files Option Compile Files Option

Compile Files Option

Check this option to have all of the output files from merging compiled into a single file. In order to prevent form field conflicts, the Flattening of Flatten Form Fields option must be selected (checked).

 

18 . Export PDF Button Export PDF Button

Export PDF Button

Click Here to start the export process. This will go through each checked entry and input the selected database values into the mapped field creating a PDF file which corresponds to the form field entry. If the Flatten Form Fields option is checked, the form fields will be removed and simply the text put in their place. If the Compile Into Single File option is checked, all of the resulting PDF files will be compiled into a single file will all filled out forms together.

 

19 . Load Map Button Load Map Button

Load Map Button

Click Here to load a previously saved database field to form field mapping. This will ONLY load the mapping and does NOT load the database values or database file location. It also does NOT load which entries (rows) in the database are checked for export. This can only be used after a CSV file has been loaded.

 

20 . Save Map Button Save Map Button

Save Map Button

Click Here to save the current database field to form field mapping. This will ONLY save the mapping and does NOT save the database values or database file location.

 

Privacy Policy | Terms of Use
Webmaster