Venus Control Suite Data Studio: How do I integrate with an online spreadsheet or calendar on a Venus cloud hosted system?
Topic
This article outlines how to integrate an Online Spreadsheet or Calendar data source within Data Studio on a Venus Control Suite cloud-hosted system. It includes connecting to Microsoft Excel (OneDrive) or Google Sheets using secure authentication (OAuth), and configuring the data source for use in content and data-driven displays.
Environment
- Product Family: Venus Professional, Venus Enterprise, Venus Live
- Product: Data Studio
- Component: Online Spreadsheet Data Source, Calendar Data Source
- Control System: Venus Control Suite (Cloud Hosted)
Local Venus Systems refer to: Venus Control Suite Data Studio: How do I use Excel as a data source on a local server?
Using Online Spreadsheets in Data Studio
Both Google Sheets and Microsoft Excel (OneDrive) can be used as data sources in Data Studio. The primary differences relate to autosave behavior and how updates are applied.
Google Sheets
-
- Automatically saves changes as they are made
- Autosave cannot be turned off
- Data Studio updates based on the configured refresh interval (not every cell change)
Considerations:
-
- Faster refresh rates may result in more frequent visible updates
- If editing while content is live, incremental updates may appear on screen
- Using a slower refresh interval can help prevent partial updates during editing
Excel (Stored in OneDrive)
-
- Allows Autosave to be turned ON or OFF
With Autosave ON:
-
- Behaves similarly to Google Sheets with continuous updates
With Autosave OFF:
-
- Changes can be made and saved manually in a single update
- Provides more control over when updates appear in Data Studio
Additional Notes
- Data Studio updates based on the configured refresh interval
- Default and minimum refresh rates vary by subscription level
- Shorter refresh intervals increase how frequently updates appear
Steps
🔽Use the arrows to expand and collapse each section.
Create the Data Source
If needed, first create your data:
Microsoft OneDrive - Adding a source and configuration
Upload Your File to OneDrive
- Go to the OneDrive website, sign in with your Microsoft account
- Navigate to the desired location where you want to add the files
- Select Upload
- Choose your file and click Open
Grant Access
Add an Online Spreadsheet in Data Studio- Log into Venus Control Suite and open Data Studio > Data Sources page
- Select Add New → Online Spreadsheet from the options
- Choose your Provider (Microsoft) from the dropdown
- Click Login
- Enter your credentials for Microsoft
- New user/logins will ask for the email address & password
- Complete multi-factor authentication if prompted
- Click Add Data Source
- Under Source Configuration, set:
- Source Name
- Refresh Interval
- Under Files, select your file from your Cloud Storage
- Only valid data sources will be shown
- Select the desired data items
- (Optional) Configure Feeds
- Click Save
Google Sheets - Adding a source and configuration
Upload Your File to Google Drive
- Log into your Google account and open Google Drive [https://drive.google.com]
- Upload your file
- Move the file to the desired location in your Google Drive account
- Log into Venus Control Suite and open Data Studio > Data Sources page
- Select Add New → Online Spreadsheet from the options
- Choose your Provider (Google) from the dropdown
- Click Login
- Enter your credentials for Google
- New user/logins will ask for the email address & password
- Complete multi-factor authentication if prompted
- Click Add Data Source
- Under Source Configuration, set:
- Source Name
- Refresh Interval
- Under Files, select your file from your Cloud Storage
- Only valid data sources will be shown
- Select the desired data items
- (Optional) Configure Feeds
- Click Save
Calendar - Adding a source and configuration
- Log into Venus Control Suite and open Data Studio > Data Sources page
- Select Add New → Calendar Source from the options
- Choose your Provider from the dropdown
- Click Login
- Enter your credentials for Google
- New user/logins will ask for the email address & password
- Complete multi-factor authentication if prompted
- Choose Browse Calendars
- Select the desired calendar(s)
- Select the desired data items
- (Optional) Configure Feeds
- Click Save
KB ID: 000027728
DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.
DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.
The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.