+ Post New Thread
Results 1 to 14 of 14
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 ...
  1. #1

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,787
    Thank Post
    572
    Thanked 2,154 Times in 982 Posts
    Blog Entries
    23
    Rep Power
    626

    Licence Manager

    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?

  2. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,779
    Thank Post
    865
    Thanked 1,665 Times in 1,450 Posts
    Blog Entries
    11
    Rep Power
    442
    Would be very handy, i jsut use good old excel.

  3. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    What platform, web based or standalone? Probably wouldn't take to long to put something like that together in ASP.net

  4. #4

    Little-Miss's Avatar
    Join Date
    Oct 2007
    Location
    London
    Posts
    5,508
    Thank Post
    2,371
    Thanked 741 Times in 454 Posts
    Blog Entries
    2
    Rep Power
    541
    That would be 'mazin!

  5. #5

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,575
    Thank Post
    834
    Thanked 873 Times in 726 Posts
    Blog Entries
    9
    Rep Power
    324
    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.

  6. #6

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,787
    Thank Post
    572
    Thanked 2,154 Times in 982 Posts
    Blog Entries
    23
    Rep Power
    626
    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.

  7. #7
    Drummer_Boy's Avatar
    Join Date
    Mar 2006
    Location
    Near Dos_Box
    Posts
    183
    Thank Post
    1
    Thanked 17 Times in 13 Posts
    Rep Power
    34
    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 11:26 AM.

  8. #8

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    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.

  9. #9
    ascott2's Avatar
    Join Date
    Nov 2007
    Posts
    180
    Thank Post
    18
    Thanked 36 Times in 28 Posts
    Rep Power
    20
    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.

  10. #10

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Quote Originally Posted by Dos_Box View Post
    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?
    I would be, but what sets this apart from a spreadsheet?

  11. #11

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    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.
    Attached Thumbnails Attached Thumbnails Licence Manager-eglm1.jpg   Licence Manager-eglm2.jpg  
    Last edited by SYNACK; 24th March 2009 at 09:55 PM.

  12. #12

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,787
    Thank Post
    572
    Thanked 2,154 Times in 982 Posts
    Blog Entries
    23
    Rep Power
    626
    Quote Originally Posted by ascott2 View Post
    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.
    If you can do that there's an Edugeek t-shirt in it for you

    Oh, and the gratitude of 13,000 geeks!

  13. #13

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    @ SYNACK!

    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

  14. #14

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    @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.

SHARE:
+ Post New Thread

Similar Threads

  1. Schools licence for Xp
    By interele in forum Windows
    Replies: 5
    Last Post: 5th January 2009, 11:30 AM
  2. Nova-T Licence Media
    By john in forum MIS Systems
    Replies: 2
    Last Post: 8th May 2008, 07:54 PM
  3. TV Licence
    By enjay in forum General Chat
    Replies: 104
    Last Post: 11th July 2007, 11:28 AM
  4. licence help
    By Uraken in forum Thin Client and Virtual Machines
    Replies: 7
    Last Post: 31st May 2007, 01:52 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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