New Project Ideas Thread, Licence Manager in EduGeek Projects; Following on from a few posts recently, how about someone developing a standalone licence manager app? Just a few things ...
11th March 2009, 11:49 AM #1
Following on from a few posts recently, how about someone developing a standalone licence manager app? Just a few things fields such as company, software title, date purchased, amount and possible department would do, and have the option to export to CSV, XLS etc. Anyone up for it?
IDG Tech News
11th March 2009, 11:54 AM #2
Would be very handy, i jsut use good old excel.
11th March 2009, 11:58 AM #3
What platform, web based or standalone? Probably wouldn't take to long to put something like that together in ASP.net
11th March 2009, 11:58 AM #4
11th March 2009, 12:04 PM #5
I'm working on a WAMP based Assett Management database for the whole school. I was 90-something% complete till I saw this post. It can handle software as it stands - but doesn't feel very 'neat'.
I'm going to bolt on software licensing over today/tomorrow. Maybe when it's complete I'll look at zipping it up with some basic destructions.
It's bespoke software, written for this school and would require some knowledge of WAMP to install and get running. The codes not pretty but totally open source so once I've zipped up a completed version y'all be free to dismantle it any way you see fit.
Should have something by this time next week.
11th March 2009, 12:17 PM #6
I was thinking more of a standalone app rather than something web based. That way it would be easier for smaller schools with little or not technical support to use. It should be able to import\export too as to allow the easy transfer of the info.
11th March 2009, 12:21 PM #7
Don't know if this would help, but we use SugarCRM here (commercial organisation), and there is an IT asset management plug-in available for that that also includes software licensing, and it's all open source!!
Also has case and bug handling in the product as well.
Just read Dos_Box's comment above.
I know this stuff is not stand alone, but I have managed to install it, as it has a good install package. WAMP/LAMP stack is what's needed.
And I found a link to the software I was talking about: http://www.sugarforge.org/projects/ithelpdesk/
Last edited by Drummer_Boy; 11th March 2009 at 12:26 PM.
11th March 2009, 12:22 PM #8
To generate the XLS export they would probably need excel on the machine that is runing it. I guess you could chuck the backend into an MDB file as it is not to big a database and you don't need access on the machine just the standard data components that ship with windows.
24th March 2009, 09:49 PM #9
Funny I was actually looking at doing this as my first SQL / C# windows app today, then read this! If I actually manage to get it sorted I'll post the code.
24th March 2009, 10:05 PM #10
I would be, but what sets this apart from a spreadsheet?
Originally Posted by Dos_Box
24th March 2009, 10:27 PM #11
I have a C# one tied into a MDB pretty much done just have not done the reporting bit. Exporting will be the easy bit it does not even require excel on the machine as there is an ADO connection for it. Can post what I have if thats any help.
Last edited by SYNACK; 24th March 2009 at 10:55 PM.
24th March 2009, 10:43 PM #12
If you can do that there's an Edugeek t-shirt in it for you
Originally Posted by ascott2
Oh, and the gratitude of 13,000 geeks!
24th March 2009, 11:37 PM #13
That little app appears to be coming on quiet nicely, a list of what is included so far would be very handy!
Cheers, and nice though DB
25th March 2009, 12:26 AM #14
@Edutech - Thanks, have been doing little bits and pieces of it when time allowed. Current features, if you can call them that are as follows:
Data - allows for addition of:
Departments + Descriptions
Suppliers + Contact information
Media Types - CD etc
License types - including whether or not they are unlimited
Software - including all stuff that was in the above thumbnail
Currently you can add and edit all of the above data and a summary is displayed on the frontpage as above. It does not need access or excell just windows with the .net2 framework to run and runs on a single workstation with no need to install it. If you have entered in a license expirey date it will tel you how many days you have left on the summary.
I am/will be working on very shortly is the reporting section, this for the moment will be basic allowing you to select from the possible colloms which will then show up in a datagrid like the summary but will be exportable. Still thinking through the best way to do custom reports that go deeper in a simple way without having to build an entire query builder and then document it.
By interele in forum Windows
Last Post: 5th January 2009, 12:30 PM
By john in forum MIS Systems
Last Post: 8th May 2008, 08:54 PM
By enjay in forum General Chat
Last Post: 11th July 2007, 12:28 PM
By Uraken in forum Thin Client and Virtual Machines
Last Post: 31st May 2007, 02:52 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)