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
MMD > Archives > May 2009 > 2009.05.24 > 06Prev  Next


Roll Inventory Computer Program
By Spencer Chase

Jack is definitely right that Excel is not the ideal program for
cataloging piano rolls.  The advantages of a relational database
are many.  However it is quite a lot more learning but there are
books such as Access for Dummies or Learn Microsoft Access in 3 Days
or whatever it is.  These "Dummies" books can be very useful if you
want to quickly learn just what you need to know and  do not need to
become a sophisticated user.

Access and most other database programs will allow you to export data
to standard formats.  Access and programs to deal with its format will
be around for a long time but it is good to have the option of
switching to something better when it comes along.

For most of my record keeping, I use Excel because it is easy to
export the data as tabbed text and then to process it with Perl
scripts.  Accessing the data in a relational database is much more
complex and Access, specifically, is more complicated than other
databases.  SQL is a much better choice but also more difficult to
learn quickly.

When I first started (mis)using Excel as a database I occasionally
messed up the whole sheet by sorting just a portion of it.  Then
I discovered a way to avoid this and have never made this sort of
mistake since then.  If you highlight a single cell in a column and
click the sort button, the entire sheet is sorted following the sort
order of the column the cell is in.  You don't have to worry that you
may have missed a line somewhere.

Excel can be very useful for quickly setting up a "database".  Copying
and pasting and the use of global replace can do a lot to avoid typing.
Sorting and replacing can fix a lot of errors.  What can not be fixed
easily, I deal with in scripts but that is a whole lot to learn.  Once
you have a "database" in excel, you can always export it to tabbed text
and then import it into Access when you are ready to do it the right way.

For those who play MIDI (or other multimedia files) you can enter
hyperlinks to the multimedia files directly in Excel.  You can then
play the files by clicking the link.  It is much easier to do this in
Excel.  Also, I have written a program that creates an Excel sheet with
hyperlinks to all MIDI files in a folder.  These can be made for your
entire collection and will also survive importing into Access.

The procedure is a little complex and badly documented by Microsoft but
I have instructions that a friend made up that do seem to work.  He has
his entire collection of about 10,000 MIDI files in an Access database
from which he can click to play them on his Disklavier.  When the
Access database is made, you can add any fields you want and can sort
and search to find just about anything.  Sort of like an iTunes for
MIDI but much more customizable.

Best regards,
Spencer Chase


(Message sent Sun 24 May 2009, 18:39:32 GMT, from time zone GMT-0700.)

Key Words in Subject:  Computer, Inventory, Program, 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