![]() |
|
![]() |
#1 |
Member
Join Date: Mar 2005
Location: USA Georgia
Posts: 1,599
|
![]()
Over the last 30 years, we have been collecting artifacts. For insurance purposes, we need to have/create a database that delineates each article, incorporates pictures, descriptions, etc.
We have about 1,000 items that need to be sorted and each item marked. I have a rough start. I made a list of all the items for insurance purposes. Brief description and have many images and many images are keyed to the item. Many of the items had a small stick on labels. and they fell off. But all this is just paper, handwritten lists. I want to have a flexible system that can show each item. A system that can mark each item individually. Please help me find a database/system? For the PC. |
![]() |
![]() |
![]() |
#2 | |
Member
Join Date: Mar 2010
Location: Olomouc
Posts: 1,693
|
![]() Quote:
|
|
![]() |
![]() |
![]() |
#3 |
Member
Join Date: Jun 2020
Location: Germany
Posts: 244
|
![]()
I use an Excel table to list my pieces and give each of them a number which depends from the item category. For example, a dagger could have the number D0103.
For each piece I made some photos I save together with the Excel table in a folder. The pictures have the item number + the picture number as name, for example D0103_1 for the first picture of a dagger. Not the most elegant way, but it works and you can use all the functions of Excel. Regards Robin |
![]() |
![]() |
![]() |
#4 |
Member
Join Date: Mar 2005
Location: USA Georgia
Posts: 1,599
|
![]()
Ian, I am looking at your suggestion. Free to collectors. A bit overkill for me. I am looking for an inventory number, description, image (could be multiples), from who I purchased it, and when.
Gonzoadler, I like the simplicity of excel and downloaded a few templates. CHecking to see how to embed images. I guess I can attach labels with zip ties? Other ideas. I have seen some museum tags are painted in tiny numbers on the items in unobtrusive areas. |
![]() |
![]() |
![]() |
#5 | |
Member
Join Date: Mar 2010
Location: Olomouc
Posts: 1,693
|
![]() Quote:
|
|
![]() |
![]() |
![]() |
#6 |
Member
Join Date: Jun 2013
Posts: 2,145
|
![]()
You can also look at freewares for libairies, books, coins, stamps, wine...
It will work for weapons too. My advice, take something simple to use otherwise you will never use it. |
![]() |
![]() |
![]() |
|
|