[Dspace-general] problem with DSpace saving multiple-file documents out-of-order

[Claudia Juergen]

Hi Christine,

if you want the bitstreams to be listed ordered by e.g. filename, you
can change:

org.dspace.content.Bundle.java (DSpace Version 1.5.1)

replace:
// Get bitstreams
TableRowIterator tri = DatabaseManager.queryTable(
            ourContext, "bitstream",
            "SELECT bitstream.* FROM bitstream, bundle2bitstream WHERE "
            + "bundle2bitstream.bitstream_id=bitstream.bitstream_id AND "
            + "bundle2bitstream.bundle_id= ? ",
            bundleRow.getIntColumn("bundle_id"));


with
// Get bitstreams
TableRowIterator tri = DatabaseManager.queryTable(
            ourContext, "bitstream",
            "SELECT bitstream.* FROM bitstream, bundle2bitstream WHERE "
            + "bundle2bitstream.bitstream_id=bitstream.bitstream_id AND "
            + "bundle2bitstream.bundle_id= ? "
            + "ORDER BY bitstream.name ",
            bundleRow.getIntColumn("bundle_id"));

hope that helps

Claudia Jürgen

> DSpace is new to me, and I have been running into a pesky problem.
>
> We are using DSpace to archive faculty publications at our small
> University.  When I am archiving documents with multiple files (such as
> books or theses), they are saved out of the order I entered them into
> the system.  This results in chapters being listed out of order, and is
> quite confusing.
>
> Any ideas to solve this problem?  I read through the help files, but
> have found no solution.
>
> Many thanks,
>
>
> Christine Guerra
> Library Assistant
> Bibliothèque J.N. Desmarais Library
> Laurentian University
> 935 Ramsey Lake Road, Sudbury, Ontario
>
>
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>