Differences

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

--- subtitles [2021/01/07 18:00] – andi
+++ subtitles [2021/02/20 14:54] – andi
@@ Line 15: / Line 15: @@
   * …
   * schiebt fertige Untertitel-Dateien (SRT) per rsync auf mirror.selfnet.de
 == CSV-Export from C3Subtitles:
@@ Line 21: / Line 22: @@
 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;2;https://amara.org/api/videos/P4gHpqpuJJIA/languages/en/subtitles/
-a2-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/
-beabddc-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/
-bdf7688-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/
-ce1398-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/
-cff41a8-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/
-```
-States
+^ `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.
 ^ ID ^ c3subtitles ^ additional information ^