On Mon, Feb 18, 2013 at 4:31 AM, Hugh Paterson III <[email protected]> wrote: > Also is there a modification, or a hack which will automatically add to the > provenance record of an item who made changes (and what the changes were), > changes like the adding of a digital object to the bit stream or changed a > metadata element's value?
This might be the way to go, but it won't help you with the records modified until this date. What you could do now is look at the last modified date of files in the assetstore and associate them with items using SQL. You can look up the filename in the "internal_id" column of the "bitstream" table to find "bitstream_id", then look up the bundle and item which it belongs to using "bundle2bitstream" and "item2bundle". If handle is preferable to "item_id", you can look that up in the "handle" column of the "handle" table (where resource_id = item_id). If you need to find the item's various dates, they're in the "metadatavalue" table, where you can look it up by "item_id" and filter by "metadata_field_id" (the names of fields can be translated to/from readable DC by looking them up in "metadataschemaregistry" and "metadatafieldregistry"). Let us know if you have a problem getting it to work. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

