Home » Brother International Manuals » Label Makers » Brother International PT-P900W » Manual Viewer

Brother International PT-P900W Users Guide - Page 220

Database, Connect, Open Database, Connect Database File, Browse, Database Field, Merge Fields

View all Brother International PT-P900W manuals

Add to My Manuals
Save this manual to your list of manuals

Page 220 highlights

Using the Touch Panel Display (Optional:PA-TDU-003) (PT-P950NW Only) a Prepare a database file in advance. Note • Files saved as XLS, MDB, CSV and TXT formats can be used as databases. • To use files in the XLSX or ACCDB format, Microsoft® Office 2007, 32-bit Microsoft® Office 2010, 2007 Office System Driver: Data Connectivity Components, or 32-bit 2010 Office System Driver: Data Connectivity Components must be installed. • Only one database can be linked to a single template. A maximum of 65,000 records can be created in that database. (The total size of templates and databases is limited to 7 MB.) • The data entered in the database can be displayed on the LCD. Only the first 13 characters can be displayed. b In P-touch Editor, open the template that will be linked to the database. c On the menu bar, click [File] - [Database] - [Connect] to display the [Open Database] dialog box. Select [Connect Database File], click [Browse], and then select the database you want to link. 24 d Click [Next] to display a settings dialog box. With [Database Field] under [Merge Fields], specify which database column will be linked to which object, and then click [OK]. 210

Section	Page
User’s Guide PT-P900W/PT-P950NW	1
Introduction	2
Important Notice	2
Available Manuals	2
Symbols Used in This Guide	3
IMPORTANT NOTE	4
Table of Contents	5
Basic Operations	11
1 Setting Up the P-touch Label Printer	12
General Description	12
Front	12
Back	13
Connecting the Power Supply	14
Inserting a Tape Cassette	15
Turning Power On/Off	17
Feeding Tape	17
2 Printing Using the Computer	18
Installing the Printer Driver and Software	18
Connecting the P-touch Label Printer to a Computer	19
Connecting Using USB	19
Connecting Using Wi-Fi®	19
Infrastructure Mode	19
Ad-Hoc Mode	21
Turning the Wireless Function On or Off	21
Connecting Using a Wired LAN (PT-P950NW Only)	22
Network Cable	22
Printing from a Computer	23
Available Applications	23
Printing from Your Computer	24
Cutting Options	24
Attaching Labels	26
3 Printing Using the Mobile Device	27
Installing Applications for Use with Mobile Devices	27
Available Applications	27
Connecting the P-touch Label Printer to a Mobile Device	27
Turning the Wireless Function On or Off	28
Printing from a Mobile Device	28
Printing from Your Mobile Device	28
Cutting Options	29
Using a Mobile Device to Print Templates Created on a Computer	30
Attaching Labels	31
4 Using the Other Interfaces (Serial Interface/Bluetooth Interface)	32
Installing the Printer Driver and Software	32
Transferring the Template to P-touch Transfer Manager	32
Transferring Templates from the Computer to the P-touch Label Printer	32
Connecting Using the Serial Adapter (Optional:PA-SCA-001)	33
Serial (RS-232C) Cable (Windows® Only)	34
Serial Interface Settings	34
Setting the Barcode Scanner or Scale Baud Rate	34
Setting the P-touch Label Printer Baud Rate (Windows® Only)	34
Connecting Using the Bluetooth Interface (Optional: PA-BI-002) (PT-P950NW Only)	35
Product Specifications of PA-BI-002	35
5 Changing the P-touch Label Printer Settings	36
Printer Setting Tool for Windows®	36
Before Using the Printer Setting Tool	36
Using the Printer Setting Tool for Windows®	37
Communication Settings for Windows®	39
Settings Dialog Box	39
Menu Bar	41
General Tab	44
Communication Settings	44
IPv6	45
Wired LAN (PT-P950NW Only)/Wireless LAN Tabs	46
TCP/IP (Wired)	46
TCP/IP (Wireless)	46
IPv6	48
Wireless Settings	49
Wireless Direct Tab	51
Wireless Direct Settings	51
Bluetooth Tab (PT-P950NW Only)	52
Bluetooth Settings	52
Applying Setting Changes to Multiple Printers	53
Device Settings for Windows®	54
Settings Dialog Box	54
Menu Bar	56
Basic Tab	58
Label Settings Tab	59
Panel Settings Tab (PT-P950NW Only)	60
Management Tabs (PT-P950NW Only)	61
Management (1)	61
Management (2)	61
Applying Setting Changes to Multiple Printers	64
P-touch Template Settings for Windows®	65
P-touch Template Settings Dialog Box	66
Printer Setting Tool for Mac	68
Before Using the Printer Setting Tool	68
Using the Printer Setting Tool for Mac	68
Settings Dialog Box	69
Basic Tab	70
Label Settings Tab	71
Bluetooth Settings Tab (PT-P950NW Only)	72
Wireless LAN Tab	73
Applying Setting Changes to Multiple Printers	74
Changing Settings When Printing from a Mobile Device	75
6 Printing Labels Using P-touch Template	76
P-touch Template Operations	76
Preparation	77
Specifying Settings in the P-touch Template Settings Tool	77
Specifying the RS232C Serial Port Settings	79
Connecting a Barcode Scanner	80
Standard Template Printing	81
Advanced Template Printing	83
Database Lookup Printing	86
Numbering (Serialized Number) Printing	89
Text Numbering (Serializing)	89
Barcode Numbering (Serializing)	90
Printing with Numbering (Serializing) Advanced Operation	91
7 Other Functions	92
Confirming the P-touch Label Printer Settings	92
Mass Storage Mode	92
Description	92
Using the Mass Storage Mode	92
Distributed Printing (Windows® Only)	94
Printing Labels in High Resolution Mode	98
Printing Labels in High Speed Mode	99
Printing Labels in High Quality Mode	100
Application	101
8 How to Use Cable Label Tool (Windows® Only)	102
Starting Cable Label Tool	102
Creating a Cable Label	104
Faceplate	104
Cable Wrap	105
Cable Flag	106
Patch Panel	107
Punch-Down Block	107
Die-cut Flag	108
Heat Shrink Tube	108
Linking a Database	109
Numbering Function (Serialized Number) Printing	110
Printing with Cable Label Tool	110
Transferring Templates from Cable Label Tool to the P-touch Label Printer	111
9 How to Use P-touch Editor	112
For Windows®	112
Starting P-touch Editor	112
Printing with P-touch Editor	115
Transferring Data to the P-touch Label Printer	116
For Mac	117
Starting P-touch Editor	117
Operation modes	118
Transferring Data to the P-touch Label Printer	119
10 How to Use P-touch Transfer Manager and P-touch Library (Windows® Only)	120
P-touch Transfer Manager	120
Transferring the Template to P-touch Transfer Manager	120
Transferring Templates or Other Data from the Computer to the P-touch Label Printer	123
Backing up Templates or Other Data Saved in the P-touch Label Printer	128
Deleting All the P-touch Label Printer Data	129
Creating a BLF File or a PDZ File	130
P-touch Library	131
Starting P-touch Library	131
Opening and Editing Templates	133
Printing Templates	134
Searching for Templates	135
11 Transferring Templates with P-touch Transfer Express (Windows® Only)	137
Preparing P-touch Transfer Express	137
Transferring the Template to P-touch Transfer Manager	138
Saving the Template as a Transfer Package File (.pdz)	139
Distributing the Transfer Package File (.pdz) and P-touch Transfer Express to the User	141
Transferring the Transfer Package File (.pdz) to Your P-touch Label Printer	142
12 How to Update P-touch Software	145
Updating Cable Label Tool (Windows® Only) and P-touch Editor	145
For Windows®	145
For Mac	147
Updating the Firmware	149
For Windows®	149
For Mac	151
Network	154
13Introduction	155
Network Features	155
14 Changing Your P-touch Label Printer Network Settings	156
Changing Your P-touch Label Printer's Network Settings (IP Address, Subnet Mask and Gateway) Using Windows®	156
Using the BRAdmin Light Utility	156
Installing BRAdmin Light	156
Setting the IP address, Subnet Mask and Gateway using BRAdmin Light	156
Other Management Utilities	158
Using Web Based Management (Web Browser)	158
Using the BRAdmin Professional Utility (Windows® Only)	158
15 Web Based Management	159
Overview	159
Configuring the Printer Settings Using Web Based Management (Web Browser)	160
Appendix	161
16 Resetting the P-touch Label Printer	162
Resetting All Settings to the Factory Settings Using the P-touch Label Printer Buttons	162
Resetting Data Using the Printer Setting Tool	162
17 Maintenance	163
Cleaning the Exterior of the Unit	163
Cleaning the Print Head and Head Roller	163
Print Head	164
Head Roller	164
Cleaning the Tape Cutter	165
18 Troubleshooting	166
Overview	166
Printing Problems	167
Label Problems	170
Printer Problems	171
Network Setup Problems	172
P-touch Label Printer Cannot Print over the Network P-touch Label Printer Is Not Found on the Network Even after Successful Installation	173
Security Software Problems	173
Checking the Operation of Network Devices	174
Version Information	174
LED Indicators	175
Indicator Warnings	179
19 Product Specifications	180
P-touch Label Printer Specifications	180
Operating Environment	182
20 Notes on Using P-touch Transfer Manager	183
Notes on Creating Templates	183
Notes on Transferring Templates	183
Notes on Transferring Data Other Than Templates	184
21 Network Terms and Information	185
Supported Protocols and Security Features	185
Types of Network Connections and Protocols	186
Types of Network Connections	186
Configuring Your P-touch Label Printer for a Network	188
IP Addresses, Subnet Masks and Gateways	188
IP address	188
Subnet mask	189
Gateway (and router)	189
Wireless Network Terms and Concepts	190
Security Terms	190
Authentication and encryption	190
Authentication and Encryption methods for a personal wireless network	190
Authentication and Encryption methods for an enterprise wireless network	192
22 List of Barcodes for the P-touch Template Function	195
General Procedure for the P-touch Template Function	195
List of Barcodes for Specifying Settings	196
23 Using the Rechargeable Li-ion Battery/Battery Base (Optional:PA-BT-4000LI/PA-BB-002)	199
Installing the Rechargeable Li-ion Battery	199
Removing the Rechargeable Li-ion Battery	200
Charging the Rechargeable Li-ion Battery	201
Stopping Rechargeable Li-ion Battery Charging	201
Notes on Using the Rechargeable Li-ion Battery	202
Rechargeable Li-ion Battery Characteristics	202
Product Specifications	203
24 Using the Touch Panel Display (Optional:PA-TDU-003) (PT-P950NW Only)	204
General Description	204
LCD	205
Main Screen	205
Touch Panel	207
Replacing the Touch Panel	208
Printing With the Touch Panel Display	211
Touch Panel Display Settings	212
Specifying Settings From the Touch Panel Display	212
Setting the Time and Date	214
Setting the Administrator Password	215
Creating a Label Layout (Windows® Only)	216
Creating a Template	216
Setting the Text and Order for Displaying on the LCD	218
Inserting the Date and Time in a Label	219
Linking a Database to a Template	219
Transferring the Label Layout to the P-touch Label Printer	222
Selecting the Touch Panel	224
Selecting the Data Assigned to Keys on the One-Touch Panel	225
Creating a One-Touch Panel	226
Printing the Label	227
Printing Using the Basic Control Panel	227
Editing Label Contents Before Printing	228
Searching for Records in a Database Linked to a Template	229
Printing Using the One-Touch Panel	229
If a Template With a Linked Database Is Registered with a One-Touch Key	230
Printing Using a Barcode Scanner	231
Label Layouts on the P-touch Label Printer (Checking, Deleting and Log)	232
Replacing the Time/Date Battery	233
Frequently Asked Questions	235
Product Specifications	237
25 Using the Brother Barcode Scanner (Optional: PA-BR-001) (PT-P950NW Only)	238