通过 ZebraDesigner Pro 在条码中使用数据库数据

文章编号:74879972

详细信息


Topic or Information

Linking data from a database/spreadsheet to a barcode field within ZebraDesigner Pro v2 Software

Applies To

ZebraDesigner Pro v2 Software

详细信息

When using ZebraDesigner Pro v2 you have the ability to link fields to data in a spreadsheet or database file.  The following procedure illustrates how to do so.  This can be done with both Barcode and Text fields on the label and the process is the same with the exception of selecting either Barcode or Text from the Objects Toolbar on the left hand side of the software.  

1.  Select Barcode or Text from the Object Selection Toolbar on the left hand side of the software and then click on the blank label template to open the object wizard.  Make sure to select Variable Data under the type.  In this example we will create a variable barcode object:

 User-added image

Note:  You can modify the font or barcode type you are using by clicking on the Define button in the lower right section of the wizard:

User-added image

 

2.  Once you have your variable data field created, click next and make sure to select database as the type of variable field to be used, click next:

User-added image

 

 3.  The following dialog box will allow for you to define the database/spreadsheet that you would like to link the field data to.  Click define and browse to the file that needs to be connected:

 

 

User-added image

Browse to the location of the database/spreadsheet file:

User-added image

 

4.  After the database/spreadsheet file is selected click next and you will be able to define which field from the database/spreadsheet you would like to connect to the text or barcode object:

User-added image

 

5.  After clicking next you will be able to specify how you want records to be selected as well as how to specify the quantities for the records when printing.  You can either specify that you would like to print all records from the table when printing or you can select the records you need printed at print time.  As far as quantity goes, you can either specify that you want one label for every record in the database, you can choose to have a field in the database/spreadsheet specify the quantity, or you can enter the quantity at the time of printing for the labels.  In this example we have chosen to select the records and the quantity at print time:

User-added image

 

6.  After proceeding you will see the Field Usage dialog box.  Here you can specify that you want a text field for each field you selected (see step 4) or you can link the database fields to label text fields at a later point.  In this example we choose to link the fields to text objects at a later point in time:

User-added image

 

7.  The last step in the wizard is to add a prefix or suffix to the object data.  This is optional and can be left blank if no prefix or suffix is required:

User-added image

 

8.  After clicking finish your barcode or text field will appear on the label.  If it appears in red, it is too large or outside of the boundaries of the printable label.  You will have to resize the barcode to make it fit within the label template.  It should turn black once within the boundaries of the label:

User-added image

 

To resize the barcode/text, click on one of the squares and drag it to modify the size of object until it is black and within the boundaries of the label:



User-added image

Note:  You can center your barcode by clicking the centering icon options on the right side toolbar as well as holding the control key in on your keyboard and clicking on the top center sizing square.  The square should turn white if clicked:

User-added image

 

9.  Once you have the barcode placed as you would like it, you can attempt printing.  Click the File dropdown and select print or click on the Print icon within the toolbar.  This will open the print dialog box.  The print dialog box will display based off how you previously chose to select your records and quantities (see step 5).  In this example we have chosen to select which records to print as well as the quantity at print time:

Click on Select Records...


User-added image
 

This will open the record selection wizard with which you can select the records you need to print and the quantity of each then click OK:

User-added image

 

10.  At this point you should have your database/spreadsheet linked to your label object, the records you need to print selected, and quantities specified.  You can preview the print sequence if you would like and then click print to initiate the print job.  The same steps can be taken to create more fields linked to that data if needed.

Note: If you wish to use data obtained from a linked database as the data in a UCC-128 or GS1-128 type barcode element, the wizard only allows keyboard entry. It is not a supported feature of the ZebraDesigner Pro software to accept data from a database for this bar code symbology. You will need to explore options provided through third party software providers for this to be an option.

更多信息

Create Basic Label in ZebraDesigner Software  Read More>>

USB Communication Information Read More>>

Excel Connection Issues and Limitations  Read More>>

 

+ Product Codes

  • 105SLPlus 工商用打印机
  • 105SLPlus 工商用打印机
  • 110PAX 打印引擎(已停产)
  • 110Xi4 工商用打印机
  • 140Xi4 工商用打印机
  • 170Xi4 工商用打印机
  • 220Xi4 工商用打印机
  • 2824 Plus 系列
  • 2824-Z Series
  • All Surface RFID 标签解决方案
  • 桌面打印机
  • EZ320 移动打印机
  • G 系列 GC 桌面打印机
  • G 系列 GK 桌面打印机
  • G 系列 GX 桌面打印机
  • GC420d 桌面打印机
  • GC420t 桌面打印机
  • GK420 Healthcare Desktop Printers
  • GK420d 桌面打印机
  • GK420d 医疗保健业桌面打印机
  • GK420t 桌面打印机
  • GK420t 医疗保健业桌面打印机
  • GT800 桌面打印机
  • GX420Rx 桌面打印机
  • GX420d 桌面打印机
  • GX420t 桌面打印机
  • GX430d 桌面打印机
  • GX430t 桌面打印机
  • HC100 腕带打印机
  • HC100 腕带打印机
  • 工商用打印机
  • LP 2824 Plus 桌面打印机
  • MZ Series
  • 移动打印机
  • P4T 移动打印机
  • P4T 移动打印机
  • 打印引擎
  • QL Plus 系列移动打印机
  • QL Series Mobile Printers
  • QL320 Mobile Printer
  • QL420 Mobile Printer
  • QLn 系列医疗移动打印机
  • QLn 系列移动打印机
  • 适用于医疗保健行业的 QLn220
  • QLn220 移动打印机
  • 适用于医疗保健行业的 QLn320
  • QLn320 移动打印机
  • QLn420 移动打印机
  • R110Xi4 RFID 打印机
  • RFID 打印机
  • RP4T RFID 打印机
  • RP4T RFID 打印机
  • RW 220 移动打印机
  • RW 420 移动打印机
  • RW 420 打印工作站
  • RW 系列移动打印机
  • TLP 2824Plus 桌面打印机
  • Xi 系列工商用打印机
  • ZD410 系列
  • ZD410D
  • ZD420 系列
  • ZD420-HC
  • ZD420C
  • ZD500 桌面打印机
  • ZD500 桌面打印机
  • ZD500R RFID 打印机
  • ZD500R RFID 打印机
  • ZE500 打印引擎
  • ZE500 打印引擎
  • ZE500R RFID 打印引擎
  • ZE500R RFID 打印引擎
  • ZM400
  • ZM600
  • ZQ500 系列移动打印机
  • ZQ510 移动打印机
  • ZQ520 移动打印机
  • ZR300 系列移动打印机
  • ZR338 移动打印机
  • ZR600 系列医疗移动打印机
  • ZR600 系列移动打印机
  • ZT200 系列工商用打印机
  • ZT210 工商用打印机
  • ZT220 工商用打印机
  • ZT230 工商用打印机
  • ZT400 系列工商用打印机
  • ZT400 系列 RFID 打印机
  • ZT410 工商用打印机
  • ZT410 RFID 工商用打印机
  • ZT420 工商用打印机
  • ZT420 RFID 工商用打印机
  • ZebraDesigner Pro
  • ZebraDesigner Pro
  • iMZ 系列移动打印机
  • iMZ220 移动打印机
  • iMZ320 移动打印机