reference:mairlistdb_library_csv_import_export
This is an old revision of the document!
Table of Contents
mAirListDB Library CSV Import/Export
This article explains the CSV file format used to import/export items from/to the mAirListDB Library.
General
File Format
- Plain text format, comma-separated values (CSV)
- Separator is comma, strings can be quoted with double-quotes
- Text encoding can be ANSI or UTF-8; for UTF-8, the file must have a valid BOM.
Columns
The CSV file contains one or more columns of values. The set of columns is not fixed, instead the first line in the CSV file must contain the names of the columns used in this file.
Some “fixed” column names will be recognized and mapped to mAirList's internal fields. The other column names will be treated as additional columns for Attributes.
Fixed column names
Column Name | Remark |
---|---|
ID | |
ExternalID | |
Filename | |
Title | |
Artist | |
Comment | |
EndType | |
Duration | seconds.milliseconds |
CueIn | seconds.milliseconds |
FadeIn | seconds.milliseconds |
Ramp1 | seconds.milliseconds |
Ramp2 | seconds.milliseconds |
Ramp3 | seconds.milliseconds |
HookIn | seconds.milliseconds |
HookFade | seconds.milliseconds |
HookOut | seconds.milliseconds |
LoopIn | seconds.milliseconds |
LoopOut | seconds.milliseconds |
Outro | seconds.milliseconds |
StartNext | seconds.milliseconds |
FadeOut | seconds.milliseconds |
FadeEnd | seconds.milliseconds |
CueOut | seconds.milliseconds |
Anchor | seconds.milliseconds |
Attribute columns
Additional columns found in the CSV file will be treated and imported as attributes.
Restrictions
Only the fixed columns and attributes columns can be used for import/export. You can not use CSV import/export to handle any of the following information:
- Folder assignment
- Playback options
- Additional cue data
- …
Exporting Items
Importing Items
Updating Existing Items
Adding New Items
reference/mairlistdb_library_csv_import_export.1453028182.txt.gz · Last modified: 2019/07/09 16:19 (external edit)