|
--------------------------------
message: 3
date: Fri, 3 May 2013 13:17:27 +0000
from: Gary Thompson <gthompson@xxxxxxxxxxx>
subject: data entry from excel workbook
Strange this project should come up this week!
This week it became apparent we need to automate data entry to
maintain detail article dimensions and attributes to support a robotic
picking system we are starting to commission.
RPGLE, embedded SQL and basic API programming is our sweet spot. We
do have one person skilled in Excel macros and automation with VBA.
Our warehouse team is very attached to an Excel workbook and we need
to eliminate delays that occur in passing the workbook to a data entry
person (not always available to meet warehouse schedules), provide
data edits and error reporting, eliminate typing errors and make the
process much faster.
My question is what tool(s) do we use to consume the Excel workbook ?
We have been using for some time (and great effect) variations on
Scott Klement's DELTREE to process files on the IFS, and have seen
discussion of ways to read Excel files (don't see a need to
write/update but have not absolutely ruled this out).
------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.