EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #08967

< 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

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=""> 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="">
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="">
*** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url="">