|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.