SMP Logo
SM Publications
Silver Salon Forums - The premier site for discussing Silver.
SMP | Silver Salon Forums | SSF - Guidelines | SSF - FAQ | Silver Sales


The Silver Salon Forums
Since 1993
Over 11,793 threads & 64,769 posts !!

General Silver Forum



Silver Salon internal search
or

REGISTER (click here) How to Post Photos


customtitle open  SMP Silver Salon Forums
tlineopen  General Silver Forum
tline3open  Cataloguing suggestions?

Post New Topic  Post A Reply
profile | register | preferences | faq | search

ForumFriend SSFFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Cataloguing suggestions?
witzhall

Posts: 124
Registered: Mar 2006

iconnumber posted 11-29-2006 10:17 AM     Click Here to See the Profile for witzhall     Edit/Delete Message   Reply w/Quote
[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!


  • Is there software that is especially designed for silver collectors? Will it run on a Macintosh? If there's more than one application, what's your recommendation?
  • What categories of information should be included for each object?
  • What other questions should I be asking? confused

Thanks in advance!

IP: Logged

Scott Martin
Forum Master

Posts: 11520
Registered: Apr 93

iconnumber posted 11-29-2006 10:35 AM     Click Here to See the Profile for Scott Martin     Edit/Delete Message   Reply w/Quote
See:

IP: Logged

swarter
Moderator

Posts: 2920
Registered: May 2003

iconnumber posted 11-29-2006 12:12 PM     Click Here to See the Profile for swarter     Edit/Delete Message   Reply w/Quote
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
Registered: Apr 93

iconnumber posted 11-30-2006 06:10 PM     Click Here to See the Profile for Scott Martin     Edit/Delete Message   Reply w/Quote
Kayvee suggested via e-mail:
quote:
Hello Scott - There is a post on the General forum regarding cataloguing a silver collection. In addition to the threads you have suggested, there is also a Silver Magazine article by W. Chandler in the March-April 2005 issue, entitled “Documenting your collection" that might be useful to include.

Thanks,
Kayvee


Thanks to

    Kayvee for the suggestion.
    Silver Magazine for permission to post the article
    and to Will Chandler

IP: Logged

Scott Martin
Forum Master

Posts: 11520
Registered: Apr 93

iconnumber posted 11-30-2006 06:11 PM     Click Here to See the Profile for Scott Martin     Edit/Delete Message   Reply w/Quote

    Collectors need to keep careful records of their holdings. Here we'll focus on the documentation of collectible silver, but many of the same concepts can be adapted to other categories of collecting, such as furniture, ceramics, woodblock prints, or�it's the collector's choice, after all� Disney-character salt shakers. My primary intent is to encourage you to keep detailed records of the items in your collection, and to suggest some methods and materials for producing and maintaining records that will serve you (and your heirs) in a variety of ways.

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.

    All images by the author
    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.
Figure 1 illustrates tools commonly used for documenting collectible silver, in an unarguably low-tech way. Included in the image is a notebook filled with copies of a standardized worksheet (Fig. 2) on which the information about an artifact or set of related artifacts (such as a flatware service) can be written down. The measuring tape is used to record the artifact's greatest physical dimensions.1 The caliper, in the upper right corner of Figure 1, can be used to more accurately measure an irregular shape, such as the diameter of a teapot or the distance from the tip of its spout to the outside curve of its handle (Fig. 3).2 The scale, seen at center, is used to measure the artifact's weight (Figs. 4,5).3 The reference book, at left, represents your whole library; as a collector you can never have too many good reference sources. (Many readers will instantly recognize the cover of Encyclopedia of American Silver Manufacturers, Revised Fourth Edition, by Dorothy T. Rainwater and Judy Redfield, one of the bibles of American silver collectors.)

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.

    Fig. 2. A sample standardized worksheet used to record the information about a silver artifact, created in Microsoft� Word and printed on a laser printer. This form can be adapted to a variety of specialized needs by modifying the categories shown.

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
Registered: Apr 93

iconnumber posted 11-30-2006 06:12 PM     Click Here to See the Profile for Scott Martin     Edit/Delete Message   Reply w/Quote
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.



    Fig. 6. A typical documentation photo. The inclusion of the measuring tape adds an immediate sense of scale to the image.

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
Harold Newman. An Illustrated Dictionary of Silverware. London and New York: Thames & Hudson, 1987.

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
1 The tape illustrated is a 5-meter /16-foot Stanley Powerlock® Model 33-158. This model includes scales for both English and metric measurements, which can be very handy when researching silver made or sold outside the United States. When using a metal tape or metal-edged ruler, always take care not to scratch your silver.

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
Registered: Aug 2005

iconnumber posted 12-01-2006 03:09 PM     Click Here to See the Profile for FWG     Edit/Delete Message   Reply w/Quote
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
Registered: Mar 2006

iconnumber posted 12-01-2006 06:46 PM     Click Here to See the Profile for witzhall     Edit/Delete Message   Reply w/Quote
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
Registered: Aug 2005

iconnumber posted 12-02-2006 10:44 AM     Click Here to See the Profile for FWG     Edit/Delete Message   Reply w/Quote
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
Registered: Aug 2005

iconnumber posted 12-02-2006 10:45 AM     Click Here to See the Profile for FWG     Edit/Delete Message   Reply w/Quote
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
Registered: Mar 2006

iconnumber posted 12-02-2006 11:54 AM     Click Here to See the Profile for witzhall     Edit/Delete Message   Reply w/Quote
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
Registered: Apr 93

iconnumber posted 12-02-2006 12:58 PM     Click Here to See the Profile for Scott Martin     Edit/Delete Message   Reply w/Quote
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
Registered: Feb 2008

iconnumber posted 01-02-2010 05:35 PM     Click Here to See the Profile for chase33     Edit/Delete Message   Reply w/Quote
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
Registered: Jul 2003

iconnumber posted 01-03-2010 10:05 AM     Click Here to See the Profile for doc     Edit/Delete Message   Reply w/Quote
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
Registered: Apr 99

iconnumber posted 01-03-2010 10:20 AM     Click Here to See the Profile for wev     Edit/Delete Message   Reply w/Quote
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

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:


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.
Click here to Register for a Free password

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.


| Home | Order | The Guide to Evaluating Gold & Silver Objects | The Book of Silver
| Update BOS Registration | Silver Library | For Sale | Our Wants List | Silver Dealers | Speakers Bureau |
| Silversmiths | How to set a table | Shows | SMP | Silver News |
copyright © 1993 - 2022 SM Publications
All Rights Reserved.
Legal & Privacy Notices