Automated Tool - suggestions please

[mohan93]

Hey guys,

Am looking to design a automated tool on tracking SLA.
Initially i started with Visual Basic as Front end and Excel as back end.

My requirements.
1. Front end Tool will be installed on users machine.
2. When they are assigned with task#, they will be updating the tool with Task#, Name, etc.
3. That need to be captured in the excel at the back end, which is located at a server location ....
4. And other task like, when the task is kept on-hold, user will update the tool which also need to be captured at the excel.

we can do the same in VB + Excel combination with ADODB etc .. is that possible to do in autoit.
Developing a frontend tool in Autoit and Back end as Excel.

Please suggest.
Thanks in Advance.

Cheers.

[JLogan3o13]

Sounds like a help desk ticketing system, which is quite possible with AutoIt. I would, however, highly suggest taking a look at the SQLite functions in the help file to store your data. Excel will get unwieldy very quickly in this kind of scenario. For a gui, you could do something like this (very much off the top of my head):

expandcollapse popup

#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>

Local $msg

GUICreate("Helpdesk Ticketing System", 1000, 650)
;=======
$lblUrgency = GUICtrlCreateLabel("Urgency", 625, 15, 100, 20)
$cUrgency = GUICtrlCreateCombo("", 600, 35, 100, 40)
    GUICtrlSetData($cUrgency, "Low|Medium|High")
;=======
$lblImpact = GUICtrlCreateLabel("Impact", 745, 15, 100, 20)
$cImpact = GUICtrlCreateCombo("", 720, 35, 100, 40)
    GUICtrlSetData($cImpact, "Individual|Group|Department|Enterprise")
;=======
$lblPriority = GUICtrlCreateLabel("Priority", 875, 15, 100, 20)
$cPriority = GUICtrlCreateCombo("", 840, 35, 120, 40)
    GUICtrlSetData($cPriority, "1 (Work Stoppage)|2 (High Priority)|3 (Medium)|4 (Low / Project)")
;=======
$lblAssignment = GUICtrlCreateLabel("Assigned To:", 855, 80, 100, 30)
$cAssignment = GUICtrlCreateCombo("", 800, 100, 180, 30)
    GUICtrlSetData($cAssignment, "Jim|Bob|Joe|Jeff")
;=======
$lblIncident = GUICtrlCreateLabel("Incident Description", 10, 105, 150, 20)
    GUICtrlSetFont($lblIncident, 11, 600, Default, "Arial")
$txtIncident = GUICtrlCreateInput("", 10, 130, 980, 400)
;=======
$btnBegin = GUICtrlCreateButton("Begin Work", 10, 35, 80, 25)
$btnResolve = GUICtrlCreateButton("Resolve", 100, 35, 80, 25)
$btnUpdate = GUICtrlCreateButton("Update", 190, 35, 80, 25)
;=======
$lblCategory = GUICtrlCreateLabel("Category", 50, 550, 100, 20)
$cCategory = GUICtrlCreateCombo("", 10, 575, 150, 30)
    GUICtrlSetData($cCategory, "Software Request|Hardware Request|Incident|Data Change Request")
;=======
$lblTicketTime = GUICtrlCreateLabel("Ticket Time", 200, 550, 100, 30)
$ticketTime = GUICtrlCreateLabel("0:00", 210, 575, 100, 20)
    GUICtrlSetFont($ticketTime, 11, 600, Default, "Arial")
;=======
$btnGo = GUICtrlCreateButton("Create Ticket", 900, 575, 90, 30)

GUISetState(@SW_SHOW)

    While 1
        $msg = GUIGetMsg()
            Select
                Case $msg = $GUI_EVENT_CLOSE
                    ExitLoop
            EndSelect
    WEnd

GUIDelete()

 

[mohan93]

Thanks JLogan3o13. 

That is a really good GUI i will have a look at SQLite functions now. 

For e.g. Many users can update the information at same time, so the data should be managed. 

I need to pull the daily reports, so if it was Excel it will be easy for me to manage. 

Is that the same can be done through SQLite. ?

[JLogan3o13]

Yes, you can run queries for reports. You will also want to initiate a lock on each record to prevent more than one user trying to update the same record, which could cause corruption.

[mohan93]

JLogan3o13, 

Yes we can run queries for reports. 

whether we can download the reports, stored in the database in the form of excel spreadsheet.

Or if at all i want to use excel as the backend database, how to i connect to the database like in VB i do the connection using Microsoft.Jet.OLEDB.4.0

Same way in autoit ?

Please assist me.

Cheers

[mohan93]

Challenge here is, manager come everyday and pull a report in excel spreadsheet format to view data.

we are not used to SQL querying.  

[JLogan3o13]

I think if Excel is what you're comfortable with, it wouldn't hurt you any to start there. I just offered up SQL because it will increase your performance (as well as the end user experience) over using a bunch of (or, God Forbid, one giant) spreadsheets.

I would go with what you're familiar with for the time being, as it sounds like time to Prod is an issue for you. But I would also invest the time looking through the help file at the different SQLite functions (start with _SQLite_Open). Each one has examples which can help you get an understanding of what you can do with them.