Stamp Community Family of Web Sites
Thousands of stamps, consistently graded, competitively priced and hundreds of in-depth blog posts to read








Stamp Community Forum
 
Username:
Password:
Save Password
Forgot your Password?

This page may contain links that result in small commissions to keep this free site up and running.

Welcome Guest! Registering and/or logging in will remove the anchor (bottom) ads. It's Free!

My Stamp Collecting Database Project

 
To participate in the forum you must log in or register.
Author Previous TopicReplies: 15 / Views: 4,596Next Topic  
Pillar Of The Community
United States
2941 Posts
Posted 01/29/2012   11:05 am  Show Profile Bookmark this topic Add PostmasterGS to your friends list Get a Link to this Message
I recently decided to rebuild the database I was using to track my stamp collection. After slaving over the keyboard for about a week, I think I have a good, workable system.

It still needs a lot of work on the backend to import the catalog data from my old database, but it's coming along nicely.

Check it out! (it's a lot easier to follow if you blow the video up to full screen)
Send note to Staff
Presenting the GermanStamps.net Collection - Germany, Colonies, & Occupied Territories, 1872-1945

Pillar Of The Community
Canada
1227 Posts
Posted 01/29/2012   12:59 pm  Show Profile Bookmark this reply Add mhc99 to your friends list  Get a Link to this Reply
Wow, congratulations Postmaster on creating an impressive and well organized database. I collect Germany as well but nothing compared to the extensive collection that you have amassed.

By the way, you put together a great video.

Send note to Staff  Go to Top of Page
Valued Member
United States
109 Posts
Posted 01/29/2012   6:41 pm  Show Profile Bookmark this reply Add falconrw to your friends list  Get a Link to this Reply
Impressive>>> Both the Software and the collection are fantastic. I wonder which you spend the most time doing, the stamp collecting or the writing of the software?
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
2941 Posts
Posted 01/29/2012   6:51 pm  Show Profile Bookmark this reply Add PostmasterGS to your friends list  Get a Link to this Reply
I spend a lot of time at the intersection of stamp collecting and computers.

When I get tired of working on the database, I work on the website.

When I get tired of working on the website, I work on scanning stamps.

When I get tired of scanning stamps, I work on designing and printing album pages.

When I get tired of building pages, I work on the database.

Repeat ad infinitum.
Send note to Staff  Go to Top of Page
Presenting the GermanStamps.net Collection - Germany, Colonies, & Occupied Territories, 1872-1945
Pillar Of The Community
USA
939 Posts
Posted 01/31/2012   01:28 am  Show Profile Bookmark this reply Add Cimarron_Warrior to your friends list  Get a Link to this Reply
Very nice work Postmaster. Would anyone happen to know of a decent stamp program that would be freeware. I have seen several that are very good programs, but of limited funds after taking care of living expenses doesn't leave much to be able to buy these programs with. Any info would be greatly appreciated.
Send note to Staff  Go to Top of Page
Valued Member
United States
396 Posts
Posted 02/20/2012   9:24 pm  Show Profile Bookmark this reply Add tikithindi to your friends list  Get a Link to this Reply
Very very good Program PostmasterGS. I like very much.
And appreciate your hard work toward building Database.



tikithindi
Send note to Staff  Go to Top of Page
Rest in Peace
Canada
5701 Posts
Posted 02/20/2012   9:29 pm  Show Profile Bookmark this reply Add BeeSee to your friends list  Get a Link to this Reply
Top notch PMGS
Send note to Staff  Go to Top of Page
BeeSee in BC
"The Postmark is Mightier than the Stamp"
http://brcstamps.com ---- BNAPS, RPSC, APS
Pillar Of The Community
Learn More...
United States
3046 Posts
Posted 02/21/2012   8:00 pm  Show Profile Bookmark this reply Add apastuszak to your friends list  Get a Link to this Reply

Quote:
Very nice work Postmaster. Would anyone happen to know of a decent stamp program that would be freeware. I have seen several that are very good programs, but of limited funds after taking care of living expenses doesn't leave much to be able to buy these programs with. Any info would be greatly appreciated.


The only one I found which was half decent was GCstar. Another was Datacrow. With Datacrow you will need to download the stamp collecting module yourself.

Or you can ask that that awesome database in this video me made available.
Send note to Staff  Go to Top of Page
Valued Member
United States
93 Posts
Posted 02/22/2012   5:05 pm  Show Profile Bookmark this reply Add Scanstamps to your friends list  Get a Link to this Reply
Very nicely done, PostmasterGS!

I'm looking to do something similar for my classic Denmark and Sweden collections, and have been contemplating whether to tweak a canned inventory application, or use MSAccess to build my own from the ground up.

For me, the issue with readymade apps is that they tend to be geared to collecting "one of each" and they are typically very "USA-centric." I need to be able to enter values in different currencies, and track large numbers of variations and different cancels on the SAME basic stamp... with resulting values being "the BASE stamp PLUS a particular premium."

Most of this seems too advanced/complex for a pre-made app.

Whereas I mostly know HOW, I'm not a big fan of extensive coding... I think the last time I actually built/coded an Access database was with Access97 or maybe 2000... but I can't imagine it has changed hugely, in terms of basic structure. Maybe it's even more widget driven, now?

Anyway, thanks for sharing... feeling a bit inspired, now!
~Peter
Send note to Staff  Go to Top of Page
Pillar Of The Community
United Arab Emirates
507 Posts
Posted 02/23/2012   04:51 am  Show Profile Bookmark this reply Add james to your friends list  Get a Link to this Reply
The BEST demo. of an organized and superb collection I've ever seen in my life!


Cheers
Send note to Staff  Go to Top of Page
Valued Member
United States
164 Posts
Posted 02/23/2012   09:47 am  Show Profile Bookmark this reply Add Footballphilately to your friends list  Get a Link to this Reply
Really nice, finding a good software is hard. You've made it yourself.
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
2941 Posts
Posted 02/23/2012   8:44 pm  Show Profile Bookmark this reply Add PostmasterGS to your friends list  Get a Link to this Reply
Thanks all! It's a labor of love, and one day I'll actually finish it...
Send note to Staff  Go to Top of Page
Presenting the GermanStamps.net Collection - Germany, Colonies, & Occupied Territories, 1872-1945
Pillar Of The Community
United States
2941 Posts
Posted 02/27/2012   9:42 pm  Show Profile Bookmark this reply Add PostmasterGS to your friends list  Get a Link to this Reply
Peter,

The trick is getting/inputting the catalog data. If you had the catalog data in an importable format, it would be fairly easy to adapt the basic design to allow for additional currencies, premiums for cancels, etc.
Send note to Staff  Go to Top of Page
Presenting the GermanStamps.net Collection - Germany, Colonies, & Occupied Territories, 1872-1945
Valued Member
Canada
78 Posts
Posted 02/27/2012   11:58 pm  Show Profile Bookmark this reply Add nodeli to your friends list  Get a Link to this Reply
PostmasterGS, very impressive indeed! The ease that you demonstrate in the video shows the program is a winner. Keep on building :)
Send note to Staff  Go to Top of Page
New Member
Australia
1 Posts
Posted 05/12/2012   02:58 am  Show Profile Bookmark this reply Add oldpos to your friends list  Get a Link to this Reply
Hi, what a great program. Any chance of releasing it, I'm looking for something just like it.
Send note to Staff  Go to Top of Page
Valued Member
United States
45 Posts
Posted 05/12/2012   06:35 am  Show Profile Bookmark this reply Add bzurer to your friends list  Get a Link to this Reply
I am also developing a stamp database. There is a thread below where I introduced it. It is hopefully going to be a collaborative site where everyone can use the contributions of others to keep track of their own collection. If you are interested in perhaps collaborating or sharing our experiences, I would greatly appreciate it. you can contact me at robert at zurer dot com.
Send note to Staff  Go to Top of Page
  Previous TopicReplies: 15 / Views: 4,596Next Topic  
 
To participate in the forum you must log in or register.

Go to Top of Page

Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Stamp Community assumes no liability for errors. Copyright 2005 - 2026 Stamp Community Family - All rights reserved worldwide. Use of any images or content on this website without prior written permission of Stamp Community or the original lender is strictly prohibited.
Privacy Policy / Terms of Use    Advertise Here
Stamp Community Forum © 2007 - 2026 Stamp Community Forums
It took 0.36 seconds to lick this stamp. Powered By: Snitz Forums 2000 Version 3.4.05