RE: Getting data into a PF from an Excel spreadsheet

This has worked every time for me - in some fairly complicated systems.
The lengths and content of the data in the spreadsheet must of course be
consistent on each download, have a direct correlation to the actual DDS
specs, and not be subject to change without notice.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, August 29, 2007 9:28 AM
To: Midrange Systems Technical Discussion
Subject: RE: Getting data into a PF from an Excel spreadsheet

AFAIK, the visible width of the spreadsheet columns have absolutely no
effect on the length of the actual data.


Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Wednesday, August 29, 2007 10:15 AM
To: Midrange Systems Technical Discussion
Subject: RE: Getting data into a PF from an Excel spreadsheet

I right click on each column in the spreadsheet and choose "column
width", and then make it the same.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Friday, August 24, 2007 12:13 PM
To: Midrange Systems Technical Discussion
Subject: Re: Getting data into a PF from an Excel spreadsheet

Don Cavaiani wrote:

I make sure the columns lengths of the Excel spreadsheet

are the same

length as the System i5 file.

Then, I save the spreadsheet as a fixed length file - a .prn format.

Finally, just ftp it directly into the qsys file - no need

for any IFS

here

OK, how do I "make sure the columns lengths . . . are the same length
as the . . . file? The first time we tried generating a .prn file,
there was truncation.

Tab-delimited failed after importing 20 (seemingly random) records.

Comma-delimited did even worse.

There is absolutely no doubt in my mind that it is the embedded CRLFs

--
James H. H. Lampert
Touchtone Corporation

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

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not
a named addressee you are hereby notified that you are not authorized to
read, print, retain, copy or disseminate this communication without the
consent of the sender and that doing so is prohibited and may be
unlawful. Please reply to the message immediately by informing the
sender that the message was misdirected. After replying, please delete
and otherwise erase it and any attachments from your computer system.
Your assistance in correcting this error is appreciated.

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