Documentation Center

Viz Channel Branding User Guide

Version 5.0 | Published July 10, 2023 ©

Importing from Text

The Any Text import module supports any format of text file. There are two such types of text file: with a delimited field structure and with a fixed width information structure.

In a delimited field structure file, each line contains a list of values, delimited by a configured character such as a comma or tab. In a fixed width information file, each line contains a list of values, and each value is stored in a given place, such as the first to tenth characters.

Viz Channel Branding’s import facility also supports reading information from the file header lines of the imported file (delimited or fixed width (indexed)).

Before performing either of the procedures below you need to ensure that a schedule is available in the required format (Any Text) and a channel has been created.

Import Delimited Files

images/download/attachments/130556298/configuration_settingsbutton.png

  1. Open the Settings window.

  2. Select the General Settings section and set the Channel Name in Schedule.
    This procedure uses channel demo as seen in the screenshot below.

  3. Select the Mapping Settings section and set Import Type to Any Text.

  4. Set the File name pattern to match the file extension (for example *.txt).

  5. For the Any Text Import Settings section enter the delimiter being used in the Column Separator (Any Text) field (for example *).

    images/download/attachments/130556298/import_anytext-delimitered-mapping-table.png



  6. In Mapping Settings, map the Field Name and Reference fields by adding a location counter for each relevant Reference field.

    • Use the format $L(counter), where L refers to the location of the segment.

    • $L(1) maps the first value (for example, demo) in the list, $L(2) the second (for example, 20100923), $L(3) the third (for example, 1051270_23_VM_16_01_1), and so on.

      demo*20100923*1051270_23_VM_16_01_1*05:48:17:07*Le radeau LE CRASH DU VOL 29,,gg,hh*32293*MAIN demo*20100923*nextshow*00:00:10:00**0*SECONDARY

      Note: The segment counter starts at 1, hence, it is not zero-indexed.

  7. Click the Import Schedule button, select your schedule file (for example, 20100923_demo) and click Open.

    • This will import the schedule and create a new playlist.
      Note that you may not have all the secondary elements (pages) in your playlist. Check the schedule file for secondary elements, create the pages required and perform an update of your playlist.

  8. Right-click your playlist (for example, Continuous Playlist) and select Update Playlist > Full Update.

  9. Select your schedule file (for example, 20100923_demo) and click Open.

Import Delimited Files with Header Lines

  1. If a delimited file contains header lines, configure the number of header lines for the system to recognize them as such, with the setting Header lines in file under the Excel Import Settings.

  2. For fields read from the header lines, link the field’s line and location counters in the file, in the format $H(line, location), where H means header.

    Example: Map $H(1,3) for the third value in the first header line, $H(4,2) for the second value in the fourth header line, etc.

Import Fixed Width Files

images/download/attachments/130556298/configuration_settingsbutton.png

  1. Open the Settings window.

  2. Select the General Settings section and set the Channel Name in Schedule. This procedure uses channel demo as seen in the example shown below.

  3. Select the Mapping Settings section and set Import Type to Any Text

  4. Set the *File name pattern *to match the file extension (for example *.txt).

    images/download/attachments/130556298/import_fixed-width-mapping-table.png



  5. In the Mapping Settings, map the Field Name and Reference fields by adding starting and ending character indexes for each relevant Reference field. Use the format $L(start- index, end-index), where L means line.

Sample Content - Fixed Width (Indexed)

images/download/attachments/130556298/configuration_sample-content-playlist-anytext-indexed.png

Example: $L(1,2) maps the first value (for example, demo) in the list, $L(4,11) the second (for example, 20100923), $L(20,40) the third (for example, 1051270_23_VM_16_01_1), and so on.

  1. If the imported file contains header lines, configure the number of the header lines for the system to recognize them as such, with the setting Header lines in file in the Mapping Settings.

  2. For fields read from the header lines, link the field’s line counter and location indexes in the file, in the format $H(line, start-index, end-index).

    Example: Map $H(2,5,10) if the field is in the second header line’s 5th-10th characters, etc.