reference:mairlistdb_library_csv_import_export
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:mairlistdb_library_csv_import_export [2016/01/17 11:04] – [Importing Items] tw | reference:mairlistdb_library_csv_import_export [2020/02/13 16:43] (current) – [Columns] Amplification/Levels tw | ||
---|---|---|---|
Line 7: | Line 7: | ||
==== File Format ==== | ==== File Format ==== | ||
- | * Plain text format, comma-separated values (CSV) | + | * Plain text format, comma-separated values (CSV). |
- | * Separator is comma, strings | + | * Separator is comma or tab (ASCII 9). |
+ | * Strings | ||
* Text encoding can be ANSI or UTF-8; for UTF-8, the file must have a valid BOM. | * Text encoding can be ANSI or UTF-8; for UTF-8, the file must have a valid BOM. | ||
Line 28: | 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 44: | 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 72: | Line 78: | ||
==== Updating Existing Items ==== | ==== Updating Existing Items ==== | ||
+ | To update existing items in the Library, mAirListDB will try to identify the item by one of the following columns: | ||
+ | |||
+ | - ID | ||
+ | - ExternalID | ||
+ | - Filename | ||
+ | |||
+ | So if the '' | ||
+ | |||
+ | If mAirListDB is unable to identify the item in any of these ways, the item will be treated as new (see below). | ||
+ | |||
+ | The item will be updated using the data found in the remaining columns of the file. All other fields will remain untouched. If a column contains the special value '' | ||
==== Adding New Items ==== | ==== Adding New Items ==== | ||
+ | |||
+ | CSV files can also be used to add new items to the Library. In this case, **the '' | ||
+ | |||
+ | When adding new **files**, the filename must be located inside any of the registered Storages. | ||
+ | |||
+ | When no filename is given, or the '' | ||
+ | ===== TL;DR - An Example ===== | ||
+ | |||
< | < |
reference/mairlistdb_library_csv_import_export.1453028647.txt.gz · Last modified: 2019/07/09 16:19 (external edit)