<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div style="padding-bottom: 10px; padding-top: 5px;">
<div style="padding:12px; border:1px solid #8D3970; background-color:#F7F9FA; color:#8D3970; font-size:14px; line-height:22px; font-family: Calibri, Arial, Helvetica, sans-serif;">
<strong>CAUTION:</strong> This e-mail originated outside the University of Southampton.
</div>
</div>
<div>Hello everyone<br>
<br>
The initial problem : many (about 1,000) metadata values entered by archive editors in a non appropriate field (used in parallel for another purpose by another import mechanism), let's say "infoX". Into the database, this information was stored in a table looking
like "eprint_creators_infoX(eprintid,pos,creators_infoX)"<br>
<br>
The solution employed :<br>
<ol>
<li>create a new metadata/field (let's say "infoY") among the creators metadata (with "eprints_fields.pl") and update the database structure in consequence => creation of a new table "eprint_creators_infoY(eprintid,pos,creators_infoY)"</li><li>backup (SQL values dump) the important values previously entered and stored into the "eprint_creators_infoX" table;</li><li>from this backup, create a new SQL file where the "infoX" column name is replaced by "infoY";</li><li>import these values into the new table ""eprint_creators_infoY";</li><li>delete the previously entered value from "eprint_creators_infoX" table (<i>there was an objective criteria to distinguish the entered from the imported values</i>);</li><li>run "bin/epdamin recommit <archivename> eprint"</li></ol>
The disaster/issue that happened : all the records from "eprint" main table have been deleted, and the archive/repository consequently appears as empty!!!<br>
<br>
Could someone explain this???<br>
<br>
Best regards<br>
--<br>
Laurent Cloarec<br>
Service Commun de la Documentation - Service du Numérique Documentaire<br>
Université Toulouse 1 Capitole<br>
</div>
</body>
</html>