Inventory/Asset management
Hi,
My organization has a library that we allow members to check out from every month. With that said I was hoping for 2 things.
1) an inventory database to keep track of our media (I can see this also being useful for other things such as equipment we own or donation items we get and then give)
2) the capability to connect members to an item. this would allow us to track who checked something out and automatically send out reminder emails to members and what they have checked out (currently this is all done my hand each month and the library has a separate excel doc with emails and information which is already in WA)
If these 2 things aren't possible I'm hoping for at least a connection to a MySQL database possible.
Thanks!
![](https://secure.gravatar.com/avatar/d8650331e6be0b38af078f036cc7d346?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
William J. David commented
Hello,
I am with EAA Chapter 582 in Toledo, Ohio. We are implementing Wild Apricot soon.
The next thing I would like to attempt is an inventory list. Let me explain. In our club we have numerous assets to lend ranging from hand tools, tables and chairs, to a rather large mobile gas grill. Most of this stuff is available for the members to borrow and some of it is not. What we would like to do is build an inventory list of what we have and then have a “form,” to fill out if a person wants to borrow it. The fields required would be rather simple. Whom borrowed what, and when, and then when it would be returned.
My question to you is have you thought of this type of requirement for inventory and can you provide me with guidance with how to go about setting something like this up? -
Paul L. Kush commented
This approach could be useful for my M&A Professionals Association if we could utilize it for business listings that are available for sale. Listings information are businesses for sale, a description, revenue, EBITDA, year founded, location, who to contact, etc.
Nice if I could link the listing to the members record.
Paul
-
Elizabeth Bass Webmaster commented
My organization has the same need!
-
Dawn Kolb commented
I don't know if this would be the proper thread for my wishlist item. We currently have an online store, and were wondering if there was a way that we could automatically keep track of inventory so that we would know how many items we still have remaining. I know there is a program out there, like virtuemart and others that you can download but they all use php.
-
Evgeny Zaritovskiy commented
I'm sure this is not something we are going to get into soon. This is very specific request so I want to collect more comments in this thread before going into analysis.
And, unfortunately, there is no way to provide a connection to external MySQL database.