About: LTN Schedule automatically generates "as-run" reports on for each day. The reports can be used to analyze which media assets have been scheduled and broadcasted. Reports are saved as semicolon separated CSVs and can be accessed using the SFTP credentials to your LTN Schedule system.
Access reports
To access reports, sign into the SFTP server of your LTN Schedule system.
Reports are saved in:
/DATA/reports
Daily reports are named:
2021-12-07report.csv
YYYY-MM-DDreport.csv
At the end of a month, all daily reports are merged into a ZIP file:
2022-04-MERGED-report.csv.zip
YYYY-MM-MERGED-report.csv.zip
Reports contain the following information:
- Start date and time (YYYY-MM-DD 0 HH:MM:SS UTC Timezone)
- End date and time (YYYY-MM-DD 0 HH:MM:SS UTC Timezone)
- Main playlist element name
- Sub-playlist element name
- Duration in milliseconds
- Custom fields (-1 = no custom fields attached)
- Viewer count
For example:
2021-12-07 - 00:54:58;2021-12-07 - 00:55:58;AD: Commercial-A;;60000;-1;0
2021-12-07 - 00:55:58;2021-12-07 - 01:54:48;Recording of LIVE: The Opening 12/03/2021 (trimmed) - w/ads (=2m);;10547000;-1;0
2021-12-07 - 01:54:48;2021-12-07 - 01:55:48;Opener;2m.COMMERCIALS;60093;-1;0
2021-12-07 - 01:55:48;2021-12-07 - 01:56:48;Opener;Highlights;59993;-1;0