Dynamic subtitles (SRT) from CSV data

Viewing 1 reply thread
  • Author
    Posts
    • #90815
      Avatarpeterh337
      Member

      Hi All,

      This is for a flying movie (I am a private pilot – see https://vimeo.com/user8026275/videos) whereby I get a GPS-generated data file containing fields like latitude, longitude, altitude, etc.

      It would be great to superimpose these onto the movie.

      I am roughly aware of the SRT method (and as a programmer i can see one could write a C program to generate the Matroska SRT format, from CSV data) but can anyone here offer specific tips for Vegas Pro 13, or even suggest a program which can do such a conversion?

      I am also aware Handbrake (which I use a lot) can import an SRT file, but I would prefer to avoid an intermediate rendering step.

      Example CSV data:

      15/07/2016 13:44:45 1321
      15/07/2016 13:44:47 1319
      15/07/2016 13:44:49 1325
      15/07/2016 13:44:51 1338
      15/07/2016 13:44:53 1356
      15/07/2016 13:44:55 1373
      15/07/2016 13:44:57 1389
      15/07/2016 13:44:59 1400
      15/07/2016 13:45:01 1398
      15/07/2016 13:45:03 1381
      15/07/2016 13:45:05 1358
      15/07/2016 13:45:07 1334
      15/07/2016 13:45:09 1309
      15/07/2016 13:45:11 1284
      15/07/2016 13:45:13 1259
      15/07/2016 13:45:15 1233
      15/07/2016 13:45:17 1207
      15/07/2016 13:45:19 1179
      15/07/2016 13:45:21 1150
      15/07/2016 13:45:23 1121

      the 3rd column is the altitude of the aircraft. The date can be stripped. The time needs to be used to “locate” the subtitle correctly onto the video. The single altitude value needs to be displayed somewhere in the corner…

      I can use Excel to get closer to SRT e.g.

      1 13:20:46 13:20:50 50.83883 -0.29529 -2
      2 13:20:50 13:20:54 50.83798 -0.29582 -3
      3 13:20:54 13:20:57 50.83692 -0.29648 -2
      4 13:20:57 13:21:00 50.83604 -0.29700 11
      5 13:21:00 13:21:04 50.83516 -0.29749 46
      6 13:21:04 13:21:07 50.83404 -0.29815 138
      7 13:21:07 13:21:10 50.83320 -0.29865 205
      8 13:21:10 13:21:13 50.83237 -0.29921 257
      9 13:21:13 13:21:16 50.83155 -0.29986 302
      10 13:21:16 13:21:19 50.83077 -0.30068 346
      11 13:21:19 13:21:22 50.83005 -0.30164 386
      12 13:21:22 13:21:25 50.82933 -0.30266 422
      13 13:21:25 13:21:28 50.82859 -0.30369 453
      14 13:21:28 13:21:31 50.82783 -0.30475 477
      15 13:21:31 13:21:34 50.82703 -0.30585 503
      16 13:21:34 13:21:37 50.82620 -0.30694 538
      17 13:21:37 13:21:40 50.82531 -0.30798 573
      18 13:21:40 13:21:43 50.82439 -0.30902 614
      19 13:21:43 13:21:46 50.82347 -0.31008 656
      20 13:21:46 13:21:49 50.82253 -0.31116 697
      21 13:21:49 13:21:52 50.82158 -0.31226 737
      22 13:21:52 13:21:55 50.82064 -0.31342 772

      where you can see the two time columns are near to what is needed i.e. start and end of each subtitle. However I can’t see a way in Excel of generating the milliseconds part e.g. 13:21:52,000. Well one could put the “000” into an adjacent column and then process the CSV file with SED and strip out the comma, but that is just tacky πŸ™‚

      I have tried this
      https://sites.google.com/site/tsdarkness/batchsubtitlesconverter
      but cannot get it to do anything useful with my CSV data.

      There is this
      http://vegasaur.com/text-generation-wizard
      which (near the bottom of the page) says it can do CSV to SRT… I am looking at that plug-in anyway because it offers one of the very few ways of generating a time code field, like the Sony Timecode but with better config options for the location of the text (the internet is full of people looking for a better Vegas timecode plug-in).

      I have no current use for the lat/long columns but in the future will try to generate an inset moving map from them! I can see one workflow for that but it’s fairly complicated – it involves feeding the GPS track to a moving map app, capturing the screen into images, and combining these into a movie which is dropped onto the timeline.

    • #214261
      AvatarRWS
      Participant

      Not sure what you’re asking..but I use SRT Edit Pro to add and create SRT files.
      Is that what you mean? Works easy.. I think they even have a YouTube video where they help you out with how to work it.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Best Products

homicide-bootstrap