Paxar 6030 manual Creating Sequential Database Files

Page 40

Item Pricing Application

________________________________________________________

Creating Sequential Database Files

The printer requires a comma-delimited ASCII sequential or flat file to use the database option. Create the sequential file using nine comma- delimited fields.

NOTE: Although formats may not require all of the fields, separate each field with a comma even if the field is blank.

The nine fields include the following:

1.bar code - numeric or alphanumeric (UPC-A, EAN+5, UPC+2, Code 39, and Code 128 can be supported.)

2.item number - numeric only

3.description 1 - alphanumeric (general information field)

4.description 2 - alphanumeric(general information field)

5.price - numeric only (decimal automatically inserted for cents)

6.lot number - numeric only

7.date - numeric only (entered with or without slashes)

8.user 1 - alphanumeric (used for NOW price field)

9.user 2 - alphanumeric (used for VENDOR or DEPT field)

For the maximum size of each field, see the individual formats.

A full record might look like this example: 028028111119,11111,DESC1,DESC2,10000,111,11/2/59,USER1,9999

36

Image 40

Contents PATHFINDER Trademarks Table of Contents Item Pricing Application No Database Use Database Using Function KeysSave Upld Recs, or Do Not Save Toggling Between Alpha/Numeric Modes Using the Escape KeyExit − Are you Sure? Y/N Type Y or N Using Non-Database Formats Non-Database Operating InstructionsSelecting Non-Database Formats 1515Numeric characters 1511 Department 0 6 numeric characters 1511 5x1.1 labelScan or enter 11 numeric characters Format 1211 2x1.1 label Prompt What You Do Format 6 Press EnterFormat 1211 2x1.1 label Sale No prompt Price Enter 1 6 numeric characters Press Enter1211 2x1.1 label Prompt What You Do Format 10 Press Enter UPC 2Lines Data Line Enter up to 14 alphanumeric characters Press Enter2011 0x1.1 label Stock number 1 10 alphanumeric characters0x1.1 label Price 1 6 numeric characters Format Shelf Description line 0 15 alphanumeric characters Stock number 1 10 numeric charactersUPC ∙ 2L Format 1227 Enter up to 14 alphanumeric characters 2040 2040 0x4.0 label Description lines 0 20 alphanumeric charactersItem Pricing Application 0x4.0 label Item Pricing Application ∙ I 2 of 5 2 20 numeric characters, even numbers only Item Pricing Application 1208 2x0.8 label Prompt What You Do Format 24 Press EnterPrice Enter 1 6 numeric characters Press Enter Format Setting Up for Database Operation Setting up the PrinterParameter Default Creating Sequential Database Files Database Operating Instructions Download Data to Database Download UploadDownload Data? Y/N Pfxsend PU2420v0.cfu /Odata.txt /LUpload Data to Host Download Data Upload DataPress Enter to begin upload PC displays this messageUsing Database Formats Successfully received X packetsFormat 1511 Selecting Database Formats028028111119,,Toothpaste,,239 028028222228,,Shampoo 028028333337,,detergent,,629,,,45342028028111119 Format 1211028028222228,,Shampoo,,349 028028333337,,,,629 028028111119,,,,239Format 2011 028028222228,,Shampoo,Herbal028028333337,75123,detergent,,629 978038071834450650,,,,899,,7/3/96,45342,599 978038071834450650,,,,899,,7/3/96,4534202802855555555,,,,259,,7/3/96,45342,209 1010101010,75126,sweater,,3999Format 2040 028028222228,,Shampoo,Herbal,349978038071834450650,,coffee,gourmet,,6381,7/3/96 Format 1208 2999Appendix a Template One Template Two Template Three