The Rivendell Library Structure and RDLibrary

The RDLibrary module allows the adding, managing, and removal of audio from the Rivendell system. It consists of a set of objects called carts which can either contain Audio, or Macro commands.

Carts

A cart is a data container that holds either one or more pieces of audio (called an audio cart), or macro commands to the system (called a macro cart). The cart is the fundamental schedule building block in Rivendell, in that it is the smallest object or 'atom' that the outside world (like a traffic or music scheduler) can see.

RDLibrary, upon startup, will show the current list of all carts on the system, as shown below:

A number of important attributes of carts can be seen from this illustration. First is the cart's number. Each cart in the Library gets assigned a unique number when it is created. This number can range between 000001 and 999999, and is the primary 'handle' by which both Rivendell and external systems (like traffic or music schedulers) refer to the cart. Very often, sites have specific rules concerning which types of audio (commercials, promos, music, etc) and macros get assigned which numbers. We'll cover this area in some detail when we discuss groups.

Immediately to the left of the cart number is an icon indicating the type of cart. Just to the right of the cart number is the average length of the cart. Except in the case of where time-scaling is in use (in which case it will be indicated in blue numerals), this value is calculated automatically by the system.

Audio Carts

Next comes various columns showing information from the cart label – Title, Artist, Client and Agency data, etc.

Cart Edit Screen

The cart information can be edited by opening RDLibrary's Edit Cart dialog (shown below), either by double-clicking on the desired cart entry in the list, or by touching the desired cart entry and then touching the Edit button. In either case, you should get a dialog similar to that shown below.

This is how an audio cart looks when loaded into the Edit Cart dialog. The upper half of the dialog is the cart label data. The meaning of most of these fields should be fairly self-evident, but a few call for special comment:

  • Enforce Length – When checked, this indicates that time-scaling should be applied to this cart when it is played in RDAirPlay, meaning that the cart will air at the length indicated by the Forced Length field, rather than the native length of the audio. Care is needed when implementing time-scaling within a facility, as there are limits to how much the length can be altered, while only certain types of audio adapters support it at all. See the Rivendell Technical Guide for more information.
  • Group – This is a pull down menu by which the group ownership for the cart can be set. The system administrator configures the list of available groups for each user in RDAdmin.
  • User Defined – As the name implies, this field has no dedicated meaning to Rivendell itself, but is provided for each site to use as is seen fit.

The example shown above shows an audio cart. As such, the bottom half of the dialog displays the lists of cuts contained within the cart.

Cuts

Each audio cart can contain one or more cuts. A Rivendell cut is an actual piece of audio, somewhat analogous to a 'track' on a CD. Up to 999 such cuts can exist within a single cart. Each line in the cut list contains information about the cut, including:

  • Description – An arbitrary name, assignable by the user as an aid in keeping track of the content, it is roughly analogous to the 'Title' field in the cart label.
  • Length – The actual, measured play out length of the cut audio. This field is set automatically by the system.
  • Last Played – The last date and time that the cut was aired by the RDAirPlay module. Useful for keeping track of stale inventory.
  • # Of Plays – The total number of times the cut has been aired by the RDAirPlay module.
  • Origin – The name of the host upon which the audio in the cut was last recorded, along with the date and time.
  • Outcue – A user settable field. This line shows up in the RDAirPlay log when the cut is played.

Multiple Cuts in a Cart

What happens when more than one cut is placed into a cart? The answer, in a word, is rotation. Rotation is the ability to schedule a single cart in a log, but to have that cart play out different material at different times. This capability has a myriad of uses. One of the simplest, common in commercial radio facilities, is to allow multiple versions of a spot to be placed into the system, while still allowing the traffic department to have to track and schedule only one cart number. A more sophisticated use involves use of the cut's dayparting settings, forcing different cuts to play based upon certain date/time criteria, such as day of the week or time of day. Cut dayparting is a very powerful feature in Rivendell, and is something we will discuss shortly.

Cut Edit Screen

To edit the properties of a cut, either double-click its entry in the cut list, or touch it once to highlight and then touch the Cut Info/Record button. The Record Dialog (shown below) will now open up.

Roughly the upper third of the dialog is for editing the various cut parameters, the middle section is for configuring the cut's daypart settings, and the bottom third is a record machine that can be used both to record new audio into the system and to audition any recording already made.

Cut Dayparting

Each cut in Rivendell can be day-parted on the basis of three parameters:

  • Absolute Start and End Date-Time
  • Relative Start and End Time
  • Day of the Week

By default, each newly created cut starts out with dayparting disabled, meaning that it will be 'eligible to play' at all times. By clicking the Enabled button in the Air Date/Time box, an absolute start and end date for the cut can be entered, meaning that the cut will be prevented from airing in the RDAirPlay module at any time outside the range of those datetimes. Likewise, by selecting the Enabled button in the Daypart box, start and end times (relative to the day the cut is to air) can be entered. Cuts designated in this way will be allowed to air only within the specified range of times. Finally, by selecting or clearing the appropriate boxes in the Day of the Week box, a cut can be designed to air only on certain days of the week.

All of the dayparting parameters can be used either singly or in combination with each other. When combined, the resulting 'eligibility' is calculated as the logical AND of the applied dayparting limits. For example, a cut with the 'Monday' box cleared will refuse to air on Mondays, regardless of whether any of the other daypart rules match.

It's important to remember that dayparting rules affect audio play out only within the RDAirPlay module. You will still be able to audition and play the audio without limitation in the other Rivendell modules.

Cart and Cut Colour Coding

Each cart or cut in RDLibrary is assigned a color to indicate it's 'playability' for air, as follows:

  • NO COLOR – Event will play normally
  • RED – Event will not play (due to dayparting or lack of audio)
  • GREEN – Event will play an Evergreen

It's important to remember that the color displayed for each event indicates playability at the instant that the event is being viewed.

Recording and Auditioning a Cut in the Record Dialog

The lower third of the Record Dialog is used both to audition and record audio. To audition the cut, simply press the play button (the one with the triangular symbol). The button should illuminate, audio should show on the bar meter and start playing immediately. The audio will play to completion, unless either the stop button (square symbol) is pressed, or the Record Dialog is closed.

To record new material into a cut, first ensure that the Channels dropdown menu is set to record the appropriate number of channels, then touch the record button (round symbol). If the cut contains audio that was recorded previously, a warning box will pop up at this point to inform you of this and to give you a chance to abort the recording without erasing what was previously recorded. If Yes is selected here, the previous recording will be overwritten and no longer accessible. The record button should now be illuminated steadily, while the play button will be flashing, indicating that the record machine is in 'ready' mode. The bar meter will also be active to indicate input levels, and this is the point where you want to verify that your levels are correct, with peaks just into the yellow area being optimal. Nothing is actually being recorded just yet.

We have two options for actually starting the record machine. We can start it manually by pressing the play button, at which point the machine will immediately begin recording, or we can set the Record Mode dropdown menu to the VOX (short for voice activated) setting. When in VOX mode, the record machine will start automatically as soon as it senses the presence of audio at the input.

Once started, recording will continue until either the stop button is pushed, or the maximum allowed length for a manual recording (set by the system administrator) has been reached. Once stopped, if the AutoTrim dropdown menu has been set to On, the Start and End markers will be automatically set to the beginning and end of detected audio within the cut. (We will discuss Markers in detail when we get to the section on the Edit Markers dialog).

Alternative Methods of Audio Ingestion

In addition to manually recording material in realtime, RDLibrary supports two alternative methods for audio ingestion:

Importing Audio from a file

To import audio from a file directly into a cut, we start by opening the cut's parent cart in the Edit Cart Dialog. Next, touch the cut's entry in the cut list and then touch the Import/Export button to open the Import/Export Audio Dialog (shown below).

Select the file you wish to import, either by entering the path and filename to it in the Filename field or by clicking the Select button to open a file browsing dialog. Rivendell is capable of importing the following types of audio files:

  • Microsoft WAV (*.wav) – Both PCM16 and MPEG supported
  • MPEG (*.mp1, *.mp2, *.mp3)
  • OggVorbis (*.ogg)
  • Free Lossless Audio Codec [FLAC] (*.flac)

Next, set the Channels dropdown menu to the appropriate number of channels. You may also wish to adjust the Normalize or Autotrim controls, although these will normally be set to reasonable default values by the system administrator and should seldom have to be altered.

If Normalize is selected, then the imported audio will be peak normalized to the level indicated. The Autotrim does the same thing as in the Record Dialog (see section 2.0.1.2, 'Recording and Auditioning a Cut in the Record Dialog' above for details).

Finally, touch the Import button. A progress bar will indicate percentage completion of the import, followed by a popup box to announce completion. The Import Audio Dialog will automatically close after acknowledging completion. The audio is now imported, and can now be auditioned and otherwise processed in the usual way.

Ripping Audio from a CD Track

To rip audio directly off of a CD into a cut, we again start by opening the cut's parent cart in the Edit Cart Dialog. Next, select the cut's by touching the cut's entry in the cut list, and then touch the Rip CD button to open the Rip CD Dialog (shown below).

Load a CD into the CD drive. After a few seconds, list of tracks should appear in the Tracks area. If the system administrator has enabled the FreeDB CD Lookup Service, the names of the various tracks may appear as well.

Set the Channels, Normalize and Autotrim controls appropriately (for more details see Normalize and Autotrim controls). Next, touch the track you wish to rip and then press the Rip Track button. The track will now be ripped into the cut, with a progress bar keeping you informed of progress. When the rip is complete, a message box will pop up to inform you of this.

If FreeDB data was found for the CD, you can have the FreeDB track, artist and album names be automatically placed on the cart label for the cart by checking Apply FreeDB Values to Cart before closing the Dialog.

Ripping Multiple CD Tracks at a Time

Sometimes, when transferring multiple audio tracks from CD, it's more convenient to be able to set up the entire transfer at once and then let the rip run in a 'batch' mode. RDLibrary is capable of ripping audio in this manner as well. To do this, click the Rip CD button near the bottom of the main RDLibrary screen, bringing up the Rip Disk Dialog (shown below).

This dialog is similar in many ways to the Rip CD Dialog described above, except that each track can be assigned to transfer to a different cut by double clicking on its listing, or by touching the listing and then the Set Cart/Cut button, bringing up the Select Cut Dialog (shown below).

The destination cut is selected by first choosing the cart from the lefthand pane, followed by the desired cut within that cart on the righthand pane. The complete set of library filtering tools are available to you here – see Navigating the Audio Library for details on their function, just as in the main RDLibrary screen.

Once all of the desired tracks have been assigned to cuts, be sure that the Normalize, Autotrim, Channels and Apply FreeDB Values to Carts controls have been set as desired, then click the Rip Disc button. A set of progress bars will keep you informed of the progress of each track, as well as overall progress. When, the rip is finished, a message box will let you know.

Macro Carts

A macro cart is a cart that contains one or more commands written in Rivendell Macro Language (or 'RML' for short). The Edit Cart dialog for a macro cart is similar in many ways to that for an audio cart with the exception of the lower half, which contains a list of RML commands to be executed rather than a list of cuts (shown below). (For a complete description of RML, including a breakdown of available commands, see Rivendell Markup Language).

To add a new line of RML, select the desired location in the list and touch the Add button. Similarly, a line can be deleted by selecting it and then touching the Delete button, or modified by touching the Edit button. The RML can be tested, either line-by-line or as a whole by touching the Run Line or Run Cart button respectively. It is also possible to Copy and Paste individual lines both within a given cart or between carts.

Navigating the Audio Library

The uppermost section of RDLibrary's main window contains tools designed to allow for fast searching of the entire audio library, making locating a particular piece of audio easy even in a library containing thousands of carts. It's possible to control what carts are listed, as well as how they are sorted.

Changing the Cart Sort Order

The order in which carts are displayed in the cart list can be changed by simply clicking on the header of the column by which you want them sorted by. By default, the carts are sorted by Cart Number.

  • To instead sort them alphabetically by Title, simply click the TITLE header once.
  • To sort them by Title in reverse – i.e. from 'Z' to 'A' – click the TITLE header once again.
  • Clicking the TITLE header a third time restores the sort to normal 'A' to 'Z' again.

And so on for all of the columns in the cart list – it's possible to sort the Library by Artist, Length, or any other parameter shown in the cart list.

Selecting Carts by the Filter Field

Very often, one will want to find a cart or set of carts whose label(s) contains a particular word or phrase. It's possible to narrow the list of displayed carts to this set by simply entering the desired word or phrase into the Filter field at the top of the main RDLibrary screen. The full list can be restored by clearing the Filter field or by clicking the Clear button.

Selecting Carts by Group

It's possible to limit the list of carts to only those in a particular group by setting the Group dropdown menu to the desired group name.

Selecting Carts by Type

You can tell RDLibrary what type of carts to list by checking the Show Audio Carts and Show Macro Carts boxes. Clearing both boxes obviously results in no carts at all being displayed. It's also possible to combine all four of the above search and sorting methods.

Selecting and Opening Carts

Once the desired cart has been located on the cart list, load it into the Edit Cart Dialog (shown below) by either double clicking its list entry, or by touching its list entry and then touching the Edit button.

Library Maintenance

Editing Markers

Rivendell uses a system of cue points within audio cuts, referred to as markers. Markers can be used to specify a number of parameters for a piece of audio. Table One shows what markers are available, their purpose and their corresponding color.

Markers are set in the Edit Markers Dialog (shown below). To access the Dialog, open an audio cart, select the cut to open on the cut list and then touch the Edit button.

The Dialog is divided into three areas: the waveform area in the upper half, consisting of the waveform display and Amplitude and Time buttons; the transport controls area in the center, consisting of Start, Pause, Stop and Loop buttons along with an audio meter; and the marker button area in the lower third of the window, consisting of controls for selecting and positioning markers.

It's possible to 'zoom-in' on the waveform in various ways by clicking the Amplitude and Time buttons. By default, the waveform is displayed fully 'zoomed-out', thus showing the entire length of the audio cut. The GoTo buttons can be used to jump directly to the current play out cursor position, start or end of the waveform.

Audio can be played one of two ways: either by clicking on the waveform to indicate where play out should start and then clicking the left-hand Play button, causing play out to start from the selected position, or by clicking the right-hand Play button, which will cause play out to start from the Start Marker (just as it would in RDAirPlay). Clicking the Pause button while playing will cause audio to stop and the play out cursor (a thin vertical black line in the waveform area) to freeze at its current position, while pressing the Stop button will stop the audio while resetting the play out cursor to the position it was in when Play was started. Clicking the Loop button will cause the audio to play out continuously, looping from end back to start, until either the Stop, Pause, Save or Cancel buttons are clicked.

To set a marker, click on the corresponding marker button and then left-click on the waveform area to indicate where on the audio the marker should be placed. (NOTE: With the exception of the FadeUp and FadeDown markers, all markers in Rivendell are assigned in pairs. For example, placing a TalkStart marker will also cause a TalkEnd marker to be placed.) Markers that have already been placed can be moved by selecting the appropriate marker button and then dragging the marker to the desired location.

It's also possible to specify the position of a marker in the form of hh:mm:ss.s (relative to time after the Start marker) by entering the desired value next to a selected marker button. It is also possible to remove a set of markers that have already been placed, either by accessing the marker menu by doing a right-click on the waveform display, or by touching the Remove Marker button and then touch the marker button corresponding to the marker to be removed. (NOTE: the exceptions to this are the Start / End markers, which are always present and hence cannot be removed.)

As an aid for accurately setting the Start and End markers, it's possible to use the Trim Start and Trim End buttons to automatically set the markers to the first and last instances of the level specified by the Threshold field, respectively.

Marker Types

Marker Type Function Colour
Cut Start Indicates the start point of the audio, where RDAirPlay starts playing audio from. RED
Cut End Indicates the end point of the audio where will stop playing (if Segue markers have not been set). RED
Talk Start Indicates point to start the Talk Counter in RDAirPlay. BLUE
Talk Stop Indicates point to stop the Talk Counter in RDAirPlay. BLUE
Segue Start Indicates the start of the audio overlap during Segue transitions in RDAirPlay. This is the point RDAirPlay will start playing the next event. If No Fade on Segue Out is not set, RDAirPlay will start fading the audio at this point. CYAN
Segue End Indicates the end of the audio overlap during Segue transitions in RDAirPlay. This is the point RDAirPlay will finish playing the current event over the next. If No Fade on Segue Out is not set, RDAirPlay will finish fading the audio at this point (i.e. Silence). CYAN
Hook Start Indicates the start of the Hook to be played when RDPanel is in Hook Mode. Usually a short snippet of audio. FUCHSIA
Hook End Indicates the end of the Hook to be played when RDPanel is in Hook Mode. Usually a short snippet of audio. FUCHSIA
Fade Up Indicates the point at which audio should be faded up to full level after starting in RDAirPlay. YELLOW
Fade Down Indicates the point at which audio should start fading down to off before ending in RDAirPlay. (Note: The end point of the Fade Down will be the Clip End marker) YELLOW

Copying and Pasting Audio from Cut to Cut

It's possible to make copies of existing an audio cut on the system by opening up the cut's parent cart in the Edit Cart Dialog, selecting it on the cut list and clicking the Copy button. To paste the copied audio, simply select the desired destination cut (within the same cart or a different one) and press Paste.

Generating Library Reports

Various Library reports can be generated by touching the Reports button on the main RDLibrary screen and then selecting the desired report and touching the Generate button. The following reports are available:

The Cart Report

The cart report consists of a list of all selected carts on the system, with their attributes.

Example

                                                        Rivendell Cart Report
Generated: 06/03/2017 - 19:12:32     Group: MUSIC           Filter: [none]

Type -Cart- -Group---- -Len- -Title------------------------- -Artist----------------------- Cuts Rot Enf -LenDev -Owner--------------
  A  010001 MUSIC       3:59 Set Fire to the Rain            Adele                             1 SEQ No    :00.0 [none]
  A  010002 MUSIC       2:50 Happy Birthday                  Altered Images                    1 SEQ No    :00.0 [none]
  A  010004 MUSIC       3:58 Let's Start a Band              Amy Macdonald                     1 SEQ No    :00.0 [none]
  A  010005 MUSIC       3:31 Mr Rock & Roll                  Amy Macdonald                     1 SEQ No    :00.0 [none]
  A  010006 MUSIC       3:18 Poison Prince                   Amy Macdonald                     1 SEQ No    :00.0 [none]
  A  010007 MUSIC       4:01 Youth of Today                  Amy Macdonald                     1 SEQ No    :00.0 [none]
  A  010008 MUSIC       3:57 Back to Black                   Amy Winehouse                     1 SEQ No    :00.0 [none]
  A  010009 MUSIC       3:14 Levels                          Avicii                            1 SEQ No    :00.0 [none]
  A  010010 MUSIC       3:33 Girlfriend                      Avril Lavigne                     1 SEQ No    :00.0 [none]
  A  010011 MUSIC       3:38 What the Hell                   Avril Lavigne                     1 SEQ No    :00.0 [none]
  A  010012 MUSIC       3:10 Now You're Gone (Fonzerelli rem Basshunter                        1 SEQ No    :00.0 [none]
  A  010013 MUSIC       3:28 Cinema                          Benny Benassi feat. Gary Go       1 SEQ No    :00.0 [none]
  A  010014 MUSIC       3:39 Take on Me                      a-ha                              1 SEQ No    :00.0 [none]
  A  010015 MUSIC       4:31 All I Ask                       Biblecode Sundays - All I Ask     1 SEQ No    :00.0 [none]
  A  010016 MUSIC       2:30 Bang Bang, You're Dead          Biblecode Sundays - Bang Bang,    1 SEQ No    :00.0 [none]
  A  010017 MUSIC       2:45 Better Man Than Me              Biblecode Sundays - Better Man    1 SEQ No    :00.0 [none]

[Truncated]

The Cut Report

The cut report consists of a list of all cuts contained by the selected carts on the system, with their attributes.

Example:

                                                        Rivendell Cut Report
Generated: 06/03/2017 - 19:15:10     Group: MUSIC           Filter: [none]

-Cart- Cut Wht -Cart Title-------------- -Description--- -Len- Last Play Plays Start Date End Date -Days of Week- -Daypart-----------
010001 001   1 Set Fire to the Rain      Cut 001          3:59  06/03/17    10   [none]     TFN    SuMoTuWeThFrSa [none]
010002 001   1 Happy Birthday            Cut 001          2:50  06/03/17     1   [none]     TFN    SuMoTuWeThFrSa [none]
010004 001   1 Let's Start a Band        Cut 001          3:58  06/03/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010005 001   1 Mr Rock & Roll            Cut 001          3:31  05/29/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010006 001   1 Poison Prince             Cut 001          3:18   [none]      0   [none]     TFN    SuMoTuWeThFrSa [none]
010007 001   1 Youth of Today            Cut 001          4:01  06/03/17     2   [none]     TFN    SuMoTuWeThFrSa [none]
010008 001   1 Back to Black             Cut 001          3:57  06/03/17     1   [none]     TFN    SuMoTuWeThFrSa [none]
010009 001   1 Levels                    Cut 001          3:14  05/29/17     1   [none]     TFN    SuMoTuWeThFrSa [none]
010010 001   1 Girlfriend                Cut 001          3:33  06/03/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010011 001   1 What the Hell             Cut 001          3:38  06/03/17     2   [none]     TFN    SuMoTuWeThFrSa [none]
010012 001   1 Now You're Gone (Fonzerel Cut 001          3:10  06/03/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010013 001   1 Cinema                    Cut 001          3:28  05/30/17     1   [none]     TFN    SuMoTuWeThFrSa [none]
010014 001   1 Take on Me                Cut 001          3:39  06/03/17     2   [none]     TFN    SuMoTuWeThFrSa [none]
010015 001   1 All I Ask                 Cut 001          4:31  05/29/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010016 001   1 Bang Bang, You're Dead    Cut 001          2:30  06/03/17     3   [none]     TFN    SuMoTuWeThFrSa [none]
010017 001   1 Better Man Than Me        Cut 001          2:45  06/03/17     4   [none]     TFN    SuMoTuWeThFrSa [none]

[Truncated]

The Cart Data Dump

The cart data dump reports are special type of reports that consists of either fixed-width or comma-separated data elements, one line per cut for the selected carts on the system. It is intended for use where a 'dump' of available carts in the system is desired for import into an external system (such as a music scheduling system).

There are two types, depending on the format required for the external system:

  • Fixed-Width (Where elements are separated by spaces in a set width)
  • CSV or Comma-Separated-Values (Where data is separated by a comma character)

When selecting either of the Cart Data Dump formats, you can optionally select if the field names are added to the file. This option depends on the requirements of your external system.

Either file format is able to be opened using a text editor (such as vi or Nano, or a Spreadsheet program such as Microsoft Excel, LibreOffice Calc.

Fixed Width Example

CART  |CUT|GROUP_NAME|TITLE                                                                                                                                                                                                                                                          |ARTIST                                                                                                                                                                                                                                                         |ALBUM                                                                                                                                                                                                                                                          |YEAR|ISRC        |LABEL                                                           |CLIENT                                                          |AGENCY                                                          |PUBLISHER                                                       |COMPOSER                                                        |USER_DEFINED                                                                                                                                                                                                                                                   |LENGTH   |
010001|001|MUSIC     |Set Fire to the Rain                                                                                                                                                                                                                                           |Adele                                                                                                                                                                                                                                                          |NRJ Hits 16                                                                                                                                                                                                                                                    |    |GBBKS1000348|                                                                |                                                                |                                                                |RCA                                                             |                                                                |                                                                                                                                                                                                                                                               |0:03:59.3|
010002|001|MUSIC     |Happy Birthday                                                                                                                                                                                                                                                 |Altered Images                                                                                                                                                                                                                                                 |Happy Birthday                                                                                                                                                                                                                                                 |    |USSM10030041|                                                                |                                                                |                                                                |Epic                                                            |Altered Images                                                  |                                                                                                                                                                                                                                                               |0:02:50.9|
010004|001|MUSIC     |Let's Start a Band                                                                                                                                                                                                                                             |Amy Macdonald                                                                                                                                                                                                                                                  |This Is the Life                                                                                                                                                                                                                                               |    |GBUM70700932|                                                                |                                                                |                                                                |Decca                                                           |Amy MacDonald                                                   |                                                                                                                                                                                                                                                               |0:03:58.6|
010005|001|MUSIC     |Mr Rock & Roll                                                                                                                                                                                                                                                 |Amy Macdonald                                                                                                                                                                                                                                                  |This Is the Life                                                                                                                                                                                                                                               |    |GBUM70607839|                                                                |                                                                |                                                                |Decca                                                           |Amy MacDonald                                                   |                                                                                                                                                                                                                                                               |0:03:31.2|
010006|001|MUSIC     |Poison Prince                                                                                                                                                                                                                                                  |Amy Macdonald                                                                                                                                                                                                                                                  |This Is the Life                                                                                                                                                                                                                                               |    |GBUM70700896|                                                                |                                                                |                                                                |Decca                                                           |Amy MacDonald                                                   |                                                                                                                                                                                                                                                               |0:03:18.8|
010007|001|MUSIC     |Youth of Today                                                                                                                                                                                                                                                 |Amy Macdonald                                                                                                                                                                                                                                                  |This Is the Life                                                                                                                                                                                                                                               |    |GBUM70702058|                                                                |                                                                |                                                                |Decca                                                           |Amy MacDonald                                                   |                                                                                                                                                                                                                                                               |0:04:01.9|
010008|001|MUSIC     |Back to Black                                                                                                                                                                                                                                                  |Amy Winehouse                                                                                                                                                                                                                                                  |Now That's What I Call Music! 67                                                                                                                                                                                                                               |    |GBUM70607752|                                                                |                                                                |                                                                |NOW                                                             |Joe Shawyer/Perry Chantler                                      |                                                                                                                                                                                                                                                               |0:03:57.9|
010009|001|MUSIC     |Levels                                                                                                                                                                                                                                                         |Avicii                                                                                                                                                                                                                                                         |Future Trance_ Best of 15 Years                                                                                                                                                                                                                                |    |SEUM71100962|                                                                |                                                                |                                                                |Polystar                                                        |                                                                |                                                                                                                                                                                                                                                               |0:03:14.2|
010010|001|MUSIC     |Girlfriend                                                                                                                                                                                                                                                     |Avril Lavigne                                                                                                                                                                                                                                                  |Now That's What I Call Music! 67                                                                                                                                                                                                                               |    |USRC10700019|                                                                |                                                                |                                                                |NOW                                                             |Now Music                                                       |                                                                                                                                                                                                                                                               |0:03:33.6|
010011|001|MUSIC     |What the Hell                                                                                                                                                                                                                                                  |Avril Lavigne                                                                                                                                                                                                                                                  |Now That's What I Call Music! 38                                                                                                                                                                                                                               |    |            |                                                                |                                                                |                                                                |                                                                |                                                                |                                                                                                                                                                                                                                                               |0:03:38.0|
010012|001|MUSIC     |Now You're Gone (Fonzerelli remix)                                                                                                                                                                                                                             |Basshunter                                                                                                                                                                                                                                                     |Ministry of Sound_ Clubbers Guide '08                                                                                                                                                                                                                          |    |            |                                                                |                                                                |                                                                |Ministry of Sound                                               |                                                                |                                                                                                                                                                                                                                                               |0:03:10.6|
010013|001|MUSIC     |Cinema                                                                                                                                                                                                                                                         |Benny Benassi feat. Gary Go                                                                                                                                                                                                                                    |Radio 538 Hitzone 59                                                                                                                                                                                                                                           |    |USUS11000974|                                                                |                                                                |                                                                |USM                                                             |                                                                |                                                                                                                                                                                                                                                               |0:03:28.7|
010014|001|MUSIC     |Take on Me                                                                                                                                                                                                                                                     |a-ha                                                                                                                                                                                                                                                           |Hunting High and Low                                                                                                                                                                                                                                           |    |USWB10403931|                                                                |                                                                |                                                                |Reprise Records/Warner Bros. Records                            |                                                                |                                                                                                                                                                                                                                                               |0:03:39.7|
010015|001|MUSIC     |All I Ask                                                                                                                                                                                                                                                      |Biblecode Sundays - All I Ask [Ghosts of Our Past 2006].mp3                                                                                                                                                                                                    |Ghosts of Our Past                                                                                                                                                                                                                                             |    |            |                                                                |                                                                |                                                                |                                                                |                                                                |                                                                                                                                                                                                                                                               |0:04:31.8|
010016|001|MUSIC     |Bang Bang, You're Dead                                                                                                                                                                                                                                         |Biblecode Sundays - Bang Bang, You're Dead [Ghosts of Our Past 2006].mp3                                                                                                                                                                                       |Ghosts of Our Past                                                                                                                                                                                                                                             |    |            |                                                                |                                                                |                                                                |                                                                |                                                                |                                                                                                                                                                                                                                                               |0:02:30.4|
010017|001|MUSIC     |Better Man Than Me                                             

[Truncated]

Notice how the data is aligned in the file using spaces. This approach is very human-readable, but does not permit for data that is too long for the field, as this will 'spill' over into another column. The file tends to be larger than CSV, as space characters are saved into the file.

CSV Example

CART,CUT,GROUP_NAME,TITLE,ARTIST,ALBUM,YEAR,ISRC,ISCI,LABEL,CLIENT,AGENCY,PUBLISHER,COMPOSER,CONDUCTOR,SONG_ID,USER_DEFINED,LENGTH,SCHED_CODE1
10001,1,"MUSIC","Set Fire to the Rain","Adele","NRJ Hits 16","","GBBKS1000348","","","","","RCA","","","","","3:59","MUSICSC"
10002,1,"MUSIC","Happy Birthday","Altered Images","Happy Birthday","","USSM10030041","","","","","Epic","Altered Images","","","","2:50","MUSICSC"
10004,1,"MUSIC","Let's Start a Band","Amy Macdonald","This Is the Life","","GBUM70700932","","","","","Decca","Amy MacDonald","","","","3:58","MUSICSC"
10005,1,"MUSIC","Mr Rock & Roll","Amy Macdonald","This Is the Life","","GBUM70607839","","","","","Decca","Amy MacDonald","","","","3:31","MUSICSC"
10006,1,"MUSIC","Poison Prince","Amy Macdonald","This Is the Life","","GBUM70700896","","","","","Decca","Amy MacDonald","","","","3:18","MUSICSC"
10007,1,"MUSIC","Youth of Today","Amy Macdonald","This Is the Life","","GBUM70702058","","","","","Decca","Amy MacDonald","","","","4:01","MUSICSC"
10008,1,"MUSIC","Back to Black","Amy Winehouse","Now That's What I Call Music! 67","","GBUM70607752","","","","","NOW","Joe Shawyer/Perry Chantler","","","","3:57","MUSICSC"
10009,1,"MUSIC","Levels","Avicii","Future Trance_ Best of 15 Years","","SEUM71100962","","","","","Polystar","","","","","3:14","MUSICSC"
10010,1,"MUSIC","Girlfriend","Avril Lavigne","Now That's What I Call Music! 67","","USRC10700019","","","","","NOW","Now Music","","","","3:33","MUSICSC"
10011,1,"MUSIC","What the Hell","Avril Lavigne","Now That's What I Call Music! 38","","","","","","","","","","","","3:38","MUSICSC"
10012,1,"MUSIC","Now You're Gone (Fonzerelli remix)","Basshunter","Ministry of Sound_ Clubbers Guide '08","","","","","","","Ministry of Sound","","","","","3:10","MUSICSC"
10013,1,"MUSIC","Cinema","Benny Benassi feat. Gary Go","Radio 538 Hitzone 59","","USUS11000974","","","","","USM","","","","","3:28","MUSICSC"
10014,1,"MUSIC","Take on Me","a-ha","Hunting High and Low","","USWB10403931","","","","","Reprise Records/Warner Bros. Records","","","","","3:39",""
10015,1,"MUSIC","All I Ask","Biblecode Sundays - All I Ask [Ghosts of Our Past 2006].mp3","Ghosts of Our Past","","","","","","","","","","","","4:31","MUSICSC"
10016,1,"MUSIC","Bang Bang, You're Dead","Biblecode Sundays - Bang Bang, You're Dead [Ghosts of Our Past 2006].mp3","Ghosts of Our Past","","","","","","","","","","","","2:30","MUSICSC"
10017,1,"MUSIC","Better Man Than Me","Biblecode Sundays - Better Man Than Me [Ghosts of Our Past 2006].mp3","Ghosts of Our Past","","","","","","","","","","","","2:45","MUSICSC"

[Truncated]

Notice how the data is separated by Comma characters, and text is grouped together using Quotation marks. This also allows more data to be exported to the external system.


QR Code
QR Code rog_2_10_3:rdlibrary (generated for current page)