Daktronics

Data Studio: How to use excel as a data source?

Topic

  • Use excel as a data source in Data Studio

Environment

  • Product: Data Studio (Local Install) 
  • Component: DMP-8000, Data Studio, Excel 
  • Control System:  Show Control System (SCS) version 2.18+
my apps_data studio.jpg

Microsoft Excel Worksheet Requirements: 

Steps

Upload the Microsoft Excel Worksheet to a local server.

This must be navigable from Data Studio.
Copy the path of the file for future use.

Configure File Data Source

  1. Login to Data Studio and choose Data Sources from the left side menu. 
  2. Click Add Data Source and select file from the drop down. 
    1. Add a descriptive Name. This is what will be seen in Content Studio's Dynamic Data Library dropdown.
    2. For Path, paste the file's location. 
    3. The format is Excel. This should automatically fill in once your cursor leaves the path box if it can detect the file.
image 

Configure Feed 

  1. Click Add Feed.
  2. Feed Name = Best practice is to use the worksheet tab name but can be anything. This shows up as the top-level folder in Content Studio.
  3. Worksheet Name = Worksheet (Choose tab name.)
  4. Add Item.
    • Add Range if there is a group of cells that need to be added.
    • Add Cell to add an individual cell.
    • Multiple items can be added from the same worksheet.
2023-09-22_12-43-04.jpg

Add Range
  1. Fill in the name of the item. For example, "Names" as in our example since we are selecting a list of names.
  2. Give the range of values. A1:A13, for example.

Orientation

Define the direction of the data flow in respect to the headers. 

Vertical example 

HeaderHeaderHeaderHeader
888888888888
888888888888
888888888888

Horizontal example

Header888888888
Header888888888
Header888888888
Header888888888
Header888888888

Header

My table contains a header refers to whether or not the table has a header included in the data set.
2023-09-22_12-58-11.jpg

If your table has headers, checking this box will show the header in the content editor. 
For the best editing experience, create 2 feeds.  
1st- Select the single row of headers and do no check the contains headers box. 
2nd- Select the entire table, including the headers.  

  1. Add Cell 
    1. Fill in the name
    2. Enter the value for the cell. 
  2. Save the Configured Feed.

Add any additional feeds as necessary.

  1. Save the Configured Data Source.

  2. Verify Feed. After saving the feed, there should be a paper clip icon to select to verify the feed.

  3. Refresh in Content Studio's Dynamic Data Library to see the new feed for content creation. 

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.