RE: Getting data into a PF from an Excel spreadsheet

We work closely with John Deere. They have a WEB site with all the open
orders they have placed with hundreds of their suppliers like us. They
have a download button which creates a .XLS, which we then convert to a
.prn, and upload directly into System i5 database. If they changed
their .XLS format even one little bit, heads may roll.

-----Original Message-----
From: midrange-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx] On
Behalf Of Darrell A Martin
Sent: Wednesday, August 29, 2007 1:01 PM
To: Midrange Systems Technical Discussion
Subject: RE: Getting data into a PF from an Excel spreadsheet

Greetings:

The only absolutely predictable thing about *.XLS files supplied by
users (or vendors or customers) is that once you have come to a firm and
binding agreement that nothing about the format will change, the format
will prove to be randomly variable. In fact the probability, for any
given instance of a file, that it will be generated by somebody other
than the normal sender (e.g. a temp working in Lotus 1-2-3 R5), is
directly proportional to the cube of the number of persons being away
from the office, who would know how to deal with a format change.

Darrell

Darrell A. Martin - 630-754-2141
Manager, Computer Operations
dmartin@xxxxxxxxxxxxx





This e-mail, including attachments, may contain information that is
confidential and/or proprietary, and may only be used by the person to
whom this email is addressed. If the recipient of this e-mail is not the
intended recipient or an authorized agent, the reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is
prohibited. If this e-mail has been delivered to you in error, please
notify the sender by replying to this message and deleting this e-mail
immediately.
--
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.