You can also drag a picture of the item for reference. You'll be presented a new record where you can begin typing in the inventory details, such as Category, Manufacturer, Item and Model details, Part numbers, location and costing. Type the name you want for the database (in case you'll have multiple inventory databases), specify where you want to save it, and click Choose. When you start out FileMaker Pro 12, just click File > New From Starter Solution… and select Inventory. It's fully unlocked so you can view and modify the database tables, relationships, layouts, and scripts. It's one of the 16 pre-made templates that's available for you to start using for your database requirements. "Tradition is not the worship of ashes, but the preservation of fire." -Gustav MahlerThe Inventory Starter Solution is a quick way to monitor your business' products and services details, location, and costing information. I am looking for suggestions and recommendations. Here's your chance to chime in on your favorite (or maybe most hated) product. To compare before they will sign off on a purchase. But admin wants several programs or applications I already talked to Tim Barnes about Gazelle which actually looks quite promising. I don't like Excell and wanted something specific to pianos. Work, work completed for projects and regular tuning/maintenance. The tech that just retired kept track of everything on index cards and I am trying to modernize and set up tracking for pianos in need of I have taken over the Piano Tech position at University of Tennessee. Subject: Piano inventory and maintenance program Subject: RE: Piano inventory and maintenance program If you wish to chat more please feel free to contact me. (Wishin' it were that easy for real!!!!) You can also create an easy to read spreadsheet out of the information. You can also "move" pianos from room to room with the touch of a key. Once set up it is very easy to use and even my students are able to enter their portion of the work they have done. ![]() Other items include setting up future work at a glance, inventory management and even budgeting and cost of repairs. With the program I am able to now track the work of course which is the prime function as far as our technical work. The second time around, now at the U of Oregon, the learning curve was much less and the time to input the inventory was about one half the amount of time. ![]() Please bear in mind a good deal of that time was learning the new system. We have about 140 instruments to track.Īt Luther I was able to assign the set up to a student who spent about 30 hours doing the work. It works very well for small to medium sized inventory. He developed the platform while the technician at E Washington U. In both cases-Luther and now the U of Oregon-I have input the information via the schema provided by Alan McCoy and available on the CAUT web site. ![]() The program is the easy part but spending the time to input the data is quite another. While at Luther College I had to give a HUGE sales pitch to a committee of three computer folks who would make the final decision about the program purchase. I have been using the FileMaker format for about 8 years with great success. You can use a simple spreadsheet but the rows get overly populated over time unless you do an annual sheet for each year and assemble them into a more complete record.Īs I have not worked at all with Gazelle I can't comment on it other than it has received great reviews from the retail side among those I know who use the system. ![]() Although the task to convert the note card system is a bit daunting, especially when there are many pianos to tune, the time invested is worth it. Having inherited not one but three schools with NO RECORDS or ones that were interrupted, I would have been quite happy with a set of note cards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |