User Tools

Site Tools


external:reaper_csv_import

This is an old revision of the document!


Reaper CSV Import

Idea and Implementation by Oliver Waits. Available on GitHub at https://github.com/owaits/avolites-reaperImport.

Another port - just a plain HTML/Javascript page - is available at https://www.avolites.de/downloads/icke_siegen/ReaperReader. See below (end of this document).

Due to modern browsers' security settings the results may vary. The safest bet is to load the alternate port locally (save the page locally and open it from there).

Defining and adjusting the correct Timecode timestamps in Titan can be an arduous work, with lots of trial and error. This is where Reaper CSV Import comes into play: within Reaper it is much easier to define exact timestamps (called Markers in Reaper).

The quick version

  1. in Reaper, set the timeline to be displayed in HH:MM:SS:FF
  2. load the track and create your markers as needed
  3. open Region/Marker Manager
  4. right-click in Region/Marker manager, Export Project Regions/Markers, save as csv
  5. open the Reaper CSV Import website
  6. connect to your Titan console or PC suite which at least has an empty cuelist, load the exported csv file, select the cuelist and click Import.

This way your cuelist has magically learned the markers you created in Reaper - you can then play the track from Reaper (with SMPTE Timecode, you can play it with Winamp (in that case adjust the frame numbers in Reaper), or use any other DAW or video player.

The long version

1. Set timeline format

Titan expects timestamps with four nibbles: hh:mm:ss:ff (for: hours, minutes, seconds, frames). Hence, the csv file needs to contain the correct format as well, and settng Reaper correctly is the easiest way to do this. Right-click in the Timeline area, and from the conext menu select Hours:Minutes:Seconds:Frames

2. Create Markers

With your track loaded, edited as needed, maybe timecode added, create your markers. The easiest way is to use the keyboard: the spacebar plays/pauses, and the M key inserts a marker at the current time. Later, holding the Ctrl key, you can easily click and move markers to adjust.

3. Open the Regions/Marker Manager

Either from the View menu or with Ctrl Alt Shift R

4. Export Markers as csv

Inside the Regions/Marker Manager you can further tweak your markers, give them names etc. Finally, right-click, from the menu select Export regions/markers…, and save it as csv to a suitable folder.

If you want you can open the file in a text editor and have a look:

5. Open Reaper CSV Import

6. Connect, Select, Import

  1. connect to your console. Here I hae the Titan Simulator running on the same machine that's why 'localhost' is okay
  2. choose and load the file you have just exported
  3. now the bottom of the page shows the cues and timestamps found in the file:
  4. select the cuelist you want to set the timestamps and click Import

This will result in your cuelist being updated with the correct legends and timestamps. If there are more cues in the csv file than in the Titan show then new cues will be appended.

Another port

Based on Olie's idea and some of is code I implemented the same thing as one single HTML/JavaScript file. This is online available at https://www.avolites.de/downloads/icke_siegen/ReaperReader/. You can also download it here: reaperreader.zip. Simply download, unzip, and load this in you browser.

external/reaper_csv_import.1588602581.txt.gz · Last modified: 2020/05/04 16:29 by icke_siegen