Differences

This shows you the differences between two versions of the page.

--- reference:mairlistdb_library_csv_import_export [2016/01/17 11:11] – [File Format] tw
+++ reference:mairlistdb_library_csv_import_export [2020/02/13 16:43] (current) – [Columns] Amplification/Levels tw
@@ Line 29: / Line 29: @@
 | EndType | |
 | Duration | seconds.milliseconds |
+| EffectiveDuration | seconds.milliseconds (export only) |
 | CueIn | seconds.milliseconds |
 | FadeIn | seconds.milliseconds |
@@ Line 45: / Line 46: @@
 | CueOut | seconds.milliseconds |
 | Anchor | seconds.milliseconds |
+| Amplification | dB (from v6.3) |
+| LevelPeak | dBFS (from v6.3) |
+| LevelTruePeak | dBTP (from v6.3) |
+| LevelLoudness | LUFS (from v6.3) |
 === Attribute columns ===
@@ Line 79: / Line 84: @@
   - Filename
-So if the ''ID'' column is present and contains a value, the ID will be used to identify the item; otherwise, if the ''ExternalID'' is present and contains a value, mAirList will try to identify the item by it's External ID; otherwise the filename will be used.
+So if the ''ID'' column is present and contains a value, the ID will be used to identify the item; otherwise, if the ''ExternalID'' is present and contains a value, mAirList will try to identify the item by its External ID; otherwise the filename will be used. If that fails as well, it will look for an item that matches both artist and title.
 If mAirListDB is unable to identify the item in any of these ways, the item will be treated as new (see below).
@@ Line 86: / Line 91: @@
 ==== Adding New Items ====
+CSV files can also be used to add new items to the Library. In this case, **the ''ID'' column must be empty**, and in case a value for ''ExternalID'' or ''Filename'' is given, there must be no other item in the Library with that External ID or filename already (otherwise mAirListDB would treat that line as an item update, not new item).
+When adding new **files**, the filename must be located inside any of the registered Storages.
+When no filename is given, or the ''Filename'' column is not present at all, the items will be treated as //Dummy// items.
 ===== TL;DR - An Example =====