RE: Accessing documents in IFS with Excel from the iSeries -- MIDRANGE-L

put quotes around it...or use the MS-DOS short name, which would
probably be CONSOL~1.XLS..but that would be a PITA because you probably
have multiple files with the same first party of the name, so the ~x
would be different for each file...yeah, use quotes.

> -------- Original Message --------
> Subject: RE: Accessing documents in IFS with Excel from the iSeries
> From: "R Allen" <rallen@xxxxxxxxxxx>
> Date: Wed, April 13, 2005 9:44 am
> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> 
> Rob,
> 
> I have this working now (Thanks to everyone's help) BUT.....
> I want to use long file names such as 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE
> 2005-04-05.XLS')
> 
> I get an error message (appears it is truncating the file name at the first
> space):
> '\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED' is not recognized as an
> internal or external command, operable program or batch file.
> 
> Does this mean I cannot use long names, or blanks are not allowed, or there
> is some other was to specify the command?
> 
> Thanks
> 
> John
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Friday, April 08, 2005 5:01 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Accessing documents in IFS with Excel from the iSeries
> 
> gdisys is the system name, rob is the share name.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> "R Allen" <rallen@xxxxxxxxxxx> 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 04/08/2005 03:06 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> RE: Accessing documents in IFS with Excel from the iSeries
> 
> 
> 
> 
> 
> 
> I tried you suggestion but cannot get mine to work, what is the share name
> gdisys or rob?
> 
> The actual path is /REPORTS/ITDEPT/SALESRPT.PDF
> I have a share named REPORTS over the /REPORTS directory
> 
> I tried: STRPCCMD ('START REPORTS\ITDEPT\SALESRPT.PDF')
> 
> I tried: STRPCCMD ('\\REPORTS\ITDEPT\SALESRPT.PDF')
> "The system cannot find the path specified"
> 
> I tried: STRPCCMD ('START \\REPORTS\ITDEPT\SALESRPT.PDF')
> "Network path not found"
> 
> None of these worked, what am I overlooking doing wrong? 
> 
> Thanks
> 
> John
> 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Friday, April 08, 2005 2:40 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Accessing documents in IFS with Excel from the iSeries
> 
> Have you thought about using a share name and not a drive?  I just did:
> STRPCCMD PCCMD('\\gdisys\rob\craigs.txt')
> and that pulled up notepad and loaded that file right in.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> "John" <Jallen@xxxxxxxxxxx> 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 04/08/2005 02:19 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> <MIDRANGE-L@xxxxxxxxxxxx>
> cc
> 
> Subject
> Accessing documents in IFS with Excel from the iSeries
> 
> 
> 
> 
> 
> 
> We are creating some PDF files and Excel files on our iSeries and placing
> them in the IFS. 
> 
> I would like to give the users the ability to access these from their 
> green
> screen application.
> 
> I have tried STRPCCMD ('START Y:/REPORTS/ITDEPT/SALESRPT.PDF')
> 
> Which works fine but requires all users to map their drive Y the same.
> 
> And also requires that the user already be logged on to the Y drive (does
> not prompt for user id and password)
> 
>  
> 
> I want to display these files from an iSeries application and give the 
> user
> the option to view the pdf and excel files without starting a program on
> their PC
> 
>  
> 
> My questions are (bear with me if these are dumb questions, Running PC
> commands from the iSeries is new to me): 
> 
> 1) Is there another way to do this without a socket program?
> 
> 2) I can create a share from the iSeries, can I map a drive from the
> iSeries?
> 
> 3) Can I check to see if a drive is mapped (from an iSeries using RPG or 
> CL)
> 
> 4) The users may put their PDF and Excel files into different directories 
> in
> the IFS, The program knows exactly where the PDF and Excel files are (has
> the complete IFS path name) I do not want to create a share of the IFS 
> root,
> is there a better way to run the STRPCCMD to allow this (without making 
> the
> user key in the directory path)
> 
> Example I have a database with /REPORTS/ITDEPT/SALES.PDF in it, The 
> easiest
> thing would be to have all users map drive Y to the root then the STRPCCMD
> at the beginning of this email would work for them all, however since I do
> not want the Y drive mapped to the root, I am looking for other
> possibilities. Has anyone done anything like this and if so how did you
> implement?
> 
>  
> 
>  
> 
> Thanks
> 
>  
> 
> John
> 
>  
> 
>  
> 
>  
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.