0
Craig Hatmaker 
0 pts. | Nov 3 2009 11:17PM GMT
Hi JohnsonMumbai,
I too, could not find anything on NASTIE; however, if you are trying to pull data from your iSeries into Excel, you may find the techniques presented here well worth a look:
<a href="http://itknowledgeexchange.techtarget.com/beyond-excel/" title="http://itknowledgeexchange.techtarget.com/beyond-excel/" target="_blank">http://itknowledgeexchange.techtarget.co…</a>
Philpl1jb 24510 pts. | Nov 4 2009 2:44AM GMT
There is no way to answer this question until we learn what NASTIE is.
Phil
JohnsonMumbai 380 pts. | Nov 4 2009 5:09AM GMT
Nastie captures iseries screens and uses scripting language and macros in excel to input information on to iseries. This is typically used for bulk data entry.
Please note data to be entered into iseries is entered in the excel sheet.Eg each fields information is entered on a different column.
The user logs into iseries and goes to the screen where the data entry is to be done.
Simultaneously he opens the NASTIE macro screen, which is in excel, this excel sheet also contains the sheet wherein the data that is to be entered is populated.
Once he begins the nastie macro all data in the excelsheet is entered on the iseries.
This is similiar to running macros on clientaccess workstation.
We would like to restrict running of such macros to selected users.
Philpl1jb 24510 pts. | Nov 4 2009 8:45AM GMT
So this is entierly an excel function .. no macro script in Client server.
Client Server and the 400 thinks the screen is being file out by user.
Very hard to stop..
some web pages make you respond by repeating a random set of letters displayed on the screen along with your request. They show them in bizaar scripts to make it hard to machine read. This is to stop something like this. You could only put these out in simple text and NASTIE could probably be altered to read these from the screen and echo them back.
Phil
JohnsonMumbai 380 pts. | Nov 4 2009 9:04AM GMT
Is there any way by which recording and playing of macros on local client access workstations be controlled centrally. Will this help in stopping such macros from executing via excel.
johnson
JohnsonMumbai 380 pts. | Nov 4 2009 12:53PM GMT
I did not get your question.
What i meant was, in Client access when a repeated activity is required to be executed, we record the steps entered on i series screen into a macro in local client access and thereafter play the macro. In this the repeated steps need not be manually keyed in, instead while playing the macro the steps are rerun.
Nastie basically is doing the same thing only in this case the variable data is stored in excel worksheet.
Johnson
Teandy 3165 pts. | Nov 4 2009 5:24PM GMT
Teandy 3165 pts. | Nov 4 2009 5:26PM GMT
Teandy 3165 pts. | Nov 4 2009 5:30PM GMT
Is this using ODBC to connect and pass the data to the iSeries? If so you can look into an exit program that will let you restrict ODBC access to certain users.
Check out this thread:
<a href="http://itknowledgeexchange.techtarget.com/itanswers/block-winsql/?asrc=EM_UGT_9808457&uid=11161" title="http://itknowledgeexchange.techtarget.com/itanswers/block-winsql/?asrc=EM_UGT_9808457&uid=11161" target="_blank">http://itknowledgeexchange.techtarget.co…</a>
I’ve tried three different times to post the code of an exit program I have that does this and all three times the post has failed to come through. Let me know if you want it and I will email it to you.
TomLiotta 7610 pts. | Nov 5 2009 2:39AM GMT
If NASTIE uses System i Access emulator DDE/EHLLAPI interfaces to access the presentation space, you could look into turning that option off for that installation of the emulator.
If you allow PC users to change settings or they have PC Administrator levels of permissions, then you probably can’t stop them from installing in whatever form they choose. If that’s the case, then don’t allow the System i Access emulator to be installed — don’t make it available. Use a different emulator such as Mocha or a TN5250j emulator. (Or even a cheap 3270 emulator, since 3270 is supported; probably would require some automated keyboard mapping on your System i.)
Tom
Philpl1jb 24510 pts. | Nov 5 2009 2:41AM GMT
I don’t think there is any ODBC or JDBC.
As I understand it, this excel program though it’s macro is writing the data into the as/400 client access screen. The AS/400 cannot tell that it isn’t actual keystrokes. Can a wall be put up to on the PC to protect the client access screen from Nasty??? That’s possible but you would be looking for someone with more PC/Client Access knowledge than I have.
Why is this a problem — these people have authority to use the system, how does the way they enter the keystrokes matter?
Phil
JohnsonMumbai 380 pts. | Nov 5 2009 5:22AM GMT
As data can be entered in bulk, similarly data can also be extracted in bulk. The objective is to limit the usage of such tools to few users.
Is it possible to only stop recording and playing of macros within client access and how.
Philpl1jb 24510 pts. | Nov 5 2009 11:55AM GMT
and I think you would want to restrict the cient access data transfer functions which can do the same thing without excel?
Phil
JohnsonMumbai 380 pts. | Nov 5 2009 12:05PM GMT
DTF access has been restricted, how can access for running macros on client access be restricted.?
Johnson
Philpl1jb 24510 pts. | Nov 6 2009 2:45AM GMT
This might help
<a href="http://itknowledgeexchange.techtarget.com/itanswers/disable-macro-function-in-client-access/" title="http://itknowledgeexchange.techtarget.com/itanswers/disable-macro-function-in-client-access/" target="_blank">http://itknowledgeexchange.techtarget.co…</a>
it removes the macro keys but I’m not sure it disables the Client Access macro capability and I’m still suspect that it’s an excel macro that you’re having problems with.
You might start a new tag with the line AS/400 disable client access macro. Perhaps someone has some good ideas.
Phil
