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.
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 folder, which is synchronized via Google Drive 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.
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.
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.
The dates in setup.csv file can be in the one of the following formats:
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)
Examples with explanation
Valid from 1 December 2019, delete all files with .jpg extension and copy all files from ZIP / USB Flash drive:
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:
Try uploading this ZIP file containing two images and setup.zip to the Slideshow app. Only one image will be extracted at any time.
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'