Review and transcode system

We use dedicated conference reviewing software with web front-ends to review videos after they are recorded. These allow end users to log in and review the videos online. Typically the review software also manage transcoding the video files to the desired publishing format and quality. The two systems we recommend (veyepar and SReview) handle transcoding. Their respective documentations are linked here:

veyepar setup
SReview setup – note that SReview is packaged in Debian

Since it is a bit complicated to set up, if you are planning a Debian event, Contact us and we might be able to set it up for you.

Adding an Apology note to a video in SReview

Sometimes, a video will have a technical flaw important enough that an Apology note (a slide at the beginning of the video) should be added to warn people.

This has to be done manually in the SReview database:

Log into vittoria.debian.org via SSH, where SReview is running
Connect to the sreview PostgreSQL database:
```
sudo -u sreview bash
psql sreview
```
List all the different conferences in the database to find the event number:
```
select * from events;
```
List all the talks marked as broken for said event, as you will need their slug and id variables:
```
select * from talks where state='broken' and event='EVENT_NUMBER';
```

Add an apologynote to the talks that require one and send them back into the cutting cue for them to be reviewed.

Make sure to run your SQL commands as transactions (delimited by BEGIN; and COMMIT; statements):

BEGIN;
update talks set apologynote='SOME PROBLEM' where slug like '%SLUG%' and event='EVENT_NUMBER' and id='ID';
update talks set state='cutting', progress='waiting' where id='ID';
COMMIT;

You can either repeat step #5 as needed or bundle all your changes in the same transaction.