FITS Compliant Web Based Helpdesk - ** RELEASED **

[ICTNUT]

Hi All,

 

Very often you get posts about how people manage thier time and prioratise thier work schedules, well I know that a number of you have already got solutions in place based on OpenSource, *nix based products but there seem to be more and more eduTechs that are not in a position to go this route.

 

So I have put together a very feature rich helpdesk based on ASP and will connect to MSSQL 2000 and 2005 and also MySQL.

 

I am in the final phase of tweaking and hope to have it available to the masses on Monday 18th June 2007 but thought I would generate some intrest with a teaser screenshot and would welcome any questions people may have.

 

Above all it's going to be free for anyones use and the source code is open to abuse within reason that is.

[webman]

Looks great Ozan, look forward to testing it, thanks!

[Jake]

Looks great, would be excellent to replace our very elementary looking Liberum system

[ICTNUT]

you have forms based authentication which requires pre population of user data or you can use NTLM for authentcation which will auto populate the staff tables for you.

 

I am working on the LDAP auth option and that should be available soon after the initial release.

 

As far as logging issues goes there is a neat little trick that scans the words typed in by a user and references the keywords in the knowledge base, if a match is found the suggested article is shown in realtime to the user prior to submitting the request and thus reducing the number of requests made.

 

Theres lots more in there but I am sure those that do use it will request additional stuff also.

[Butuz]

Wow this is great!! I have been looking at several helpdesks including Liberum and Sharepoint with Helpdesk template.

 

I would love to try yours out! Please give me a shout as soon as it is available!

 

Andrew

[plexer]

Ozan: I've been waiting for this ever since I saw the coming may 31st on your website.

 

I'm currently using a RT windows install but it lacks the knowledgebase so I'm very keen.

 

Does your system allow for the creation of tickets via incoming email?

 

Thanks,

 

Ben

[ICTNUT]

Email polling is already in the pipeline, the helpdesk itself already supports it but there is a requirement for a little windows app to "poll" for email.

 

The app itself is in development but I have put that on hold untill the helpdesk has been released and any creases have been ironed out but I wouldn't think it would be that much after the initial release.

 

Once the inital release is out I will put together and publish a road map to work out the direction of development.

[plexer]

Ok cool it's just that at the moment I use a web form that send itself via email for the users to enter jobs and if I can keep that then the backend can be changed at will.

 

Ben

[Jake]

Looking forward to the 18th to check this out, we've been looking for a more professional looking Helpdesk and Room Booking solution (currently we use liberum and a free roombooking thing), this combined with Craigs CRBS should help to make things look alot more appealing to our staff

[wesleyw]

Can it authenticate against an IMAP server?

 

 

Wes

[ICTNUT]

@wesleyw: Not at the moment but with intergrated NTLM and with LDAP to follow would you really need to use IMAP??

[wesleyw]

Sometimes its causes issue with external use. Both the teachers and the pupils have access to the helpdesk here. We use GLPI and OCS so we're not looking to change but it would be interesting to compare?

 

 

Wes

[ICTNUT]

I'm sure it would'nt be that hard to include it but that would be at a later date.

[Midget]

ICTNUT> now that is VERY tasty, i shall have to keep an eye on this thread

[ICTNUT]

Hi All,

 

I am happy to say the Helpdesk is available and ready for download.

 

I think I have pretty much covered everything but hey let me know if I did miss anything, anyhow you can download from the linkis my signature below with full install instructions available here --> http://www.opsoftware.co.uk/forum/index.php/topic,18.msg23.html#msg23

 

If you do plan on using NTLM Authentication please pay attention to the WARNING in the setup docs.....

 

If you want to to provide feedback you can do so here --> http://www.opsoftware.co.uk/forum/index.php/board,2.0.html or on this forum with bug and feature requests being made here --> http://www.opsoftware.co.uk/forum/index.php/board,7.0.html

 

Any problems shout me.

[localzuk]

Small bug - the Mysql file has the 4 'INSERT INTO `tblstaff`' lines - but they don't run due to the list of fieldnames being short by one. Adding ',`createdDate`' after accountKey fixes it.

[ICTNUT]

@localzuk: Thanks for this, I will update the script and post an update shortly.

[localzuk]

Also, there doesn't seem to be any mention of what the default admin/tech/user password actually is...

[ICTNUT]

ooohhhhhhh, I forgot that bit ;-)

 

The default admin details are as follows:

 

Username: admin

Password: password

 

I'll update the install docs now with that, cheers mate

[localzuk]

Another one, you have to have the ODBC/Mysql connector from http://dev.mysql.com/downloads/connector/odbc/3.51.html installed as a requirement if you are using Mysql.

 

And now I've hit a wall. When logging in it is giving me the message

 

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/helpdesk/support_summary.asp, line 68 

[ICTNUT]

@Localzuk: Found the problem, it is MySQL specific, sorting it now and will post an update in about 10 mins.

[webman]

I think this is to do with the case of the table names is it?

[ICTNUT]

@webman: It is just that MySQL has a slightly different syntax when it comes to CASE statements.

 

@localzuk: If I PM you the updated file can you try it out for me as I am not anywhere near a MySQL database at the moment (I use MSSQL)

[localzuk]

@ICTNUT - sure.

[ICTNUT]

@localzuk: can you PMme your email address as I can not attach any files to a PM.