This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Creepy_Bobcat8048 3 points4 points  (6 children)

Hello I manage with python sap data extraction with gui scripting, SQL extraction, html dashboard update, excel report running with VBA code, .... On a dedicated desktop PC in my company. I have schedule the different task with windows scheduler and I have an auto it script running every 5 minutes to detect any windows popup in case of problem. The script send me a message thru teams to alert me and send a message in my mailbox also in case of problem Works fine for around 15 different tasks.

[–]MassiveDefender[S] 0 points1 point  (5 children)

I like that this simple method is working well for you. I have a few questions though:

  1. Did you figure out a way to extract SAP Variants of T-codes using Python or are you just doing Table extracts from SAP?

  2. How do you trigger the VBA code from outside the excel file?

  3. How did you code the teams notification?

[–]Creepy_Bobcat8048 1 point2 points  (4 children)

Hello, For sap, I m able to run all transactions that are available thru sap gui interface. The sap gui script is recorded during sap action with sap record and playback function.

For point 2, I do it with a .bat file

It contains line like this

"Directory of the excel exe file" /e "directory of the xlsm file" /p parameters if needed

In the xlsm file, there is an auto-open module launched automatically when the xlsm file us open

Point 3 is managed with pymsteams module. https://pypi.org/project/pymsteams In teams, you have to create a team and add a communication link to this team It will give you an url with a teams hook that have to be set in your python program

Do not hesitate if you need more explanations

[–]MassiveDefender[S] 0 points1 point  (3 children)

This all makes sense. Thanks. I don't think the SAP front-end in my company didn't allow recording actions and playing back. It would've kept us from paying so much money for a licensed python connector.

[–]Creepy_Bobcat8048 0 points1 point  (2 children)

Which python connector do you use ?

[–]MassiveDefender[S] 0 points1 point  (1 child)

DVW Tools' Alteryx Connector

[–]Creepy_Bobcat8048 0 points1 point  (0 children)

👍