Sign in to follow this  
Followers 0
mohan93

Automated Tool - suggestions please

7 posts in this topic

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.

Share this post


Link to post
Share on other sites



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):

#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()

 

1 person likes this

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

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. ?

Share this post


Link to post
Share on other sites

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.

1 person likes this

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

we are not used to SQL querying.  

Share this post


Link to post
Share on other sites

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.  

1 person likes this

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0