Link to home
Start Free TrialLog in
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

asked on

EXCEL TO SAP RECORDING TOOL

Is there any software that can record desktop screen. I am working on a SAP project which requires picking data 1 by 1 from the excel file and then  going to SAP field and thus saving it.
Avatar of yo_bee
yo_bee
Flag of United States of America image

I use Snag-it and it works well.  It's not free, but I think it's doable @ $49.

There are most likely others and I am sure there will be multiple suggestions.

Good luck
Hi,

Camtasia or snagit

https://www.techsmith.com/video-editor.html
https://www.techsmith.com/screen-capture.html

If you just want screenshots use windows native tool PSR

SSKUMAR
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

ASKER

Yes but this are screen capture tools. What I am looking for is manual picking data 1 by 1 from excel file and then going to sap field and saving it. Same like script recording.
You are talking about recording actions to automate a process.
yes
I would see if you can change the title a bit.  It is very misleading.
@Martin
I think the asker is looking for a means to get the data from excel into SAP one record at a time.  The title he originally had was asking for a DESKTOP recording app and as you can see we suggested Snag-it.  Later in the thread I ask the ASKER to change the title to be a bit clearer, but IMO is still not clear.  


Yes but this are screen capture tools. What I am looking for is manual picking data 1 by 1 from excel file and then going to sap field and saving it. Same like script recording.
Hi Tejas,
I suggest writing a script to do this. You can do it in any scripting language that you prefer. I would do it in AutoHotkey. If AutoHotkey interests you, but you're not familiar with it, my EE article will get you going on it:
AutoHotkey - Getting Started

Also, here are a couple of other EE articles that have fully functioning AutoHotkey scripts in them that should be helpful in learning the language:
How to solve the problem of incorrect System Uptime being reported when a system has been up for a long time (approximately 50 days or more)
How to create an on/off toggle to mute the system audio/sound with a single mouse click or single keystroke

Here's an answer that I gave to a recent EE question that relates directly to your question:
https://www.experts-exchange.com/questions/29106430/Fill-in-web-forms-with-Excel-data.html?anchorAnswerId=42607648#a42607648

Here's an EE article with sample AutoHotkey code for sending both keystrokes and mouse clicks:
https://www.experts-exchange.com/articles/29416/

However, instead of copy/paste via sending keys, I recommend using AutoHotkey's native Component Object Model (COM) support to read the contents of Excel cells — that's a much better way to do it. Note this code sample at my AutoHotkey - Getting Started article:
https://www.experts-exchange.com/articles/18346/AutoHotkey-Getting-Started.html#c1733937

Also, here's another post that shows how to do it:
https://www.experts-exchange.com/questions/28973610/AutoHotKey-vs-Pulover's-Macro-Creator-syntax.html?anchorAnswerId=41824810#a41824810

And here's a thread with numerous code samples along the way:
https://www.experts-exchange.com/questions/28952712/SSIS-extracting-data-from-excel-and-pdf-documents.html

Regards, Joe
I object to deleting this question, especially with a reason of "xyz", which is disrespectful of the members who put in time and effort trying to help. Furthermore, there are already some very good suggestions here, and if we get additional clarification from the author on the requirements, I believe that the highly-qualified experts on this thread would find a solution. Regards, Joe
I agree with Joe.
My apologies Tejas, I didn't see your explanation when I objected.
ASKER CERTIFIED SOLUTION
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial