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 10:57] – [Adding New 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 20: | Line 21: | ||
^ Column Name ^ Remark ^ | ^ Column Name ^ Remark ^ | ||
- | | ID | | | + | | ID | With or without leading 0s | |
| ExternalID | | | | ExternalID | | | ||
| Filename | | | | Filename | | | ||
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 58: | Line 64: | ||
===== Exporting Items ===== | ===== Exporting Items ===== | ||
+ | When exporting items as CSV from the mAirListDB Library, you have two file formats to choose from: | ||
+ | |||
+ | * //CSV file//: Will export all columns, including ID and all attributes found in any of the items | ||
+ | * //CSV file (without IDs)//: Will omit the ID column | ||
+ | |||
+ | The latter can be used to import the items into another mAirListDB, where the items have a different ID. | ||
===== Importing Items ===== | ===== Importing Items ===== | ||
+ | |||
+ | CSV files can be used to update existing items in the Library, as well as adding new items. | ||
+ | |||
+ | In either case, you can have as many or few columns in the CSV file as you like. Columns not found in the file will be ignored. For example, you can use a CSV file with only the //ID// and //Comment// columns to update only the comment of a particular set of items (identified by their ID), and leave all other fields untouched. | ||
==== 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.txt · Last modified: 2020/02/13 16:43 by tw