RE: Accessing documents in IFS with Excel from the iSeries

This worked, 


Thanks


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: Wednesday, April 13, 2005 9:18 AM
To: Midrange Systems Technical Discussion
Subject: RE: Accessing documents in IFS with Excel from the iSeries

Try this...

STRPCCMD PCCMD('"\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE
2005-04-05.XLS"')

Double quotes around the whole thing.


> -------- Original Message --------
> Subject: RE: Accessing documents in IFS with Excel from the iSeries
> From: "R Allen" <rallen@xxxxxxxxxxx>
> Date: Wed, April 13, 2005 10:10 am
> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> 
> Put quotes around what? I have quotes around the PCCMD
> I tried:
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE
> 2005-04-05.XLS')
> 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\"CONSOLIDATED BALANCE
> 2005-04-05.XLS" ')
> 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\''CONSOLIDATED BALANCE
> 2005-04-05.XLS'' ')
> 
> All with the same results
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> michael@xxxxxxxxxxxxxxxxxx
> Sent: Wednesday, April 13, 2005 8:56 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Accessing documents in IFS with Excel from the iSeries
> 
> 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.
> 
> -- 
> 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.