Thank you Eric for the wiki page. I agree that Galaxy Reports are not visible enough and this might help. Martin, Galaxy Team On Fri, Jan 17, 2014 at 12:29 PM, Eric Rasche <rasche.eric@yandex.ru> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Well! This is the first I've heard of a Galaxy Reports page. Too bad I already re-invented the wheel because I hadn't ever heard of this tool...
Anyway, since "run_reports.sh" was only mentioned once anywhere in the wiki (according to search, in a DevNewsBrief from 2008), I've added a wiki page for the report tool.
Please add whatever information you all feel I've left out. https://wiki.galaxyproject.org/Admin/Usage%20Reports
Cheers, Eric Rasche
On 01/17/2014 10:38 AM, Liisa Koski wrote:
Hello, First..I love the Galaxy Reports tool...thanks so much for this.
I did however come across an error when trying to few the Registered Users per month link. It would be really nice to have this working :)
Thanks in advance, Liisa
URL: http://domain:9001/users/registered_users_per_month <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month> Module paste.exceptions.errormiddleware:*144* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# app_iter*=* self*.*application*(*environ*,* sr_checker*)* Module paste.debug.prints:*106* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# environ*,* self*.*app*)* Module paste.wsgilib:*543* in intercept_output_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# app_iter*=* application*(*environ*,* replacement_start_response*)* Module paste.lint:*170* in lint_app_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# iterator*=* application*(*environ*,* start_response_wrapper*)* Module paste.recursive:*84* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# *return*self*.*application*(*environ*,* start_response*)* Module paste.httpexceptions:*633* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# *return*self*.*application*(*environ*,* start_response*)* Module galaxy.web.framework.base:*132* in __call___ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# *return*self*.*handle_request*(* environ*,* start_response*)* Module galaxy.web.framework.base:*190* in handle_request_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# body*=* method*(* trans*,* ****kwargs*)* Module galaxy.webapps.reports.controllers.users:*29* in registered_users_per_month_ __>> _ <http://martin.dnalandmarks.ca:9001/users/registered_users_per_month# *for*row*in*q*.*execute*():* Module sqlalchemy.sql.expression:*2841* in execute Module sqlalchemy.engine.base:*2453* in _execute_clauseelement Module sqlalchemy.engine.base:*1584* in _execute_clauseelement Module sqlalchemy.engine.base:*1698* in _execute_context Module sqlalchemy.engine.base:*1691* in _execute_context Module sqlalchemy.engine.default:*331* in do_execute Module MySQLdb.cursors:*173* in execute Module MySQLdb.connections:*36* in defaulterrorhandler* OperationalError: (OperationalError) (1305, 'FUNCTION galaxy_production.date_trunc does not exist') 'SELECT date_trunc(%s, date(galaxy_user.create_time)) AS date, count(galaxy_user.id) AS num_users \nFROM galaxy_user GROUP BY date_trunc(%s, date(galaxy_user.create_time)) ORDER BY date DESC' ('month', 'month')*
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux)
iQIcBAEBAgAGBQJS2Wh7AAoJEMqDXdrsMcpVlZsP/0PtATKuyVA8Dt3U9NzEnSd3 oe2duZcCiIEqKrsllazdoH9l1uJja49d66FuOLcQag2/nNONVcNSSQXw4EbYqRe4 piZTf4bptsm1m44c615NCbfvUCg5XpGW6SniA5WWAbH2c4p+TRWiA5+N6AtD6GC0 +V5l8JScuPXyRt8Zq6Kt22mLYMeimRVOM2Y6PjSqqm/+kldvhzlwRWaQS7YCIH6v CBiHCA13XTvaJKl3NpSaJ4CpOMkVUOjZg1eKTlydUGespOUX5w1ZVZl6J/rvIAUd M7JRou1FtFeilCW/MiS6sgKFI4xl5IwZI4pxvq2s8dbOFSBKnz2p0/thcVjnPFzY x3yPM4A6lIehRrJHLOa3IiqEAjb/q0pmmla+Lh53dURhEWw6FISyktwng5Yaa/IS o/O6P+/paH/ujaOUFIMTEtb1hxoyUdkjDEaNLRwCpDlimqYOYhRG+XrAK9/8rbh5 8lntRnjN32Istkrq8Dk1p6ZRCceiYqfNZWdwHdvB65TYwcHfP7jmOAdLrObd3TN5 Fy+irjZALmCng8BBksJ5661xqXWICYwyW9U2XiVdPVBnb9DF2orCpsqQ2WRwWWFK mqJiGqpTSULy8FaPOsUQVc1n+ZafBaTgHs/XgM8PAfd8PlKUiZiaFhMkfuaUQ2so QGWlEJDCFNEwG6vPIwYv =7Tym -----END PGP SIGNATURE----- ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/