|
The Silver Salon Forums
Since 1993 Over 11,793 threads & 64,769 posts !! General Silver Forum
|
REGISTER (click here) |
How to Post Photos
|
SMP Silver Salon Forums
General Silver Forum Cataloguing suggestions?
|
SSFFriend: Email This Page to Someone! | next newest topic | next oldest topic |
Author | Topic: Cataloguing suggestions? |
witzhall Posts: 124 |
posted 11-29-2006 10:17 AM
[01-2529] I've searched the SSF and no one seems to have addressed this topic, so I'll give it a shot, hoping that it's appropriate. I have acquired a small but growing collection of spoons (early American coin silver, mostly pre-1800 New England). I'd like to know how other collectors catalogue their objects; while I have kept any information I received when I acquired each spoon, it's getting unwieldy and difficult to access! Suggestions about any of the following will be most gratefully received!
Thanks in advance! IP: Logged |
Scott Martin Forum Master Posts: 11520 |
posted 11-29-2006 10:35 AM
See: IP: Logged |
swarter Moderator Posts: 2920 |
posted 11-29-2006 12:12 PM
If a database is too restrictive with its fixed length fields, more flexibility can be achieved with a word processor - simply set up an outline, copy and past it, and fill out the "form." This is probably not needed for spoons, if little description is anticipated and you have a lot of them, but works well for hollow ware if you don't have many pieces. See this thread for an example. IP: Logged |
Scott Martin Forum Master Posts: 11520 |
posted 11-30-2006 06:10 PM
Kayvee suggested via e-mail: quote: Thanks to
Silver Magazine for permission to post the article and to Will Chandler IP: Logged |
Scott Martin Forum Master Posts: 11520 |
posted 11-30-2006 06:11 PM
Many of these ideas and methods are based on my experience as a museum. curator responsible for a varied collection that included more than 3,500 artifacts. That being said, I believe that record keeping for the private collector can be a reasonably low-tech process. The important thing is to make a commitment to keep accurate records, and then do so consistently in a way that will enable others to understand those records and to correctly identify the individual artifact documented by each entry.
Fig. 1. A worktable with a typical set of tools used for documenting collectible silver. The essential documentation tool missing from this image is the camera used to record it. Not seen in Figure 1 is the camera used to photograph the silver, but it is also an essential tool of good documentation. A clear photo of an artifact often provides the quickest and most reliable means of identification, especially when a collection contains several similar items. Photos made for documentation do not need to be of studio or publication quality, but they do need to be visually legible. In my experience, most Polaroid prints do not provide a clear-enough image to be useful, nor do videotaped images. Either a conventional 35mm film or digital camera with good lenses provides the best results for the purpose of documentation.4 When using a digital camera, set it to record high-resolution images only, to avoid murky results when the photos are printed. Including a portion of a tape measure in an image can provide an instant sense of scale, even if the numbers on the tape are not legible in the photo (Fig. 6). Despite the increasing convenience of digital image storage and home computer InkJet photo printers, I still strongly recommend professionally processed color photo prints on glossy photo paper, stored in archival clear plastic sleeve-type album pages. Remember to carefully store the negatives, too, for backup. Conventional glossy photo prints, especially when kept in archival albums, remain the most reliable means of storing an image for long-term use, by which I mean more than ten years. The inks and papers used by many inkjet printers are more vulnerable to variations in heat and moisture and as yet have no conclusively proven track record of long-term stability. Digitized images stored on magnetic media such as CD-ROM or DVD disks have a known potential of degrading or becoming completely irretrievable within a few years. (To be safe, plan to recopy your image and other data files onto a new disk every two years.) And, needless to say, your hard drive is your filing cabinet only as long as your computer is running and its operating system is functioning properly. Your computer is a terrific tool for documenting your collection, but for safety's sake, produce printed paper copies of your records and store at least one complete set (text and images) offsite, in a safety deposit box or other secure storage.
Figure 2 presents an annotated sample of a standardized worksheet that can be used to record useful data about your silver. Its format is based on a curatorial department worksheet I developed for decorative arts records, and which I have since modified somewhat as an independent consultant. While this form works well for me, I encourage you to freely adapt it to your specific needs. The boldface, capitalized headings in the left column represent the categories of information. The annotations to the right of each heading have been added here to clarify the heading's intended function. Absent the annotations, the form can be used for handwritten entries in a notebook format. Or you can build a version on your computer, providing greater spatial elasticity in the form for your actual data entry. (For those readers who use Microsoft Word, a document file version of the form illustrated in Figure 2 can be downloaded: Although I hope that most of the headings on the sample worksheet are self-explanatory, some additional comments on the "Inventory Number" heading might be useful. This heading is included to encourage the use of a standard numbering system for tracking your artifacts, similar to the acquisition numbers used by many museums. Each artifact gets its own number, and all records include this number as an organizational aid. A simple numbering system usually works the best; avoid the temptation of making the number do too much. Usually, the number indicates the year of acquisition combined with the individual artifact's number, assigned in the order that the piece was acquired in that year. For example, 2005:001 would indicate the first item to enter the collection in the year 2005; 2005:123 would indicate the one hundred twenty-third item acquired in that same year. In 2006 the cycle would repeat itself. IP: Logged |
Scott Martin Forum Master Posts: 11520 |
posted 11-30-2006 06:12 PM
With sets of items, such as a tea service, decimal numbers can be appended to the primary inventory number to aid in tracking the individual pieces. If the set's inventory number is 2005:015, the teapot would be 2005:015.01, the coffee pot 2005:015.02, and so on. If all of your records use a system of inventory numbers, it will be worthwhile to use the same numbering system on the physical artifacts. In storage, the artifact or its storage bag can often be marked with a simple paper string tag or other written label, but I cannot recommend the use of adhesive labels on the artifacts themselves. If you need to mark the silver itself, I suggest using this durable but completely reversible method. A small rectangle of clear nail lacquer can be added to the base or back of the piece, where it will not readily be seen in display. Once the lacquer has dried hard, the number can be drawn on the lacquer using a fine draftsman's pen—a Rapidograph-type, not a ballpoint— charged with a plastics-compatible India ink (available from art or architect supply stores). Once the ink is dry, add a second layer of clear lacquer to protect the ink. Similarly, your photo prints can be labeled with your inventory numbers using any pen and a small press-on paper label, such as Avery® label 05418. If you are using digital image files, the inventory number can be added to the image filename in your data storage manager. Related papers, such as sales receipts, should be stored in clear Mylar page protectors labeled with the appropriate inventory numbers. The form illustrated here was developed in Microsoft® Word, which is easy for most people to use but offers very limited sorting capabilities. If you are fluent in using a spreadsheet program such as Microsoft® Excel or Access, you can modify the individual information fields to enhance the ability to sort your records in various ways. For example, you might want to configure a database that allows you to sort your collection records by type of artifact, date of acquisition, monetary value, or provenance. Although the initial labor of documenting your collections might seem daunting, the long-term benefits should be readily apparent. (How many of us have said, "I wish I'd asked my grandmother to write down what she knew about that teapot.") Well-organized documentation is the best means I know for preserving the results of your research on your collections, and for sharing with your heirs and/or other collectors the stories that add no small measure of enjoyment to the artifacts themselves.
Will Chandler is an editor for Silver Magazine and the owner of Chandler Art Consulting Services in San Diego. A 1972 graduate of the UC Berkeley College of Environmental Design, he was associate curator of decorative arts at the San Diego Museum of Art from 1976 to 1988. BIBLIOGRAPHY Dorothy T. Rainwater and Judy Redfield. Encyclopedia of American Silver Manufacturers, Revised Fourth Edition. Atglen, Pa.: Schiffer Publishing Ltd., 1998. Arthur W. Schultz, gen. ed.. National Institute for the Conservation of Cultural Property. Caring for Your Collections. New York: Harry N. Abrams, Inc., 1992. ENDNOTES 2 The example shown is a Kemper Model AL12. Large sculptor's calipers are available from most art supply or hobby stores for less than $10. 3 The scale illustrated is an Acculab® Model GS-2001, with a maximum weight capacity of 2,000 grams. It can be set to indicate the weight in grams or in English ounces and tenths of ounces. To calculate traditional troy ounces from grams, multiply the gram weight by 0.0321507. 4I use a moderately priced Nikon 35mm single-lens reflex camera with a Tamron 28-105mm zoom lens, and a set of Kenko extension tubes, not macro lenses, for the few extremely close details I might need. I typically use Kodak 400 HD4 High Definition color print film (C41 Process). Others will have their own preferences, but this combination seems to give the most reliable results in the varied circumstances I encounter. IP: Logged |
FWG Posts: 845 |
posted 12-01-2006 03:09 PM
For those with just a bit more computer savvy, I find Filemaker -- a relational database available for both Mac and pc platforms -- to be excellent. You can configure both your input and output forms to suit; this is espcially handy, because you can set up one output form to be complete, full-page records and another to be line entries for easy of carrying around. It takes a little effort to set up at the beginning, but once you've done that the data entry and management are a breeze. IP: Logged |
witzhall Posts: 124 |
posted 12-01-2006 06:46 PM
I'm sorry not to have thanked Scott Martin and Swarter and Kayvee in a more timely fashion; but, having procrastinated, now I can thank FWG as well! All of your suggestions were useful. Having explored them all and having learned that as a Mac user I was pretty much doomed when it came to finding good inventory-collection software, I finally turned to (great minds seem to think alike ...) Filemaker, a rare breed of business software written for a Mac. It has a rather steep learning curve, but I think it is all that FWG suggests. So I've begun. The earlier threads were very interesting, and the other websites had much to offer as well. So, many thanks again to each of you. [This message has been edited by witzhall (edited 12-01-2006).] IP: Logged |
FWG Posts: 845 |
posted 12-02-2006 10:44 AM
I use Filemaker for everything from tracking expenses to my library catalogue (I made up a template just like an old-fashioned card record for the sake of comfort), and am about to start converting the catalogue of the anthropology collections I am professionally in charge of over to Filemaker as well. I also got a colleague started cataloging cooking recipes using it -- so he can search for all recipes using certain ingredients or techniques, for example. It's really good software (I've been using it for well over a decade). The most important aspect of setting up a catalogue is thinking through the dataset beforehand, determining all the variables you're likely to want to record. I then usually add a couple of 'spare' fields to accommodate anything I didn't think of that I might want to add later. Every person and every purpose is likely to have different requirements -- but blank (unused) fields don't hurt anything. If you don't already have your own set of things you like to record you could certainly start with Mr. Chandler's as a base. IP: Logged |
FWG Posts: 845 |
posted 12-02-2006 10:45 AM
A quick PS: you can also get that kind of caliper made of wood in artists' supply houses -- much safer to use on silver objects. In either case I'd recommend adding felt pads to the ends.... IP: Logged |
witzhall Posts: 124 |
posted 12-02-2006 11:54 AM
Thanks once again, FWG - I did indeed start with a combination of Mr. Chandler's categories and the ones I had set up on my very low-tech Word spread sheet. I like - and will add to my layout - your suggestion of one or two "blank" fields, just in case... The calipers will go on my Christmas list. Thanks again! IP: Logged |
Scott Martin Forum Master Posts: 11520 |
posted 12-02-2006 12:58 PM
Not that any of us regular participants at the Silver Salon Forums need more to.... Would some of the members with database design experience (WP to SQL and anything else) care to collaborate on developing a recommended database specification? If there are several members volunteering, I can offer a private Silver Caucus Room for you all to meet in. IP: Logged |
chase33 Posts: 362 |
posted 01-02-2010 05:35 PM
I was reviewing the entries on creating a database for silver (one of my New Years resolutions!). While I have been keeping a listing of my flatware and a few other catagories of smalls, I havn't really been keeping a written record of my other pieces (I have kept the receipts and other documentation though). Anyway my question is: do I really need to catalogue my basic flatware (Chantilly) and holloware (also Chantilly) in as much detail as I would my more unusal pieces ie a Gorham coin fruit bowl? Does it really matter where and when I bought all my forks, teaspoons, knives etc. since this is such a common pattern? I do plan on cataloguing the more rare pieces of Chantilly. And what about pictures, would a group picture of the forks, spoons, knives be sufficient? or do I even need pictures of the flatware? Any thoughts or ideas? Thanks Robert IP: Logged |
doc Posts: 728 |
posted 01-03-2010 10:05 AM
This is a very timely topic for me; one of my New Year's resolutions is to properly document my silver (and other antiques), both for my own purposes and because my homeowners insurance doesn't give me enough coverage and a supplemental policy requires documentation. So far, my documentation has consisted of Excel spreadsheets, but I think it's time for something better, so I will definitely look into Filemaker. Chase33, I think that for flatware patterns, identification of the number and types of pieces is really sufficient, but I would recommend photographing them (perhaps putting several piece types in a single photograph) for insurance purposes. IP: Logged |
wev Moderator Posts: 4121 |
posted 01-03-2010 10:20 AM
Primasoft's Collectibles Organizer Deluxe is worth a look -- very flexible structure, good image and report handling and a lot cheaper than Filemaker. IP: Logged |
All times are ET | next newest topic | next oldest topic |
Ultimate Bulletin Board 5.46a
1. Public Silver Forums (open Free membership) - anyone with a valid e-mail address may register. Once you have received your Silver Salon Forum password, and then if you abide by the Silver Salon Forum Guidelines, you may start a thread or post a reply in the New Members' Forum. New Members who show a continued willingness to participate, to completely read and abide by the Guidelines will be allowed to post to the Member Public Forums. 2. Private Silver Salon Forums (invitational or $ donation membership) - The Private Silver Salon Forums require registration and special authorization to view, search, start a thread or to post a reply. Special authorization can be obtained in one of several ways: by Invitation; Annual $ Donation; or via Special Limited Membership. For more details click here (under development). 3. Administrative/Special Private Forums (special membership required) - These forums are reserved for special subjects or administrative discussion. These forums are not open to the public and require special authorization to view or post. |
copyright © 1993 - 2022
SM Publications
All Rights Reserved. Legal & Privacy Notices |