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
Column names in first line
Fixed colums
| 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
Exporting Items
Importing Items
Updating Existing Items
Adding New Items
reference/mairlistdb_library_csv_import_export.1453027912.txt.gz · Last modified: 2019/07/09 16:19 (external edit)