railandsail Mainesam Apple is soon going to a 64 bit format so all older programs and most legacy programs will no longer work if you upgrade to latest IOS this Fall. I would, therefore, be very suspect of using older program. Excel should continue to work well, even though no photos. An option for photos might be a group of albums in the IOS photo app. Does that mean that many persons that have their inventory on an older program will no longer be able to read it on a new system / computer??
Mainesam Apple is soon going to a 64 bit format so all older programs and most legacy programs will no longer work if you upgrade to latest IOS this Fall. I would, therefore, be very suspect of using older program. Excel should continue to work well, even though no photos. An option for photos might be a group of albums in the IOS photo app.
Apple is soon going to a 64 bit format so all older programs and most legacy programs will no longer work if you upgrade to latest IOS this Fall. I would, therefore, be very suspect of using older program.
Excel should continue to work well, even though no photos.
An option for photos might be a group of albums in the IOS photo app.
Does that mean that many persons that have their inventory on an older program will no longer be able to read it on a new system / computer??
I'm guessing that's only an issue if you're constrained by using a Mac.
I've been using 64-bit versions of Windows for many years now, and the (not always "older") 32-bit versions of programs continue to Always Just Work.
To get back on topic, my inventory tool of choice is a database using OpenOffice's "Base". It's similar to Access, except IMHO it's much easier and more intuitive. (And that's from the perspective of having retired from a 40-year IT career!)
It's very easy to suck out some specific set of data using a query, and format into a readable report if you so desire. You want a report showing all your 50-foot box cars, broken down by manufacturer and sorted by road number within road name? No problem, use Base's in-built report wizard!
Oh, and OO runs on Windows, Linux, and Mac so everyone's covered. IIRC, they also have an Android reader, although I just create a PDF when I need something on my phone.
Brian
My Layout Plan
Interesting new Plan Consideration
PRR01 Are there any useful train inventory software programs? I am looking for something a step up from Excel. A lot of the discussions I found on MR or google are really old, and links to many systems don't exist.
Are there any useful train inventory software programs? I am looking for something a step up from Excel. A lot of the discussions I found on MR or google are really old, and links to many systems don't exist.
I use excel mainly because I get the entire office suite for home use at next to nothing through the Microsoft Home User Program. I think it was like $10 so you should see if your employer participates.
Joe Staten Island West
Brian,
You want Calc:
https://www.openoffice.org/product
Tom
https://tstage9.wixsite.com/nyc-modeling
Time...It marches on...without ever turning around to see if anyone is even keeping in step.
What would the equivalent program be in Open Office suite?
Another vote for Excel. I can also use it on my cellphone, which makes it handy and convenient to check when I'm out n' about at a train show or LHS.
I don't think anything can do a better job of a simple inventory sheet than Excel does.
.
-Kevin
Living the dream.
I have used JMRI and Easy Model Railroad Inventory (EMRI). EMRI is also freeware available on the internet. I have been frustrated with both, so I have gone back to using Excel and am happy as a clam.
Bear "It's all about having fun."
This is an old thread that has been brought back to life so l will throw in my approach. Like many, I used Excell for many years and it worked well for me. But then I started implementing JMRI OperationsPro. Since OpsPro also has a car inventory feature included and it is a required element to run OpsPro, I decided I did not want to maintain two seperate inventories. I am still in transition but when I am done, my OpsPro inventory list will be my only list. I can still export my OpsPro list to an Excell sheet any time I want if I want an Excel version to look at. The only flaw in this approach is that the OpsPro file does not allow as many fields to play with as I do in Excel.
Paul D
N scale Washita and Santa Fe RailroadSouthern Oklahoma circa late 70's
Having started to inventory my small fleet, I found Excel works fine. Excel provides what I need to then convert the list to car cards and way bills. These tools help me to create more operations than simply keeping track of the cars.
The questions to ask are why you need an inventory system? How much time you plan on spending in updating it? Want something free or with a cost? Should you want something quick, flexible, and free, go with Excel.
G Paine At Boothbay Railway Village, we use Easy Model Railroad Inventory. It is a freeware program. http://easy-model-railroad-inventory.software.informer.com/5.4/
At Boothbay Railway Village, we use Easy Model Railroad Inventory. It is a freeware program.
http://easy-model-railroad-inventory.software.informer.com/5.4/
I was really surpried that this one was only mentined once in this subject thread? On another forum it came highly recommended.
https://easy-model-railroad-inventory.software.informer.com/5.4/
Canalligators I would go back a step, and ask why have an inventory at all?
I would go back a step, and ask why have an inventory at all?
For me, it's mainly to keep a record of what all I have should the unthinkable happen and I have to replace anything.
Several years ago, I purchased a model railroad database program called Train Track. It worked great, but I could only install it on either my PC or my laptop. I chose my laptop since I could take it down to the basement with me. Last year, I had to upgrade my PC and later my laptop since they were unable to go past Windows XP. I got a new PC and laptop running Windows 10. I went to contact the place I'd gotten Train Track from before, but they're apparently no longer around. I was going to keep my old laptop for just the database, but video going out on the laptop forced me to get screenshots of the rolling stock records before retiring the laptop.
When I'd purchased the new laptop, I'd also purchased the full version of Office 2016 through my company's home use program where we could get one copy of it for only $10. With it came Access 2016. I'd never used Access before, but after watching tutorial videos for Access on YouTube, it really isn't difficult to use. I've been able to recreate the original database with little effort, even customizing it to include maintenance/service records for my locomotive fleet. By learning Access, I've also found other uses for it with my inventory of books, DVDs, CDs, etc. around home, which I already had on Excel spreadsheets but have since converted.
Kevin
http://chatanuga.org/RailPage.html
http://chatanuga.org/WLMR.html
I use a program called RRTrains2000.
It provides a listing/form that includes Model, RoadName,Number, Color, Scale, Era, Category, Type, Coupler DCC?, Manufacturer, Catalog Number, Date purchased, and Value. There is also a place for a photograph.
The program is easy to use and best of all its free. Here is the link, just scroll down the page to RRTrains2000.
http://www.gregorybraun.com
Remember its your railroad
Allan
Track to the BRVRR Website: http://www.brvrr.com/
CanalligatorsI would go back a step, and ask why have an inventory at all?....
I had a couple of reasons for creating an inventory. One was to keep track of all my free-lanced home road equipment. Stuff suitable for the '50s, '60s and early '70s has all been sold-off or given away, but I don't want to re-use numbers, just in case I do another era change and the same friends (or strangers) buy stuff with numbers identical to what they bought last time.
My other reason for an inventory was to aid in disposal of stuff after I go for that last train ride. A friend and I have a mutual agreement to take care of that for the first one of us out of the picture. It just makes things a little simpler, and that's the only reason I included prices in mine - not as if he has to get that price, but only to ensure that he doesn't over-value things, as he's commented, more than once, that the numbers are too low. The whole idea is to get rid of it, so I disagree.
A minor consideration, especially for the models of prototype rolling stock and locomotives, is the record of car types and, more importantly, car numbers. It's much easier to check the written record than to go through hundreds of boxes just to make sure that I'm not lettering a new boxcar with the same number as one already on the layout.With my luck, I'd post a photo here of a train on my layout, with two identically-numbered cars coupled to one another, and not notice it until 27 others had pointed out my error....sorta negates the reason for choosing to letter almost all of my rolling stock, rather than go with factory paint and lettering.
Wayne
I would go back a step, and ask why have an inventory at all? I used to keep my inventory (homemade Access tool), but I wasn't using the information for anything. My intent was to keep a maintenance history, so it could generate a list of pieces that were due for service, but I spent a lot of time entering info when I was just giving things an annual once-over anyway. And all the bad ordered bits are parked on a service lot anyway.
I guess there's an attraction to having a nice list. Or if you do a lot of buying and selling, being able to keep track of what is available to sell/barter. I've gotten over wanting a nice list and don't do a lot of equipment changes.
Keep an inventory if you like, but only if you have a good use for the data. Otherwise you're pounding in info and updates with no return benefit.
Genesee Terminal, freelanced HO in Upstate NY ...hosting Loon Bay Transit Authority and CSX Intermodal. Interchange with CSX (CR)(NYC).
CP/D&H, N scale, somewhere on the Canadian Shield
Great questions!
I'm not sure what size of collection has to do with an inventory program (OK if you only have 1 loco and 4 cars, you probably DON'T need an inventory program). In addition to having a full list of everything I bought (which is stored on my server, which is backed up to a cloud backup, thus it will survive any disaster that should happen to my home), which would come in very handy for insurance purposes (some day I will get around to having a full photo roster as well), I added my own report to the database (which wasn't int he odler versions, but is now) that makes a small rather high density list of road names and numebrs that I can take along to train shows and keep from buying duplicate equipment.
There are fields in this database to record what you paid for a piece, what it might be worth now, and other stuff like what kind of couplers it has (I use all Kadee, but not everything takes a #5 or #148), what kinds of wheels (I repalce all plastic wheels with metal, but there are several kinds, plus a subset of my rolling stock has resistor wheelsets to active the detection system at the club - eventually all will be so equipped as I will be installing detection and signalling on my layout). Plus many other things that I don't necessarily use. When I come home with some new kits, one of the first things I do is enter them into the database, using one of the notes fields to indicate "unbuilt kit", which gets removed once I get around to building it. It's extremely useful to know what you have, and in many cases, when you got it.
--Randy
Modeling the Reading Railroad in the 1950's
Visit my web site at www.readingeastpenn.com for construction updates, DCC Info, and more.
I use free "My Railroad Apps" menu on Dallas Model Works website. Can be as simple or detailed as you want.
Dave
USAF (Retired)
PRR01Are there any useful train inventory software programs?
Wow, I wouldn't know where to begin doing this. I never have. So much has come and gone.
It just always seemed so unimportant to me, way too much "bookkeeping". I guess what shelves and boxes of stuff I have, must fail in volume comparison as to what many of you have, that you need an inventory program to keep track of it all.
I know one thing, that if I was to start a list, or inventory, I would use any one of the office programs, such as Excel, that I already have on my computer(s).
Good luck PRR01 with your "inventory control".
Mike.
My You Tube
I use Dave Husman's CarCard Generator which does a whole lot more than car cards, it has a full and detailed inventory of locomotives and rolling stock as well as structures and other model railroad items. PLUS it does the car cards and waybills and switch lists for operation, if you so desire.
Old? So what? It's a model train inventory, what has changed in 10 years? Being a niche within a niche within a niche, model train inventory software isn;t under the pressure to add umpteen new features every couple of years like more mainstream stuff like word processors and spreadsheets. As such, the software is stable and relatively bug free as the authors concentrate on making sure it works instead of adding feature after feature that hardly anyone needs.
I use 'Yard Office'. It is a free inventory program designed specifically for model railroaders. I liked it enough that I bought the upgrade. The program is set up to allow you to store just about any information about each piece of rolling stock that you could want. It also allows you to attach multiple pictures to each listing.
http://www.musicmixradio.com/yardoffice/
Note that the Yard Office home page isn't displayed properly when I use Chrome. There is some overlapping text. You may have to try another browser.
I'm just a dude with a bad back having a lot of fun with model trains, and finally building a layout!
George In Midcoast Maine, 'bout halfway up the Rockland branch
I go another step and use Google Sheets. That way I can look something up on the road.
Excel is best, Access would be overkill. It would be pretty easy to write some simple VBA (i.e. macros) and use a basic userform to make data entry easier. That way you wouldn't have to put it all in rows and columns, the macro/userform would do it for you.
Excell spread sheet.
Just easy, and no extra software costs, as it came with my purchase of office.
I have one sheet loco's, one sheet freight cars, one sheet electronics and trackage, and one sheet "accessories", which is anything that doesn't fit the other categories listed. (Buildings, automotive models, tools, etc...)
Yes, other programs allow photos to be included, but, no big deal for me there.
Ricky W.
HO scale Proto-freelancer.
My Railroad rules:
1: It's my railroad, my rules.
2: It's for having fun and enjoyment.
3: Any objections, consult above rules.
I've used Excel too, and have found it to fill every record keeping need. I print a copy of the freight car inventory to take to train shows to avoid buying duplicates.
I'm in the process of programming Excel to inspect the cars, clean the wheels and correct coupler height as needed, but progress has been slow.
Jim
I did a multipage inventory using Excel (with some help from my daughter). I like the fact that I can update it at any time, even on my Mac, which doesn't otherwise seem to play very well with MS Word.
Here's a partial screenshot...(click on it for an enlarged view)
It also allows me to keep track of all of the home road cars I've owned over the years, so that a car number is never duplicated unless I know for sure that the original has been destroyed.
RR_MelI agree with Mouse
Take note people. Having someone agree with me just doesn't happen every day.
Chip
Building the Rock Ridge Railroad with the slowest construction crew west of the Pecos.