My point of departure is an Acces file with the following entries:
COMPOSER if necessary followed by letters of first names, Bach J.S. of Bach C.P.E. e.g.
WORK official standardised title + "nickname" like Symphony no. 6 "Pastoral"
, or Le Sacre du Printemps. Names in English, Welsh, German, French, Italian, Latin and Dutch with their original titel, otherwise the English translation (all Russian titles are in English therefore, e.g.)
KEY if there is one
OPUS (or KV with Mozart, D with Schubert, main Hobokengroup for Haydn, etc)
#: sub number, e.g. the a from opus 81a is marked here. That's necessary as opus must be a numeric field, otherwise you are unable to get the order numerically right.
ALT#NR# WoO with Beethoven, opusnrs with Haydn or Schubert e.g. White with Stravinsky, H with Martinu or Honegger, etc
YEAR if known year of completion or publication
REMARK version (Bruckner !), arrangements, arrangers, orcehstration if necessary
LP
MC
CD
LOCATION either number or title of sleeve/box + recod company + recordnumber
DATE of recording or of registration.
I don't do genres or performers and only mark them is they are really special (composer playing e.g.) in the "Remarks"-field.
Location: Cassette-tapes are (mainly chronologically) numbered.
LP and CD location consist of composer's name where located (if more than one composer), if necessary the work, a * if more than one composer on that record, record company, record number and, if more LP/CD set located separately, "box" .
It is not necessary to mark here whether it is an LP, MC or CD as that's mentioned in an earlier field already.
E.g.
So Beethoven Pastoral is DGG 2747.001
Beethoven Egmont on Pastoral is Sym 6: DGG 2747.001
Mozart's Don Giovanni overture on Beethoven's pastoral: Beethoven Sym 6 * DGG 2741.001
Gabrieli's works on a Virgin CD Venetian Coronatian 1595: Venetian Coronation * virgin 7.911123-2
DesPrez's Scamarella va la Guerra: Glory Netherlands * EMI SLS 890 box
A cassette tape recorded in 1995 or so: 560
although the collections are spread over three locations now, it is immedately clear where to find what (hence the extra help of the Date), and within seconds.
It means that one must have the discipline to put titles of CDs immediately into the system, otherwise it is very swiftly unreliable.
It's the only way to get a firm grip on 53.000+ recordings with only some 20% doublets.
COMPOSER if necessary followed by letters of first names, Bach J.S. of Bach C.P.E. e.g.
WORK official standardised title + "nickname" like Symphony no. 6 "Pastoral"
, or Le Sacre du Printemps. Names in English, Welsh, German, French, Italian, Latin and Dutch with their original titel, otherwise the English translation (all Russian titles are in English therefore, e.g.)
KEY if there is one
OPUS (or KV with Mozart, D with Schubert, main Hobokengroup for Haydn, etc)
#: sub number, e.g. the a from opus 81a is marked here. That's necessary as opus must be a numeric field, otherwise you are unable to get the order numerically right.
ALT#NR# WoO with Beethoven, opusnrs with Haydn or Schubert e.g. White with Stravinsky, H with Martinu or Honegger, etc
YEAR if known year of completion or publication
REMARK version (Bruckner !), arrangements, arrangers, orcehstration if necessary
LP
MC
CD
LOCATION either number or title of sleeve/box + recod company + recordnumber
DATE of recording or of registration.
I don't do genres or performers and only mark them is they are really special (composer playing e.g.) in the "Remarks"-field.
Location: Cassette-tapes are (mainly chronologically) numbered.
LP and CD location consist of composer's name where located (if more than one composer), if necessary the work, a * if more than one composer on that record, record company, record number and, if more LP/CD set located separately, "box" .
It is not necessary to mark here whether it is an LP, MC or CD as that's mentioned in an earlier field already.
E.g.
So Beethoven Pastoral is DGG 2747.001
Beethoven Egmont on Pastoral is Sym 6: DGG 2747.001
Mozart's Don Giovanni overture on Beethoven's pastoral: Beethoven Sym 6 * DGG 2741.001
Gabrieli's works on a Virgin CD Venetian Coronatian 1595: Venetian Coronation * virgin 7.911123-2
DesPrez's Scamarella va la Guerra: Glory Netherlands * EMI SLS 890 box
A cassette tape recorded in 1995 or so: 560
although the collections are spread over three locations now, it is immedately clear where to find what (hence the extra help of the Date), and within seconds.
It means that one must have the discipline to put titles of CDs immediately into the system, otherwise it is very swiftly unreliable.
It's the only way to get a firm grip on 53.000+ recordings with only some 20% doublets.
Comment