+ Post New Thread
Results 1 to 7 of 7
Group Project Thread, Inventory System - Bespoke for schools in Coding and Web Development; Hey Everyone, I've been developing an open source inventory system for schools that strips out all the unused junk from ...
  1. #1
    DEvans's Avatar
    Join Date
    Sep 2010
    Location
    Droitwich, Worcestershire
    Posts
    72
    Thank Post
    3
    Thanked 16 Times in 10 Posts
    Rep Power
    21

    Inventory System - Bespoke for schools

    Hey Everyone,

    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
    • Make
    • Model
    • 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.

  2. 4 Thanks to DEvans:

    jdoldridge (1st July 2013), linkazoid (1st July 2013), nathan3388 (1st July 2013), speckytecky (20th October 2013)

  3. #2

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,203
    Thank Post
    372
    Thanked 376 Times in 334 Posts
    Rep Power
    147
    Sounds good - I'll happily help once your in a position to launch it.

  4. #3

    Join Date
    Mar 2012
    Location
    East Riding of Yorkshire
    Posts
    155
    Thank Post
    35
    Thanked 7 Times in 7 Posts
    Rep Power
    6
    Brill. will give it a go

  5. #4
    mdench's Avatar
    Join Date
    Oct 2011
    Location
    Billingshurst
    Posts
    771
    Thank Post
    36
    Thanked 102 Times in 92 Posts
    Rep Power
    38
    Sounded great till the asp part as all our web servers are apache on ubuntu. Sounds great tho so keep it going if we happen to set up IIS ill give it a go!

  6. #5
    DEvans's Avatar
    Join Date
    Sep 2010
    Location
    Droitwich, Worcestershire
    Posts
    72
    Thank Post
    3
    Thanked 16 Times in 10 Posts
    Rep Power
    21

    Question Screenshots

    Few Updates on the Project

    The import feature is working, you can bulk import multiple devices of the same type in 4 simple steps or simply scan in individuals in a quick one step fashion.

    The web application is following a very straight forward, common sense approach. The basics you want from a website, such as if there is an error, you don't need to go back and retype everything back in again, the feature that you can resolve errors without needing to go back to other steps etc. The fact that it works in pretty much any screen resolution. Big buttons have also been implemented with tablets in mind also, sorta working on the mobile side of things and ways to use a tablets/mobile camera for scanning.

    Just all the tools you need there and then, no faffing about. Simple and straight to the point.

    Also, this is open source and i'll be providing documentation on how to "make it your own". Logos can be modified and by all means change the colour scheme if you so desire, all I ask is that my initials/name is kept in the footer.

    Additionally, I have spoken to a good PHP developer of mine and we are working on a way to get this working on apache servers and MySQL. Understandably I don't want to limit this to just your windows systems, that's unfair as I love both sides of the fence.

    So to give you an idea on what its looking like here are some screenshots of the bulk import process.

    Homepage
    home.png

    Logged In Home Page
    homelogin.png

    Inventory Main Menu
    inventoryhome.png

    Scan In Bulk Step 1
    scaninstep1.png

    Scan In Bulk Step 2
    step2.png

    Scan In Bulk Step 3
    step3.png

    Scan in Bulk Step 4
    step4.png

    Scan in Import Summary (PreChecks)
    summary.png

    The single step process is for individual scanning in, the only way (I know how) to successfully ensure that what you put in is controlled to prevent junk in the database is to do a step by step process for the bulk imports as each serial needs to be checked before import and each bit of data needs to be double checked to prevent duplication.

    When its just one device, it is easier to handle.


    Before BETA Release I am working on the following

    • Optimise and Index SQL for faster imports
    • Admin Control Panel and User Management
    • Button Modifications and Clean up
    • Debug Mode Switch for error reporting
    • Messaging centre optimisation (duplicate message prevention)
    • PDF Report Outputs
    • Excel Importer (Import Bulk from Excel)
    • Excel Report Output



    There will be more screenshots when I get further with these developments. I'm also taking requests on how people would prefer it to be laid out and trying to work a way of implementing those recommendations, unfortunately I am just a bit far away from that, I need it working before I add new stuff.

    Current Future Features since first announcement

    • Messaging Centre with Warranty Monitoring
    • Printer Support (Bespoke Forms for Printers)
    • Projector Inventory (Bespoke Projector Forms)
    • Smartboard and Promethean Board Inventory Management


    It's really getting on and to see what it looked like about 6 months ago to now is quite amazing, I haven't done a big programming project for a long time, not since my university days and i've missed the feeling of seeing something like this grow up.

    Just hope it holds out for BETA.

    Thanks for all your support,

    I'll update you all again soon in a couple weeks,

    Dan
    Last edited by DEvans; 31st July 2013 at 09:12 PM.

  7. 3 Thanks to DEvans:

    has (31st July 2013), round2it (14th August 2013), speckytecky (20th October 2013)

  8. #6
    kevin_lane's Avatar
    Join Date
    Mar 2007
    Location
    Derby
    Posts
    505
    Thank Post
    23
    Thanked 20 Times in 20 Posts
    Blog Entries
    5
    Rep Power
    19
    looks gud

  9. #7
    DEvans's Avatar
    Join Date
    Sep 2010
    Location
    Droitwich, Worcestershire
    Posts
    72
    Thank Post
    3
    Thanked 16 Times in 10 Posts
    Rep Power
    21
    Ok its been a while and just to let everyone know the stages this is at.

    I've been busy building a PHP version of this website which essentially is identical to the current. I've had a vast amount of people say a php version would be amazing, so i've heard you and am building one. I'm trying to get them to be at the same level side by side, purely for sanity purposes.

    It is now tablet friendly with HTML 5 tabs and drop downs. It works off SQL Server Express (ASP version) and MySQL (PHP Version).

    I am literally transitioning to a different job at present, so naturally development has halted briefly, but it's still coming and still being developed. In fact my new job enables me to spend more time on it as before this was done during personal hours not working hours.

    Apologies for the delay, i'm just trying to please everyone. My PHP knowledge is not the best in the world, its been a while since I used it, but once I got into the swing of it again, I was able to get stuff working in the same way as the ASP version rather quickly.

    Still in development and I appreciate the support, some people have been absolutely amazing.

    Some Alpha testers have just taking it apart and broken it in ways I thought were not possible, its amazing how much testing needs to be done, even before Beta.

    Thanks again and stay tuned,

    Dan

SHARE:
+ Post New Thread

Similar Threads

  1. PC Pro - OpenSource is no good for schools?
    By Ric_ in forum General Chat
    Replies: 60
    Last Post: 21st August 2012, 12:16 PM
  2. LNL Free Printers for Schools
    By OverWorked in forum General Chat
    Replies: 19
    Last Post: 20th September 2006, 07:16 PM
  3. Any recommendations for music system for school hall? Help!
    By kfq61 in forum Recommended Suppliers
    Replies: 8
    Last Post: 13th June 2006, 08:02 PM
  4. Which CMS for School Website?
    By Ric_ in forum How do you do....it?
    Replies: 19
    Last Post: 10th November 2005, 12:41 PM
  5. Microsoft tool for schools
    By russdev in forum Windows
    Replies: 8
    Last Post: 28th July 2005, 06:15 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •