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
ID,ExternalID,Filename,Title,Artist,Comment,EndType,Duration,CueIn,FadeIn,Ramp1,Ramp2,Ramp3,HookIn,HookFade,HookOut,LoopIn,LoopOut,Outro,StartNext,FadeOut,FadeEnd,CueOut,Anchor,Album,Top40,Track,Jahr,Genre 00005217,,"M:\Music\Yann Tiersen\Skyline\01 Another Shore.m4a","Another Shore","Yann Tiersen",,,293.907,,,,,,,,,,,,,293.906,,293.907,,Skyline,,1,, 00005206,,"M:\Music\Yann Tiersen\Good Bye Lenin\13 Birthday Preparations.mp3","Birthday Preparations","Yann Tiersen",,,151.000,,,,,,,,,,,,,147.905,,151.293,,"Good Bye Lenin",,13,2003,Soundtrack 00005196,,"M:\Music\Yann Tiersen\Good Bye Lenin\03 Childhood (1).mp3","Childhood (1)","Yann Tiersen",,,97.000,,,,,,,,,,,,,91.606,,97.533,,"Good Bye Lenin",,03,2003,Soundtrack 00005208,,"M:\Music\Yann Tiersen\Good Bye Lenin\15 Childhood (2).mp3","Childhood (2)","Yann Tiersen",,,104.000,,,,,,,,,,,,,97.762,,104.893,,"Good Bye Lenin",,15,2003,Soundtrack 00005195,,"M:\Music\Yann Tiersen\Good Bye Lenin\02 Coma.mp3",Coma,"Yann Tiersen",,,78.000,,,,,,,,,,,,,76.751,,78.400,,"Good Bye Lenin",,02,2003,Soundtrack 00005177,,"M:\Music\Yann Tiersen\Die fabelhafte Welt der Amelie\04 Comptine d'un Autre ete - L'apres-midi.mp3","Comptine d'un Autre ete - L'apres-midi","Yann Tiersen",,,138.000,0.249,,,,,,,,,,,,131.805,,138.710,,"Die fabelhafte Welt der Amelie",,04,2001,Soundtrack
reference/mairlistdb_library_csv_import_export.1453028243.txt.gz · Last modified: 2019/07/09 16:19 (external edit)