EPrints Technical Mailing List Archive

Message: #08968

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Browse by year

CAUTION: This e-mail originated outside the University of Southampton.

Hi, David, thank you. The following phrase does exist in the system.xml file.

<epp:phrase id="viewnull_eprint_year">Not Specified</epp:phrase>

I'm also using the local.xml file. Should the above entry be included
in the local.xml file as well?

Best regards, Francis

On Tue, May 31, 2022 at 2:50 PM David R Newman <drn@ecs.soton.ac.uk> wrote:
>
> Hi Francis,
>
> I was able to manually find this as I knew your repository hostname.  I am pretty sure the issue is the missing phrase I suggested in my earlier email.  As I can see that there is a link to NULL.html for this item when I look at the HTML but it has no text so the link is not clickable.  Once you have re-added the viewnull_eprint_year phrase, you will also need to regenerate this browse view page.  This can be done with the following command (substituting EPRINTS_PATH and ARCHIVEID as appropriate):
>
> EPRINTS_PATH/bin/generate_views ARCHIVEID --view year --generate menus
>
> Regards
>
> David Newman
>
> On 31/05/2022 10:10 am, Francis Jayakanth wrote:
>
> CAUTION: This e-mail originated outside the University of Southampton.
>
> Hi David and Chris, Thank you for responding so quickly. Please accept
> my apologies for the jumbled screenshot URL. Please see
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Feprints.iisc.ac.in%2Fview%2Fyear%2F&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C6a941c8697e745b25dc908da42f94d0c%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637895936168433273%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=5WcF7Oae8u1zdzHMP8QFQCjn38k%2FccWvqC5r%2Fug4tHs%3D&amp;reserved=0 for a browse view by year.
>
> The last item in the third column of the above image is what I'm referring to.
>
> I was able to obtain entries with NULL values in the date_year field,
> but not those in the browse view that are unclickable.
>
> Best regards, Francis
>
> On Tue, May 31, 2022 at 1:33 PM David R Newman <drn@ecs.soton.ac.uk> wrote:
>
> Hi Francis,
>
> Your screenshot URL got a bit mangled.  I am not sure how you could have a row in year view that is not clickable.  The date_year field used in the year browsw view in the eprint record is an integer.  If you set it to a value that is not an integer (including just spaces) the year will be set to 0 and appear as 0000 in the browse view.  If you set to an integer greater than 9999, then this year be concatenated to the first four digits (e.g. 12345 becomes just 1234*).  If you set an integer less than 1, then the year will show as 0000 in the browse view.  Finally, if no value is set, the database will store this as null and the link in the browse view should show as "Not Specified".  This is provided by the following line in lib/lang/en/phrases/system.xml:
>
> <epp:phrase id="viewnull_eprint_year">Not Specified</epp:phrase>
>
> Maybe you don't have this phrase but I think it has been present at least since the first release of EPrints 3.4.  Maybe you set this phrase to empty for some reason.  Most likely it was showing "Not Specified" in some place that looked untidy,
>
> Regards
>
> David Newman
>
>
> *This is technically a bug but unlikely to ever be an issue unless something wei
>
> On 31/05/2022 8:28 am, Francis Jayakanth via Eprints-tech wrote:
>
> CAUTION: This e-mail originated outside the University of Southampton.
>
> Hi,
>
> Values for the date_year column in roughly fifty records in our
> repository may not be inserted correctly. As a result, the 'browse by
> year' view for such entries is incorrectly created and not clickable.
> The following link will take you to a screenshot of the browse view by
> year:
>
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Findianinstituteofscience-my.sharepoint.com%2F%3Ai%3A%2Fg%2Fpersonal%2Ffrancis&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C6a941c8697e745b25dc908da42f94d0c%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637895936168433273%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=KTrr66H37CuJUzH7hyElgVUxILHv%2BCO81McA9cx%2BAXY%3D&amp;reserved=0
> iisc ac in/EQhONAS12hxMseEf7e8lHMUBU0D8IuwQhdbkLrekIGJj1g?e=e1yxHP
>
> As evident from the screenshot, the last item in the third column is
> not clickable.
>
> What SQL statement should I use to obtain these records? I've tried
> the SQL commands below, but they all return empty sets:
>
> select eprintid, title, official_url from eprint where date_year  like '  %';
> select eprintid, title, official_url from eprint where date_year  like ' % '
> select eprintid, title, official_url from eprint where date_year  like '  % '
>
> Thanks for your attention.
>
> Best regards, Francis
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: 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%7C6a941c8697e745b25dc908da42f94d0c%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637895936168433273%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=pFqMlkVS5zLqUtG21mdJYkz%2B%2B%2Bml%2F0AT509xU8%2BfqS8%3D&amp;reserved=0
> *** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C6a941c8697e745b25dc908da42f94d0c%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637895936168433273%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=BPqJTDsd65gaXKPOUJKChqh%2B0UnTu4xwDywBMfAyDEc%3D&amp;reserved=0