revolutionSCREEN · Knowledge base

CSV Data

With the «CSV Data» app you display external data from a CSV file on the screen, as a clear table or as a chart.

Purpose

Ideal for dashboards, statistics and other data sources that change frequently, e.g. measured values, production figures or energy data. The file stays with you, and the screen always shows the current state.

Requirements

  • An active revolutionSCREEN account with access to my.rstv.app.
  • A CSV file accessible via a URL.
  • At least one configured screen.

Install the app

In the sidebar on the left click «Apps» and at the top «zum App-Store» (to the app store).

Scroll to the «Alle» (all) list and click the «CSV Data» tile. Use the category buttons to narrow down the list.

The app's detail view opens. If it is not yet installed, first click «Installiere» (install). Then click «Neue Instanz» (new instance). «App Guide» opens a quick guide.

ⓘ
What is an instance?

An instance is its own configuration of the app, e.g. one gallery for the reception and another for the canteen. You can create as many instances as you like and use each one individually on screens, in playlists or layouts.

Create a new instance

Under «Apps › Meine Apps» (my apps) you see all instances of the app as tiles. Use «Neue Instanz» (new instance) at the top right to create another one, and click a tile to open an existing one.

In the editor, move your mouse over the title and click the pencil to give the instance a name. A new instance shows «Kein Name angegeben» (no name given) in red until then. At the top right you choose whether the preview appears in portrait or landscape format.

Configuration in detail

All settings are on the left, and on the right you immediately see in the live preview how the instance looks on the screen. Use the arrow next to the card to collapse the settings.

Further down in the card follow the toggles for first row, header and zero values.

  • CSV URL: the address of the CSV file.
  • Logo: choose your own logo via «Bilder» (images).
  • Layout: «Default» (table) or «Charts» (chart).
  • Chart type: for «Charts»: «Bars», «Line», «Bars (Full Width)» or «Line (Full Width)».
  • Columns: which columns are used for label and value. Example: 1:2 means that column 1 contains the label and column 2 contains the value.
  • Primary / Secondary font: fonts for title and values. You upload your own fonts under «Konto-Einstellungen» → «Marken» (brands).
  • Separator: the file's separator: «Comma (,)», «Semicolon (;)», «Tab (\t)» or «Pipe (|)».
  • Rows: number of rows to display.
  • Title: heading above the data.
  • Text color / Background color: colors for text and background. Use × to reset a color.
  • Background image: optional image via «Bilder» (images).
  • Show first row: shows or hides the first row.
  • Show header: shows or hides the CSV header.
  • Show zero values: displays values of 0 in the chart or in the table.
ⓘ
Make the background image visible

Reduce the opacity of the background color to 80 percent or less, then the background image shows through.

Save & play out on the screen

Save the instance at the top right with «Speichern & Schliessen» (save & close).

Add to a playlist: Open the playlist, select the «Apps» tab on the right, click the app and then the instance. The instance is added immediately.

Add to a layout: Open the layout and click the pencil on the desired section.

In the «Inhalt für Abschnitt bearbeiten» (edit content for section) window you add the instance with «Inhalt hinzufügen» (add content). On the right of each element you set the schedule via «Täglich» (daily).

Then click «Veröffentlichen» (publish) in the playlist or layout. As long as it shows «Entwurf, Veröffentlichung erforderlich» (draft, publishing required), the screen still shows the old state.

Tips & troubleshooting

No data

Check whether the «CSV URL» points directly to the file and is publicly accessible.

Values are in a single column

Choose the «Separator» that matches the file, e.g. «Semicolon (;)».

Wrong label

Under «Columns» specify the correct columns for label and value.

Content does not appear

Check whether the playlist or layout is published and assigned to the correct screen and that the Player is online.

Open in the interactive HelpDesk ›