RE: Accessing documents in IFS with Excel from the iSeries

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.