JeFCo

JeFCo - The Jesterware freedb Collector

Export to Text File

 JeFCo
Record Delimiter Column Delimiter Text Delimiter Title Record Columns File

Export to Text File Dialog

JeFCo gives you the possibility to export the collected disc information to a single text file. The output format of this file can be configured to make it possible to import it to a big number of database and spreadsheet products. The chosen configuration is remembered and recalled the next time an export is performed.
This is the first of a possibly growing number of output modules. Please let me know what export modules you need.

You open this export dialog by choosing the "Database -> Export to Text File..." menu item.

Record Delimiter

The field "Record Delimiter" gives you the possibility to choose a sequence of characters that is included at the end of every record. This character sequence seperates the records from each other. There are some special 'characters' that can be included by using following special escape sequences:
   \b   backspace BS       \u0008
   \t   horizontal tab HT  \u0009
   \n   linefeed LF        \u000a
   \f   form feed FF       \u000c
   \r   carriage return CR \u000d
   \\   backslash \        \u005c

Column Delimiter

The field "Column Delimiter" gives you the possibility to choose a sequence of characters that is included between the columns of one record. This character sequence seperates the columns from each other. The last column of every record is followed by the record delimiter instead of the column delimiter. The same special escape sequences possible for the record delimiter can also be used in the column delimiter.

Text Delimiter

You can choose a character to frame the columns including text. This is necessary if the record or column delimiter may be part of the disc information. The same special escape sequences possible for the record delimiter can also be used in the column delimiter.

Title Record

If this checkbox is activated one additional record is included as first record of the file. Instead of the information about one disc this record contains the names of the columns. This record can be used to automatically name the columns in the importing program.

Columns

The checkboxes in the 'Columns' frame decide which columns should be included in the export file. The possible columns are:
Disc Title The Title of the disc
Disc ID The unique freedb disc id
Category One of the 12 freedb categories
Genre The genre this cd belongs to
Release Year The year this cd was released
Disc Length The Length of the cd in the form "[hh:mm]"
Track Count The number of songs on this cd
Track Names The names of the songs on this cd. This is not at single columns but one column for the 1. song, another one for the 2. song and so one. This means enabling this columns lead to records with a variable column count.
Track Length The length of the songs in the form "[mm:ss]". This is not at single columns but one column for the 1. song, another one for the 2. song and so one. This means enabling this columns lead to records with a variable column count. If both the "Track Names" and the "Track Length" columns are enabled the column for the track name of the first song is followed by the the column for the track length for the first song; followed by the column for the track name of the second song and the column for the track length for the second song and so on.

File

Here you can enter the name of the file to export the cd data to. You can use the "Browse..." button to choose one file on your system or create one file in an choosen directory.