uPortal 3 stats recorder to database

[Matthew Peterson-2]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Does anyone know of a stats recorder for uPortal3 which records to db tables using uPortals spring defined datasource? Or any other suggestion with regards to recording stats to our db?

 

Cheers,

 

Matt Peterson

Web Developer

University of New England

Ph. [phone]

 

-- 

You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Neusa Bach]

Hi everyone!

We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.

I am trying to install de quick-start version of uPortal so we can get a
feeling of the portal but I'm having trouble installing it on Windows.

If anyone could point me where to find more detailed information on how
to install it on windows I will be grateful.

I have already installed JDK 1.6 and it includes the tools.jar and I set
the path on the JAVA_HOME environment variable.

Thanks!

Neusa Bach

Consultant

USC


>

-- 

> 

You are currently subscribed to uportal-user@... as: 
nbach@...

> To unsubscribe, change settings or access 
archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Eric Dalquist]

Some parts of this message have been removed. Learn more about Nabble's security policy.

We have one for the 2.5 stats recorder interfaces that I'll be porting to 3.0 in the next few weeks If you're interested in either helping with that work or waiting for us to get to it we'll be happy (and plan to) share it.

-Eric

Matt Peterson wrote:

Does anyone know of a stats recorder for uPortal3 which records to db tables using uPortals spring defined datasource? Or any other suggestion with regards to recording stats to our db?

 

Cheers,

 

Matt Peterson

Web Developer

University of New England

Ph. [phone]

 

-- 

You are currently subscribed to uportal-user@... as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Eric Dalquist]

What version of uPortal are you using? What trouble are you having, please include any error messages.

One thing to keep in mind on Window is that the unzipping program included in Window does not handle path names longer than 255 characters and therefor cannot be used to unzip uPortal. You will need to find another unzip tool such as WinZip to extract uPortal on Windows.

'-Eric

Neusa Bach wrote:

Hi everyone!

We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.

I am trying to install de quick-start version of uPortal so we can get a
feeling of the portal but I'm having trouble installing it on Windows.

If anyone could point me where to find more detailed information on how
to install it on windows I will be grateful.

I have already installed JDK 1.6 and it includes the tools.jar and I set
the path on the JAVA_HOME environment variable.

Thanks!

Neusa Bach

Consultant

USC


>

-- 

> 

You are currently subscribed to uportal-user@... as: 
nbach@...

> To unsubscribe, change settings or access 
archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Neusa Bach]

Hi Eric,

Thank you for reminding me to unzip with winzip, it solved part of the problem but now I am receiving the following error message:

C:\uPortal-3.0.0-quick-start > ant hsql

Unable to initialize threads: cannot find class java/lang/Thread

Thanks for your help, Neusa

On Thu, 22 May 2008 09:58:42 -0500, Eric Dalquist wrote

> What version of uPortal are you using? What trouble are you having, please include any error messages.
>
> One thing to keep in mind on Window is that the unzipping program included in Window does not handle path names longer than 255 characters and therefor cannot be used to unzip uPortal. You will need to find another unzip tool such as WinZip to extract uPortal on Windows.
>
> '-Eric
>
> Neusa Bach wrote:

Hi everyone!
>
> We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.
>
> I am trying to install de quick-start version of uPortal so we can get a
> feeling of the portal but I'm having trouble installing it on Windows.
>
> If anyone could point me where to find more detailed information on how
> to install it on windows I will be grateful.
>
> I have already installed JDK 1.6 and it includes the tools.jar and I set
> the path on the JAVA_HOME environment variable.
>
> Thanks!
>
> Neusa Bach
>
> Consultant
>
> USC
>
> >

-- 


> 


You are currently subscribed to uportal-user@... 
as: 

nbach@...

> To unsubscribe, change settings or access 

archives, see 

http://www.ja-sig.org/wiki/display/JSG/uportal-user

>
> --
> Open WebMail Project (http://openwebmail.org)
>
>
>

-- 


You are currently subscribed to uportal-user@... 
as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Eric Dalquist]

What JDK are you using? Can you run "java -version" and post the results?

Neusa Bach wrote:

Hi Eric,

Thank you for reminding me to unzip with winzip, it solved part of the problem but now I am receiving the following error message:

C:\uPortal-3.0.0-quick-start > ant hsql

Unable to initialize threads: cannot find class java/lang/Thread

Thanks for your help, Neusa

On Thu, 22 May 2008 09:58:42 -0500, Eric Dalquist wrote
> What version of uPortal are you using? What trouble are you having, please include any error messages.
>
> One thing to keep in mind on Window is that the unzipping program included in Window does not handle path names longer than 255 characters and therefor cannot be used to unzip uPortal. You will need to find another unzip tool such as WinZip to extract uPortal on Windows.
>
> '-Eric
>
> Neusa Bach wrote:

Hi everyone!
>
> We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.
>
> I am trying to install de quick-start version of uPortal so we can get a
> feeling of the portal but I'm having trouble installing it on Windows.
>
> If anyone could point me where to find more detailed information on how
> to install it on windows I will be grateful.
>
> I have already installed JDK 1.6 and it includes the tools.jar and I set
> the path on the JAVA_HOME environment variable.
>
> Thanks!
>
> Neusa Bach
>
> Consultant
>
> USC
>
> >

-- 


> 


You are currently subscribed to uportal-user@... 
as: 

nbach@...

> To unsubscribe, change settings or access 

archives, see 

http://www.ja-sig.org/wiki/display/JSG/uportal-user

>
> --
> Open WebMail Project (http://openwebmail.org)
>
>
>

-- 


You are currently subscribed to uportal-user@... 
as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Neusa Bach]

I download the jdk1.6.0_06. When I run java version I get version "1.1.7.31o"

On Thu, 22 May 2008 12:47:11 -0500, Eric Dalquist wrote

> What JDK are you using? Can you run "java -version" and post the results?
>
> Neusa Bach wrote:

> Hi Eric,
> Thank you for reminding me to unzip with winzip, it solved part of the problem but now I am receiving the following  error message:
> C:\uPortal-3.0.0-quick-start > ant hsql
> Unable to initialize threads: cannot find class java/lang/Thread
> Thanks for your help, Neusa
> On Thu, 22 May 2008 09:58:42 -0500, Eric Dalquist wrote
> > What version of uPortal are you using? What trouble are you having, please include any error messages.
> >
> > One thing to keep in mind on Window is that the unzipping program included in Window does not handle path names longer than 255 characters and therefor cannot be used to unzip uPortal. You will need to find another unzip tool such as WinZip to extract uPortal on Windows.
> >
> > '-Eric
> >
> > Neusa Bach wrote:

Hi everyone!
> >
> > We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.
> >
> > I am trying to install de quick-start version of uPortal so we can get a
> > feeling of the portal but I'm having trouble installing it on Windows.
> >
> > If anyone could point me where to find more detailed information on how
> > to install it on windows I will be grateful.
> >
> > I have already installed JDK 1.6 and it includes the tools.jar and I set
> > the path on the JAVA_HOME environment variable.
> >
> > Thanks!
> >
> > Neusa Bach
> >
> > Consultant
> >
> > USC
> >
> > >

-- 



> 



You are currently subscribed to uportal-user@... 

as: 


nbach@...

> To unsubscribe, change settings or access 


archives, see 


http://www.ja-sig.org/wiki/display/JSG/uportal-user

> >
> > --
> > Open WebMail Project (http://openwebmail.org)
> >
> >
> >

-- 



You are currently subscribed to uportal-user@... 

as: eric.dalquist@...
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-user

>
> --
> Open WebMail Project (http://openwebmail.org)
>
>

-- 


You are currently subscribed to uportal-user@... 
as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Eric Dalquist]

A co-worker has informed me that is the Microsoft JVM. It has personally been a long time since installing the JDK on Windows but I'm guessing something isn't setup correctly with the install or your path for using the JDK you downloaded.

-Eric

Neusa Bach wrote:

I download the jdk1.6.0_06. When I run java version I get version "1.1.7.31o"

On Thu, 22 May 2008 12:47:11 -0500, Eric Dalquist wrote
> What JDK are you using? Can you run "java -version" and post the results?
>
> Neusa Bach wrote:

> Hi Eric,
> Thank you for reminding me to unzip with winzip, it solved part of the problem but now I am receiving the following  error message:
> C:\uPortal-3.0.0-quick-start > ant hsql
> Unable to initialize threads: cannot find class java/lang/Thread
> Thanks for your help, Neusa
> On Thu, 22 May 2008 09:58:42 -0500, Eric Dalquist wrote
> > What version of uPortal are you using? What trouble are you having, please include any error messages.
> >
> > One thing to keep in mind on Window is that the unzipping program included in Window does not handle path names longer than 255 characters and therefor cannot be used to unzip uPortal. You will need to find another unzip tool such as WinZip to extract uPortal on Windows.
> >
> > '-Eric
> >
> > Neusa Bach wrote:

Hi everyone!
> >
> > We are evaluating options to deploy a portal at our institution and since we are an academic institution uPortal seems to be the perfect match.
> >
> > I am trying to install de quick-start version of uPortal so we can get a
> > feeling of the portal but I'm having trouble installing it on Windows.
> >
> > If anyone could point me where to find more detailed information on how
> > to install it on windows I will be grateful.
> >
> > I have already installed JDK 1.6 and it includes the tools.jar and I set
> > the path on the JAVA_HOME environment variable.
> >
> > Thanks!
> >
> > Neusa Bach
> >
> > Consultant
> >
> > USC
> >
> > >

-- 



> 



You are currently subscribed to uportal-user@... 

as: 


nbach@...

> To unsubscribe, change settings or access 


archives, see 


http://www.ja-sig.org/wiki/display/JSG/uportal-user

> >
> > --
> > Open WebMail Project (http://openwebmail.org)
> >
> >
> >

-- 



You are currently subscribed to uportal-user@... 

as: eric.dalquist@...
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-user

>
> --
> Open WebMail Project (http://openwebmail.org)
>
>

-- 


You are currently subscribed to uportal-user@... 
as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

--
Open WebMail Project (http://openwebmail.org)

-- 

You are currently subscribed to uportal-user@... as: eric.dalquist@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Cris J Holdorph]

Make sure to create a JDK_HOME environment variable pointing to the jdk
home dir.

Make sure to put the %JDK_HOME%\bin  directory *AT THE BEGINNING* of
your PATH environment variable.

Doing both of these things then restarting your command prompt and
running "java -version" should give you a different result.

---- Cris J H

Eric Dalquist wrote:

> A co-worker has informed me that is the Microsoft JVM. It has personally
> been a long time since installing the JDK on Windows but I'm guessing
> something isn't setup correctly with the install or your path for using
> the JDK you downloaded.
>
> -Eric
>
> Neusa Bach wrote:
>>
>> I download the jdk1.6.0_06. When I run java version I get version
>> "1.1.7.31o"
>>
>> *On Thu, 22 May 2008 12:47:11 -0500, Eric Dalquist wrote*
>> > What JDK are you using? Can you run "java -version" and post the
>> results?
>> >
>> > Neusa Bach wrote:
>>
>>>
>>> > Hi Eric,
>>> > Thank you for reminding me to unzip with winzip, it solved part of
>>> the problem but now I am receiving the following  error message:
>>> > C:\uPortal-3.0.0-quick-start > ant hsql
>>> > Unable to initialize threads: cannot find class java/lang/Thread
>>> > Thanks for your help, Neusa
>>> > *On Thu, 22 May 2008 09:58:42 -0500, Eric Dalquist wrote*
>>> > > What version of uPortal are you using? What trouble are you
>>> having, please include any error messages.
>>> > >
>>> > > One thing to keep in mind on Window is that the unzipping program
>>> included in Window does not handle path names longer than 255
>>> characters and therefor cannot be used to unzip uPortal. You will
>>> need to find another unzip tool such as WinZip to extract uPortal on
>>> Windows.
>>> > >
>>> > > '-Eric
>>> > >
>>> > > Neusa Bach wrote:
>>>> Hi everyone!
>>>> > >
>>>> > > We are evaluating options to deploy a portal at our institution
>>>> and since we are an academic institution uPortal seems to be the
>>>> perfect match.
>>>> > >
>>>> > > I am trying to install de quick-start version of uPortal so we
>>>> can get a
>>>> > > feeling of the portal but I'm having trouble installing it on
>>>> Windows.
>>>> > >
>>>> > > If anyone could point me where to find more detailed information
>>>> on how
>>>> > > to install it on windows I will be grateful.
>>>> > >
>>>> > > I have already installed JDK 1.6 and it includes the tools.jar
>>>> and I set
>>>> > > the path on the JAVA_HOME environment variable.
>>>> > >
>>>> > > Thanks!
>>>> > >
>>>> > > Neusa Bach
>>>> > >
>>>> > > Consultant
>>>> > >
>>>> > > USC
>>>> > >
>>>> > > >
>>>> --
>>>>
>>>>
>>>>
>>>> >
>>>>
>>>>
>>>>
>>>> You are currently subscribed to uportal-user@...
>>>>
>>>> as:
>>>>
>>>>
>>>> nbach@...
>>>>
>>>> > To unsubscribe, change settings or access
>>>>
>>>>
>>>> archives, see
>>>>
>>>>
>>>> http://www.ja-sig.org/wiki/display/JSG/uportal-user
>>>>
>>>> > >
>>>> > > --
>>>> > > Open WebMail Project (http://openwebmail.org 
>>>> <http://openwebmail.org/>)
>>>> > >
>>>> > >
>>>> > >
>>>> --
>>>>
>>>>
>>>>
>>>> You are currently subscribed to uportal-user@...
>>>>
>>>> as: eric.dalquist@...
>>>> To unsubscribe, change settings or access archives, see
>>>> http://www.ja-sig.org/wiki/display/JSG/uportal-user
>>>
>>> >
>>> > --
>>> > Open WebMail Project (http://openwebmail.org 
>>> <http://openwebmail.org/>)
>>> >
>>> >
>>> --
>>>
>>>
>>> You are currently subscribed to uportal-user@...
>>> as: eric.dalquist@...
>>> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user
>>
>>
>>
>> --
>> Open WebMail Project (http://openwebmail.org <http://openwebmail.org/>)
>>
>>
>> --
>>
>> You are currently subscribed to uportal-user@... as: eric.dalquist@...
>> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

---
You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[AUDEOUD Dominique]

I am beginnig a work to integrate stat events directly in the database
of the 2.6 version of the portal.
The goal is to edit monthly and annual statistics more easyly.
Eric, do you can give us more information about your project (new
database tables already configured, event handler already modified) ?
With my thanks
Dominique Audéoud
Service DSI-TICE
Université de Franche-Comté
Besançon, France
------------------

Eric Dalquist a écrit :

> We have one for the 2.5 stats recorder interfaces that I'll be porting
> to 3.0 in the next few weeks If you're interested in either helping
> with that work or waiting for us to get to it we'll be happy (and plan
> to) share it.
>
> -Eric
>
> Matt Peterson wrote:
>>
>> Does anyone know of a stats recorder for uPortal3 which records to db
>> tables using uPortals spring defined datasource? Or any other
>> suggestion with regards to recording stats to our db?
>>
>>  
>>
>> Cheers,
>>
>>  
>>
>> Matt Peterson
>>
>> Web Developer
>>
>> University of New England
>>
>> Ph. [phone]
>>
>>  
>>
>>
>> --
>>
>> You are currently subscribed to uportal-user@... as: eric.dalquist@...
>> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

---
You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user

[Eric Dalquist]

I've attached the tables we currently write stats events to. All the
code really does is use the database as a normalized log store. Although
we have historical stats going back to the uPortal go-live in June 06 we
still don't have much in the way of reporting tools for the data. Part
of the problem is simply the sheer volume and we haven't found the time
to put in work to get summarizing processes running.

I'll be starting on converting the recorder to the 2.6/3.0 stats system
next week and will post the end result, if there is enough interest we
can look at including it in a future version of uPortal.

-Eric

AUDEOUD Dominique wrote:

> I am beginnig a work to integrate stat events directly in the database
> of the 2.6 version of the portal.
> The goal is to edit monthly and annual statistics more easyly.
> Eric, do you can give us more information about your project (new
> database tables already configured, event handler already modified) ?
> With my thanks
> Dominique Audéoud
> Service DSI-TICE
> Université de Franche-Comté
> Besançon, France
> ------------------
>
> Eric Dalquist a écrit :
>> We have one for the 2.5 stats recorder interfaces that I'll be
>> porting to 3.0 in the next few weeks If you're interested in either
>> helping with that work or waiting for us to get to it we'll be happy
>> (and plan to) share it.
>>
>> -Eric
>>
>> Matt Peterson wrote:
>>>
>>> Does anyone know of a stats recorder for uPortal3 which records to
>>> db tables using uPortals spring defined datasource? Or any other
>>> suggestion with regards to recording stats to our db?
>>>
>>>  
>>>
>>> Cheers,
>>>
>>>  
>>>
>>> Matt Peterson
>>>
>>> Web Developer
>>>
>>> University of New England
>>>
>>> Ph. [phone]
>>>
>>>  
>>>
>>>
>>> --
>>>
>>> You are currently subscribed to uportal-user@... as:
>>> eric.dalquist@...
>>> To unsubscribe, change settings or access archives, see
>>> http://www.ja-sig.org/wiki/display/JSG/uportal-user
>
>
>
> --- You are currently subscribed to uportal-user@... as:
> eric.dalquist@...
> To unsubscribe, change settings or access archives, see
> http://www.ja-sig.org/wiki/display/JSG/uportal-user

--Clean out old tables if they exist
DROP TABLE STATS_EVENT_TYPE         CASCADE CONSTRAINTS;
DROP TABLE STATS_SESSION            CASCADE CONSTRAINTS;
DROP TABLE STATS_SESSION_GROUPS     CASCADE CONSTRAINTS;
DROP TABLE STATS_EVENT              CASCADE CONSTRAINTS;
DROP TABLE STATS_CHANNEL            CASCADE CONSTRAINTS;
DROP TABLE STATS_FOLDER             CASCADE CONSTRAINTS;
DROP TABLE STATS_PORTLET_STATE      CASCADE CONSTRAINTS;
DROP TABLE STATS_RENDER_TIME        CASCADE CONSTRAINTS;
DROP TABLE STATS_TRANSFERRED_GROUPS CASCADE CONSTRAINTS;

--Clean out old sequences
DROP SEQUENCE STATS_EVENT_ID_SEQ;
DROP SEQUENCE STATS_SESSION_ID_SEQ;



-- Create the tables, no FKs are used to reduce DB load for high insert volumes
CREATE TABLE STATS_EVENT_TYPE (
  ID           NUMBER                           NOT NULL,
  TYPE         VARCHAR2(64 BYTE)                NOT NULL,
  DESCRIPTION  VARCHAR2(1024 BYTE),
  CONSTRAINT STATS_EVENT_TYPE_PK PRIMARY KEY (ID)
);


CREATE TABLE STATS_SESSION (
  ID      NUMBER                                NOT NULL,
  USERID  VARCHAR2(64 BYTE)                     NOT NULL,
  CONSTRAINT STATS_SESSION_PK PRIMARY KEY (ID)
);


CREATE TABLE STATS_SESSION_GROUPS (
  SESSION_ID  NUMBER                            NOT NULL,
  GROUPID     VARCHAR2(64 BYTE)                 NOT NULL
);


CREATE TABLE STATS_EVENT (
  ID           NUMBER                           NOT NULL,
  SESSION_ID   NUMBER                           NOT NULL,
  TYPE_ID      NUMBER                           NOT NULL,
  ACT_DATE     TIMESTAMP(6)                     NOT NULL,
  DESCRIPTION  VARCHAR2(2000 BYTE),
  CONSTRAINT STATS_EVENT_PK PRIMARY KEY (ID)
);

CREATE TABLE STATS_CHANNEL (
  EVENT_ID       NUMBER                         NOT NULL,
  DEFINITION_ID  VARCHAR2(64 BYTE)              NOT NULL,
  SUBSCRIBE_ID   VARCHAR2(64 BYTE)
);

CREATE TABLE STATS_FOLDER (
  EVENT_ID   NUMBER                             NOT NULL,
  FOLDER_ID  VARCHAR2(128 BYTE)                 NOT NULL
);


CREATE TABLE STATS_PORTLET_STATE (
  EVENT_ID   NUMBER                             NOT NULL,
  NEW_STATE  VARCHAR2(128 BYTE)                 NOT NULL,
  OLD_STATE  VARCHAR2(128 BYTE)
);


CREATE TABLE STATS_RENDER_TIME (
  EVENT_ID  NUMBER                              NOT NULL,
  TIME      NUMBER                              NOT NULL,
  CACHED    VARCHAR2(2 BYTE)
);


CREATE TABLE STATS_TRANSFERRED_GROUPS (
  GROUP_ID           VARCHAR2(64 BYTE)          NOT NULL,
  GROUP_NAME         VARCHAR2(64 BYTE)          NOT NULL,
  GROUP_DESCRIPTION  VARCHAR2(64 BYTE)          NOT NULL
);


--Add indexes to tables
CREATE INDEX STATS_CHANNEL_IDX ON STATS_CHANNEL (EVENT_ID);

CREATE INDEX STATS_EVENT_SESSION_IDX ON STATS_EVENT (SESSION_ID);

CREATE INDEX STATS_EVENT_IDX2 ON STATS_EVENT (ACT_DATE);

CREATE INDEX STATS_FOLDER_IDX ON STATS_FOLDER (EVENT_ID);

CREATE INDEX STATS_PORTLET_STATE_IDX ON STATS_PORTLET_STATE (EVENT_ID);

CREATE INDEX STATS_RENDER_TIME_IDX ON STATS_RENDER_TIME (EVENT_ID);


--Add sequences for IDs
CREATE SEQUENCE STATS_EVENT_ID_SEQ
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  ORDER;

CREATE SEQUENCE STATS_SESSION_ID_SEQ
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  ORDER;
 
 
 
--Populate tables  

Insert into STATS_EVENT_TYPE (ID, TYPE) Values (1, 'PORTLET_MODE_CHANGE');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (2, 'WINDOW_STATE_CHANGE');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (3, 'PORTLET_ACTION');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (4, 'CHANNEL_RENDERED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (5, 'LOGIN');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (6, 'LOGOUT');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (7, 'SESSION_CREATED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (8, 'SESSION_DESTROYED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (9, 'CHANNEL_DEFINITION_PUBLISHED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (10, 'CHANNEL_DEFINITION_MODIFIED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (11, 'CHANNEL_DEFINITION_REMOVED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (12, 'LAYOUT_CHANNEL_ADDED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (13, 'LAYOUT_CHANNEL_UPDATED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (14, 'LAYOUT_CHANNEL_MOVED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (15, 'LAYOUT_CHANNEL_REMOVED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (16, 'LAYOUT_FOLDER_ADDED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (17, 'LAYOUT_FOLDER_UPDATED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (18, 'LAYOUT_FOLDER_MOVED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (19, 'LAYOUT_FOLDER_REMOVED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (20, 'CHANNEL_INSTANTIATED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (21, 'CHANNEL_TARGETED');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (22, 'CHANNEL_RENDER_TIME');
Insert into STATS_EVENT_TYPE (ID, TYPE) Values (23, 'PAGE_RENDER_TIME');
COMMIT;

[AUDEOUD Dominique]

Your work to write the events directly in the database will be very
useful for us, if you include it in the future version of uPortal.
In France (as a know), we need to edit monthly and annual statistics
according to establishments and establishment groups, elements (of
establishments) and groups of elements, users and user groups, services
and service groups.
Do you plan to integrate this information in the future stats module?
Thanks Eric for this information. Greetings.
Dominique
-----------
Eric Dalquist a écrit :

> I've attached the tables we currently write stats events to. All the
> code really does is use the database as a normalized log store.
> Although we have historical stats going back to the uPortal go-live in
> June 06 we still don't have much in the way of reporting tools for the
> data. Part of the problem is simply the sheer volume and we haven't
> found the time to put in work to get summarizing processes running.
>
> I'll be starting on converting the recorder to the 2.6/3.0 stats
> system next week and will post the end result, if there is enough
> interest we can look at including it in a future version of uPortal.
>
> -Eric
>
> AUDEOUD Dominique wrote:
>> I am beginnig a work to integrate stat events directly in the
>> database of the 2.6 version of the portal.
>> The goal is to edit monthly and annual statistics more easyly.
>> Eric, do you can give us more information about your project (new
>> database tables already configured, event handler already modified) ?
>> With my thanks
>> Dominique Audéoud
>> Service DSI-TICE
>> Université de Franche-Comté
>> Besançon, France
>> ------------------
>>
>> Eric Dalquist a écrit :
>>> We have one for the 2.5 stats recorder interfaces that I'll be
>>> porting to 3.0 in the next few weeks If you're interested in either
>>> helping with that work or waiting for us to get to it we'll be happy
>>> (and plan to) share it.
>>>
>>> -Eric
>>>
>>> Matt Peterson wrote:
>>>>
>>>> Does anyone know of a stats recorder for uPortal3 which records to
>>>> db tables using uPortals spring defined datasource? Or any other
>>>> suggestion with regards to recording stats to our db?
>>>>
>>>>  
>>>>
>>>> Cheers,
>>>>
>>>>  
>>>>
>>>> Matt Peterson
>>>>
>>>> Web Developer
>>>>
>>>> University of New England
>>>>
>>>> Ph. [phone]
>>>>
>>>>  
>>>>
>>>>
>>>> --
>>>>
>>>> You are currently subscribed to uportal-user@... as:
>>>> eric.dalquist@...
>>>> To unsubscribe, change settings or access archives, see
>>>> http://www.ja-sig.org/wiki/display/JSG/uportal-user
>>
>>
>>
>> --- You are currently subscribed to uportal-user@... as:
>> eric.dalquist@...
>> To unsubscribe, change settings or access archives, see
>> http://www.ja-sig.org/wiki/display/JSG/uportal-user

---
You are currently subscribed to uportal-user@... as: lists@...
To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-user