Caterpillar - Asset Tracking Printing

Work Order - Roll Out Details

1. Make a copy of Google Sheet "** Roll-Out Details Template **" in the folder Google Shared Drive > Strategic > Strategic Resources > WORK ORDERS and save with the name "SOXXXXX - Caterpillar, Inc." 

2. Select the Media Details 

   • Add Check for Printing/Encolding

   • Add Check for Re-Roll/ Rewind

   • In Other add number of batches to be printed

   • In Syntax, copy and paste the URL link for the Google Drive spreadsheet located in Google Drive 

     • Shared Drives > Strategic > Technical Services > Customer Files > Caterpillar > RFIDTagPrining > Asset Tracking > open the SOXXXX folder > Copy the share link for the Spreadsheet

   • In Printer Used type ZT410R Silverline

   • Save

Open Bartender Template and Setup Database connection

• 1. Open Bartender template

     • File → Open

     • This PC → Google Drive → Shared drives → Strategic → Tech services → Customer files → Caterpillar → RFIDTagPrinting → Asset Tracking → CAT-LABEL.BTW

  2.  Connect Database batch

     • File → Database connection

     • Create a New database connection

     • MS Excel → Select file

     • This PC → Google Drive → Shared drives → Strategic → Tech services → Customer files → Caterpillar → RFIDTagPrinting → Asset Tracking → open S0XXXX folder and select the Excel Sheet

     • Open > Next > uncheck use automatic field

     • Next > if multiple sheets start w/ the first one (first batch), uncheck first row has fields (if there is no header) > Next →  finish

     • Press OK

  3. Double click Barcode in label template to open Barcode properties  

  4. Confirm or Update Embedded data to Database Connection

     • On Type: section select the Change Data Source type icon

     • Select New Type 

     • From Dropdown: Database field 

     • Next > confirm A & Sample # → Finish → Close 

Begin Print Job

• 1. Perform print of first Record

     • Ctrl + P to print

     • Under Record Selection Section click on select records

     • uncheck first check box to deselect all

     • Check box for record value 1

     • select OK

     • Select Print

     • Confirm print is successful and the ID is printed for the barcode 

  2. Print remaining Records of the Batch

     • Ctrl + P to print

     • Under Record Selection Section click on select record 

     • Check first check box to select all → uncheck box for record value 1

     • select ok

     • Select Print 

  3. During large print job, begin to loosely hand Roll the labels → once labels run out, printer will show media out

     • open printhead

     • remove labels and core

     • set aside for boxing

     • open new box

     • Follow step 2 from Load Printer with Media

     • Printing will resume

  4. Continue hand roll

  5. Once print job batch finishes, press feed button once, and use box cutter to cut between the last blank label and spacer

  6. Box up label roll(s) following the steps from Boxing up label Batches

  7. Print next Batch

     • Select Database Setup

     • Select Tables

     • Select the existing table and select Change Table

     • Select the next batch from the sheet dropdown → select OK

     • Press OK

  8. Follow Steps 1-7 to complete existing batch and start the next until completed with all batches

  9. Once Completed, follow steps to Disconnect the Database and Close Template

Boxing up Label Batches

• 1. After completing print Job of Batches →  Use existing boxes, bubble wrap and stickers in the same method used for the black labels

  2. Write outside the box Box# and site name

  3.  Boxing 

     • for large batches use the original label boxes

     • for smaller batches use 8×6×4 boxes w/ paper from shipping Desk  

Disconnect Database and close Bartender Template

• 1. Disconnect the Database and Save & close bartender template

     • Open File → Database connection setup

     • Select red X on bottom left corner

     • Select Yes

     • Select OK

     • Close Template

     • Select Yes to Save