You can use setup.csv file for definition which uploaded file should be played in which time interval. This functionality can be used for changing the displayed files over time without direct access to Slideshow’s web interface.

Location

File setup.csv can be located:

  • In ZIP archive, which can be uploaded through web interface, FTP, USB Flash drive or downloaded from internet via periodic download
  • In Google Drive or Dropbox folder, which is synchronized via periodic download
  • Directly on the USB Flash drive

If this file won’t be present in ZIP archive or on USB Flash drive, all files will be copied (the default behavior).

File format

File setup.csv is text file (UTF-8 encoded) with one command on each line. The number of commands in one file is not limited, use as many commands as you need to.

You can use comma , or semicolon ; as a separator of the parts of the command.

Commands

Each line of setup.csv file can contain one of the following commands:

  • The line starts with two slashes // or hash sign # – used for comment, this like won’t be processed, it is just a note for the author of the file.
  • The line starts with colon : – special command:
    • :VALID;date from;date to – whole setup.csv file si valid only between the two dates. Outside of this interval, no subsequent commands will be processed and no file at all will be copied. One of the dates may be empty string.
    • :DELETE;file name – deletes file in the folder where files should be copied. You can either enter the exact file name, or use the wildcard * to specify multiple files.
    • :CONFIG;file name;delete – restore XML configuration backup from the file. “
  • Other lines – definition from when until when should the file be displayed/played (provided that it will be in a playlist). The order is file name, date from, date to. One of the dates may be empty string. If date to is in the future, file will be automatically deleted at that date.

Date formats

The dates in setup.csv file can be in the one of the following formats:

  • yyyy-MM-dd (e.g. 2019-12-07)
  • yyyy-MM-dd HH:mm (e.g. 2019-12-07 13:20)
  • dd.MM.yyyy (e.g. 07.12.2019)
  • dd.MM.yyyy HH:mm (e.g. 07.12.2019 13:20)
All times are parsed in 24 hour format.

    Examples with explanation

    Valid from 1 December 2019, delete all files with .jpg extension and copy all files from ZIP / USB Flash drive:

    :VALID;2019-12-01;
    :DELETE;*.jpg

    Valid until 31 December 2019, delete file test.png, copy file banner.jpg only after 15 December 2019, copy other files at all times (until the global valid date of 31 December 2019):

    :VALID;;31.12.2019
    :DELETE;test.png
    "banner.jpg";15.12.2019;

    Valid always, files image1.jpg and image2.jpg will be coppied only in December 2019 and they will be automatically deleted on 31 December 2019 at 12:00:

    // Comment example
    image1.jpg,1.12.2019,31.12.2019 12:00
    image2.jpg,1.12.2019,31.12.2019 12:00

    Import XML configuration from file configuration.xml and replace the previous configuration of Slideshow:

    :CONFIG,configuration.xml,delete

    Sample

    Try uploading this ZIP file containing two images and setup.zip to the Slideshow app. Only one image will be extracted at any time.

    Troubleshooting

    You can check whether the file was recognized by checking the logs (Web interface – Information – Log) and looking for the line similar to this:
    02.01.20 18:43:26 DEBUG sk.mimac.slideshow.csv.FileDataParser - Detected file data file 'setup.csv'