Re: data entry from excel workbook -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On Fri, May 3, 2013 at 12:16 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Think web applications that look and behave like worksheets
as far as keyboard navigation is concerned, but data is validated
& recorded in IBM i database tables the moment an [Enter] key
is pressed. Calculations are performed on the server and displayed
on the client.

This is all well and good, but what's the development time for this?
I mean, given enough time (and/or money?), I think it's a great
solution.

If the goal is just to extract data that's already in an Excel file, I
could probably walk someone through installing iSeriesPython,
installing xlrd, and writing a simple script in under an hour. And by
under, I mean it could take 15 minutes if they already have the
"tooling" like a nice FTP client connected to their i and something to
unpack tarballs. Even if things don't go particularly smoothly, I
think an hour should be plenty of time to get from zero to reading
Excel files, at a proof-of-concept level of refinement.

John

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.