====== Reaper CSV Import ======
~~HEADLINE NUMBERING FIRST LEVEL = 3~~

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.avosupport.de/downloads/icke_siegen/ReaperReader. See below (end of this document).

<fs large>**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).**</fs>

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 [[external:software_list|Reaper]] it is much easier to define exact timestamps (called Markers in Reaper).

===== The quick version =====

  - in Reaper, set the timeline to be displayed in HH:MM:SS:FF
  - load the track and create your markers as needed
  - open Region/Marker Manager
  - right-click in Region/Marker manager, Export Project Regions/Markers, save as csv
  - open the Reaper CSV Import website
  - 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 [[external:smpte_timecode|]], you can play it with [[external:winamp|]] (in that case adjust the frame numbers in Reaper), or use any other DAW or video player.

===== The long version =====

==== - 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''

{{:external:reaper_1_sm.png?300|}}

==== - 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.

==== - Open the Regions/Marker Manager ====
Either from the View menu or with ''Ctrl'' ''Alt'' ''Shift'' ''R''

{{:external:reaper_2.png?100|}}                {{:external:reaper_3.png?350|}}

==== - 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.

{{:external:reaper_4.png?350|}}

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

{{:external:reaper_5.png?300|}}

==== - Open Reaper CSV Import ====

Find it at https://owaits.github.io/avolites-reaperImport/

==== - Connect, Select, Import ====

  - connect to your console. Here I hae the Titan Simulator running on the same machine that's why 'localhost' is okay \\ {{:external:reaper_6.png|}}
  - choose and load the file you have just exported \\ {{:external:reaper_7.png|}}
  - now the bottom of the page shows the cues and timestamps found in the file: \\ {{:external:reaper_8.png?300|}}
  - select the cuelist you want to set the timestamps and click ''Import'' \\ {{:external:reaper_9.png|}}

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.

{{:external:reaper_10.png|}}

===== 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.avosupport.de/downloads/icke_siegen/ReaperReader/. You can also download it here: {{ :external:reaperreader.zip |}}. Simply download, unzip, and load this in your browser.

<fs large>**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).**</fs>