Answer to your Frequently Asked Question:

 
Printer Friendly
Description of Problem 100000022118

How do I import a database in the Ptouch Editor 5.x for Windows?


Description of Solution 200000028129

In order to import a database into the PTouch Editor 5.0, the database file must be in one of the following formats:

·         ACCDB

·         MDB

·         XLSX

·         XLS

·         CSV

·         TXT

 

You can view a video of instructions 1 – 6 or follow the instructions listed below:

 

- To view the video of instructions 1 – 6 click here or enter the following address into your web browser:

    http://www.brother-usa.com/videos/?VID=1290

1. Open a new layout in PTouch Editor.

 

a)    Open a new layout by clicking on the NEW/OPEN icon.

 

b)    In the NEW/OPEN dialogue box click on the MEDIA SIZE drop down menu arrow and select the size of the label.

 

c)    Click on the NEW tab and select the orientation HORIZONTAL or VERTICAL.

 

d)    Click OK.

 

 

 

 

 

2. Select the database file containing the data you wish to put onto the label.

 

a)                    In the menu bar

 

b)                    Click on File

 

c)                    GO down to Database

 

d)                    Select Connect.

 

 

 

 

3. Click on Browse in the Open Database dialogue box.

 

 

4. Locate the database file in the Open Database dialogue box and then click Open.

 

 

 

5. After clinking Open, the selected file location and name will appear in the File Name box. 

In the Select Editing Mode section, select Connect as read only or Connect to original file and allow editing, and then click NEXT.

 

 

6. After clinking NEXT, the selected database file will open up in the PTouch Editor 5.0.  

 

Note:  If you only want to display the barcode from the label list data (import data) to the label’s layout. Go to step 15.

 

 

 

7. Connect the fields (Joining the fields) that you wish to go onto the label.  By connecting the fields together this will allow us to have one format for all the connected fields; the text on the label will be uniform. This does not change the columns of the database.  If you do not connect the fields, each field can have individual format (font type, font size, font style, etc.).

 

a)    Click on a record on the database table. 

 

Note: that the options in the menu bar have changed.

 

b)    In the menu bar, click on Database and select Connect Fields.

 

 

 

8. In the Define Joined Fields dialogue box, click ADD.

 

 

9. Select the fields you wish to join together.

 

a)    Click on the first field you want to join.

 

b)    Click ADD

 

 

 

 

10. Select your next field and click ADD.

 

Note: You can use spaces, commas, and Enter key to arrange the fields. 

For example, put a space between First Name and Last Name

After Last Name press the Enter key to go to the next line to add the Company field.

 

 

 

 

 

 

 

11. Continue adding all fields you desire to join together, click OK when you are finish.

 

 

 

12. After clicking OK the Define Joined Fields dialogue box will appear with the fields you have selected, Click CLOSE.

 

 

 

 

 

 

 

13. In the menu bar, click on Database and select Merge into Layout.

 

 

a.                    In the Merge Fields dialogue box, select the Joined Fields.

 

b.    For Merge Type select TEXT.

 

c.    Click OK.

 

 

 

14. After clicking OK an image of a record appears on the layout. 

 

a)                    Click on the line border around the image, eight boxes will appear on the border.

 

b)                    At this point you can click on one of the boxes, keep the mouse button down and move it to resize the border.   

 

 

 

 

 

 

15. Add a POSTNET barcode to the layout. 

 

a)    Click on a record on the database table.

 

b)    In the menu bar, click on Database and select Merge into Layout.

 

 

 

16. Select the field for the Zip Code and merge onto the label layout.

 

a)    In the Merge Fields dialogue box, select ZIP.

 

b)    For Merge Type select BAR CODE.

 

c)    Click OK.

 

 

17. After clicking OK a barcode appear on the layout.  It may not be the correct barcode type. 

 

To change the barcode type:

 

a)    Click on the barcode on the layout.

 

b)    Click on the Properties icon.

 

 

 

18. Change the Barcode type to POSTNET.

 

a)    In the Bar Code Properties dialogue box, click on the Protocol tap.

 

b)    Select the POSTNET protocol.

 

c)    Click OK.

 

 

 

 

19. After clicking OK it will bring you back to the PTouch Editor 5.0 window.

 

a)                    In this view, you can reposition the barcode on the layout.

 

b)                    Click on it, do not release the button and move the mouse with the button held down.

 

 

 

 

20. Save the layout, click on FILE in the menu bar and select SAVE

 

 

 

a)    In the SAVE dialogue box, for File name: type in a name for the new layout.

 

b)    In Save as type: select Layout File (*.lbx).

 

c)    Click SAVE.

 

Note: Once you saved the layout, whenever you open the saved layout, it will also open the database file. 

 

 

 

21. To print, click on FILE in the menu bar and select PRINT

 

 

22. In the Print dialogue box, select the Print Range and click PRINT.

 

5

 

 

Was this helpful?
Please help us to improve our services by letting us know if this information was helpful: