RE: Trying to copy an excel spreadsheet

[CWilt@xxxxxxxxxxxx]

First off, this isn't really RPG related so it should go into MIDRANGE-L.

Secondly, if you're really trying to use CPYFRMIMPF on an excel file ( with
.XLS) there's no way that will work.

.XLS is a binary file format.  CPYFRMIMPF works on text files only.  You
need to save the excel file from excel as a .CSV file.


HTH

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: David Rittenberg [mailto:DRittenberg@xxxxxxxxxxxxx]
> Sent: Wednesday, November 24, 2004 3:25 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Trying to copy an excel spreadsheet
> 
> 
> I'm trying to copy an excel spreadsheet from the IFS to an externally 
> described file whose fields allow nulls using CPYFRMIMPF as follows:
> 
> CPYFRMIMPF FROMSTMF('/QDLS/BW/BW/XFER/EDIPACER.XLS') 
> TOFILE(WLIBWH/MATPICK) MBROPT(*REPLACE) RCDDLM(*CRLF)
> 
> I get the following error messages:
> 
> Message ID . . . . . . :   CPIA082       Severity . . . . . . 
> . :   10  
> Message type . . . . . :   Information  
> Date sent  . . . . . . :   11/24/04      Time sent  . . . . . 
> . : 12:10:48
>   
> Message . . . . :   End-of-file found before physical end of file. 
> Cause . . . . . :   An end-of-file character was found in the 
> stream file
>   before the end of the stream file was reached. 
> Recovery  . . . :   Check to ensure correct stream file code page is 
>   specified, then submit the command again. 
> 
> Message ID . . . . . . :   CPF2973       Severity . . . . . . 
> . :   10  
> Message type . . . . . :   Diagnostic  
> Date sent  . . . . . . :   11/24/04      Time sent  . . . . . 
> . : 12:10:48 
>  
>   
> Message . . . . :   Data from file QACP678463 in QRECOVERY 
> truncated to 3  
>  
>   characters.  
> Cause . . . . . :   The maximum record length for member 
> QACP678463 in  
>   from-file QACP678463 in library QRECOVERY is longer than 
> the maximum 
> record 
>   length for to-file MATPICK in library WLIBWH.  
> Technical description . . . . . . . . :   If the from-file is 
> a tape file 
> with
>   variable length records or if multiple record formats are 
> copied from a  
>  
>   logical file, only the records that are longer than 3 
> characters are  
>   truncated.  If the to-file has a *FCFC value on the CTLCHAR 
> parameter 
> for 
>   the printer file, the record length includes one byte for a 
> control  
>   character.  If the from-file and to-file are different file 
> types (*SRC 
> or 
>   *DATA), this message is sent only if the data part of 
> from-file records 
> is 
>   truncated in the to-file.  If FMTOPT(*NULLFLAGS) was 
> specified then the  
>  
>   maximum record length of the to-file is the sum of the 
> to-file record 
> length
>   and the number of null-capable fields in the to-file.  
> 
> I'm only getting 1 record copied and only 3 characters in 
> that record (the 
> length of the first field) and they're garbage.  Can someone 
> please tell 
> me what I'm doing wrong?  Thanks,
> 
> Dave
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>