mAirList Wiki

User Tools

Site Tools

Trace:
reference:mairlistdb_library_csv_import_export

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
reference:mairlistdb_library_csv_import_export [2016/01/17 11:13] – [Adding New Items] twreference:mairlistdb_library_csv_import_export [2020/02/13 16:43] (current) – [Columns] Amplification/Levels tw
Line 29: Line 29:
 | EndType | | | EndType | |
 | Duration | seconds.milliseconds | | Duration | seconds.milliseconds |
 +| EffectiveDuration | seconds.milliseconds (export only) |
 | CueIn | seconds.milliseconds | | CueIn | seconds.milliseconds |
 | FadeIn | seconds.milliseconds | | FadeIn | seconds.milliseconds |
Line 45: Line 46:
 | CueOut | seconds.milliseconds | | CueOut | seconds.milliseconds |
 | Anchor | 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 === === Attribute columns ===
Line 79: Line 84:
   - Filename   - 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). If mAirListDB is unable to identify the item in any of these ways, the item will be treated as new (see below).
Line 87: Line 92:
  
 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). 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 ===== ===== TL;DR - An Example =====
  
reference/mairlistdb_library_csv_import_export.1453029211.txt.gz · Last modified: (external edit)
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki