SA - 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 - Success Academy" 

2. Select the Media Details 

   • Add Check for Printing/Encoding

   • Add Check for Re-Roll/ Rewind

   • In Other add total number of labels and 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 > Success Academy Charter Schools > redbeam > open the SOXXXX folder > Copy the share link for the Spreadsheet

   • In Printer Used type ZT411R

   • 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 → Success Academy Charter Schools → redbeamg → RFIDBookLabel.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. Open the Excel spreadsheet and navigate to sheet 2 to display the batches to print

Begin Print Job

• 1. Ctrl + P to print

  2. Under Record Selection Section set Queried Records to All

  3. Select Print

  4. The Data Entry form will appear

  5. Copy and paste the school name and reading level batch to print from th excel sheet2 batch info

  6. Confirm the record count to the batch count in excel

  7. Select print

  8. Update the record in excel from FALSE to TRUE for the batch printed

  9. Use scissors to cut between the last label and spacer for the batch print

  10. Confirm RFID Reads with RFID reader > Redbeam application

      • Success Acadamy Tenant

      • Mass Update

      • Scan the RFIDs on low RFID power 10%

      • Confirm count 

      • Update Status to Printed

      • Save

  11. Package the current batch:

      •   Small Envelopes: Use these for each Reading Level. Place the RFID labels inside these envelopes.

      • Large Envelopes: Use one large envelope per school.

      • Assembly: For each school, place all corresponding small envelopes (Reading Levels) into the large envelope labeled with the school's name.

  12. Follow Steps again to Print next Batch