Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Kyle Banerjee
On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote: Hi all. What are you using to process circ data for ad-hoc queries. I usually extract csv or tab-delimited files - one row per item record, with identifying bib record data, then total checkouts over the given time

Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Harper, Cynthia
than just taking the lazy approach every time... Cindy -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Kevin Ford Sent: Wednesday, August 05, 2015 5:16 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data On the surface

Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Harper, Cynthia
] Processing Circ data On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote: Hi all. What are you using to process circ data for ad-hoc queries. I usually extract csv or tab-delimited files - one row per item record, with identifying bib record data, then total checkouts over

Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Cornel Darden Jr.
- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Kyle Banerjee Sent: Thursday, August 06, 2015 12:34 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote: Hi all. What

Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Dunham, Denise
Rochester, NY 14627 585.275.1059 ddun...@library.rochester.edu -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Harrison G. Dekker Sent: Thursday, August 06, 2015 12:08 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data

Re: [CODE4LIB] Processing Circ data

2015-08-06 Thread Harrison G. Dekker
[mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Kevin Ford Sent: Wednesday, August 05, 2015 5:16 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data On the surface, your difficulties suggest you may need look at a few optimization tactics. Apologies if these are things

[CODE4LIB] Processing Circ data

2015-08-05 Thread Harper, Cynthia
Hi all. What are you using to process circ data for ad-hoc queries. I usually extract csv or tab-delimited files - one row per item record, with identifying bib record data, then total checkouts over the given time period(s). I have been importing these into Access then grouping them by bib

Re: [CODE4LIB] Processing Circ data

2015-08-05 Thread Owen Stephens
Another option might be to use OpenRefine http://openrefine.org - this should easily handle 250,000 rows. I find it good for basic data analysis, and there are extensions which offer some visualisations (e.g. the VIB BITs extension which will plot simple data using d3

Re: [CODE4LIB] Processing Circ data

2015-08-05 Thread Kevin Ford
Hi Cindy, This doesn't quite address your issue, but, unless you've hit the 2 GB Access size limit [1], Access can handle a good deal more than 250,000 item records (rows, yes?) you cited. What makes you think you've hit the limit? Slowness, something else? All the best, Kevin [1]

Re: [CODE4LIB] Processing Circ data

2015-08-05 Thread Harper, Cynthia
Sent: Wednesday, August 05, 2015 4:23 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data Hi Cindy, This doesn't quite address your issue, but, unless you've hit the 2 GB Access size limit [1], Access can handle a good deal more than 250,000 item records (rows, yes

Re: [CODE4LIB] Processing Circ data

2015-08-05 Thread Kevin Ford
: Wednesday, August 05, 2015 4:23 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Processing Circ data Hi Cindy, This doesn't quite address your issue, but, unless you've hit the 2 GB Access size limit [1], Access can handle a good deal more than 250,000 item records (rows, yes?) you cited