I am currently creating a program that takes data from our clients database system, SAP, and inputing it into our own database system, Navision. We are currently doing this manually which is very tedious and error prone. While I have access to download information from SAP, I don't have direct database access, nor do I have unrestricted access to our Navision database. My idea is to make a program that mimics the actions a users would take in inputting this data by hand. What I mean is that the program would push the F12 key or close etc. Is this even possible? Is there some type of open source or source code that does this? Am I even using the correct terminology? I've read about screen scrapers, but this seem to only work on web based applications. Any help at all would be greatly appreciated.
-Ray
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Your real problem is that the validation done when the user enters by hand needs to be done also when you do the import as well.
You cannot call the validation during database inserts.
So you can try to make a screen macro program that will enter the data as the user would do, but I belive you will have great difficulties doing this. You would have to handle every pop-up window and when the window changes you would need to redo you programming.
My best solution for you is to let a Navision programmer do the import. You can provide the data for him as a file or maybe a new import table in the Navision database. He will be able to make a solution that works everytime and that also call the validation code of Navision. It should not take him long to do such an import if you know precisely where to put the data in question.
Business Accounts
Answer for Membership
by: shamusguyPosted on 2008-04-22 at 16:43:10ID: 21416600
You can probably use some VBScript to do it.
Check out http://www.mjtnet.com/reso