Differences

This shows you the differences between two versions of the page.

--- subtitles [2020/09/21 23:48] – andi
+++ subtitles [2022/01/16 17:42] (current) – [Table] andi
@@ Line 5: / Line 5: @@
 {{::docs:architecture-overview-subtitles.png?600|}}
-<callout type="warning">Achtung: Der Rest dieser Seite wird ggf. nicht mehr aktiv gepflegt. Das Team hat inzwischen eigene Infrastruktur: https://wiki.c3subtitles.de</callout>
 * Sync-Skript von subtitlesStatus -> vocotoweb: https://github.com/voc/scripts/blob/master/subtitles/sync_media_recordings.py
-  * SystemD Timer auf releasing
+  * systemd Timer auf [[intern:server:releasing.c3voc.de]]
 * https://github.com/c3subtitles/subtitleStatus
   * Dashboard mit Übersicht des Transkriptionsstatus pro Konferenz und Vortrag
@@ Line 15: / Line 13: @@
   * …
   * schiebt fertige Untertitel-Dateien (SRT) per rsync auf mirror.selfnet.de
+=== CSV-Export from C3Subtitles:
+https://c3subtitles.de/media_export/2020-12-30T0:00:00.99Z
+Example:
+^ `GUID` ^ `complete` ^ `media_language` ^ `srt_language` ^ `last_changed_on_amara` ^ `revision` ^ `url` ^ `touched` ^ `amara_key` ^ `amara_language` ^ `state` ^ `amara_subtitle_url` ^
+| db11e86c-ecf8-40c0-b8d8-2f6798507146 | False | eng | en | 1-01-01T00:00:00Z | 1 | https://mirror.selfnet.de/c3subtitles/events/rc3/rc3-mcr-11546-eng-deu-Measuring_radioactivity_using_low-cost_silicon_sensors.en.srt | 2021-01-03T12:30:45Z | P4gHpqpuJJIA | en | 7 | https://amara.org/api/videos/P4gHpqpuJJIA/languages/en/subtitles/ |
+| 221560a2-7470-4e90-9190-99a2bef53238 | False | deu | de | 1-01-01T00:00:00Z | 1 | https://mirror.selfnet.de/c3subtitles/events/rc3/rc3-mcr-11574-deu-Globalisierung_Digitalisierung_und_die_Wachstumsfrage.de.srt | 2021-01-06T10:37:48Z | dSkmesksKqIe | de | 2 | https://amara.org/api/videos/dSkmesksKqIe/languages/de/subtitles/ |
+| 6beabddc-2dd6-43d2-9936-618d41d42cde | True | deu | de | 1-01-01T00:00:00Z | 5 | https://mirror.selfnet.de/c3subtitles/congress/35c3/35c3-9744-deu-eng-Inside_the_Fake_Science_Factories.de.srt | 2021-01-01T23:14:02Z | vsf2PBryeqW9 | de | 8 | https://amara.org/api/videos/vsf2PBryeqW9/languages/de/subtitles/ |
+| 7bdf7688-8620-4170-93bf-3c2adfd30030 | False | deu | de | 1-01-01T00:00:00Z | 1 | https://mirror.selfnet.de/c3subtitles/congress/36c3/36c3-10983-deu-eng-Its_alive_-_Nach_den_Protesten_gegen_die_Polizeigesetze_ist_vor_den_Protesten_gegen_die_autoritaere_Wende.de.srt | 2020-12-30T10:58:21Z | NWHl9bK0MXF8 | de | 2 | https://amara.org/api/videos/NWHl9bK0MXF8/languages/de/subtitles/ |
+| 52ce1398-fa9b-4bd3-aa9e-6a49a764ac2c | True | deu | de | 1-01-01T00:00:00Z | 7 | https://mirror.selfnet.de/c3subtitles/congress/35c3/35c3-9343-deu-eng-Court_in_the_Akten.de.srt | 2021-01-04T22:17:06Z | 3mDTDpROSDxZ | de | 8 | https://amara.org/api/videos/3mDTDpROSDxZ/languages/de/subtitles/ |
+| 1cff41a8-455e-42a6-ab08-d6cb166e7d3b | False | deu | de | 1-01-01T00:00:00Z | 1 | https://mirror.selfnet.de/c3subtitles/congress/35c3/35c3-10036-deu-eng-Mondnacht.de.srt | 2021-01-04T22:12:21Z | gAbEiRm8Mocc | de | 2 | https://amara.org/api/videos/gAbEiRm8Mocc/languages/de/subtitles/ |
+To download the raw (draft) subtitles from Amara, append use `https://amara.org/api/videos/{amara_key}/languages/{amara_lanuage}/subtitles/?format=vtt` (compare https://apidocs.amara.org/#fetch-raw-subtitles)
+==== States
+For voctoweb (media.ccc.de) only states 7, 8 and 12 are relevant. Subtitle files in all other states should be ignored.
+{{tablelayout?colwidth=""}}
+^ ID  ^ voctoweb    ^ c3subtitles                            ^ additional information                          ^
+| 1   |             | Nothing available yet                  | irrelevant should not exist                     |
+| 2   | todo        | Transcribed until                      | should exist                                    |
+| 3   |             | Transcript finished                    | might exist - still no timestamps               |
+| 4   |             | Please do not touch, work in progress  | Autotiming in process no timestamps             |
+| 5   |             | Synced until                           | rare case of syncing by hand                    |
+| 6   |             | Syncing finished                       | with timestamps, usable as draft                |
+| 7   | draft       | Quality control done until             | with timestamps, usable as draft                |
+| 8   | complete    | Job completed                          | finished, obviously with timestamps and usable  |
+| 9   |             | Unknown                                | should not exist                                |
+| 11  | todo        | Translated until                       | translation, not usable as draft                |
+| 12  | translated  | Translation is finished                | finished, obviously with timestamps and usable  |
 == Communication
-  * Web: [[https://c3subtitles.de/]]
+<callout type="warning">Achtung: Der Rest dieser Seite wird ggf. nicht mehr aktiv gepflegt. Das Team hat inzwischen eigene Infrastruktur: https://wiki.c3subtitles.de</callout>
-  * Twitter: www.twitter.com/c3subtitles
-  * Mailinglist: subtitles-angels -at- lists.selfnet.de
+   * Web: [[https://c3subtitles.de/]]
-  * Mailinglist: subtitles -at- lists.ccc.de
+* Twitter: twitter.com/c3subtitles
-  * IRC: [[irc://irc.hackint.org:9999/#subtitles|#subtitles]] auf hackint. **Requires SSL**. - but also the #voc channel
+* Mailinglist: subtitles-angels -at- lists.selfnet.de
-  * Etherpad-Domain: [[https://subtitles.pads.ccc.de]]
+* Mailinglist: subtitles -at- lists.ccc.de
-  * Jabber: c3subtitles -!-at-!- jabber.ccc.de
+* IRC: [[irc://irc.hackint.org:9999/#subtitles|#subtitles]] auf hackint. **Requires SSL**. - but also the #voc channel
-  * Videos on amara.org : [[http://www.amara.org/en/profiles/videos/c3subtitles/|c3subtitles videos on amara.org]]
+* Etherpad-Domain: [[https://subtitles.pads.ccc.de]]
-  * E-Mail: subtitles -!-at-!- c3voc.de
+* Jabber: c3subtitles -!-at-!- jabber.ccc.de
+* Videos on amara.org : [[http://www.amara.org/en/profiles/videos/c3subtitles/|c3subtitles videos on amara.org]]
+* E-Mail: subtitles -!-at-!- c3voc.de
 == What is our goal?
@@ Line 40: / Line 80: @@
   * If you are interested in what we are working on behind the scenes, just contact us!
   * Help us creating the subtitles via amara.org - you do not even have to visit the congress to do that! Everybody from at home can do that!
 == What are our current projects behind the scenes?
@@ Line 48: / Line 89: @@
   * Building a steno keyboard
   * Using an old mechanical stenographer with a micro controller to detect the pressed keys as steno input
 [[intern:subtitles|Intern]]