RE: Getting a file to excel

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Could do that in the IFS, but the authority would be applied via os400 user 
profile, while their Windows domain profile/password may be different.  They 
could look in that folder, but they wouldn't see anything.  If I could instruct 
Windows to prompt for login, then I'd be fine.....

So far, the only solution that makes sense to me is a cgi app that prompts the 
user for their AS400 credentials, validates the creds, then gives them a list 
of files that were registered to their profile.  On the application side, we 
would have a registration api that acquires the output (DBF, stmf, splf, ...) 
and stores it to a repository.  Seems simple enough.....  

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 Holden Tommy
Sent: Monday, July 03, 2006 12:33 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Getting a file to excel


How about using a single directory but using the CHGAUT command to allow
only the creating user access to the document?? 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: Monday, July 03, 2006 12:11 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Getting a file to excel

Yes, we have a default user for our file transfer utility that uses
QNTC, but in this case, mapping to end-user folder destinations would
need to be defined for hundreds of users.  We're concerned that each
user's output should be secured from access by all other users,
requiring a unique destination for each user.  We *could* go this way,
but network support group does not want to manage 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 Scott Johnson
Sent: Friday, June 30, 2006 4:03 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel


What I did here to get around user access issues is create a userid that

exists on both the AS400 side and the PC server side.  On the AS400, the

job that creates the spreadsheet is run using this userid.  It writes
the 
spreadsheet to a folder on a pc server using the QNTC in the IFS.  I
just 
have to tell the network admin that this user needs access to that
folder.

-- Scott J.

DeLong, Eric wrote:
> 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