EPrints Technical Mailing List Archive

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

Message: #07960

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

Re: [EP-tech] Getting Data from the EPrints Database - not urgent

Hi Alan,

Thank you; that was it! I have no idea why I struggled so much with it when I was first doing it because that seems quite straight forward and I've used"get_value" to get at other fields elsewhere since then.

My only defence is that it was almost seven months ago and I hadn't been in the job for long. I'm currently going through past things that I've done that appear to work and checking them for stupidity and making sure they've been done the "correct" way.

Thanks for your help!

James



On Thu, Aug 29, 2019 at 12:04 PM Alan.Stiles <alan.stiles@open.ac.uk> wrote:

Hi James,

Once you have the eprint object, I’d have expected something like

 

my $elements_id = $eprint->get_value(“elemid”);

 

Though I’m just back from holiday and that’s come from my partially functional brain.

 

Alan

 

 

From: eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> On Behalf Of James Kerwin via Eprints-tech
Sent: 29 August 2019 11:39
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] Getting Data from the EPrints Database - not urgent

 

Hello everyone,

 

I altered the staff/admin view of our EPrints installation at the start of February this year so that it displays both a link to the EPrints record and a link to the corresponding Elements record:

 

image.png

 

I managed to successfully grab the Elements ID from the Crosswalks and add it as a new field in the EPrints database ("eprint" table) under a field name of "elemid". The link only shows if an item has an elements ID and so far I've not had any problems with it.

 

I'm just not sure the way I'm grabbing the elements ID from the eprints database is correct. When I get the eprint ID I do the following in my local copy of View.pm:

 

my $eprint = $self->{processor}->{eprint};

$eprint->id;

 

I know there's other STUFF elsewhere in this module that handles getting the eprint  and ID. No matter what I do I can't get the Elements ID in this way and I have to use a small function to perform a SQL query to get "elemid". Is there a way I could more easily/cleanly get the elemid without writing a SQL query? I'm assuming there is and I'm totally misunderstanding what's happening.

 

Thanks,

James

-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority in relation to its secondary activity of credit broking.