Manuals / Keystone / Computer Equipment / Computer Keyboard

Keystone Computer Keyboard manual Map a BARCODE label element to a Database Field

Models: Computer Keyboard

1 38

Download 38 pages 37.46 Kb

Page 26

Map a BARCODE label element to a Database Field

Map a BARCODE label element to a Database Field

1.Click on the BARCODE element.

2.Map this barcode label element to the Source Type of “Database” and Field of “Barcode”.

3.The default barcodes used are Code 39. You also have the option to create barcodes using Code 128, 2-D or other barcodes by referring to the barcode section titled “Map a BARCODE label element to a Database Field”.

At this point you can save the label format you have created. Go to the top menu bar and click on “File, Save As” and type in the appropriate file name (the file name used can be up to a maximum of 8 characters).

IMPORTANT:

When creating a label template using a DATABASE, we recommend that you also create a separate label template (with the same layout) using the KEYBOARD input method. This will allow you to create and print labels even if an item currently does not exist in your database.

26	TimeMed Labeling Systems, Inc. - Call Toll Free: 800-323-4840 or visit www.timemed.com

Image 26

Keystone Computer Keyboard manual Map a BARCODE label element to a Database Field

Contents

144 Tower Drive Burr Ridge, IL Phone Fax Keystone Labeling System Instruction ManualTimeMed Labeling Systems, Inc Getting started with the TimeMed Keystone Labeling System Table of ContentsKeystone User Manual Monday through Friday between 800 a.m. and 500 p.m. CST A. Unpacking Keystone800 323-4840 extension Important Safety Instructions B. Loading the Label MediaLabel Media Sensor Adjustment Printer Coverage C. Equipment Service CoverageEquipment Service/Support Thermal Printhead Coverage Keyboard CoverageReturns D. Installing the Labeling SoftwareSoftware Installation IMPORTANT During the installation you will asked for a CD key Use the CD key #Click on “Next” to continue Click on “I accept the terms of the license agreement” to continueType in the appropriate User and Company Names and click on “Next” to continue Page Click “Install” to begin the installation process E. Connecting the keyboard to the PC Running the programBaud rate 57,600 Data Bits Parity None Stop Bits IMPORTANT the communication settings MUST BE IDENTICAL betweenCommunication settings on the keyboard Flow Control XON/XOFFBoth switches are set toward the connector cord Keyboard Internal DIP switchesDefault Both switches should be set away from the connector cordF. Connecting to a database Option 1 - Microsoft Excel IMPORTANT Be sure to put the column names in ROWYou have now connected your Excel spreadsheet to the software IMPORTANT Be sure to put the column names in ROW F. Connecting to a database Option 2 - Microsoft AccessHow to import a Microsoft Excel spreadsheet into an Access database You will now see the data that was imported from Excel Select “Access *mdb” and locate your saved Access databaseDouble click on the new table name you created in the database window Select “Sheet 1$”You have now connected your database to the software COTTON BALLS G. Setting up the labels/building the label template123456 Page Print Method Printer ModelM-4206 Direct ThermalMap a TEXT label element to a Database Field Fixed Data - The information printed will always be the sameKeyboard - User input is required by typing on the keyboard Map a BARCODE label element to a Database Field Map a Label element using the Keyboard User Input Creating Fixed Text that does not change Other Label Setup OptionsYou can also custom design the label layout to meet your needs Map a TEXT label element to a Database Field1. Add a TEXT label element “Quantity” Map a label element using Keyboard User InputMap a BARCODE label element to a Database Field I. Stand-alone operation - Calling up/Printing a record H. Transferring labels to the KeyboardPlease note Calling up a record from a databaseData entry Keyboard User Input Q. The keyboard does not respond or the screen is blank J. Frequently Asked Questions and Troubleshooting TipsKeyboard communication settings BAUD 57,600 PARITY NONE DATA BIT STOP BIT SHAKE XON/XOFFPrinter communication settings Datamax M-Class PC and Program SettingsKeyboard communication settings baud rate 57,600 data Bits 8 Parity None Stop BitsbaUD RATE 9,600 PROTOCOL BOTH PARITY NONE daTA BITS STOP BITS Keyboard Internal DIP switches Default IMPORTANT the communication settings MUST BE IDENTICAL betweenCommunication settings on the keyboard Keyboard and the printer COM Datamax M-Class/Z Both switches are set toward the connector cordbaud rate 57,600 data Bits 8 Parity None Stop Bits Communication settings on the PCCommunication Settings on the Printer Flow Control XON/XOFFCleaning the Printhead To clean the printheadTimeMed Labeling Systems, Inc 144 Tower Drive Burr Ridge, IL Phone Fax