Como usar dados de banco de dados em um código de barras com ZebraDesigner pro | Zebra

Como usar dados de banco de dados em um código de barras com ZebraDesigner pro

Article ID: 74879972

Details


Topic or Information

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

Applies To

ZebraDesigner Pro v2 Software

Details

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.

Additional Information

Create Basic Label in ZebraDesigner Software  Read More>>

USB Communication Information Read More>>

Excel Connection Issues and Limitations  Read More>>

 

+ Product Codes

  • 105SLPlus impressoras industriais
  • 105SLPlus impressoras industriais
  • Motores de impressão 110PAX (disco.)
  • 110Xi4 impressora industrial
  • 140Xi4 impressora industrial
  • 170Xi4 impressora industrial
  • 220Xi4 impressora industrial
  • 2824 série Plus
  • 2824-Z Series
  • Solução de etiqueta RFID surface
  • Impressoras desktop
  • EZ320 impressoras móveis
  • G-Series GC desktop Printers
  • G-Series GK desktop Printers
  • Impressoras de mesa G-Series GX
  • GC420d impressora desktop
  • GC420t impressora desktop
  • GK420 Healthcare Desktop Printers
  • GK420d impressora desktop
  • GK420d Healthcare Desktop Printer
  • GK420t impressora desktop
  • GK420t Healthcare Desktop Printer
  • GT800 impressora desktop
  • GX420Rx impressora desktop
  • GX420d impressora desktop
  • GX420t impressora desktop
  • GX430d impressora desktop
  • GX430t impressora desktop
  • HC100 impressora pulseira
  • HC100 impressora pulseira
  • Impressoras industriais
  • Impressora de mesa LP 2824 Plus
  • MZ Series
  • Impressoras móveis
  • P4T impressoras móveis
  • P4T impressoras móveis
  • Motores de impressão
  • Impressoras móveis série QL Plus
  • QL Series Mobile Printers
  • QL320 Mobile Printer
  • QL420 Mobile Printer
  • Impressoras móveis da série QLn Healthcare
  • Impressoras móveis da série QLn
  • QLn220 saúde
  • QLn220 impressora móvel
  • QLn320 saúde
  • QLn320 impressora móvel
  • QLn420 impressora móvel
  • R110Xi4 impressora RFID
  • Impressoras RFID
  • RP4T impressoras RFID
  • RP4T impressoras RFID
  • RW 220 impressora móvel
  • RW 420 impressora móvel
  • Estação de impressão RW 420
  • Impressoras móveis série RW
  • TLP 2824Plus Desktop Printer
  • Xi Series Industrial Printers
  • Série ZD410
  • ZD410D
  • Série ZD420
  • ZD420-HC
  • ZD420C
  • ZD500 impressora desktop
  • ZD500 impressora desktop
  • ZD500R impressoras RFID
  • ZD500R impressoras RFID
  • ZE500 motores de impressão
  • ZE500 motores de impressão
  • ZE500R RFID motor de impressão
  • ZE500R RFID motor de impressão
  • ZM400
  • ZM600
  • Impressoras móveis da série ZQ500
  • ZQ510 impressora móvel
  • ZQ520 impressora móvel
  • Impressoras móveis da série ZR300
  • ZR338 impressoras móveis
  • ZR600 Series Healthcare impressoras móveis
  • Impressoras móveis da série ZR600
  • Impressoras industriais da série ZT200
  • ZT210 impressora industrial
  • ZT220 impressora industrial
  • ZT230 impressora industrial
  • Impressoras industriais da série ZT400
  • Impressoras RFID série ZT400
  • ZT410 impressora industrial
  • ZT410 RFID impressora industrial
  • ZT420 impressora industrial
  • ZT420 RFID impressora industrial
  • ZebraDesigner pro
  • ZebraDesigner pro
  • Impressoras móveis da série iMZ
  • iMZ220 impressora móvel
  • iMZ320 impressora móvel