eprints_tech messages

Joseph,
The subject tree is initially imported from a file (flat-text or XML), and from ↵
then on it is stored in the database.

It would be possible for someone to script an admin plugin to manage this type ↵
of thing - although I haven't tried making one myself (as I'm happy poking ↵
about in the SQL ;).

The plugin would need to do something like:
-find unmatched entries
-suggest replacements for these entries (with ↵
change-one/change-all/remove-one/remove-all options?)

The real issue is actually that un-matched entries aren't rendered in the ↵
Workflow - so you can't remove them in the most logical place!
It's controlled by:
perl_lib/EPrints/Plugin/InputForm/Component/Field/Subject.pl

-but I haven't had time to pick it apart and work out how best to render these ↵
'problem' values!

Cheers,
John

-----Original Message-----
From: eprints-tech-bounces AT ecs.soton.ac.uk [mailto:eprints-tech-bounces AT ↵
ecs.soton.ac.uk] On Behalf Of Joseph Reeves
Sent: 15 March 2010 15:12
To: eprints-tech AT ecs.soton.ac.uk
Subject: [EP-tech] Re: Changed my subjects list - now I have a problem with old ↵
items...

Thanks John, that's very helpful,

I'm looking at the web interface (Eprints 3.0.5 on Ubuntu) now to edit these ↵
items with subjects that have been removed - the subjects are not shown, ↵
leaving me able to apply the new subjects. Obviously the old subjects are still ↵
referred to in the database, leaving me with entries such as:

http://library.thehumanjourney.net/86/

With the ?subjects?

Editing the database is one option, but could the web interface be changed to ↵
allow me to fix broken things like this? I don't know the workings of these ↵
things, but I imagine the webinterface is used to write to a file based ↵
representation of the entry and not the db?

Thanks again, Joseph

On 26 February 2010 16:05, John Salter <J.Salter AT leeds.ac.uk> wrote:
> Joseph,
> I did something like this on the database recently (after some imported ↵
eprints had mangled subject id's):
> In our archive we have a subject field called 'iau' - replace this with ↵
whatever the mangled subject field is called!
>
> Get eprint ID's and bad subject codes:
> mysql> SELECT eprintid, iau FROM eprint_iau WHERE iau NOT IN (SELECT 
> mysql> subjectid FROM subject) ORDER BY eprintid;
>
> Get titles/status' of items with bad subject codes:
> mysql> SELECT eprintid, eprint_status, title FROM eprint WHERE 
> mysql> eprintid IN (SELECT eprintid FROM eprint_iau WHERE iau NOT IN 
> mysql> (SELECT subjectid FROM subject)) ORDER BY eprintid;
>
> This will give you a list of eprints where the subject code assigned to it ↵
has no entry in the subject tree.
> You can then either:
> 1) Add subjects as necessary
> 2) Update eprint_subject as necessary.
>
> I was going to post this sometime soon as a 'One-liner' short ↵
database/perl hacks to test things in EPRints.
> Does anyone else have anything they've worked out that might be useful to ↵
share?
>
> Cheers,
> John
>
>
>
> -----Original Message-----
> From: eprints-tech-bounces AT ecs.soton.ac.uk 
> [mailto:eprints-tech-bounces AT ecs.soton.ac.uk] On Behalf Of Joseph 
> Reeves
> Sent: 26 February 2010 13:58
> To: eprints-tech AT ecs.soton.ac.uk
> Subject: [EP-tech] Re: Changed my subjects list - now I have a problem ↵
with old items...
>
> Thanks Ranju,
>
> I've just gone through the same process and the mention of the old ↵
subjects still remain:
>
> http://library.thehumanjourney.net/86/
>
> I've since restarted Apache as well, but this did not solve the problem ↵
either.
>
> Thanks again, Joseph
>
>
>
>
> On 26 February 2010 13:41, Ranju Upadhyay <Ranju.Upadhyay AT ↵
nuim.ie> wrote:
>> Hi Joseph,
>>
>> We also changed our subject files recently and doing, import_subject 
>> generate_views and generate_abstract
>>
>> took care of everything for us.We did not need any database changes.
>>
>> Ranju
>> National University of Ireland Maynooth.
>>
>> ----- Original Message -----
>> From: Joseph Reeves <iknowjoseph AT gmail.com>
>> Date: Friday, February 26, 2010 1:34 pm
>> Subject: [EP-tech] Changed my subjects list - now I have a problem 
>> with old items...
>> To: eprints-tech AT ecs.soton.ac.uk
>>
>>> Dear all,
>>>
>>> Cutting a long story short, I have been asked to change the ↵
subjects 
>>> file on our eprints installation - this all went fine and all our 
>>> live items have been updated with their new subjects.
>>>
>>> Unfortunately, however, I discovered that there was a large amount ↵

>>> of items in the review area that were tagged with the old ↵
subjects. 
>>> I've applied the new subjects and can see no mention of the old 
>>> ones, but in the item view I see links to "?? Old Subject ↵
??". Of 
>>> course, these
>>> 404 when clicked.
>>>
>>> I've ran generate_abstracts and the mention of the old subjects 
>>> remain, although I can't find where these would be defined.
>>>
>>> Will this need a database update to resolve? If so, could somebody ↵

>>> please point me in the right direction? Would it be possible to 
>>> remove subject information for every item under review?
>>>
>>> We're all very pleased with our Eprints repository and resolving 
>>> this issue will give us the opportunity to add much more content ↵
to 
>>> it (at which point it'll go public).
>>>
>>> Thanks in advance, Joseph
>>> *** Options:
>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive: http://www.eprints.org/tech.php/
>>> *** EPrints community wiki: http://wiki.eprints.org/
>> *** Options:
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: http://www.eprints.org/tech.php/
>> *** EPrints community wiki: http://wiki.eprints.org/
>>
>>
> *** Options: 
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
>
> *** Options: 
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
>
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/

eprints_tech messages

[EP-tech] Re: Changed my subjects list - now I have a problem with old items...