Thanks Andrew,
 
Certainly sounds like an answer to me :)
 
I'm still curious if anyone has seen an ODBC driver for SOLR because it would enable access to the bid data via there as well... but I'm doubtful, it sounds too left of field.
 
Ta,
 

Greg Pendlebury
Electronic Services Officer (Systems Team)
Division of Academic Information Services
University of Southern Queensland
Phone: +61 7 4631 1501
Fax: +61 7 4631 1841

 


From: Andrew Nagy [mailto:asnagy@gmail.com]
Sent: Friday, 31 October 2008 1:11 PM
To: Greg Pendlebury
Cc: vufind-tech@lists.sourceforge.net
Subject: Re: [VuFind-Tech] Reporting Tools and SOLR

Greg - I had begun a statistics recording process that would record various statistical items such as a record view, a search, etc. to a separate solr index.  However, I didn't really like creating extra effort on the server and decided to "disable" the feature.  The code is still there.  You could simply change the action of recording to solr to a database such as mysql instead. 

The vufind/web/sys/SolrStats.php is the file.  You could change this to write to mysql rather than to Solr.  I think this would be pretty easy to do since the SolrStats.php file is very basic.

Let me know if this seems like your answer.

Andrew

On Thu, Oct 30, 2008 at 10:33 PM, Greg Pendlebury <pendlebu@usq.edu.au> wrote:

Hi All,

I'm just wondering how other organisations are looking at their usage statistics that VuFind keeps in SOLR?

As part of our product evaluation I've been asked to assess how our existing reporting tool (Cognos Impromptu) would talk to the stats.

Of course the logical answer from me would be to find a reporting tool that actually likes XML data sources (<sarcasm>how 21st century of me</sarcasm>), but that's not an option. Impromtu likes ODBC data sources…

Does anyone know if:

A) There are any projects out there for ODBC drivers that talk to SOLR. (couldn't find any from quick searches today)
B) Switch VuFind's stats to the underlying database would be easy.

Thanks,

Greg Pendlebury
Electronic Services Officer (Systems Team)
Division of Academic Information Services
University of Southern Queensland
Phone: +61 7 4631 1501
Fax: +61 7 4631 1841


This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.

The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.

The University of Southern Queensland is a registered provider of education with the Australian Government (CRICOS Institution Code No's. QLD 00244B / NSW 02225M)

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Vufind-tech mailing list
Vufind-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/vufind-tech



This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.

The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.

The University of Southern Queensland is a registered provider of education with the Australian Government (CRICOS Institution Code No's. QLD 00244B / NSW 02225M)