eprints_tech messages

Hi John,

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

I'm happy with this, but it's about the limit of my EPrints knowledge,
still I'm pleased with the repository I've put together.

> 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

I suppose the EPrints authors didn't think that there would be people
like myself out there suffering these "left hand knowing what the
right hand is doing" issues. My Perl skills aren't strong enough to
add un-matched entries to the workflow, but if anyone could hack up a
new perl file, I'd be more than willing to test it!

Cheers, Joseph

On 15 March 2010 17:05, John Salter <J.Salter AT leeds.ac.uk> wrote:
> 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/
>

*** 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...