I am trying to save a file to a network path (UNC) so that others can access it to extract the data. I beleive the problem is that the path name has both a '$' and spaces in it and I believe one or both is causing my problem. The code I am using is:

-SET &FULLPATH = '\\Directory name\reports$'
-SET &FILENAME = '\' | 'Filename.xls'
-SET &FULLFILE = &FULLPATH | &FILENAME ;
APP MAP TEMPDATA &FULLPATH
APP HOLD TEMPDATA
FILEDEF QCEXLTMP DISK &FULLFILE
....
....
ON TABLE HOLD AS QCEXLTMP FORMAT EXL2K TEMPLATE 'QCEXPHLD' SHEETNUMBER 1

I get this error:
(FOC358) ERROR ISSUING FILEDEF COMMAND FOR: filedef QCEXLTMP DISK \\Directory name\reports$

(The actual directory is MUCH longer. Could that be causing the problem?)

Any help would be appreciated.

try taking out the $
the $ is useful when mapping a drive
eg d$ will mapp to the root of the d drive
but not useful in a filedef drive reference
at least in my installation...
If blanks are giving you a prob, you could try replacing them with %20
No promises..but worth a shot till somebody smarter comes along.

Mathew,

try coding it as follows

-SET &FULLPATH = '\my reports\reports$';
-SET &FILENAME = '\' || 'Filename.xls';
-SET &FULLFILE = '&FULLPATH.EVAL' || '&FILENAME.EVAL' ;

FILEDEF QCEXLTMP DISK "&FULLFILE.EVAL"
-RUN
TABLE FILE CAR
PRINT MODEL
BY CAR
ON TABLE HOLD AS QCEXLTMP FORMAT EXL2K
END
-RUN

I assume that the directory structure is on the same disk as the WebFocus server otherwise you need to give it a drive letter.

There is a bug in 7.1 (beta 3 anyway) where if the WebFocus server is started as a service then
it cannot see mapped network drives (works fine in 5.3) It cannot even do a DOS copy or move.
The problem does not occur if the WebFOcus server is started via the edastart batch file.

JG

Try putting double quotes around the fullname variable in the filedef. Also...Do you have semi-colons after the first two -set commands?

-SET &FULLPATH = '\\Directory name\reports$';
-SET &FILENAME = '\' | 'Filename.xls';
-SET &FULLFILE = &FULLPATH | &FILENAME;
-*
-TYPE FULLPATH ---- &FULLPATH
-TYPE FILENAME ---- &FILENAME
-TYPE FULLFILE ---- &FULLFILE
-*
FILEDEF QCEXLTMP DISK "&FULLFILE"

Jim

Thanks for everyone's suggstions. I did get it to work with the "$" and Spaces in the path name. I think it was the double quotes that did the trick.

Matthew,

This also works for me if you're interested.

-SET &FULLPATH = '\\Directory name\reports$';
-SET &FILENAME = 'Filename.xls';
-*
-TYPE FULLPATH ---- &FULLPATH
-TYPE FILENAME ---- &FILENAME
-*
FILEDEF QCEXLTMP DISK "&FULLPATH|\&FILENAME"

Jim