Accéder au contenu principal

Oracle WebCenter Spaces Governance

 

Oracle WebCenter Space allows creation of Collaboratives areas. As it’s very easy to create a WorkSpace, it’s common to observe a workspace proliferation. So, it can be useful to check  the activity inside each of Spacers, and decide if it has to be archived depending the audience.

This post explains how to setup a very simple diagram which provides, inside WebCenter Space, an overall activity statistics for a given Workspace.The idea relies on the fact that activity is recorded in database Table.

Prerequisites

  • Oracle WebCenter Spaces is already installed
  • The schema which contains Spaces metadata is : DEV_WEBCENTER (or an other name) and the password must be known.

Steps

  • Create the following objects in DEV_WEBCENTER schema, with sqlplus or a similar tool

create type ext_array as table of number;

create function
  ext_gen_numbers(n in number default null)
  return ext_array
  PIPELINED
  as
  begin
     for i in 1 .. nvl(n,999999999)
     loop
         pipe row(i);
     end loop;
     return;
  end;

  • Create a diagramm with omniportlet tool (it’s a generic portlet which allows to create diagrams or lists based on SQL statements, XML, etc)

Along the wizzard, choose a SQL source, then enter the following statement:

select to_char(B.ti,'Month YY') month, nvl(A.nb,0) nb from (
select trunc(activity_time,'MONTH') ti, count(*) nb
from WC_SPACE_HEADER S,
WC_AS_ACTIVITY_ELEMENT A
where S.DISPLAY_NAME='ODrink'
group by trunc(activity_time,'MONTH')
) A,
(
select add_months(trunc(sysdate,'MONTH'),-column_value+1) ti
  from TABLE(ext_gen_numbers(12))
) B
where A.ti(+) = B.ti
order by B.ti

In the Layout tab, choose Line displaying:

image

After validating, this is the result which can be easily obtained:

image

 

By instancing the omniportlet multiple time, one can setup a complet dashboard: The following SQL provides Page activity for all the spaces (only three in our sample, but it’s just a demo):

select display_name, count(*) nb
from WC_SPACE_HEADER S,
WC_AS_ACTIVITY_ELEMENT A
where A.SCOPE_ID = S.SPACE_GUID and
service_id like 'oracle.webcenter.page%'
group by display_name, service_id

image

 

Version: 1.1 19-Aug-2010

Commentaires

Posts les plus consultés de ce blog

Oracle Documents Cloud Service - Using Upload File REST API

If the Upload File sample given in ODCS documentation is used "as is", we get a http 400 error. The syntax is strict and every blank line must be empty (no space character for instance). If we cust and paste the sample, there are residual space characters which must be removed. So, use this pattern instead: -----1234567890 Content-Disposition: form-data; name="jsonInputParameters" { "parentID": " " } -----1234567890 Content-Disposition: form-data; name="primaryFile"; filename="example.txt" Content-Type: text/plain Hello World! -----1234567890-- instead the original one: -----1234567890 Content-Disposition: form-data; name="jsonInputParameters" { "parentID":"FB4CD874EF94CD2CC1B60B72T0000000000100000001" } -----1234567890 Content-Disposition: form-data; name="primaryFile"; filename="example.txt" Content-Type: text/plain -----1234567890-- Tests can be...

Radio privée sur Freebox avec VLC , IceCast et Freemi

Voici quelques notes pour réaliser une radio privée, de type webradio , destinée à être reçue par plusieurs récepteurs de type FreeBox ou autres. Le cas d’usage est celui on l’on désire passer d’une pièce à l’autre tout en écoutant le même morceau de musique à partir d’une FreeBox TV HD. Version de ce post: 1.1 Configuration matérielle nécessaire FreeBox 5 ADSL PC Windows XP SP3 ou + FreeBox TV Nro 1 FreeBox TV Nro 2 (optionnel) Un serveur contenant les fichiers MP3 à diffuser (cela peut être le PC mentionné plus haut ou bien un serveur NAS connecté sur le routeur de la Freebox) Principe Mettre en place un serveur de diffusion de type shoutcast qui s’appelle IceCast2 (similaire et gratuit) Générer un flux musical en streaming avec VLC vers le serveur de diffusion IceCast, à partir des fichiers MP3 situés sur un disque accessible en direct ou depuis un NAS Référencer le serveur IceCast au niveau du serveur UpnP Freemi Au niveau de la FreeBox, choisir la source radio...

Streaming mp3 fromVLC / Icecast to Android

Here are some tips for streaming music to android mobile devices from a PC. Platform which has been used fo test: Ubuntu 11.10 oneiric + a NAS for storing music (windows can fit as well) Videolan VLC 1.1.12 (providing mp3 flow) icecast 2.3.2 (shoutcast radio) Winamp 1.2.12 for Android mobile(music player) Android-vlc-remote for Android (remote control for VLC) Start icecast server icecast2 -c icecast.xml The icecast xml config file is the original one. don't modify anything at this stage.  Setup VLC in order to stream mp3 instead ogg format Close VLC Prepare a playlist (ie: scarlatti.m3u) with Banshee or whatever. Launch VLC in command line vlc scarlatti.m3u --sout '#standard{access=shout,mux=ogg,dst=source:hackme@192.168.0.3:8000/scarlatti}' --sout-keep --extraintf=luahttp --fullscreen --http-album-art     Check that icecast is displaying a mount point for the new radio Check the HTTP...