Home > Print Labels Using Barcode Scanner or Other Devices (P-touch Template) > Try the P-touch Template Function Using the Barcode List > Print the Template Linked to the Database (Database Lookup Printing)
Print the Template Linked to the Database (Database Lookup Printing)
![image](../images/topic1_icon5.png)
- For more information on the barcodes scanned using various settings, see Related Information.
- The printer has reserved the leftmost column (A) of a downloaded linked database for this operation, therefore the keyword scanned from a barcode must be in this column of the database.
- For the printer to find keywords successfully, the data in the leftmost column (A) must exactly match the keywords scanned from a barcode.
- P-touch Editor and the printer can read only one line of data in each field of a linked database so we do not recommend using databases with two or more lines of data in the leftmost column (A).
- Use P-touch Editor to create a template and connect to a database file.
- You can link as many columns to a text and barcode objects in the template as needed.
- Make sure the keywords are included in the leftmost column (A) but do not link any text or barcode object in the template with field (A) if you do not need the data on the printed label.
- For more information on specifying the settings, refer to the P-touch Editor Help menu.
- Use P-touch Transfer Manager to transfer a template or label layout from the computer to the printer.For more information, see Related Information.The linked database file will also be transferred.
When a template is transferred to the Configurations folder in P-touch Transfer Manager, the Key Assign number is automatically assigned.
You can add a custom folder under Configurations, and drag-and-drop a transferred template into the custom folder to manage different sets of templates. - Select the transferred template, and then click Transfer to download the template to the Key Assign number in the printer.
- Scan the following barcode:
- P-touch template command (initialise + begin specifying settings)
- From the following barcode list, scan each barcode to send a command or setting to the printer:
- Basic settings
Auto cut on (Cut every one label) + Cut at end on
Auto cut on (Cut every two labels) + Cut at end on
Auto cut off + Cut at end on
Auto cut off + Cut at end off
Number of copies
- Settings can be made with multiple commands.
- If no settings have been made by scanning the barcode commands, a template is printed using the P-touch Template settings. The default P-touch Template settings are to print a single copy with Auto Cut turned on.
For more information on P-touch Template Settings, see the P-touch Template Manual/Command Reference (English only). You can download the latest version from the Brother support website at support.brother.com/manuals.
- Specify the number of copies you want.
- Scan the following barcode:
Number of copies
- Scan the following barcodes to specify a three-digit number:
Example:
Specify numbers by scanning the following barcodes: when printing 7 sheets; [0][0][7], when printing 15 sheets; [0][1][5]
- For entering numbers
1
2
3
4
5
6
7
8
9
0
00
To change the setting for the number of copies, repeat these steps. - Scan the following barcode:
- Select template
- Scan the following barcodes with the same number (three digits) as the Key Assign number used for the downloaded template to be printed:
Example:
Specify numbers by scanning the following barcodes: when printing number 7; [0][0][7], when printing number 15; [0][1][5]
- For entering numbers
1
2
3
4
5
6
7
8
9
0
00
The downloaded template is selected after the three digit numbers have been scanned.
You can use P-touch Editor to create and print a label with a single barcode.Example:
- Scan a barcode containing the keyword to look up in the downloaded database.
Example:
- Scan the following barcode to send the command to start searching the downloaded database for the scanned keyword:
- Delimiter
- Scan the following barcode to send the command to start printing:
- Begin printing
You can use P-touch Editor to create and print a label with a single barcode.Example:
The printer prints the template with the data inserted from the database record, found with the scanned keyword.