Stock database?

[bluedepot]

i look forward to the day when i need a database for all my stock!!! still got a lot of collecting to do though...

tim

[kirky]

Ta da!

http://www.modular-model-railroads.com/2010/09/model-train-inventory-software/

You've got some reading in your future I think!

Nice one Polo, that is a great find. I never knew it was called 'inventory software' let alone that there was so much available.

Cheers
Kirky

[grid078]

Made it out into the garage and have unearthed the copy of model rail with the database/inventry reviewed. There is a free download to evaluate with and a buy option. The link is:-
http://www.archive.org/download/http://www.archive.org/details/tucows_324651_Track_Those_Trains

Hopefully it will do what you want, i`ve just downloaded the free version and had a quick play, yes it is an old program, June 2004 looks like the last update, but it does allow you to list, add photo`s, insurance value, price paid etc etc, it also allows you to list other gauges if you collect other makes/gauges etc.

Stu

[CarriageShed]

Being totally anal (and also self-employed, so good record-keeping is a must), I have a stock list of all of my rolling stock in Excel. If you haven't managed to find a solution in the last year or so, I'd be happy to give you a blank copy of mine for your own use.

[DCCDave]

I’m a software engineer by trade so I wrote my own, because I can!

It’s a web application with sections to manage locomotives, carriages and wagons, to enable me to assemble them into trains and put together a schedule for running them on the layout.

Below are a few screenshots to give you a flavour:



The welcome screen with shortcuts to major areas of the application. The menu at the top can also be used to move through the applications sections.



The locomotives list page. A picture of each locomotive is shown, along with its running number and a basic summary. Clicking on the locomotive drills down to the detail page for that locomotive. Note that the list can be sorted using a number of criteria listed on the left under ‘order by’.



The detail page shows complete data for the locomotive. This Class 108 DMU has a DCC decoder fitted which is signified by the decoder chi graphic toward the top right. Details of the fitted chip such as its type, short address and long address are shown under the ‘Control method’ heading. Note that the sub-menu to the left allows a history of modifications and maintenance (work), and running (outings) to be recorded.



Details of the model can be edited. Drop-down boxes are used to filter entries where sorting and grouping can be used elsewhere in the application. In this example the list of known coupling types is offered for selection of the rear coupling type. This information is used when assembling trains to ensure that adjacent vehicles have compatible couplings.



Here the history of modifications and maintenance is shown. Additional tasks can be added to the history.

Carriages and wagons are listed in a similar way from their own menu item and can have their own work history recorded.

Cheers
Dave

[Newportnobby]

Looks pretty comprehensive to me, Dave. Nice one

[DCCDave]

Looks pretty comprehensive to me, Dave. Nice one

Thanks Mick,

It still needs quite a bit of work to finish it off. I'm hoping I wont have time after next month if the railway room plans come to fruition.

Cheers
Dave

[Newportnobby]

Looks pretty comprehensive to me, Dave. Nice one

Thanks Mick,

It still needs quite a bit of work to finish it off. I'm hoping I wont have time after next month if the railway room plans come to fruition.

Cheers
Dave

I wonder if your priority would be the same as mine

[Richard G Dallimore]

Hi Dave you database looks very good and slick, will it be available for others one day?

[DCCDave]

Hi Dave you database looks very good and slick, will it be available for others one day?

Thanks Richard,

I've toyed with the idea although making it so robust as to be a product used by others not just myself would require further development. What sort of price do you think would be reasonable?

Cheers
Dave

[CarriageShed]

A licence for AnyRail track modelling software is £35, so I guess something around that mark would also be fair for a pretty decent database package.

[daveg]

An impressive database. It'll be interesting to see if Dave does offer it at an attractive price to (at least) NGF members at some point.

I'm currently using Excel with some photos and links to info pages for the locos.

Dave G

[Richard G Dallimore]

It depends on what if any information is already in the database.
I think £35 sounds good.

[trainsdownunder]

I have spent some time looking at all the "commercial" software out there.

Yard Office is very good, but detail held in the initial Dbase is all American. Some of the screens have too much info on them for my liking.

Easy Model Railroad Inventory was also well done but again for the majority here would need a lot of work as US based.

Tayden Design - All Aboard Data Express and others Is basically an Access Dbase and not particularly friendly. Not worth the money.

Link to others van be found here http://www.modular-model-railroads.com/2010/09/model-train-inventory-software/

[DCCDave]

Thank you all for your feedback.

The application is currently a web application which would make it impossible to package and distribute on a commercial basis. I'm in the process of converting it to a Windows application, which will mean it's easier to distribute.

Since I'm expecting my railway room conversion to be completed next month, I expect more of my available time will be spent on modelling, but I'll keep this group updated with progress on the Windows application

Cheers
Dave