<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.
midrange.com
