RE: Query in CPYFRMIMPF

[Alan Shore <ashore@xxxxxxxx>]

Sorry - no
You need to perform a "Save as" within excel (I also recommend that you delete the column headings) 
How are you communicating with the AS400?
Are you using I Series Access for Windows?
If so I can show you and "easier" way 

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

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

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


Disclaimer: This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.