Vendors¶
One row for each kind of outside identifier, such as a Spotify artist ID: its format and its link pattern.
| Field | Type | Required | Allowed values or link | Definition | Purpose | MP4 tag | MP3 tag |
|---|---|---|---|---|---|---|---|
Vendor_Key |
Text | Yes | The permanent key of a vendor identifier type (for example SPOTIFY_ARTIST). It never changes, so formulas that read it cannot be broken by a rename. | Lets a formula find its vendor row safely. | None | None | |
Vendor_Name |
Text | The vendor's name as written in field names (Spotify, Apple_Music, YouTube). | Readable name for the row. | None | None | ||
Vendor_Entity |
Text | What the vendor identifies: Artist, Track, Song, Channel, Video and so on. | Tells two identifier types of one vendor apart. | None | None | ||
ID_Characters |
One value from a list | Digits, Letters_And_Digits, Base64_Url, Hex, UUID, Username, Slug | Which characters the identifier is made of: Digits, Letters_And_Digits, Base64_Url (letters, digits, - and _), Hex, UUID, Username or Slug. | A structured description that cannot be mistyped into an invalid pattern. | None | None | |
ID_Length |
Whole number | How many characters follow the prefix. Blank when the length varies. | Part of the structured pattern. | None | None | ||
ID_Prefix |
Text | A fixed start every identifier has (UC for a YouTube channel, nm for an IMDb name). It is part of the stored identifier. | Part of the structured pattern. | None | None | ||
URL_Prefix |
Text | The start of the vendor's link, up to the identifier. | Builds the calculated link. | None | None | ||
URL_Suffix |
Text | The end of the vendor's link, after the identifier. | Builds the calculated link. | None | None | ||
Example_ID |
Text | A real example identifier of this type. | A quick check of the format and the calculated link. | None | None | ||
ID_Pattern |
Derived text | Derived from other fields | The validation pattern, calculated from the structured parts. | What every stored identifier of this type must match. Never typed. | None | None | |
Example_URL |
Derived text | Derived from other fields | The link built from the example identifier, calculated. | A wrong row is obvious at a glance. | None | None | |
Updated_Date |
Date | The date the row was last changed. It stamps itself. | Shows what changed recently. On a video it is also written to the file's tag. | None | None |
This page is generated from the data dictionary. Change the dictionary, not this page.