Re: Excel Macro doing mass Input via GreenScreen

[Kirk Goins <kirkgoins@xxxxxxxxx>]

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.