Manuals / Keystone / Computer Equipment / Computer Keyboard

Keystone Computer Keyboard manual F. Connecting to a database Option 1 - Microsoft Excel

Models: Computer Keyboard

1 38

Download 38 pages 37.46 Kb

Page 17

Image 17

F. Connecting to a database (Option 1 - Microsoft Excel)

1.Ensure that your data is in an Excel Spreadsheet format, as shown below.

RECORD #	DESCRIPTION	BARCODE #
123456	COTTON BALLS	12345678
654321	TRAY C SECTION	87654321
9876543	SYRINGE 10ML	98765432

Give the spreadsheet any name you want and save it on your computer.

IMPORTANT: Be sure to put the column names in ROW 1.

Make sure that the Excel spreadsheet containing the user database is closed before proceeding with using the Solo Studio software

2.Run SOLO Studio from the StartProgramsSOLO Studio menu (or by clicking on the Solo Studio icon on your desktop), after it has been installed.

3.Use the Database Connection Wizard, from the DatabaseProperties top menu item, to connect SOLO Studio to the Excel spreadsheet you have just saved.

Select “Excel (*xls)” and locate your saved Excel spreadsheet

For technical support, please call: 800-323-4840 ext. 290 (M - F 8 a.m. to 5 p.m CST)	17

Page 17

Image 17

Keystone Computer Keyboard manual F. Connecting to a database Option 1 - Microsoft Excel

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 B. Loading the Label Media Important Safety InstructionsLabel Media Sensor Adjustment Printer Coverage C. Equipment Service CoverageEquipment Service/Support Keyboard Coverage Thermal Printhead CoverageReturns D. Installing the Labeling SoftwareSoftware Installation Use the CD key # IMPORTANT During the installation you will asked for a CD keyClick on “I accept the terms of the license agreement” to continue Click on “Next” to continueType in the appropriate User and Company Names and click on “Next” to continue Page Click “Install” to begin the installation process Running the program E. Connecting the keyboard to the PCCommunication settings on the keyboard IMPORTANT the communication settings MUST BE IDENTICAL betweenBaud rate 57,600 Data Bits Parity None Stop Bits Flow Control XON/XOFFDefault Keyboard Internal DIP switchesBoth switches are set toward the connector cord Both switches should be set away from the connector cordIMPORTANT Be sure to put the column names in ROW F. Connecting to a database Option 1 - Microsoft ExcelYou 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 Double click on the new table name you created in the database window Select “Access *mdb” and locate your saved Access databaseYou will now see the data that was imported from Excel Select “Sheet 1$”You have now connected your database to the software COTTON BALLS G. Setting up the labels/building the label template123456 Page M-4206 Printer ModelPrint Method 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 You can also custom design the label layout to meet your needs Other Label Setup OptionsCreating Fixed Text that does not change 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 Please note H. Transferring labels to the KeyboardI. Stand-alone operation - Calling up/Printing a record Calling up a record from a databaseData entry Keyboard User Input Keyboard communication settings J. Frequently Asked Questions and Troubleshooting TipsQ. The keyboard does not respond or the screen is blank BAUD 57,600 PARITY NONE DATA BIT STOP BIT SHAKE XON/XOFFKeyboard communication settings PC and Program SettingsPrinter communication settings Datamax M-Class baud rate 57,600 data Bits 8 Parity None Stop BitsbaUD RATE 9,600 PROTOCOL BOTH PARITY NONE daTA BITS STOP BITS Communication settings on the keyboard Keyboard and the printer COM IMPORTANT the communication settings MUST BE IDENTICAL betweenKeyboard Internal DIP switches Default Datamax M-Class/Z Both switches are set toward the connector cordCommunication Settings on the Printer Communication settings on the PCbaud rate 57,600 data Bits 8 Parity None Stop Bits Flow Control XON/XOFFTo clean the printhead Cleaning the Printhead144 Tower Drive Burr Ridge, IL Phone Fax TimeMed Labeling Systems, Inc