Re: Query in CPYFRMIMPF

[Nisha Ramesh <n4nisha@xxxxxxxxx>]

When I save the excel file to .csv format and just tried to open the excel
again, it is non readable format. Is that okay?

On 6 October 2012 00:24, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

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