RE: Getting a file to excel -- RPG400-L

One of the problems we have with that is that not all iSeries users keep their 
Windows and iSeries profiles in sync.  SSO is not an option, and I was told NO 
to creating a web app to serve as a file/report broker.  I could solve this 
easily if I had some way to force a "login as user...." dialog whenever the 
user tried to access the IFS, but I can't see any way to do this.....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Robert Cozzi
Sent: Wednesday, June 28, 2006 11:34 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel


Eric,

Since someone mentioned RPG xTools' CPYTOCSV command, I thought I'd mention
that to solve the email-size issue, most of my customers simply pump the
file to the IFS and then send a URL/link to the file in the email. It has
worked great.

-Bob Cozzi



On 6/28/06 11:10 AM, "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx> wrote:

Steve,

I feel I should chime in with a word of caution....  Sending CSV or XLS
attachments in Email is a practice guaranteed to create grief.  Eventually,
someone will run a report for the last 15 fiscal years, and produce an
attachment too large to be delivered.  We are exploring alternatives to email
delivery for just this reason.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of steema@xxxxxxxxxxxxx
Sent: Wednesday, June 28, 2006 8:23 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel


Michael, I think they want it to be hands - free. So it could be emailed
to them. Is there a easy way to do this?

I have users, go to

Tools --> Transfer Data from iSeries.   Then have them select a data
transfer request that is saved to their personal network drive. It's been
awhile, but if I remember correctly... the file doesn't even have to be
CSV, just a regular database file.

Michael Schutte




             steema@diskhaven.
             com
             Sent by:                                                   To
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx
             midrange.com                                               cc
                                       midrange-l@xxxxxxxxxxxx
                                                                   Subject
             06/28/2006 09:16          Getting a file to excel
             AM


             Please respond to
              RPG programming
              on the AS400 /
                  iSeries
             <rpg400-l@midrang
                  e.com>






HI What are some of the methods in taking a file that was generated by an
RPG program and getting it to the user in an Excel Worksheet file?

It seems to be a straightforward file. Is there a preferred method. Any
issues w/ v5.3 and the client access ?

Thanks,
Steve
--
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.



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