Mechanical Music Digest  Archives
You Are Not Logged In Login/Get New Account
Please Log In. Accounts are free!
Logged In users are granted additional features including a more current version of the Archives and a simplified process for submitting articles.
Home Archives Calendar Gallery Store Links Info

End-of-Year Fundraising Drive In Progress. Please visit our home page to see this and other announcements: https://www.mmdigest.com     Thank you. --Jody

MMD > Archives > December 2022 > 2022.12.20 > 02Prev  Next


Cataloging a Music Roll Collection
By Spencer Chase

I use Microsoft Excel and tab-delimited text files for my roll lists.
If you need more sophisticated queries you probably want to use
a relational database.

The _most important_ thing is do not invest time in cataloging within
a computer program that does not allow you to export the data to a
standard format. Most likely this will not be a problem but, if you
pick a program that encrypts data and they stop updating the program,
you might not be able to access your data.

Although I am a fast and almost accurate typist I hate typing. I will
do anything to find data already entered in an electronic format that
I can copy and paste.
I have a variety of tabbed text files that I will share from which
others can copy the data. I have the Obenchain Ampico Catalog but it
is in PDF and not formatted in a very friendly way. I probably wrote
a script a while ago to get the data in a more useful format.

All these files are available for sharing. I do have an Ampico file
with about 2000 rolls, the data for which came from various sources.

To make a list of collected rolls I would make a list of just the
roll numbers you have and use this to do multiple selections to copy
and arrange the data any way you want. I like to sort by title,
composer and performer and make sure that there is consistency. It is
easy to do bulk changes such as to change "J.S. Bach" to "Bach J. S."

Spencer Chase


(Message sent Tue 20 Dec 2022, 18:14:47 GMT, from time zone GMT-0800.)

Key Words in Subject:  Cataloging, Collection, Music, Roll

Home    Archives    Calendar    Gallery    Store    Links    Info   


Enter text below to search the MMD Website with Google



CONTACT FORM: Click HERE to write to the editor, or to post a message about Mechanical Musical Instruments to the MMD

Unless otherwise noted, all opinions are those of the individual authors and may not represent those of the editors. Compilation copyright 1995-2024 by Jody Kravitz.

Please read our Republication Policy before copying information from or creating links to this web site.

Click HERE to contact the webmaster regarding problems with the website.

Please support publication of the MMD by donating online

Please Support Publication of the MMD with your Generous Donation

Pay via PayPal

No PayPal account required

                                     
Translate This Page