Re: Excel Macro doing mass Input via GreenScreen

Frankly, I don't know how the data is getting into Excel, heck maybe the
data is coming from a vendor in an email ( Excel file attachment ), My
client has a concern about these unknown and unapproved data entry methods.
They may perfectly harmless and error free, but maybe not.


On Tue, Apr 30, 2013 at 2:56 PM, Dan Kimmel <dkimmel@xxxxxxxxxxxxxxx> wrote:

<rant>
This is exactly why IBMi is perceived as being old and old-fashioned: We
make people enter stuff twice, once in their spreadsheet and once in the
green screen. For crying out loud, give the folks a button in their
spreadsheet that validates the data and uploads it!! It's simple!!
</rant>

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Monnier, Gary
Sent: Tuesday, April 30, 2013 3:55 PM
To: Midrange Systems Technical Discussion
Subject: RE: Excel Macro doing mass Input via GreenScreen

Kirk,

They could be using a product called DataLoad. It uses an Excel interface
to load data into screens (green or other GUI). You essentially capture
the keystrokes needed to enter something then replicate the keystrokes on
other lines and replace the data elements.

It can be handy when you have large volumes of similar data to enter.
Also very handy when testing screen changes.

HTH,

Gary

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Monday, April 29, 2013 7:52 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Excel Macro doing mass Input via GreenScreen

Why don't you re-post more exact details once you know exactly what is
happening and then we can offer ideas.

I know of folks uploading transactions into JDE and other accounting
systems via Excel.

Why not as long as the data gets scrubbed and validated before it hits the
live system data ?

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------

message: 6
date: Mon, 29 Apr 2013 14:45:32 -0700
from: Kirk Goins <kirkgoins@xxxxxxxxx>
subject: Excel Macro doing mass Input via GreenScreen

I am still digging for exact details, but I received a call this afternoon
from a concerned IT Manager. He has heard of some users using Excel and
Macro's to do larger numbers of data entries via standard greenscreen
sessions. I assume they are populating a spreadsheet from an external
source and then running the macro to run the greescreen input. Anyone seen
this before? Can you stop it by A. Tasering the user(s) B. Using a Group
Policy to block ALL Macro Use within Excel ( this seems a little extreme)
C. ??

I am not looking for better or different ways to do this, looking to stop
this method.

Thanks
--
Kirk




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.