In this video tutorial you will learn how to link your Brother Ptouch Editor software to an existing database or excel CSV spreadsheet. You will also learn how to merge the fields into both new and existing labels. This video is for Macintosh users, for the Windows version click: https://www.youtube.com/watch?v=V_LM4Bkj_qk You can download the Ptouch Editor and other software at: https://ift.tt/2olE3Oz For more videos, tutorials, and FAQs visit our support site at: https://ift.tt/KVp7Rt Quick Links / Table of Contents: Requirements 0:18 Import database 0:29 Merge database/spreadsheet into a new label 1:03 Arranging label format 1:46 Merge database/spreadsheet into existing label 2:21 Map merged fields 2:49 Transcript: Welcome. Today we are going to look at how to connect an Excel Database to P-Touch Editor. This video will cover multiple models. Even though your machine may not match the model referred to on the screen the overall process will still be the same. Before beginning, you will need to have the Brother P-Touch Editor software installed on your computer. You will also need an Excel Database created in a CSV format and ready to connect. (You can also connect to excel spreadsheet.) To begin click File, then click Database…Now click on Connect. Click the Browse Button to search your computer for the correct database. If your database contains a Header row, select Header Row Contains Field Names. Then click Next. The database will now show in the lower window. Click on the database to select all fields. From the menu bar click Database, and then Merge Into Layout. Select the fields you would like to merge. For this example, we will merge the Part and Part number fields as Text and the UPC field as a Barcode. From the Merge Type dropdown select Text. Then highlight Part and Part Number…and click OK. To merge the UPC Field, again click Database…and Merge Into Layout. Select Bar Code from the dropdown and select UPC. The layout of your label will be aligned to the default settings of the Brother P-Touch Editor. To adjust the layout, use the Layout icon on the Inspector. Using the arrow Icon, select one of the fields within the label. For this example, we will center all fields on the label. Please note that if any of the text appears outside the dotted margin lines, you will need to manually adjust the fields. All the records in the database are now aligned to the same format. You can also merge a database to an already existing label. For this example, we have a label created with three different fields. Click File, then click Database and select the database from the list. (You can also connect to excel spreadsheet.) You will now be prompted to Map your Merged Fields. Click on each Database Field on the right of the widow and use the dropdowns to select the appropriate column from the database for each entry. As each column is selected the Preview window will update, displaying an example label. Once all fields are set, Click OK. As before, all labels are formatted the same way. For more Tutorials, FAQ's and Videos, visit us at www.brother-usa.com Thank you for choosing Brother Customers also searched: Ptouch database link macintosh Ptouch database merge macintosh Ptouch database connect macintosh Ptouch spreadsheet link macintosh Ptouch spreadsheet merge macintosh Ptouch spreadsheet connect macintosh Ptouch editor link An official Brother printer support resource
2018年8月30日星期四
Ptouch Editor – link to database or spreadsheet - Macintosh
In this video tutorial you will learn how to link your Brother Ptouch Editor software to an existing database or excel CSV spreadsheet. You will also learn how to merge the fields into both new and existing labels. This video is for Macintosh users, for the Windows version click: https://www.youtube.com/watch?v=V_LM4Bkj_qk You can download the Ptouch Editor and other software at: https://ift.tt/2olE3Oz For more videos, tutorials, and FAQs visit our support site at: https://ift.tt/KVp7Rt Quick Links / Table of Contents: Requirements 0:18 Import database 0:29 Merge database/spreadsheet into a new label 1:03 Arranging label format 1:46 Merge database/spreadsheet into existing label 2:21 Map merged fields 2:49 Transcript: Welcome. Today we are going to look at how to connect an Excel Database to P-Touch Editor. This video will cover multiple models. Even though your machine may not match the model referred to on the screen the overall process will still be the same. Before beginning, you will need to have the Brother P-Touch Editor software installed on your computer. You will also need an Excel Database created in a CSV format and ready to connect. (You can also connect to excel spreadsheet.) To begin click File, then click Database…Now click on Connect. Click the Browse Button to search your computer for the correct database. If your database contains a Header row, select Header Row Contains Field Names. Then click Next. The database will now show in the lower window. Click on the database to select all fields. From the menu bar click Database, and then Merge Into Layout. Select the fields you would like to merge. For this example, we will merge the Part and Part number fields as Text and the UPC field as a Barcode. From the Merge Type dropdown select Text. Then highlight Part and Part Number…and click OK. To merge the UPC Field, again click Database…and Merge Into Layout. Select Bar Code from the dropdown and select UPC. The layout of your label will be aligned to the default settings of the Brother P-Touch Editor. To adjust the layout, use the Layout icon on the Inspector. Using the arrow Icon, select one of the fields within the label. For this example, we will center all fields on the label. Please note that if any of the text appears outside the dotted margin lines, you will need to manually adjust the fields. All the records in the database are now aligned to the same format. You can also merge a database to an already existing label. For this example, we have a label created with three different fields. Click File, then click Database and select the database from the list. (You can also connect to excel spreadsheet.) You will now be prompted to Map your Merged Fields. Click on each Database Field on the right of the widow and use the dropdowns to select the appropriate column from the database for each entry. As each column is selected the Preview window will update, displaying an example label. Once all fields are set, Click OK. As before, all labels are formatted the same way. For more Tutorials, FAQ's and Videos, visit us at www.brother-usa.com Thank you for choosing Brother Customers also searched: Ptouch database link macintosh Ptouch database merge macintosh Ptouch database connect macintosh Ptouch spreadsheet link macintosh Ptouch spreadsheet merge macintosh Ptouch spreadsheet connect macintosh Ptouch editor link An official Brother printer support resource
订阅：
博文评论 (Atom)
没有评论:
发表评论