Full PDF Manual (5.35 MB)

Preparing Data Files
Defining Fields
Linking to Fields
Masking
Printing Forms with merged Data
 
Printing forms with merged data


When you print your form containing linked objects, you select the data file to merge for the current print run. FoD-OMR opens the file and examines the first record (line), extracting the data for its fields. Data fields from the record are displayed on the form as text, barcodes and response position pre-slugging and the form is printed.

The process repeats for each record in the file, with one records corresponding to a single form.

Click the Print button to open the Print dialog box and select the Merge tab.

From the Merge tab, click Browse to locate the data file. FoD-OMR shows either fixed size records or delimited records, depending on the answer to this question when this form was set up:

Separated values defines delimited data files. Click Options to select the Field Delimiter and the use (or not) of the  Text qualifier:

Some databases and spreadsheets enclose text fields in a single or double quotation mark. FoD-OMR can remove this character when extracting text if you select the Text qualifier used.

Most databases and spreadsheets also put the name of each field in the first record of their file, like a table header. If your data file is formatted in this way, you can select First row contains field names. When this option is checked FoD-OMR will use the first row to identify each column and extract the information to the relevant data field.

If your data file does not have column headers, the order of extraction is determined by the start position of each data field. The first column is the data is extracted to the first data field, the second column to the second data field and so forth. For more info on defining the start position of a data field see Defining Fields.

Click Print to merge the files and print them, or Preview to view a sample of the print run.