Where is the information about what username created/modified a "biblio" record saved?
Hi list, I'm using the last "snapshot" development version of Koha 3 from git, but I think my question is also applicable to older Koha 3 "versions" (and probably also to Koha 2.X versions). I'm using UNIMARC (but NOT using Zebra) in my Linux installation (running openSUSE 11.0). Basically, the question is the one that I put in the subject of this message, that is: "Where is the information about what username created/modified a biblio record saved?" When I say this, I'm thinking of a Library that uses Koha, and where several Librarians have a Koha username and password for logging in the "Intranet" area for adding / modifying bibliographic records in the Library's Catalog. So, what I'm asking is this: 1 - Does the Koha (MySQL) database include any table(s)/field(s) for the username that created/modified a bibliographic record? I couldn't find it in the most "obvious suspect", the "biblio" table. I *did* find a "datecreated" and a "timestamp" fields in this "biblio" table, though. 2 - Do the UNIMARC / MARC 21 standards include any tag / subfield where this information should / may be saved in a bibliographic record? I have consulted the "Log Viewer" that is available in the "Tools" page of the "Intranet" area of Koha, but could NOT find any entry for creation / modification of bibliographic records: http://192.168.0.2:8080/cgi-bin/koha/tools/viewlog.pl Am I looking for this in the wrong places? If this functionality has NOT been implemented yet, are there any reasons for NOT doing it (e.g: any legal restrictions related to privacy concerns)? Thanks in advance! Best wishes, Ricardo Dias Marques lists AT ricmarques DOT net
* Ricardo Dias Marques (lists@ricmarques.net) wrote:
Hi list,
I have consulted the "Log Viewer" that is available in the "Tools" page of the "Intranet" area of Koha, but could NOT find any entry for creation / modification of bibliographic records:
http://192.168.0.2:8080/cgi-bin/koha/tools/viewlog.pl
Am I looking for this in the wrong places?
No, but you may not have switched the logging on at http://librarian.koha.workbuffer.org/cgi-bin/koha/admin/systempreferences.pl... I have the logs turned on, and I can see things like this in the logviewer 2008-07-15 12:00:03 1 CATALOGUING ADD biblio 9 biblio (where 1 is a link to the librarian who did it, and 9 is a link to the biblio) There are also entries for modifys, but its too big to paste nicely :) Chris
Hi Chris, I must admit I'm amazed: you received my message, read it and replied with a very informative reply in just 6 MINUTES! I think that you just set some world record! :) Some more comments / questions below: On Fri, Aug 8, 2008 at 1:18 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
[...] you may not have switched the logging on at http://librarian.koha.workbuffer.org/cgi-bin/koha/admin/systempreferences.pl...
I have the logs turned on, and I can see things like this in the logviewer
2008-07-15 12:00:03 1 CATALOGUING ADD biblio 9 biblio
(where 1 is a link to the librarian who did it, and 9 is a link to the biblio)
You're right. I navigated to the "Logs" tab of the "System Preferences" page at: http://192.168.0.2:8080/cgi-bin/koha/admin/systempreferences.pl?tab=Logs In that page, I found out that only log that is DISABLED is precisely the "Cataloguing Log": ____________________ CataloguingLog If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming. [Set to OFF] ____________________ Do you Chris (or anyone else, for that matter) have any input if it is "safe" to enable this setting in a production environment, for a reasonably small library (with about 30 thousand bibliographic records) with relatively infrequent catalog changes ? Is there any field (tag / subfield) in UNIMARC / MARC 21 for storing information about who created and/or "last modified" a bibliographic record? Thanks again Chris! Your first answer was, as I mentioned in the beginning, very good and lightning fast! :) Best wishes, Ricardo Dias Marques lists AT ricmarques DOT net
Ricardo Dias Marques a écrit :
Hi Chris,
I must admit I'm amazed: you received my message, read it and replied with a very informative reply in just 6 MINUTES!
I think that you just set some world record! :)
hehe Chris, the man that answers faster than his shadow.... or call him Flash chris ;)
Some more comments / questions below:
On Fri, Aug 8, 2008 at 1:18 AM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
[...] you may not have switched the logging on at http://librarian.koha.workbuffer.org/cgi-bin/koha/admin/systempreferences.pl...
I have the logs turned on, and I can see things like this in the logviewer
2008-07-15 12:00:03 1 CATALOGUING ADD biblio 9 biblio
(where 1 is a link to the librarian who did it, and 9 is a link to the biblio)
You're right. I navigated to the "Logs" tab of the "System Preferences" page at:
http://192.168.0.2:8080/cgi-bin/koha/admin/systempreferences.pl?tab=Logs
In that page, I found out that only log that is DISABLED is precisely the "Cataloguing Log": ____________________
CataloguingLog If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming. [Set to OFF] ____________________
Do you Chris (or anyone else, for that matter) have any input if it is "safe" to enable this setting in a production environment, for a reasonably small library (with about 30 thousand bibliographic records) with relatively infrequent catalog changes ?
Yes it is safe.
Is there any field (tag / subfield) in UNIMARC / MARC 21 for storing information about who created and/or "last modified" a bibliographic record?
/me doesnot know for USMARC Sorry. But as far as UNIMARC is concerned, this (Who/When/Where) information has sometimes been stored in 801 tag or 809 if you want to use a local tag. -- Henri-Damien LAURENT
Hi Henri, On Fri, Aug 8, 2008, Henri-Damien LAURENT <laurenthdl@alinto.com> wrote:
hehe Chris [Cormack], the man that answers faster than his shadow.... or call him Flash chris ;)
Yep. I do think that Chris really deserves that nickame of "Flash Chris"! :)
Yes it is safe [if it is"safe" to enable the CataloguingLog setting in a production environment, for a reasonably small library (with about 30 thousand bibliographic records) with relatively infrequent catalog changes ]
That's great. Thanks for the feedback Henri! I also asked if:
Is there any field (tag / subfield) in UNIMARC / MARC 21 for storing information about who created and/or "last modified" a bibliographic record?
and Henri replied that:
/me doesnot know for USMARC Sorry. But as far as UNIMARC is concerned, this (Who/When/Where) information has sometimes been stored in 801 tag or 809 if you want to use a local tag.
OK. Thank you very much for that info also Henri. Best wishes, Ricardo Dias Marques lists AT ricmarques DOT net
"Ricardo Dias Marques" <lists@ricmarques.net> wrote:
Is there any field (tag / subfield) in UNIMARC / MARC 21 for storing information about who created and/or "last modified" a bibliographic record?
Depending on the context, I think you might find MARC21 fields 040 and 583 useful. http://www.loc.gov/marc/bibliographic/bd040.html http://www.loc.gov/marc/bibliographic/bd583.html Hope that helps, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237
Hi MJ, On Mon, Aug 11, 2008, MJ Ray <mjr@phonecoop.coop> wrote:
"Ricardo Dias Marques" <lists@ricmarques.net> wrote:
Is there any field (tag / subfield) in UNIMARC / MARC 21 for storing information about who created and/or "last modified" a bibliographic record?
Depending on the context, I think you might find MARC21 fields 040 and 583 useful. http://www.loc.gov/marc/bibliographic/bd040.html http://www.loc.gov/marc/bibliographic/bd583.html
Very interesting. I had already found some references to the 040 MARC 21 tag ("Cataloging Source") - that corresponds to the 801 tag in UNIMARC ("Originating Source") that Henri-Damien Laurent also mentioned. I did NOT know about the 583 MARC 21 tag ("Action Note") - that corresponds to the 318 UNIMARC tag ("Action Note"). That also seems to be a good candidate for inserting information about what username (person) created/modified a bibliographic record, although none of the mentioned tags seem to have been created with this purpose in mind. Many thanks for the help MJ! :) Best wishes, Ricardo Dias Marques lists AT ricmarques DOT net
participants (4)
-
Chris Cormack -
Henri-Damien LAURENT -
MJ Ray -
Ricardo Dias Marques