Asia Pacific (English)
Barcode Better

At TEKLYNX, we believe barcode software isn’t just something you buy. It’s an integrated technology solution that makes your company work.

Blog

How to Print Labels with Cloud Data

Travis Wayne

How to Print Labels with Cloud Data

BY: TRAVIS WAYNE / DATE: 24/06/2021 / TOPICS: LABEL DESIGN, ENTERPRISE LABEL MANAGEMENT, CLOUD LABELING

As the world is becoming increasingly digital, cloud technology is becoming more prevalent in our daily lives and in our companies. People stream their favorite shows through the cloud, facilitate business meetings through the cloud, and share important company files and documents in the cloud. So why not store your barcode data and labels in the cloud, too?

 

DOWNLOAD FREE TRIAL

 

With cloud integration available directly within your labeling software, connecting to cloud data has never been so simple. In this blog, learn how to store and print labels from the cloud using Excel Online, Google Sheets, and OData connections.  

 

Printing Labels with Cloud Data 

 

While remote work is becoming more common, locally saved spreadsheets and label files limit accessibility. Users are limited to the files stored on their computer, creating unnecessary back-and-forth between users who need to edit or share label files and potentially multiple versions of label files. With cloud-based database connections, authorized users who sign into their cloud-based account using a two-factor authentication process can securely access the files they need anywhere in the world with an internet connection, creating a more efficient sharing and collaboration process. 

 

If label files are saved locally and your hardware malfunctions, files may be permanently lost. Having your labels and data stored in the cloud reduces the risk of losing files through automatic backups. 

 

With TEKLYNX label software products, connecting to cloud data is effortless. Label files (LABELVIEW (.lbl) or CODESOFT (.lab)) can be stored in cloud locations such as Google Drive or Microsoft OneDrive. Data sources stored in cloud locations such as Google Sheets, Microsoft Excel Online or OData can be leveraged for use on a label file. Download a free 30 day trial and follow these next steps to learn how to print labels with cloud data from Google Sheets, Excel Online, and OData connections.  

 

How to Print Labels from Google Sheets 

 

Google Drive and Google Sheets have gained popularity with businesses in recent years. TEKLYNX products make it easy to integrate your labeling process with cloud data from Google Drive and Google Sheets. 

 

How to connect to your Google Drive account

 

  1. Select File > Open > Google Drive 
  2. Link you Google Drive account
  3. Authenticate your account if prompted
  4. Click Allow
  5. Close confirmation window
  6. Click OK

 

How to connect to Google Sheets as a data source 

 

  1. To connect to Google Sheets, go to your top menu bar, click on Data Source > Database > Create/Edit query 
  2. Click on New and select Google Sheets
  3. Name your connection and click the three dots to the left to locate the file 
  4. Select your file and click Open 
  5. Under Select the table drop down, select the table you want to drive your data from 
  6. Select the relevant fields you would like to load and click OK 
  7. Under Data sources, click and drag the information you would like on your label 

 

How to save your labels to Google Drive 

 

  1. Go to File > Save As > Google Drive 
  2. Name your file and click Save 

 

 

 

How to Print Labels from Excel Online

 

Microsoft products such as Excel have been a staple resource for businesses for many years. Now, Microsoft products are available in the cloud which means you need barcode labeling software that has the ability to integrate with Microsoft OneDrive or Excel Online. 

 

How to connect to your Microsoft OneDrive account

 

  1. Select File Open > Microsoft OneDrive
  2. Link your OneDrive account
  3. Authenticate your account if prompted
  4. Click Allow
  5. Close confirmation window
  6. Click OK

 

How to connect to Excel Online as a data source 

 

  1. To connect to Google Sheets, go to your top menu bar, click on Data Source > Database Create/Edit query 
  2. Click on New and select Microsoft Excel Online
  3. Name your connection and click the three dots to the right to locate the file 
  4. Select your file and click Open 
  5. Under Select the table drop down, select the table you want to drive your data from 
  6. Select the relevant fields you would like to load and click OK 
  7. Under Data sources, click and drag the information you would like on your label 

 

How to save your labels to Microsoft OneDrive

 

  1. Go to File Save As > OneDrive
  2. Name your file and click Save 

 

 

 

How to Print Labels Using OData Connections 

 

Open Data Protocol (OData) is a protocol used for coordinating with REST API’s, allowing you to access cloud data from any online database, cloud-enabled ERP or business system that your organization might use. To connect your OData source with your TEKLYNX barcode labeling software, follow these steps: 

 

  1. In the top menu bar, click on Data Source > Database > Create/Edit query 
  2. After the window pops up, you will then click on New and select OData Feed
  3. Name your connection and paste in your URL from your OData feed 
  4. Under Select the table drop down, select the table you want to drive your data from 
  5. Select the relevant fields you would like to load and click OK 
  6. Under Data sources, click and drag the information you would like on your label 

 

 

 

Cloud-Enabled Label Printing 

 

If you want to take your cloud connections one step further, consider hosting your label software in the cloud! TEKLYNX offers a cloud-enabled label printing solution where your organization can quickly deploy secure label printing anywhere in the world, without the hassle of hosting local servers. 

 

Having your labeling software hosted via cloud technology allows any print user to access a simple label printing interface while removing the burden of IT maintenance, such as server management, software upgrades, and local installations. 

 

Labeling Software with Cloud Connections 

 

LABELVIEW and CODESOFT have the ability to connect to the cloud, making it easy to store your labels on Google Drive or OneDrive, or pull variable data from Google Sheets or Excel Online onto your label.  

 

Download a free 30-day trial today of LABELVIEW or CODESOFT to see the cloud connection features in action!

 

DOWNLOAD FREE TRIAL

 

 

About Travis

 

Travis Wayne is the Product Manager at TEKLYNX. Travis applies his 20+ years of IT and health sciences experience to empower businesses to streamline operations and barcode better by applying software and technology. He works to continually improve TEKLYNX strategic planning, product and project management principles, and cross-functional communications. When not working, he enjoys many outdoor activities with his wife and two children. 

 

Subscribe to The Human Readable blog

 

SUBSCRIBE

 

Share this post with your network:

Related Blog Posts

Top Trends in Enterprise Labeling for 2021

BY: NICK RECHT / DATE: 08/06/2021 / TOPICS: MANUFACTURING, ENTERPRISE LABEL MANAGEMENT, LABEL TRACEABILITY, PRINT AUTOMATION, CLOUD LABELING

 

Embracing innovation through cloud-hosted technologies, being agile enough for disaster recovery and business continuity, and speed of transformation through establishing simple integrations are among the top trends we’re seeing in enterprise labeling for 2021, as well as the continuing need to meet ever-evolving labeling regulations this year and beyond.

READ MORE

How to Print Labels in a (Mostly) Remote World

BY: TRAVIS WAYNE / DATE: 22/01/2021 / TOPICS: ENTERPRISE LABEL MANAGEMENT, LABEL TRACEABILITY, PRINT AUTOMATION

 

With the right tools and configurations, printing labels from your home office to the factory floor is easy.

READ MORE

Best Barcode Labeling Software for 2021: TEKLYNX 2021 Products

BY: TRAVIS WAYNE / DATE: 25/05/2021 / TOPICS: MANUFACTURING, LABEL DESIGN

 

In 2021, companies are seeking better connectivity more than ever before. The world-changing year of 2020 is over, and businesses around the globe are using the lessons they learned to implement better systems and forge stronger connections throughout the supply chain. 

 

The best barcode labeling software for 2021 equips manufacturers to build better connections between people, systems, and organizations.

READ MORE

What do you think? Leave us a comment.

Comments will be reviewed and are subject to TEKLYNX’ comment policy. Your email address will not be published publicly.

 

Required field
Required field Not valid
Required field
There was an error adding your comment. Please try again.
Required field

Add Comment
You have successfully submitted a comment. Your comment will be published after review. You will be notified by email when your comment is published. If you have any questions in the meantime, please contact TEKLYNX in your region.