Sign in to follow this  
Followers 0
DiabolicNerd

Automate Helpdesk Software

4 posts in this topic

I work on a helpdesk, when service or incident e-mails come in we have to manually create incident tickets in a system known as "Frontrange." I'm trying to eliminate as much manual labor as possible by utilizing AutoIT to extract information from incoming e-mails and enter the data into the Frontrange system. I've very new to AutoIT and really the only thing I can think of is creating a macro to perform some basic mouse clicks, drags, and copying and pasting data. Anyone have any suggestions? Experience with this?

Here's what I have so far...it works but..i'm wondering if theres a more efficient way of doing things.

;Open Outlook
WinActivate ( "Inbox - Microsoft Outlook")

;Highlight e-mail subject
MouseClick ( "left", 766, 125, 3, 0 )

Sleep (1000)

;Copy the e-mail subject
Send("^c")

Sleep (1000)

;Open ITSM Window
WinActivate ( "FRS Application")

Sleep (1000)

;Create a new Incident
MouseClick("left", 122, 62, 1, 0)

Sleep (5000)

;Select the Summary field to insert e-mail subject and priority
MouseClick("left", 369, 325, 1, 0)

Sleep (1000)

;Default to priority 2
Send("2 - ")

Sleep (1000)

;Begin pasting
MouseClick("left", 375, 325, 1, 0)

Sleep (1000)

;Paste
Send("^v")

Sleep (1000)

;Back to Outlook
WinActivate ( "Inbox - Microsoft Outlook")

Sleep (1000)

;Select e-mail body text
MouseClickDrag("left", 1454, 977, 772, 243)

Sleep (1000)

;Copy highlighted text
Send ("^c")

Sleep (1000)

;Back to ITSM
WinActivate ( "FRS Application")

Sleep (1000)

;Select description
MouseClick ( "left", 379, 369, 1, 0)

Sleep (1000)

;Paste e-mail contents
Send ("^v")

Sleep (1000)

;Select source
MouseClick ( "left", 324, 433, 1, 0)

Sleep (1000)

;Select e-mail
MouseClick ( "left", 171, 461, 1, 0)

Sleep (1000)

;Select type incident
MouseClick ( "left", 325, 291, 1, 0)

Sleep (500)

;Select type incident
MouseClick ( "left", 158, 305, 1, 0)

Share this post


Link to post
Share on other sites



Have you tried uising the "AutoIt Window Info" tool to get better ctrl info? then you can use $hText = GUICtrlRead($hCtrl) and then ControlSetText($sCtrl, $hText) just so you don't have to do "mouseclick", and "Send" to do you actions. just a thought.

Share this post


Link to post
Share on other sites

the outlook UDF may be helpful as well


,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites

Thanks for the speedy responses guys :graduated: Let me go ahead and do my research on what you've provided and see what I can come up with and put togther. I knew there would be a better way. I couldn't share this with my co-workers either becuase their resolution and X Y coordinates would more then likely be off. Thanks again, any more suggestions, tips are welcome

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