topic Re: Publishing excel and pdf to xythos in Developers

Publishing excel and pdf to xythos

deleted_user — Wed, 10 Jan 2007 15:41:28 GMT

All,

I have figured out how to publish pdf files to xythos. However, excel files get sent as data sets. Has anyone found a way to have the excel file show up in xythos? We intend to automate everything. Scenario:

1) program runs as a job via job scheduler.
2) the output could be in 2 formats, excel and/or pdf
3) the output should be sent to xythos in its original format (i.e. excel shows up as excel in xythos, not data set)
4) when user logs into the portal, the new excel/pdf file should show up for the user (if they are authorized to see it)
5) when the job runs the next day or week or month, the output should have a different name so that users can see old data.

Has anyone accomplished this? if so, how? I already asked SAS support they said I will need to write custom code to accomplish this. I just wanted to know if folks in other companies are doing this, or what other possible alternatives are available.

Thanks in advance.

Re: Publishing excel and pdf to xythos

Vince_SAS — Wed, 31 Jan 2007 16:30:33 GMT

Can you post some simple SAS code that illustrates how you are publishing the files?

Vince
SAS R&D

Re: Publishing excel and pdf to xythos

deleted_user — Fri, 23 Feb 2007 21:30:21 GMT

Here it is:

/* ------------------------------------------------
Package: pdf to xythos
To channel: test of xythos
SAS Server: SASMain
------------------------------------------------
*/
ODS _ALL_ CLOSE;
/* Diagnostic function */
%macro chkrc(function);
%if &rc = 0 %then %put "NOTE: &function succeeded.";
%else %do;
%let msg = %sysfunc(sysmsg());
%put &function failed - &msg;
%end;
%mend;

/* package preamble */
%let package_options = ABSTRACT;
%let pid = 0;
%let rc = 0;
%let namevalue= ;
%let abstract_text= %nrbquote(Published Automatically on 11/15/06);
%let description = %nrbquote(pdf to xythos);
%syscall package_begin(pid, description, namevalue, rc, package_options, abstract_text);
%chkrc(Package Begin);

/* Add the "path\filename" file */
%let description = %nrbquote(filedescription);
%let namevalue = ;
%let body = %nrbquote(filename:path\filename);
%let type = BINARY;
%let mimetype = %nrbquote(application/pdf);
%syscall insert_file(pid, body, type, mimetype, description, namevalue, rc);
%chkrc(Insert File);

/* Publish the package */
%let pubType = TO_SUBSCRIBERS;
%let pub_properties = CHANNEL_STORE, PARENT_URL, METAUSER, METAPASS;
%let channelURI = %nrbquote(SAS-OMA://server:port/reposname=reponame);
%let channel = %nrbquote(test of xythos);
%let url = ;
%let muser = %nrbquote(domain\id);
%let mpass = %nrbquote(password);
%syscall package_publish(pid, pubType, rc, pub_properties, channelURI, url, muser, mpass, channel);
%chkrc(package publish);

Re: Publishing excel and pdf to xythos

Cynthia_sas — Sat, 24 Feb 2007 19:26:07 GMT

Every time you see 😛 above, replace it with colon followed by the letter 'p' (: p).
cynthia

Note to forum monitor: the use of square bracket+pre, etc does NOT prevent the colon+p from getting turned into a smiley face. For example, this section is a "pre" section:
[pre]
colon p 😛
colon ) 🙂
semicolon ) 😉
[/pre]
I thought the 'pre' and '/pre' would prevent these letter/punctuation combos from getting translated to a smiley??