Quality assurance and reporting

[Jason Stirnaman]

I'm just beginning to define some reports that our staff need in order to better maintain data quality. So far, I've just come up with a couple of SQL queries that should be helpful, e.g. Inactive people with memberships that have no end date, or active people who have no group memberships. I'm sure there are others that I've already forgotten about.

I think our preference is to run these on a schedule and email results to specific staff. I can also think of spots in the current views where we might display Admin-only notifications about people, groups, etc. Looking to the future, though, I wonder if something like http://activeadmin.info/ might be a good addition to Bibapp.

Thoughts or suggestions? Is anyone generating custom reports now? If so, are you using Ruby, Rails, raw SQL, what?

Thanks,

Jason

[Claudia Jürgen]

Hello Jason,

I think something like the DSpace curation tasks would be great for
metadata and data quality management etc.

What I meant with reporting was something more, in terms of Bibapp this
related to archive analysis in scheduled reporting to the departments,
e.g. like overview of publications/year etc. more for administrative and
evaluation purpose.

Cheers

Claudia

Am 21.10.2011 21:02, schrieb Jason Stirnaman:
> I'm just beginning to define some reports that our staff need in order to
> better maintain data quality. So far, I've just come up with a couple of SQL
> queries that should be helpful, e.g. Inactive people with memberships that
> have no end date, or active people who have no group memberships. I'm sure
> there are others that I've already forgotten about.
> I think our preference is to run these on a schedule and email results to
> specific staff. I can also think of spots in the current views where we
> might display Admin-only notifications about people, groups, etc. Looking to
> the future, though, I wonder if something like

> http://activeadmin.info/might be a good addition to Bibapp.

> Thoughts or suggestions? Is anyone generating custom reports now? If so, are
> you using Ruby, Rails, raw SQL, what?
>
> Thanks,
> Jason
>

--
Claudia Juergen
Universitaetsbibliothek Dortmund
Eldorado
0231/755-4043
https://eldorado.tu-dortmund.de/

[Jason Stirnaman]

Yes, the curation tasks might be a good model. That analogy hadn't occurred to me. I've started doing some work around this to scratch my own itch, mostly just using gems Clockwork and DelayedJob. Clockwork is a Ruby replacement of cron which makes scheduling jobs extremely easy.

Jason

2011/10/24 Claudia Jürgen <Claudia...@ub.tu-dortmund.de>

--
You received this message because you are subscribed to the Google Groups "bibapp-dev" group.
To post to this group, send email to bibap...@googlegroups.com.
To unsubscribe from this group, send email to bibapp-dev+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/bibapp-dev?hl=en.