<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Helvetica;
        panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
        {font-family:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"\@SimSun";
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Tahoma",sans-serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:10.0pt;
        font-family:"Tahoma",sans-serif;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
        {mso-style-name:msonormal;
        mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.EmailStyle19
        {mso-style-type:personal;
        font-family:"Tahoma",sans-serif;
        color:windowtext;}
span.EmailStyle20
        {mso-style-type:personal;
        font-family:"Tahoma",sans-serif;
        color:#1F497D;}
span.EmailStyle21
        {mso-style-type:personal;
        font-family:"Tahoma",sans-serif;
        color:windowtext;}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;}
span.EmailStyle26
        {mso-style-type:personal;
        font-family:"Tahoma",sans-serif;
        color:#1F497D;}
span.EmailStyle27
        {mso-style-type:personal-compose;
        font-family:"Tahoma",sans-serif;
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style>
</head>
<body lang="EN-CA" link="#0563C1" vlink="#954F72">
<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>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thank you John and David!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">That&#8217;s worked beautifully, and it was simple.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Why is it that the sort doesn&#8217;t work on that column, the &#8220;virtual&#8221; field means it&#8217;s not accessible to the sort functions?&nbsp;
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Anyway, even with the sort issue, it&#8217;s an easy improvement to our workflows.&nbsp; Thanks again!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Tomasz<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> David R Newman &lt;drn@ecs.soton.ac.uk&gt;
<br>
<b>Sent:</b> August 3, 2022 6:13 PM<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk; John Salter &lt;J.Salter@leeds.ac.uk&gt;; Tomasz Neugebauer &lt;Tomasz.Neugebauer@concordia.ca&gt;<br>
<b>Subject:</b> Re: [EP-tech] depositing user email in the Review table<o:p></o:p></span></p>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p><b><span style="color:#9C0000">Attention</span></b> This email originates from outside the concordia.ca domain. // Ce courriel provient de l'exterieur du domaine de concordia.ca<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p><o:p>&nbsp;</o:p></p>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<p><span style="font-size:13.5pt">Hi Tomasz,</span><o:p></o:p></p>
<p><span style="font-size:13.5pt">I think John's suggestion of a virtual field is the easiest solution.&nbsp; I added the following to eprint_fields.pl:</span><o:p></o:p></p>
<p><span style="font-family:&quot;Courier New&quot;">{<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name =&gt; 'user_email',<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; virtual =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type =&gt; 'text',<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; render_value =&gt; 'render_user_email',<br>
},</span><o:p></o:p></p>
<p><br>
<span style="font-size:13.5pt">Then added another file in my archive's cfg/cfg.d/ directory to define the render function (and added a phrase for the field name):</span><o:p></o:p></p>
<p><span style="font-family:&quot;Courier New&quot;">$c-&gt;{render_user_email} = sub<br>
{<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my( $session, $field, $alllangs, $nolink, $value, $obj ) = @_;<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my $ds = $session-&gt;get_dataset( 'user' );<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my $user = $ds-&gt;dataobj( $obj-&gt;get_value( 'userid' ) );<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $session-&gt;xml-&gt;create_text_node( $user-&gt;get_value( 'email' ) );<br>
},</span><o:p></o:p></p>
<p>Regards<o:p></o:p></p>
<p>David Newman<o:p></o:p></p>
<p><o:p>&nbsp;</o:p></p>
<div>
<p class="MsoNormal">On 03/08/2022 10:26 pm, John Salter via Eprints-tech wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div style="border:solid #8D3970 1.0pt;padding:9.0pt 9.0pt 9.0pt 9.0pt">
<p class="MsoNormal" style="line-height:16.5pt;background:#F7F9FA"><strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970">CAUTION:</span></strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970"> This
 e-mail originated outside the University of Southampton. <o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Tomasz,<br>
I think 'user/view' is the role you'd need to grant to editors to be able to see the profiles.<br>
<br>
For the email address aspect (I haven't fully thought these through yet):</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">- there may be a way to change the Review screen to use a different citation style for the user (but you wouldn't want to change e.g.
 how it is rendered on the summary page)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">- you could add a virtual field which rendered the email address (if added to the review columns, this column would not be sortable).
 Let me know if you want some example script for this.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">- &#8230; (I feel there's an eprint 'trick' I'm overlooking here&#8230;)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Cheers,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">John</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">
<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a> [<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">mailto:eprints-tech-bounces@ecs.soton.ac.uk</a>]
<b>On Behalf Of </b>Tomasz Neugebauer via Eprints-tech<br>
<b>Sent:</b> 03 August 2022 21:50<br>
<b>To:</b> <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><br>
<b>Subject:</b> Re: [EP-tech] depositing user email in the Review table</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">&nbsp;<o:p></o:p></p>
<div>
<div style="border:solid #8D3970 1.0pt;padding:9.0pt 9.0pt 9.0pt 9.0pt">
<p class="MsoNormal" style="line-height:16.5pt;background:#F7F9FA"><strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970">CAUTION:</span></strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970"> This
 e-mail originated outside the University of Southampton. </span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Another related question to this one, especially if it is not possible or easy to get the email address to appear in the Review Table:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Is there a specific permission/role that I could add to the editors so that they can view (but not modify) the Users Profile information?</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Right now, only admins can see that info, editors see this:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.5pt;font-family:&quot;Helvetica&quot;,sans-serif;color:#333333;background:#FFC0C0">You may not view this screen: Workflow::View.</span><span style="font-size:11.0pt;color:#1F497D">
</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">and I would like to give the editors access as well, primarily for that email address.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Tomasz</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">
<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a> &lt;<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>&gt;
<b>On Behalf Of </b>Tomasz Neugebauer via Eprints-tech<br>
<b>Sent:</b> August 3, 2022 4:14 PM<br>
<b>To:</b> <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><br>
<b>Subject:</b> [EP-tech] depositing user email in the Review table</span><o:p></o:p></p>
<p class="MsoNormal">&nbsp;<o:p></o:p></p>
<p><b><span style="color:#9C0000">Attention</span></b> This email originates from outside the concordia.ca domain. // Ce courriel provient de l'exterieur du domaine de concordia.ca<o:p></o:p></p>
<p>&nbsp;<o:p></o:p></p>
<div>
<p class="MsoNormal">&nbsp;<o:p></o:p></p>
</div>
<p class="MsoNormal" style="line-height:16.5pt;background:#F7F9FA"><strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970">CAUTION:</span></strong><span style="font-size:10.5pt;font-family:&quot;Calibri&quot;,sans-serif;color:#8D3970"> This
 e-mail originated outside the University of Southampton. </span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Is there any way to get the Depositing User&#8217;s email address visible as a column in the Review screen?</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I can get the &#8220;Depositing User&#8221; name displayed in the review screen, and the name is clickable, but is there any way to get the email right into that review table to save having to click on the name to access
 the user metadata screen?</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Tomasz</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">&nbsp;</span><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,serif"><br>
<br>
<o:p></o:p></span></p>
<pre>*** Options: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailman.ecs.soton.ac.uk%2Fmailman%2Flistinfo%2Feprints-tech&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cfa4471ea52f04ee8ecb408da76716fb0%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637952526831848443%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=YcvaYgm18EFgYeJWpKNuGbi7F268RJBvBs2uCyjuc5E%3D&amp;reserved=0" originalSrc="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" shash="AWxxFpmBK/6AxjvBd6oxQObss5IFV4M1nVpOfbYHxlDPgkZADidDeSLVKdIfB05esMK7QrG8cntT3g2/sC0XDg1sqn2xJJMNuaEfa9E32OCWkCvWnsPFRSSt0eZlKqyOQmr63iOAb0TOP9wACTcclROq9O6DPDamGDM70n8jS1w=">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><o:p></o:p></pre>
<pre>*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cfa4471ea52f04ee8ecb408da76716fb0%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637952526831848443%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=OvckXtY8WRBfb9XmwIkuguRC624M%2F7FLb0sE0Bhc2Q0%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="xHOxvSsA+LihtzvCo5sUqrrJwqeHQomVg1UFzFl60G7qNfFUb0MtCJDeQN8gkR1Q0PbAEnFHRj5B7kbtdQFI4KtuAdxoXWNcISnT6oHOm/E4Ml73csBs4Kr6KBpxQhMRSpsubp//srpLojArAa/zmGHi9nmuOuhD0IRqEXbrm9k=">http://www.eprints.org/tech.php/</a><o:p></o:p></pre>
<pre>*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cfa4471ea52f04ee8ecb408da76716fb0%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637952526831848443%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=wfPAkfPYpY2oTT%2BMoBBp0JjI%2FvBN9Lpk8fwXZhU2ofI%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="Kf3XFlLdcCfc3GoEECYl7l+FIyi+2pc17aRp9xr6Zu2a9apkcaXTmCgKGhJ8Rqu/a/nGBisJg4XAM1i7weURqM/S80tkfatuOqO5OXzv6yu81hFSCYQjF5v/kAV1sDRbK9Zs7C4dEVyeo+aEXWPA7usw6hsFezPr+c+eb6HD9Nw=">http://wiki.eprints.org/</a><o:p></o:p></pre>
</blockquote>
</div>
</div>
</body>
</html>