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.
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
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
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.
ASKER
yes
I would see if you can change the title a bit. It is very misleading.
How about the Excel camera tool?
@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.
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 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are most likely others and I am sure there will be multiple suggestions.
Good luck