|
|
Post by bruckner8 on Oct 7, 2023 18:19:57 GMT
I have no problem designing/using my own inventory system (Excel, Access, SQL Server, whatever), but I'd like to find all of the DATA somewhere, so I can just "look it up" and choose what I have in my own inventory. Doesn't there exist a database somewhere that has every O Gauge train/rolling stock across all manufacturers, with years produced, and estimate values based on condition?? I just inherited my dad's trains, including dozens of Lionel, MTH, WIlliams steam locomotives, from pre-war and postwar. I gotta believe someone has all of the data so I can just "pick it" from a list. Otherwise, I'll have to spend time looking up every single item in a web search, finding prices, making a best guess about its year manufactured, etc. Or, I'll be inudating this fourm with questions and pictures...and you don't want that!!
Please, someone, point me in the right direction of a website or database that already has every single O gauge locomotive and rolling stock stored somewhere!!!
|
|
|
|
Post by Traindiesel! on Oct 8, 2023 3:20:48 GMT
…. Doesn't there exist a database somewhere that has every O Gauge train/rolling stock across all manufacturers, with years produced, and estimate values based on condition?? …
Some were beta models and their websites warned users to keep a copy of the data they entered, just in case.
So us train people have to enter our own data into our own design. I still haven’t done much with the iMac “Under My Roof” program yet. So far it doesn’t look like a traditional database so I need some time to figure it out.
Depending on the operating system you use you can check out the Google or Apple Store for inventory programs. But none I have found are specifically for trains.
|
|
|
|
Post by robert on Oct 8, 2023 13:00:56 GMT
My friend and I use Excell. His is very up to date.
|
|
|
|
Post by Adam on Oct 9, 2023 11:20:33 GMT
One site you may try is www.hobbydb.com/. I use it to manage my Brooklin model collection and they do have trains in their database. However, I do not know how complete their database is. For Brooklin, it is fairly complete. |
|
|
|
Post by atsda on Oct 9, 2023 18:56:55 GMT
Curtis, glad to see you back posting. I catalog my trains and items using an Excel spreadsheet. I don't have much and it serves my purposes well. I have item name, description, year of manufacture, condition, purchase and repair dates, and a lot of other background info. Alfred (I also use Excell to catalog layout track routes (switch positions) and wiring info. I also used it to catalog consist make up and route info - I did this for someone who was affiliated with a small train museum and needed a way of directing volunteers on how to put trains together and make runs.)
|
|
|
|
Post by stoshu on Oct 9, 2023 23:12:20 GMT
Look at Apache open office. It's free and pretty good.
This way you have lost nothing but a little time...
|
|
|
|
Post by bruckner8 on Jan 29, 2024 19:45:20 GMT
I have no problem designing/using my own inventory system (Excel, Access, SQL Server, whatever), but I'd like to find all of the DATA somewhere, so I can just "look it up" and choose what I have in my own inventory. Doesn't there exist a database somewhere that has every O Gauge train/rolling stock across all manufacturers, with years produced, and estimate values based on condition?? I just inherited my dad's trains, including dozens of Lionel, MTH, WIlliams steam locomotives, from pre-war and postwar. I gotta believe someone has all of the data so I can just "pick it" from a list. Otherwise, I'll have to spend time looking up every single item in a web search, finding prices, making a best guess about its year manufactured, etc. Or, I'll be inudating this fourm with questions and pictures...and you don't want that!! Please, someone, point me in the right direction of a website or database that already has every single O gauge locomotive and rolling stock stored somewhere!!! To circle back on this, I wound up developing my own system using SQL Server (backend) and MS Access (frontend). Since there's no single repository of model train data, I had to make a system that could easily do web searches. With a Manufacturer and Part Number entered into my system, an automatic Google search will return Road Name, Description, etc, as well as recent eBay lots, and other vendor hits. The user could merely copy/paste data from there (instead of typing every other detail). Saving the links is part of the operation. Lucky for me, my lady-friend enjoys working on this project with me, and she does all of the data entry, as I pull my dad's boxes out of the closet, and the item off the layout (or display shelves). The app runs on my machine at home, but we use an iPad and TeamViewer to remote into it. We've already boxed and entered data for 125 pieces of rolling stock; about half done. Not to mention the accessories, track and other sundry items!
|
|
|
|
Post by Adam on Jan 29, 2024 19:49:30 GMT
Sounds like a great piece of work. You may want to consider posting your work up on Github for others to leverage.
|
|
|
|
Post by atsda on Jan 29, 2024 20:14:02 GMT
Bruckner8, Welcome to the OGF. Sounds as if you have developed a good inventorying system. As for a searchable database of O Gauge trains, I can't say. Perhaps AF3020 or harborbelt70 may have an idea. Maybe a call to the TCA Reference Librarian may give you a lead. Alfred
|
|
|
|
Post by curtis on Jan 29, 2024 22:11:51 GMT
Ah sounds great but is it possible for us to get it?
|
|
|
|
Post by healey36 on Jan 31, 2024 14:55:18 GMT
My friend and I use Excell. His is very up to date. I use Excel also. It has a lot of database functionality (search/sort), you can attach images, other docs, etc. The problem is being diligent and keeping it up-to-date.
|
|
