K
K
Konstantin Korotaev2017-05-12 10:55:11
PowerShell
Konstantin Korotaev, 2017-05-12 10:55:11

Automate a task with powershell or something else?

I have one routine task:
1. An event from the HR department "BRIF on the exit of a new employee" arrives in the mail, this event is automatically entered into the Outlook calendar.
2. I open a double-click event from the calendar, I poke anywhere in the table with data about the new employee, select everything Ctrl + A, copy Ctrl + C
3. Open a new MS Excel document and press Ctrl + V, then copy Ctrl + C
4. Open Paint and press Ctrl + V, then Ctrl +
C
6. Item 5 can be replaced with the option create a new letter to the addressee write technical support, in the subject "Exit: Ivanov Ivan 05/12/2017 ABBREVIATION NAME" in the body of the letter I insert an image from Paint Ctrl + V.
I will explain why in this order:
1. If you just send an event to the technical support mail, then it arrives in SD in plain text and all the data is mixed and moved
out 2. If you copy from the calendar directly into a new SD request, then the table is inserted, but some important checkboxes are not are visible (for example, the type of PC for an employee)
In general, there are a lot of such "ifs" and therefore such a path was chosen from the event in the calendar to the application in SD. The option of sending an event directly to SD also does not work, the data comes in an unreadable form. Events are sent to us from the E-Staff program.
Is it possible to automate this process, if so, how?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Stalker_RED, 2017-05-13
@Stalker_RED

The problem with the tab from TomasHuk 's answer is solved by opening a new tab, or pinning it, or even forming a POST and sending it to the right place without jerking the browser. AutoHotkey can do that, and Autoit probably can too.
The intermediate steps with excel and paint also look dumb, most likely all these items can be omitted by replacing them with:
1. get the text from the letter
2. format
3. send POST to ServiceDesk
And yes, PowerShell can handle this too.

T
TomasHuk, 2017-05-12
@TomasHuk

I think Autoit will do.
He's made for that kind of stuff.
Able to run programs , simulate keystrokes and mouse clicks .
Only now he will not be able to find the tab in chrome where ServiceDesk is open.
Therefore, it is better to use point 6 (if an external program is used to send letters), where it remains to enter in the subject "Exit: Ivanov Ivan 05/12/2017 ABBREVIATION NAME OF THE UNIT".

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question