EPrints Technical Mailing List Archive

Message: #04215

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

[EP-tech] Re: eprintid reassignment

I think this is something you'd really need to question how important it is.  It's easy enough (sort of) to implement technically, but my gut thinks it's extremely inadvisable.

IDs are assigned to items at creation time and are assumed to be unique.  They are used to generate URLs with which to refer to the records.  It's extremely useful that a URL always points to one thing, and if that thing ceases to exist, then we would expect the URL to land at some kind of gravestone page, or give a 404 error.

It would be kind of like reassigning National Insurance Numbers whenever someone died.

Any idea why your RDM project leaders don't want any gaps?

--
Adam Field
Business Relationship Manager and Community Lead
EPrints Services
+44 (0)23 8059 8814





On 11 May 2015, at 15:19, Simon Jennings wrote:

> Hi Adam,
> 
> "Interesting question.  What's driving this requirement?  Integers are not a finite resource..."
> 
> One of our RDM project leaders who doesn't really want to see any gaps in the id sequence. It's not really a functional requirement so I guess its more of a question of how easy is it to do?
> 
> I think if it's something that's tricky, as Ian indicated, we'll have to see how important it really is.
> 
> Simon.
>  
> >>> <eprints-tech-request@ecs.soton.ac.uk> 11/05/2015 15:04 >>>
> Send Eprints-tech mailing list submissions to
>     eprints-tech@ecs.soton.ac.uk
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>     http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> or, via email, send a message with subject or body 'help' to
>     eprints-tech-request@ecs.soton.ac.uk
> 
> You can reach the person managing the list at
>     eprints-tech-owner@ecs.soton.ac.uk
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Eprints-tech digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: eprintid reassignment (Field A.N.)
>    2.  Files.eprints.org is down? (David Kane)
>    3. Re: Files.eprints.org is down? (Timothy Miles-Board)
>    4. Re: eprintid reassignment (Simon Jennings)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 11 May 2015 12:35:23 +0100
> From: "Field A.N." <af05v@ecs.soton.ac.uk>
> Subject: [EP-tech] Re: eprintid reassignment
> To: eprints-tech@ecs.soton.ac.uk
> Message-ID: <03B3C404-0C37-4D8D-B394-C379DA98215A@ecs.soton.ac.uk>
> Content-Type: text/plain; charset=us-ascii
> 
> Interesting question.  What's driving this requirement?  Integers are not a finite resource...
> 
> --
> Adam Field
> Business Relationship Manager and Community Lead
> EPrints Services
> +44 (0)23 8059 8814
> 
> 
> 
> 
> 
> On 11 May 2015, at 11:37, Simon Jennings wrote:
> 
> > Hi everyone,
> > 
> > I was wondering what the possibility might be of reclaiming deleted eprint ids. The eprintid assignment is incremental but due to deletion, and accidentally created records via the new item button, many ids in the sequence can go unused.
> > 
> > Is it possible to recycle these in some way?
> > 
> > Many thanks,
> > 
> > Simon.
> > *** 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 developers Forum: http://forum.eprints.org/
> 
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Mon, 11 May 2015 12:05:27 +0000
> From: David Kane <DKANE@wit.ie>
> Subject: [EP-tech]  Files.eprints.org is down?
> To: Eprints Technical <eprints-tech@ecs.soton.ac.uk>
> Message-ID: <1431345927231.57042@wit.ie>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Hi,
> 
> 
> I am trying to get the latest build of EPrints, and the webserver seems to be down.  Is that something on my side only, or are others having trouble with it.
> 
> 
> Thanks,
> 
> 
> David.
> 
> 
> --
> David F. Kane, MSc (Econ). ILS.
> Systems Librarian
> Waterford Institute of Technology
> Ireland
> http://library.wit.ie/
> T: ++353.51302838
> M: ++353.876693212
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150511/cdb0be81/attachment-0001.html 
> 
> ------------------------------
> 
> Message: 3
> Date: Mon, 11 May 2015 12:44:20 +0000
> From: Timothy Miles-Board <timothy.miles-board@ulcc.ac.uk>
> Subject: [EP-tech] Re: Files.eprints.org is down?
> To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
> Message-ID: <c9d5e13a-4a48-4f73-b777-33f54c00473a@email.android.com>
> Content-Type: text/plain; charset="utf-8"
> 
> http://www.downforeveryoneorjustme.com/files.eprints.org
> 
> On 11 May 2015 1:13 pm, David Kane <DKANE@wit.ie> wrote:
> 
> Hi,
> 
> 
> I am trying to get the latest build of EPrints, and the webserver seems to be down.  Is that something on my side only, or are others having trouble with it.
> 
> 
> Thanks,
> 
> 
> David.
> 
> 
> --
> David F. Kane, MSc (Econ). ILS.
> Systems Librarian
> Waterford Institute of Technology
> Ireland
> http://library.wit.ie/
> T: ++353.51302838
> M: ++353.876693212
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150511/4d6f9b0b/attachment-0001.html 
> 
> ------------------------------
> 
> Message: 4
> Date: Mon, 11 May 2015 14:57:04 +0100
> From: "Simon Jennings" <Simon.Jennings@lshtm.ac.uk>
> Subject: [EP-tech] Re: eprintid reassignment
> To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
> Message-ID: <5550C3400200007E000120E7@smtp-b.lshtm.ac.uk>
> Content-Type: text/plain; charset="us-ascii"
> 
> Thanks Ian,
> 
> sounds like I need to do a bit research for that one.
> >>> <eprints-tech-request@ecs.soton.ac.uk> 11/05/2015 12:00 >>>
> Send Eprints-tech mailing list submissions to
>     eprints-tech@ecs.soton.ac.uk
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>     http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> or, via email, send a message with subject or body 'help' to
>     eprints-tech-request@ecs.soton.ac.uk
> 
> You can reach the person managing the list at
>     eprints-tech-owner@ecs.soton.ac.uk
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Eprints-tech digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Auto complete not working for authors (Jacob Wenzel)
>    2.  eprintid reassignment (Simon Jennings)
>    3. Re: eprintid reassignment (Ian Stuart)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Sun, 10 May 2015 13:32:47 +0200
> From: Jacob Wenzel <jw@energiakademiet.dk>
> Subject: [EP-tech] Re: Auto complete not working for authors
> To: eprints-tech@ecs.soton.ac.uk
> Message-ID: <554F41DF.4070404@energiakademiet.dk>
> Content-Type: text/plain; charset=windows-1252; format=flowed
> 
> I have the same problem with Eprints 3.3.14 on Ubuntu 12.04.5 LTS with 
> MySQL 5.5.43.
> 
> I made a simple auto complete file for the projects field, that worked 
> in Eprints 3.3.12, but broke in 3.3.13. Most others worked, though I 
> don't think Journal title has ever worked.
> 
> But after upgrading to Eprints 3.3.14 only Title works, like Matheiu wrote.
> 
> On 24-03-2015 13:25, Mathieu Perron wrote:
> > Hi Alen,
> >
> > Thank you for your reply!  Don't worry I have a test instance for all this
> > :)
> >
> > My MySQL version is 5.0.95 and I did do the databse upgrade after
> > installing the new version.  After some bug fixing my instance is working
> > fine (except for one or two missing phrases but I'll get to this soon
> > enough).  I can deposit new documents, run searches, etc.  But that damn
> > auto complete is working for the title but not for the authors.
> >
> > I have checked the eprint_creators_name table and all the varchar columns
> > have "latin1_swedish_ci" as Collation.  Does it have to be utf8?  From
> > what I read utf-8 should work with latin1 collation...
> >
> > Am I understanding this right?
> >
> > Thanks for clearing that up!
> >
> > *** 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 developers Forum: http://forum.eprints.org/
> >
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Mon, 11 May 2015 11:37:10 +0100
> From: "Simon Jennings" <Simon.Jennings@lshtm.ac.uk>
> Subject: [EP-tech]  eprintid reassignment
> To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
> Message-ID: <555094660200007E000120C0@smtp-b.lshtm.ac.uk>
> Content-Type: text/plain; charset="us-ascii"
> 
> Hi everyone,
> 
> I was wondering what the possibility might be of reclaiming deleted eprint ids. The eprintid assignment is incremental but due to deletion, and accidentally created records via the new item button, many ids in the sequence can go unused.
> 
> Is it possible to recycle these in some way?
> 
> Many thanks,
> 
> Simon.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150511/e8c444ca/attachment-0001.html 
> 
> ------------------------------
> 
> Message: 3
> Date: Mon, 11 May 2015 11:53:07 +0100
> From: Ian Stuart <Ian.Stuart@ed.ac.uk>
> Subject: [EP-tech] Re: eprintid reassignment
> To: eprints-tech@ecs.soton.ac.uk
> Message-ID: <55508A13.8010302@ed.ac.uk>
> Content-Type: text/plain; charset=windows-1252; format=flowed
> 
> On 11/05/15 11:37, Simon Jennings wrote:
> > Hi everyone,
> >
> > I was wondering what the possibility might be of reclaiming deleted
> > eprint ids. The eprintid assignment is incremental but due to deletion,
> > and accidentally created records via the new item button, many ids in
> > the sequence can go unused.
> >
> > Is it possible to recycle these in some way?
> 
> With trickery, all things are possible on code.
> 
> The challenge is that the eprintid also relates to directory locations 
> for documents... which means that when you search for "the next free 
> slot", you need to check that the records isn't in use in the database 
> (remembering that records can be in a users inbox or in the retired 
> buffer too), and that the directory [tree] is not present.
> 
> -- 
> 
> Ian Stuart.
> Developer: ORI, RJ-Broker, and OpenDepot.org
> Bibliographics and Multimedia Service Delivery team,
> EDINA,
> The University of Edinburgh.
> 
> http://edina.ac.uk/
> 
> This email was sent via the University of Edinburgh.
> 
> The University of Edinburgh is a charitable body, registered in
> Scotland, with registration number SC005336.
> 
> 
> 
> ------------------------------
> 
> _______________________________________________
> Eprints-tech mailing list
> Eprints-tech@ecs.soton.ac.uk
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> 
> 
> End of Eprints-tech Digest, Vol 80, Issue 13
> ********************************************
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150511/164e54c7/attachment.html 
> 
> ------------------------------
> 
> _______________________________________________
> Eprints-tech mailing list
> Eprints-tech@ecs.soton.ac.uk
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> 
> 
> End of Eprints-tech Digest, Vol 80, Issue 14
> ********************************************
> *** 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 developers Forum: http://forum.eprints.org/