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