Venus Control Suite Data Studio: How do I use Excel as a data source on a local server?

Topic

This article explains how to use a Microsoft Excel file as a data source in Data Studio on a local system. This workflow uses a locally stored Excel file to provide data for content and data-driven displays.

For examples of how this data can be used, refer to:

For using an online data source instead, refer to:

 

Environment

  • Product Family: Show Control System (SCS)
  • Product: Data Studio (Local Install)
  • Component: DMP-8000, Microsoft Excel Data Source
  • Control System: Show Control System (SCS) version 2.18+

 

Microsoft Excel Requirements

Steps

▶️Use the arrows to expand or collapse each section. 

Upload the Excel File to a local server
  1. Upload the Microsoft Excel worksheet to a local server
  2. Ensure the file is accessible from Data Studio
  3. Copy the file path for use during setup
Configure File Data Source and Source Details
  1. Log into Data Studio and select Data Sources from the left-side menu
  2. Click Add Data Source and select File from the dropdown
    1. Enter a Name: Add a descriptive Name. This is what will be seen in Content Studio's Dynamic Data Library dropdown.
    2. Enter the Address: Paste the file's path. 
    3. Confirm the format: The format should automatically detect as Excel.

image

Configure Feed

Screenshot 2024-06-18 161931b.png

Select Data Properties

  1. Under Feeds, click the ➕ to select data properties
  2. Check the fields you want to use
  3. Select the pencil icon to edit source details
    • Feed Name
      • Best practice: use the worksheet tab name
      • Appears as the top-level folder in Content Studio
    • Output By
      • Select Rows if your data is organized by rows
    • Include Headers
      • Recommended: Yes

Screenshot 2024-06-18 154120.png

Orientation

Define how your data is structured in relation to headers: 

Vertical Example

HeaderHeaderHeaderHeader
88888888888
888888888888
888888888888

Horizontal example

Header888888888
Header888888888
Header888888888
Header888888888
Header888888888
Headers
  • My table contains a header refers to whether the data includes a header row
  • If headers are included, selecting Yes will display them in the content editor

2023-09-22_12-58-11.jpg

 

Related Resources
Venus Control Suite Data Studio: How do I configure data trimming?

KB ID: 000020097

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.