Skip to content

POSTEK-OX-Script/Google_sheet_Read-Print

Repository files navigation

Google_sheet_Read-Print

This code is designed to print labels on POSTEK printers based on data retrieved from a or many cloud Google sheet files

Demo video

A demonstration of what this script can do can be found here

https://youtu.be/FFZGU_X2ulE?si=Mpna_DV3tUFYh9fz

Tutorial video

A tutorial on developing this script can be found here

https://youtu.be/apklOWnz-BQ

Installation

To run this code, you will need to have Python 3.8+ installed on your printer(which comes standard on all POSTEK Printers that support OX Script after May 2023). You will be able to execute this code directly on your computer but the behavior is probably going to be different from behaviors on the printer as it is intended to be executed on the printer

You will also need the free POSTEK Companion app which can be downloaded here:

https://www.postekus.com/service-support/download/software/

Usage

The code requires two additional files to execute, a file called sound-service(used for Google sheet authentication) and a command file that holds all the information in regard to the actual label design.

Both files are provided in this repository. Please note the command file is provided for 300 dpi machines, You can easily generate your own design using a label editing software like Bartender, and the sound service file is provided as a dummy file without real data inside it(as it is sensitive information specific to your google account). Be sure to change the sound service file to the one corresponding to your account when using this code

To execute this demo, simply load the .py file, sound-service-xxxxxxxxx.json(Source for the Google authentication), and rfid.prn(the command file for the label design) into your printer through the POSTEK App. Then to run the program you can initiate it from the printer touch screen or the POSTEK App.

  • Initiating the program from the printer touchscreen

    • On your printer's touch screen, go to settings>Ox Script>[your file name].py. Press it and select run from the bottom right of the pop-up window
  • Initiating the program from the POSTEK App

    • Inside the App, select Ox Script from the left-hand side. Connect to the printer that you just moved the files to and select the file from the left-hand side drop-down, click run on the top right-hand corner

License

This code is released under the MIT License. Please see the LICENSE file for more information.

Disclaimer

This software is provided "as is" and the author of the software is not liable for any damages or losses that may arise from the use of the software. Use at your own risk.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages