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



I'd also look into trying different values of the RCDDLM parameter in
CPYFRMIMPF. The default is *EOR, and I usually find I need to change
this to either *CR, *LF or one of the combinations of those.

Trevor Briggs
Analyst/Programmer
Lincare, Inc.
(727) 431-1246
TBriggs2@xxxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Friday, October 05, 2012 2:54 PM
To: RPG programming on the IBM i / System i
Subject: Re: Query in CPYFRMIMPF

Save the file from Excel in .csv format for the first thing - you
don't need to do the NotePad thing.

Then, use CPYFRMIMPF and specify FROMRCD(2). That will skip the heading
line.

Try that, and check for error messages with the QCMDEXC technique.
Look in your job log.



On Fri, Oct 5, 2012 at 2:49 PM, Nisha Ramesh <n4nisha@xxxxxxxxx> wrote:
Hi,

Could you please extend your help to me as I am stuck here with one
issue.
This is the requirement. I have an excel sheet with some rows of data
in
it. It is in .xls format. The first row is heading and second row
onwards
are data. I need to copy this file to a physical file in AS400. For
this, I
have opened the excel, copied the data to a notepad and I have put the
delimeters(,) after each field and saved it back as .csv. Now I used
Iseries navigator and placed this .csv file onto the location I want
it.
Inorder to get the data onto a PF, I am changing an existing RPG
program
which uses CPYFRMIMPF. with the help of QCMDEXC. But this command
fails.
But when I try to enter the same command from command line it is
copying
data to PF. The other issue here is with the heading. If I include
heading,only heading is coming in. But if I remove heading, then first
row
alone comes in . Please let me know why the QCMDEXC fails when it runs
properly in command line. Second is if the excel has one row of
heading,
how to deal with it? Then how do I copy multiple rows of data here? It
will
be really helpful if u respond back..
--
This is the RPG programming on the IBM i / System i (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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.