How to Print Labels with Cloud Data

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