Subscriber & Member Login

Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!

model train inventory software?

2304 views
22 replies
1 rating 2 rating 3 rating 4 rating 5 rating
  • Member since
    February, 2005
  • 12 posts
model train inventory software?
Posted by dmreed@dmreed.com on Saturday, February 19, 2005 12:14 AM
I have been looking for a program to inventory my collection. I would like one which can update the currents of the items. I have been looking at several inventory programs but none of them can automatically update current valuse.

any help would be greatly appreciated.

my email is dmreed@dmreed.com for any direct communications or offers.
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Saturday, February 19, 2005 2:10 AM
I keep a college ruled 150 page notebook. It goes with me to train shows and hobby shop sales. I cannot carry my great big desktop with me.
  • Member since
    July, 2003
  • From: Whitby, ON
  • 2,570 posts
Posted by CP5415 on Saturday, February 19, 2005 7:06 AM
I doubt you'd find one that will automatically update anything to "current" values unless your database was somehow connected to the manufacturers or supplies website.

Gordon

Brought to you by the letters C.P.R. as well as D&H!

 K1a - all the way

  • Member since
    June, 2003
  • From: Culpeper, Va
  • 6,683 posts
Posted by IRONROOSTER on Saturday, February 19, 2005 7:43 AM
Automatic updates would mean a subscription service and I doubt there is enough demand to make it worthwhile. Alternatively you could develop your own software to download pages from sites such as Walthers or Ebay and parse them for prices. This is not a trivial project, but wouldn't be difficult if you know how to develop software.

You don't say what scale you're collecting. The collectors market is really only well established for O & S toy trains. Resale prices for others are not well established and probably will require some estimating, something you would have to do manually in any event.
Enjoy
Paul
If you're having fun, you're doing it the right way.
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Saturday, February 19, 2005 11:29 AM
I use Excel, but I don't bother with "value". You might check out some of the more generic collection management programs. I doubt highly that you will find one that can automatically update prices however. Your best bet will be managing the collection with a software tool, but updating prices manually. Sorry.

-dave
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Saturday, February 19, 2005 12:03 PM
Current value is a tricky concept in my experience. The prices asked for models vary everywhere - on eBay they are often higher (or lower) than an LHS, and some LHS charge higher prices than others. I've seen Fleischmann cars that I bought used with a "sticker price" of £10 go for £20 on eBay (same car, same condition, and I'll be going back to that store again!). Price guides are often very far removed from reality - again, I've seen list prices well above what you'd pay for an item and also far below.

As far as cataloguing is concerned, I'd use something like Access (database package) and build a custom database. I've done this for some Hornby coaches in my collection, sorting by paint scheme, running number, manufacturer model number, etc. You could do this and add a "amount paid" section where you record what you paid for the item, then just check this against what they're now going for sometimes. Hope this helps!
  • Member since
    January, 2004
  • From: Chiloquin, OR
  • 284 posts
Posted by Bob Hayes on Saturday, February 19, 2005 5:05 PM
I wrote my own inventory program in Foxpro. Everytime I add something, I just print out a new list, and that goes with me to train shows. Also wrote an inventory and sales history program for a hobby shop 15 years ago. It's really easy using Foxpro. Almost like basic.

Bob Hayes
  • Member since
    January, 2003
  • From: US
  • 328 posts
Posted by bikerraypa on Saturday, February 19, 2005 5:25 PM
I use Frostbow Home Inventory for my trains and my other collections. It's only 20 bucks for the full version and it works really well. http://frostbow.com/
  • Member since
    January, 2005
  • 379 posts
Posted by dwRavenstar on Saturday, February 19, 2005 6:22 PM
Heyas,
I have no idea how this could be made to work but upon thinking it over I see several potential questions that it brings to relevance.

Were I to do this would I:

Depend upon one source for accepted value or have several available and accept one over the other by some predetermined criteria?

When deciding upon that criteria would I want the current value to reflect the best available price or the highest reported value of the item in question? (The age old dilema of either showing the Financial Controller that the money has been well spent or bargains have been discovered)

I guess one could use the highest possible value as an ego trip. Look at all the more I paid for this collection but think of how much it could be worth if I were to liquidate the whole thing.

Personally, I'm pretty much satisfied with knowing that I've undercut the SRP on most if not all of my collected bits and at least three of my diesels were purchased with the cash I've saved by ducking the state sales tax on my transactions online.

BTW I'm using a Data Village Model Collector version toi keep track of everything. Got it and just saw it again on Ebay for under ten clams.

dwRavenstar
If hard work could hurt us they'd put warning lables on tool boxes
  • Member since
    June, 2003
  • From: Colorado Springs
  • 728 posts
Posted by FThunder11 on Saturday, February 19, 2005 8:32 PM
Are there any freeware ones?
Kevin Farlow Colorado Springs
  • Member since
    May, 2003
  • From: Robe Valley, Wa.
  • 719 posts
Posted by GN-Rick on Sunday, February 20, 2005 2:23 AM
QUOTE: Originally posted by FThunder11

Are there any freeware ones?


I found a good freeware inventory program called "RRTrains 2000"
The website is: www.gregorybraun.com
Good luck.
Rick Bolger Great Northern Railway Cascade Division-Lines West
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Sunday, February 20, 2005 4:31 AM
www.openoffice.org has a free office package that includes a spreadsheet (along with word-processor and presentation software, both of which handle pretty much all file types). Not sure if they have a database package to go with this yet though - there'll probably be one along soon. Beats me why people pay a small fortune for MS Office when you can download something better for free (and legally)!
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Sunday, February 20, 2005 7:16 AM
It would be nice if the freeware ones allow you to attach a JPEG photo of the piece so you can even see the condition. A picture is worth a thousand words. :)
  • Member since
    November, 2003
  • From: PA
  • 1,582 posts
Posted by 8500HPGASTURBINE on Sunday, February 20, 2005 10:21 AM
You can attach a pic to this software.

http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=11644&item=5929218272&rd=1

  • Member since
    January, 2002
  • 1,132 posts
Posted by jrbarney on Sunday, February 20, 2005 12:44 PM
And, to add to the mix, here's a link to a model railroad collection software product from Oz:
http://www.gppsoftware.com/cmsstock/cmsstock.asp
Looks as though it has some nice features. Wish some of our Australian "cousins" would post a review of this product. It's from the outfit that sponsors the free downloadable quarterly of Australian British practice model railroading, Model Railways Online.
Bob
NMRA Life 0543
"Time flies like an arrow - fruit flies like a banana." "In wine there is wisdom. In beer there is strength. In water there is bacteria." --German proverb
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Tuesday, February 22, 2005 10:53 AM
QUOTE: Originally posted by mktrains

It would be nice if the freeware ones allow you to attach a JPEG photo of the piece so you can even see the condition. A picture is worth a thousand words. :)


The RRTrains software mentioned earlier does let you attach a picture to the description. It's a neat little program, and more than sufficient for my purposes (and probably most modelers).
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Tuesday, February 22, 2005 11:00 AM
if you can brave learning Microsoft access's advanced features, you can create a database, and a front end that will allow you to see pictures fo the object when you search on it.

Really, there's a lot of free stuff out there that will help you, course you also have to be willing to learn a little computer skills as well ;)
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Tuesday, February 22, 2005 11:13 AM
my dad has an old inventory system i think i am going to use it wont be able to ato updatte but it has a search bar and it is very well organized
  • Member since
    April, 2003
  • 282,437 posts
Posted by Anonymous on Tuesday, February 22, 2005 12:34 PM
QUOTE: Originally posted by Bob Hayes

I wrote my own inventory program in Foxpro. .Also wrote an inventory and sales history program for a hobby shop 15 years ago. It's really easy using Foxpro. Almost like basic.


is there a way you could put it on here for us to download or mabey you dont whant to put it up but if you could it would be great
  • Member since
    January, 2004
  • From: Chiloquin, OR
  • 284 posts
Posted by Bob Hayes on Tuesday, February 22, 2005 4:42 PM
I had to buy Foxpro in order to write the program, and you want me to give it away for free? Fat chance. I only mentioned it as a way to get an inventory program the way you want it. Besides, it wouldn't fit on this forum, even if the moderators would allow it. Free isn't always best. Just look at some of the free track planning software.

Bob Hayes
  • Member since
    August, 2004
  • From: Eastern Nebraska
  • 166 posts
Posted by SP4449 on Tuesday, February 22, 2005 10:47 PM
I use excel and every couple of years, purchase a Walthers catalog to get the prices.
  • Member since
    May, 2004
  • From: Ohio
  • 1,614 posts
Posted by Virginian on Wednesday, February 23, 2005 4:10 AM
Special software for that? I never even thought of that. I just used Excel. I guess Lotus would work too, or that Microsoft Works spreadsheet.
What could have happened.... did.
  • Member since
    December, 2002
  • From: US
  • 403 posts
Posted by bcammack on Wednesday, February 23, 2005 6:33 AM
QUOTE: Originally posted by Bob Hayes

I had to buy Foxpro in order to write the program, and you want me to give it away for free? Fat chance.


Funny, but I've always gotten far more satisfaction from knowing that people were utilizing and gaining benefit from the software I created than from the fact that it was "Mine! All mine!!" If your attitude was purvasive there'd be no Linux, Apache, Mozilla, etc.

Wouldn't he have to buy FoxPro, too, to run your app? Or will it compile to a freestanding executable? If so, doesn't FoxPro have a packaging wizard to make distribution painless the way Visual Basic does?
Regards, Brett C. Cammack Holly Hill, FL

Subscriber & Member Login

Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!
Popular on ModelRailroader.com
Model Railroader Newsletter See all
Sign up for our FREE e-newsletter and get model railroad news in your inbox!
ADVERTISEMENT
ADVERTISEMENT

Search the Community

ADVERTISEMENT
Find us on Facebook

Loading...