I've been developing an open source inventory system for schools that strips out all the unused junk from an expensive inventory system and keeps things basic and organised.
It's still in Alpha at present, but will be putting it out for Beta in the upcoming weeks.
So far it will do:
- Bulk Imports of ICT Equipment
- Individual imports
- Warranty Monitoring and alerts
- Note taking on individual machines
- Simple Scan item Show data, quickly.
- Admin control panel to manage user logins to the system, database admin etc.
The data stored includes:
- Serial Number
- Purchase Date
- Purchased From (Company you purchased through, with invoice data)
- Warranty Start Date (If different to purchase date)
- Warranty Length (with countdown)
- Warranty Name/Type (Accidental Damage, NBD etc)
I chose all these as these are the most commonly used by all technicians around schools. Working with people who script in powershell, we are exploring secure and reliable ways to import data from machines already out in your schools and unlike spiceworks, be quick about it.
The sole reason I've done this is for speed. Spiceworks is a fantastic system which I have little trouble with, but it does seem to be a little over developed for the needs of some of the smaller schools.
The idea is to take the experience from people who work in the ICT departments of schools and colleges and develop a bespoke, free system, that requires no flash, no shockwave, java etc. Simple Html 5, CSS 3 and some bog standard programming.
It's developed in Classic ASP which puts many off, but its a complete language, supported on all latest windows o/s's, plugs into IIS magically and no update for it is going to come along and break it. It's also extremely quick and is running with the latest SQL Express 2012 database.
I'm looking for people who want to try it out, aid me in the development, throw ideas at me. At the end of the day, if you are fed up of your current inventory solution and would like a simple one that requires no additional resources on your computer to run, then this might be for you, so help me help you.
There's been plenty developed as open source before, but people have different needs. If you want bog standard, why do you need to install all the features, the majority of which you are never going to use.
I've designed the whole site in a modular method, you add the features you will use and never install those you won't.
It's essentially a sober version of spiceworks, just developed by one guy lol.
I'll be posting screenshots in the next few weeks (graphically it needs tidying up) and i'll progress from there.
What I would like are more ideas.
If you got a new set of laptops, what data would you like stored about them? Would you like what O/S is installed, Software? or are you more specific on the hardware, Maybe RAM amounts etc.
The trick is to find what data technicians need and then data that they want. Those we need, will come pre-installed, those people want, i'll create as an option, which can be added by the administrator of the system.
If you receive a broken laptop and you scan it, what data do you need to jump out at you. Would you like the option to choose what data jumps out at you before you scan it in? (e.g Click Serial, Scan and it comes up with all data with the serial key highlighted for you) Everything is possible.
So far it works in all resolutions between 800x600 to 1920x1080, in IE8+, Chrome, Firefox, Safari and Opera.
What do you guys think, would anyone be willing to help out during Beta also.