<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hi Laurent,</p>
<p>So to confirm: Are there are no records in the eprint database
table or you just don't see any records when you look at the
Manage Deposits page in the repository? When you ran recommit at
the end of your set of instructions. How long did this take to
run and how many record did you have before you started this whole
process? If it took quite a long time then it suggests some how
the recommit process caused you problem. However, if it ran
quickly this suggests you eprint records were already deleted or
broken so could not be displayed in the Manage Deposits page.</p>
<p>As a general comment on your solution. I would have not dumped
out and reimported database tables. I would have created a rule
(block of code) in your archive's
cfg/cfg.d/eprint_fields_automatic.pl to map (probably just copy)
the old field to new field. You would have still had to have the
old field defined in eprint_fields.pl but as long as you had
removed the old field from the eprint workflow and any other
config files (except eprint_fields_automatic.pl and
eprint_fields.pl) it should not be editable, or visible to
non-logged in users. You would then need to run epadmin recommit
like you did in your original instructions and once this completed
you could remove (probably best to comment out) references to the
old field and the rule to map the old field to the new field.</p>
<p>Regards</p>
<p>David Newman<br>
</p>
<div class="moz-cite-prefix">On 16/11/2020 10:49, Laurent Cloarec
via Eprints-tech wrote:<br>
</div>
<blockquote type="cite" cite="mid:EMEW3|b8979a87ba7d76c395142bb6ac3eb681wAFAqY14eprints-tech-bounces|ecs.soton.ac.uk|b563296d-5b2f-2f43-f317-00d52bdf0ed1@ut-capitole.fr">
<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=04%7C01%7C%7C4797964720bc4a6354e208d88a200e54%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637411217564470737%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=r5ggL0PZUS8dmX0CMJ1ZJtmOwuL9IoWJBO%2FvI0EbTLc%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="sG+v7Z43hu0cN6DPpKvdT0WxVN7dCqEG5N951WCdrBfJwtqCawDAif0gWHCYV3DPhQQYoiLsiBEkpZeP0x8iq6oKXILOtZ+X4ejfvoPvVXQv5SlyI3+TUmXH99Jf/BTcb0uAhRfFLqywpUmImzl9LjzfexivJo0AhNcmx0cyhlM=">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=04%7C01%7C%7C4797964720bc4a6354e208d88a200e54%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637411217564470737%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=a7t7Mkwp%2BIIoMQfneeZT9qb11rs9F6JgKXkYaSrGlno%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="VhxcVIoRwN6s8VziO4UbhNH/GDQSSvwOus37958iNq3PvukUik8zexyWLuNzuep1FqiaWEfyhcZpx7FHHoj2aX+Ta5u2+vQMhRRTy77h0RTKAhscOuk1U55+CpmBURTWjIFNlQIAYiqt6QxmnHPKLvqoihsUfJRehEyUdUvVMg0=">http://wiki.eprints.org/</a></pre>
</blockquote>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top: 1px solid #D3D4DE;">
<tr>
<td style="width: 55px; padding-top: 13px;"><a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&data=04%7C01%7C%7C4797964720bc4a6354e208d88a200e54%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637411217564480733%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=tmawn%2FZqVtItKBno6mD%2BAMPvq3EFFBNaiMESkd0YIbc%3D&reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="LXfZW+Mk8mOtwkC4HYaktZ3io8x6xyKCV9YC9RSP4jJLOJkD+G5TItbIdoZLertFEgSVs7ymR2mET9RX2frYxYrQ3YtNf7fj/sGrBn191VwGtePQCDbR0yTmM4KF6EwOtNVSfEjFpaOpSYtzgkgMWzjqiiL0wAaRDotj+0N4cO8=" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&data=04%7C01%7C%7C4797964720bc4a6354e208d88a200e54%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637411217564480733%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=tmawn%2FZqVtItKBno6mD%2BAMPvq3EFFBNaiMESkd0YIbc%3D&reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="LXfZW+Mk8mOtwkC4HYaktZ3io8x6xyKCV9YC9RSP4jJLOJkD+G5TItbIdoZLertFEgSVs7ymR2mET9RX2frYxYrQ3YtNf7fj/sGrBn191VwGtePQCDbR0yTmM4KF6EwOtNVSfEjFpaOpSYtzgkgMWzjqiiL0wAaRDotj+0N4cO8=" target="_blank" style="color: #4453ea;">www.avg.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>