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:10] – [Updating Existing 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 78: | Line 84: | ||
- Filename | - Filename | ||
- | So if the '' | + | 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). | If mAirListDB is unable to identify the item in any of these ways, the item will be treated as new (see below). | ||
Line 84: | Line 90: | ||
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 '' | 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.1453029015.txt.gz · Last modified: 2019/07/09 16:19 (external edit)