topic Re: html on remote path in ODS and Base Reporting

html on remote path

NN — Wed, 12 May 2010 12:20:16 GMT

HI,
I wanted to save my html on a remote UNIX server. I have the following details with me HOST , Path = /mypath/ , Username , Password.

Secondly i want my GPATH to also point to the above remote path.

Will i be able to achieve this. If yes could someone please guide.

Re: html on remote path

Andre — Wed, 12 May 2010 12:32:40 GMT

First of all , be clearer

are you working on a sas windows and using a sas connect to work also upon a sas unix session?
are you working through a x11 screen from a windows pc
are you working on sas windows and wishing to save a file on a unix server
which is asking you a password to deposit the file on the (html) server?

Andre

Re: html on remote path

NN — Wed, 12 May 2010 14:00:51 GMT

Andre,
I am using EG4.2 on a BI Intelligence platform Server1 where my html query is executed.
I have a second server Server2(unix) where i wish to save the above created html output. I donot wish to open any sessions on this server i just wish to save the html on a given path.

I hope the above info proves useful if not please do let me know.

Re: html on remote path

Cynthia_sas — Wed, 12 May 2010 14:32:45 GMT

Hi:
An additional few questions...you say you have an HTML query??? is this an EG query that returns HTML output??? Are you running a Stored Process using either the Stored Process Server or the Workspace Server to execute the query as a stored process?? Where does the data for the query live??? (standalone data or defined in the metadata)

Is the second server your webDAV server??? Are you trying to publish your EG report to the webDAV server (like Xythos), so the report will be accessible to other clients on the BI platform???

cynthia

Re: html on remote path

NN — Wed, 12 May 2010 14:46:04 GMT

@cynthia,
The query is a regular ods html Query on EG on Workspace Server and the data is a standalone data.

I wanted to save the ouput on the second webDAV server so that i could use the URL to display my ouput on SAS portal so that it can be viewed by other clients.

Re: html on remote path

Cynthia_sas — Wed, 12 May 2010 15:35:39 GMT

Hi:
I don't have access to a 4.2/9.2 Platform installation right now. You can't just do a FILE--> SAVE AS to the webDAV server from EG. I believe there's an explicit PUBLISH choice someplace. It's either on the Results tab or on the HTML icon for the results, where you can select PUBLISH to publish the output to the webDAV server.

You might check with Tech Support for the publishing steps when you're dealing with the Platform.

cynthia

Re: html on remote path

NN — Thu, 13 May 2010 06:04:31 GMT

The second server / HOST that i talk about is not on my intelligence Platform .
Hence the Save as / PUBLISH option doesnot work.

I was Looking for something in the lines of the filename FTP Statement.

If a direct solution is not available My fianl Alternative will be to use the regular FTP protocol to tranfer my outputs to the remote host.

Re: html on remote path

NN — Thu, 13 May 2010 06:04:44 GMT

Re: html on remote path

NN — Thu, 13 May 2010 06:10:55 GMT

Re: html on remote path

NN — Thu, 13 May 2010 06:19:32 GMT

Re: html on remote path

NN — Thu, 13 May 2010 06:24:39 GMT

Re: html on remote path

NN — Thu, 13 May 2010 09:09:28 GMT

Found the following code in SAS help. Just the thing that i was looking for.
But i think this works only on 9.2.

filename output1 ftp "~user/dir" fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
filename output2 ftp "~user/dir" dir fileext host="host.unx.company.com"
user="userid" pass="userpass" recfm=s debug;
ods listing close;
ods html body='body.html' path=output1 gpath=output2
frame='frames.html' contents='contents.html';
proc gtestit;run;quit;
ods html close;
ods listing;

Re: html on remote path

NN — Thu, 13 May 2010 09:10:36 GMT