MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2013

Re: Excel Macro doing mass Input via GreenScreen



fixed

On Tue, Apr 30, 2013 at 6:34 AM, <paultherrien@xxxxxxxxxxxxxxxxxx> wrote:
What is the concern exactly? Is the green screen application not editing
the data correctly?

Obviously I don't know the OP's exact situation, but I am imagining
what a macro that loads Excel data into interactive green screens
would look like, and what *my* concern would be is that if the green
screen app wasn't specifically designed for bulk upload, then if the
app *does* edit the data correctly by displaying some kind of error
message in the *middle* of the execution of the macro, that the macro
wouldn't know how to deal with it and it would just keep going, and
possibly munge things up. (For example, part of the Excel data might
turn into a response for the error message dialog, which by chance
clears the dialog, and then the rest of the data goes into the wrong
places, and the original error may or may not have been answered
appropriately.)

In other words, it just seems likely an inordinately high risk of
train wreck to me, given the information OP has provided so far. My
assessment could definitely change once he provides more details.

Incidentally, if the green screen app is *not* really designed for
human interactive use, but is actually just a receptacle for the Excel
data, then there's less chance of train wreck, but to me there are
still better ways of getting that Excel data. Just upload the Excel
file to the i (can be made to be a single-click for the end-user) and
then read the Excel file directly on the i. Rob and others will
happily point to RPG and Java solutions; I will of course push Python.

John





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact