<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>Hi Martin</div>
<div><br>
</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>- No, there’s no existing script to do this.</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>- It’s been designed this was as a path of least resistance to meet some preservation issues with not storing the state of the object on change. An XML dump to the filesystem each time the object
is written to the database ticks a lot of boxes and was almost free because there was already an XML exporter.</div>
<div><br>
</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>Creating a ‘by field’ view of the history instead of a ‘by commit’ view is a simple matter of parsing the XML and rerendering it. No rocket science, but XML parsing is computationally expensive,
so performance may be slow for items with long and chequered histories.</div>
<div><br>
</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>I’m happy to advise if anyone wants to do the leg-work on this, as long as it’s released as a bazaar package at the end. It might lead to a training video or two, too.</div>
<div><br>
</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE">
<p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; font-size: 11pt;"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="font-family: Calibri;">
<tbody>
<tr>
<td valign="top" style="border-style: solid none none; border-top-color: rgb(44, 56, 65); border-top-width: 1pt; padding: 0cm 0cm 3pt;">
<p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<a href="http://www.jisc.ac.uk/" style="color: rgb(149, 79, 114);"><span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: blue; text-decoration: none;"><img border="0" width="60" height="35" id="Picture_x0020_1" src="cid:232DA2F6-79F0-4659-9659-0E57B65DA77A" alt="Jisc" type="image/png"></span></a><span style="font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding: 7.5pt 0cm 0cm;">
<p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<b><span style="font-size: 12pt; font-family: Corbel, sans-serif; color: rgb(44, 56, 65);">Adam Field</span></b><span style="font-size: 12pt; font-family: 'Times New Roman', serif;"><br>
</span><span style="font-size: 12pt; font-family: Corbel, sans-serif; color: rgb(44, 56, 65);">SHERPA services analyst developer</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:12pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>> on behalf of "<a href="mailto:martin.braendle@id.uzh.ch">martin.braendle@id.uzh.ch</a>" <<a href="mailto:martin.braendle@id.uzh.ch">martin.braendle@id.uzh.ch</a>><br>
<span style="font-weight:bold">Reply-To: </span>"<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>" <<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>><br>
<span style="font-weight:bold">Date: </span>Monday, 11 January 2016 11:26<br>
<span style="font-weight:bold">To: </span>EP tech <<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>><br>
<span style="font-weight:bold">Subject: </span>[EP-tech] Traceability of record changes<br>
</div>
<div><br>
</div>
<div>
<div>
<p><font size="2" face="sans-serif">Hi,</font><br>
<br>
<font size="2" face="sans-serif">and a happy and successful 2016!</font><br>
<br>
<font size="2" face="sans-serif">If one wants to find all eprints for which a given field X has changed its value from A to B, this seems to be quite cumbersome, because the history table only stores the name of the fields that have been modified, but not their
content, which is saved in the revisions XML files in the documents directory.</font><br>
<br>
<font size="2" face="sans-serif">- Is there already a method or script that enables one to do so?</font><br>
<font size="2" face="sans-serif">- Why has this been designed this way, and not the way that all changes (which field and which content) are tracked in the SQL database? Whether disk space is used up by the database or in the filesystem should not matter. Having
the changes only in the database would facilitate searching a lot; in addition, rollbacks to a given point would be possible.</font><br>
<br>
<font size="2" face="sans-serif">Best regards,</font><br>
<br>
<font size="2" face="sans-serif">Martin</font><br>
<br>
<font size="2" face="sans-serif">--</font><br>
<font size="2" face="sans-serif">Dr. Martin Brändle</font><br>
<font size="2" face="sans-serif">Zentrale Informatik</font><br>
<font size="2" face="sans-serif">Universität Zürich</font><br>
<font size="2" face="sans-serif">Stampfenbachstr. 73</font><br>
<font size="2" face="sans-serif">CH-8006 Zürich</font><br>
<br>
<font size="2" face="sans-serif">mail: <a href="mailto:martin.braendle@id.uzh.ch">
martin.braendle@id.uzh.ch</a></font><br>
<font size="2" face="sans-serif">phone: +41 44 63 56705</font><br>
<font size="2" face="sans-serif">fax: +41 44 63 54505</font><br>
<font size="2" face="sans-serif"><a href="http://www.zi.uzh.ch">http://www.zi.uzh.ch</a></font></p>
</div>
</div>
</span>
<font size="1"> <font face="Corbel"> <br />
Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.<br /><br />
Jisc Services Limited is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under company number 2881024, VAT number GB 197 0632 86. The registered office is: One Castle Park, Tower Hill, Bristol BS2 0JA. T 0203 697 5800.
</font></font></body>
</html>