Skip to main content

User Friendly Inventory/Catalog System

 

I am using Microsoft Word and Microsoft Frontpage to create my own custom Model Railroad Inventory/Catalog. Rather than just a simple inventory list I have created a real full color catalog with multiple photo illustrations and other graphics as needed.

 

First  I have created a "web" which runs using Microsoft Explorer.  This "web" contains many web pages which describe the various models in my collection.  These pages are "hyper linked" so that I can "point and click" and move from manufacturer to manufacturer or model type to model type just like an ordinary internet web site. The "web" also has a comprehensive index (and sub indexes) which allows me to select a manufacturer or model type and "point and click" again to make a selection.

 

Note: I can either "run" the web from my computer in Internet Explorer or make a "CD" that contains the "web" and open the CD on any other computer using Internet Explorer.

 

Second I have a Microsoft word "form" which I use to capture information about a specific model. The "form" allows me to create a "catalog sheet" with information very similar to what is shown on the MTH Product Locator Site.  I can also add various other data such as condition of the model or current market value or any other notes.

 

Next I convert the form to a "catalog" web page (HTML document). I can then add any number of photos of the item or other graphics to the page. Next I add this HTML document to my "web".

 

I can then open the "web" on my computer using Internet Explorer and "navigate" the catalog pages as I wish.

 

A nice feature of this system is that once the "web" is completed it can be run on any PC that has Explorer.  To use you do not need to buy any costly software to view the "web".

 

Actually the "web" can be run using other internet "browsers" since it uses standard HTML.

 

Original Post

Replies sorted oldest to newest

This sounds like a pretty nice project, but be careful of which features you use within Front Page.

 

Many of Front Page's features are proprietary to Microsoft and will only run on a Windoze computer or server. Unix and Linux servers, which comprise the majority of web servers in use because they are much more stable than Windoze servers, are out of luck. Also, much of the code generated by Front Page is not "standard" HTML.

 

I used to use Front Page to develop web sites for clients. As I climbed the learning curve, I soon found out that it was not a good tool for doing that. It had too many Microsoft-specific "gotchas" to be a broad-base development tool. For that reason Front Page is not typically used by serious web developers.

A more comprehensive web design would use Microsoft Access. Then the web pages would be "built" dynamically using the current data in Access. This however is a more complex approach but it has advantages. This approach requires skills in programming with Access but once set up is a very good way of building an inventory system.

 

Note: I happen to have a copy of FrontPage which I purchased many years ago. (Now this software is obsolete. It has limitations but it still works for me).

 

There are other more capable software products on the market for the professional web builder.

For those inclined to build their own web based inventory/catalog I would suggest the following free software.

 

SeaMonkey

http://www.seamonkey-project.org/

 

The SeaMonkey project is a community effort to develop the SeaMonkey all-in-one internet application suite (see below). Such a software suite was previously made popular by Netscape and Mozilla, and the SeaMonkey project continues to develop and deliver high-quality updates to this concept. Containing an Internet browser, email & newsgroup client with an included web feed reader, HTML editor, IRC chat and web development tools, SeaMonkey is sure to appeal to advanced users, web developers and corporate users.  Under the hood, SeaMonkey uses much of the same Mozilla source code which powers such successful siblings as Firefox, Thunderbird, Camino, Sunbird and Miro. Legal backing is provided by the Mozilla Foundation.

 

Excel Spreadsheet:

 

I have also used an Excel Spreadsheet for simple lists. There are ways of formatting a spreadsheet to make data entry easier. Each "cell" can be formatted to "protect" cells which do not have data.

 

A very simple "example" list in Excel is attached (as a PDF only). The area highlighted in blue cannot be altered by the user since it is protected. Moving from cell to cell requires only a "tab".

 

 

Attachments

Post

OGR Publishing, Inc., 1310 Eastside Centre Ct, Suite 6, Mountain Home, AR 72653
800-980-OGRR (6477)
www.ogaugerr.com

×
×
×
×
Link copied to your clipboard.
×
×