suggest to “ APP MAP the server/machine via the Reporting server in edasprof.prf and SAVE to the MAPped DRIVE:\\foldername “. I have all the permission for the output drive - “Full control, modify, Read & execute, list folder contents, read,…”. Our folks can save output to the drive with WF 7.7.03 window server, but my WF8.0.03 does not work.
My question is : should the APP MAP be done at edasprof.prf or can be done at wf program level? or anything I miss?
1) I used APP AMP at WF program level, it ran OK with no error, but I can’t find the output file at my output drive. See attached WF program.
2) Our admin later added the APP MAP in EDASPROF.prf, and also include it at Application path. When I ran the attached WF program, it remains the same, no error from program, but I still can’t locate the output in the output drive.
Do you have any clues? Thanks.
APP MAP WFOUTPUT \\s11BAB3\DMIA\WF_OUTPUT
FILEDEF SAVEOUT DISK WFOUTPUT\EMILY1.XLS
TABLE FILE CAR
PRINT
CAR.ORIGIN.COUNTRY
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.SPECS.MPG
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
TABLE FILE HOLD1
PRINT
*
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SAVE AS SAVEOUT FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END
This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.2.01 AppStudio HTML, PDF, Excel
November 03, 2014, 04:56 PM
rogerwilkouk
The way we do this is to map a network drive on our reporting server first. We then create the file on a drive within the Reporting Server and the copy (or move) it to the desired network outside the Server
FILEDEF SAVEOUT DISK \\s11BAB3\DMIA\WF_OUTPUT\EMILY1.XLS
:
:
TABLE FILE HOLD1
PRINT *
ON TABLE SAVE AS SAVEOUT FORMAT EXL2K
END
Didn't it work for you?This message has been edited. Last edited by: Rifaz,
-Rifaz
WebFOCUS 7.7.x and 8.x
November 04, 2014, 12:45 PM
Emily Lee
Use FILEDEF SAVEOUT DISK \\s11BAB3\DMIA\WF_OUTPUT\EMILY1.XLS I get FOC350 ERROR WRITING OUTPUT FILE:SAVEOUT.
use APP FI SAVEOUT DISK WFOUTPUT\EMILY1.XLS or FILEDEF SAVEOUT DISK WFOUTPUT\EMILY1.XLS I receive file save success message, but can't find the output file.
WebFOCUS 8.2.01 AppStudio HTML, PDF, Excel
November 04, 2014, 09:59 PM
StuBouyer
Is the WebFOCUSA service running as a named user or as "Local System"
If the later, then you should try running as a named user and then ensure that the named user has write/modify access to the shared folder.
you may also need to give the user modify access to the folder on the NTFS level too as sometimes this can over-ride the share permissions.
Hope that helps
Regards
Stu
WebFOCUS 8.2.03 (8.2.06 in testing)
November 05, 2014, 08:12 AM
njsden
Did you try rogerwilkouk's suggestion? Avoiding the UNC notation altogether and exposing it as a mapped drive instead may make things easier:
-DOS net use G: \\s11BAB3\DMIA
APP MAP WFOUTPUT G:\WF_OUTPUT
FILEDEF SAVEOUT DISK WFOUTPUT/EMILY1.XLS
-RUN
TABLE FILE CAR
PRINT
CAR.ORIGIN.COUNTRY
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.SPECS.MPG
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
TABLE FILE HOLD1
PRINT
*
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SAVE AS SAVEOUT FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END
-RUN
-DOS net use G: /delete