Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[helix84]

Hi Mark, Jacob,

you're both correct. bundle.name was used in DSpace up to version 4.
DSpace 5 and later moves metadata of DSpace objects to the
metadatavalue table. The code in ItemDAOPostgres is clearly wrong, but
has been missed, probably because it rarely triggers. I filed a bug
report [1] which also has the new query to get bundle name.

[1] https://jira.duraspace.org/browse/DS-2395

Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


On Tue, Jan 6, 2015 at 7:54 PM, Brown, Jacob  wrote:
> Sorry, I should have clarified that this was for a DSpace 4.1 setup…
>
>
>
> I don’t know anything about the database tables for 5.x, but I just looked
> at:
>
>
>
> https://github.com/DSpace/DSpace/blob/dspace-5.0-rc2/dspace-api/src/main/java/org/dspace/content/dao/ItemDAOPostgres.java
>
>
>
> which still references a `bundle.name`, which doesn’t make sense unless a)
> the `bundle` table still has a name field, or b) ItemDAO is deprecated.
>
>
>
> Jacob
>
>
>
> From: Mark Ehle [mailto:marke...@gmail.com]
> Sent: Tuesday, January 06, 2015 12:42 PM
> To: Brown, Jacob
> Cc: DSpace-tech@lists.sourceforge.net
> Subject: Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream
>
>
>
> OK, Guys, just call me dense, but I can't make sense of Jacob's query -
> where it says, bundle.name='THUMBNAIL' - the bundle table does not have a
> name field. What am I missing?
>
> (This is on a DSpace 5.0-rc2 box)
>
> Thanks -
>
> Mark
>
>
>
> On Thu, Dec 11, 2014 at 7:08 AM, Mark Ehle  wrote:
>
> Thanks, guys! That gives me something to chew on. What I need the query for
> is to generate a media rss feed from Dspace.
>
>
>
> On Wed, Dec 10, 2014 at 5:16 PM, Brown, Jacob  wrote:
>
> Hi Mark,
>
>
>
> Not sure if what you are using the query for, but if you are using it inside
> a Java application, DSpace provides a
> [service](https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
> to get the primary bitstream’s thumbnail for an item. It’s used like, e.g.:
>
>
>
> org.dspace.content.service.ItemService.getThumbnail(context, item.id, false)
>
>
>
> If you need it outside Java, try the following (sorry for the CTEs, I’m
> using SQL snippets from helix84 and the ItemService code and didn’t want to
> rewrite everything). It could use some re-writing, but should get you
> started.
>
>
>
> with itemHolder as (
>
>   SELECT item_id as id FROM item, handle
>
>   WHERE handle.resource_id = item.item_id
>
>   AND handle.handle = 'dspace/handle'
>
> ),
>
> primaryBitstream as (
>
>   SELECT bundle.primary_bitstream_id as id FROM item2bundle, bundle
>
>   WHERE item2bundle.item_id in (SELECT id FROM itemHolder) AND
> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='ORIGINAL' LIMIT 1
>
> ),
>
> nameHolder as (
>
>   SELECT name || '.jpg' as name
>
>   FROM bitstream
>
>   WHERE bitstream_id IN (SELECT id FROM PrimaryBitstream)
>
> ),
>
> namedBitstream as (
>
>   SELECT bitstream.bitstream_id as id FROM item2bundle, bundle,
> bundle2bitstream, bitstream
>
>   WHERE item2bundle.item_id IN (SELECT id FROM itemHolder) AND
> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='THUMBNAIL'
>
>   AND bundle.bundle_id=bundle2bitstream.bundle_id AND
> bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name IN
> (SELECT name from nameHolder)
>
> ) SELECT id FROM namedBitstream;
>
>
>
> Jacob
>
>
>
> From: Mark Ehle [mailto:marke...@gmail.com]
> Sent: Wednesday, December 10, 2014 11:12 AM
> To: DSpace-tech@lists.sourceforge.net
> Subject: [Dspace-tech] Query to get ID of thumbnail of primary bitstream
>
>
>
> Folks -
>
> I am in need of a way to query postgres in Dspace to give me the ID of the
> primary bitstream's thumbnail ID. I am able to get the primary bitstream ID
> from the handle (thanks to helix84,
> http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
> but I don't know where to match up the thumbnail to it.
>
> Thanks!
>
> Mark Ehle
>
> Computer Support Librarian
>
> Willard Library
>
> Battle Creek, MI
>
>
>
>
>
>
> --
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from w

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Brown, Jacob]

Sorry, I should have clarified that this was for a DSpace 4.1 setup…

I don’t know anything about the database tables for 5.x, but I just looked at:

https://github.com/DSpace/DSpace/blob/dspace-5.0-rc2/dspace-api/src/main/java/org/dspace/content/dao/ItemDAOPostgres.java

which still references a `bundle.name`, which doesn’t make sense unless a) the 
`bundle` table still has a name field, or b) ItemDAO is deprecated.

Jacob

From: Mark Ehle [mailto:marke...@gmail.com]
Sent: Tuesday, January 06, 2015 12:42 PM
To: Brown, Jacob
Cc: DSpace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

OK, Guys, just call me dense, but I can't make sense of Jacob's query - where 
it says, bundle.name<http://bundle.name>='THUMBNAIL' - the bundle table does 
not have a name field. What am I missing?
(This is on a DSpace 5.0-rc2 box)
Thanks -

Mark

On Thu, Dec 11, 2014 at 7:08 AM, Mark Ehle 
mailto:marke...@gmail.com>> wrote:
Thanks, guys! That gives me something to chew on. What I need the query for is 
to generate a media rss feed from Dspace.

On Wed, Dec 10, 2014 at 5:16 PM, Brown, Jacob 
mailto:j.h.br...@tcu.edu>> wrote:
Hi Mark,

Not sure if what you are using the query for, but if you are using it inside a 
Java application, DSpace provides a 
[service](https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
 to get the primary bitstream’s thumbnail for an item. It’s used like, e.g.:

org.dspace.content.service.ItemService.getThumbnail(context, 
item.id<http://item.id>, false)

If you need it outside Java, try the following (sorry for the CTEs, I’m using 
SQL snippets from helix84 and the ItemService code and didn’t want to rewrite 
everything). It could use some re-writing, but should get you started.

with itemHolder as (
  SELECT item_id as id FROM item, handle
  WHERE handle.resource_id = item.item_id
  AND handle.handle = 'dspace/handle'
),
primaryBitstream as (
  SELECT bundle.primary_bitstream_id as id FROM item2bundle, bundle
  WHERE item2bundle.item_id in (SELECT id FROM itemHolder) AND 
item2bundle.bundle_id=bundle.bundle_id AND 
bundle.name<http://bundle.name>='ORIGINAL' LIMIT 1
),
nameHolder as (
  SELECT name || '.jpg' as name
  FROM bitstream
  WHERE bitstream_id IN (SELECT id FROM PrimaryBitstream)
),
namedBitstream as (
  SELECT bitstream.bitstream_id as id FROM item2bundle, bundle, 
bundle2bitstream, bitstream
  WHERE item2bundle.item_id IN (SELECT id FROM itemHolder) AND 
item2bundle.bundle_id=bundle.bundle_id AND 
bundle.name<http://bundle.name>='THUMBNAIL'
  AND bundle.bundle_id=bundle2bitstream.bundle_id AND 
bundle2bitstream.bitstream_id=bitstream.bitstream_id AND 
bitstream.name<http://bitstream.name> IN (SELECT name from nameHolder)
) SELECT id FROM namedBitstream;

Jacob

From: Mark Ehle [mailto:marke...@gmail.com<mailto:marke...@gmail.com>]
Sent: Wednesday, December 10, 2014 11:12 AM
To: DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net>
Subject: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

Folks -

I am in need of a way to query postgres in Dspace to give me the ID of the 
primary bitstream's thumbnail ID. I am able to get the primary bitstream ID 
from the handle (thanks to 
helix84<http://dspace.2283337.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&user=211466>,
 
http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
 but I don't know where to match up the thumbnail to it.
Thanks!
Mark Ehle
Computer Support Librarian
Willard Library
Battle Creek, MI


--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Mark Ehle]

OK, Guys, just call me dense, but I can't make sense of Jacob's query -
where it says, bundle.name='THUMBNAIL' - the bundle table does not have a
name field. What am I missing?

(This is on a DSpace 5.0-rc2 box)

Thanks -

Mark

On Thu, Dec 11, 2014 at 7:08 AM, Mark Ehle  wrote:

> Thanks, guys! That gives me something to chew on. What I need the query
> for is to generate a media rss feed from Dspace.
>
> On Wed, Dec 10, 2014 at 5:16 PM, Brown, Jacob  wrote:
>
>> Hi Mark,
>>
>>
>>
>> Not sure if what you are using the query for, but if you are using it
>> inside a Java application, DSpace provides a [service](
>> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
>> to get the primary bitstream’s thumbnail for an item. It’s used like, e.g.:
>>
>>
>>
>> org.dspace.content.service.ItemService.getThumbnail(context, item.id,
>> false)
>>
>>
>>
>> If you need it outside Java, try the following (sorry for the CTEs, I’m
>> using SQL snippets from helix84 and the ItemService code and didn’t want to
>> rewrite everything). It could use some re-writing, but should get you
>> started.
>>
>>
>>
>> with itemHolder as (
>>
>>   SELECT item_id as id FROM item, handle
>>
>>   WHERE handle.resource_id = item.item_id
>>
>>   AND handle.handle = 'dspace/handle'
>>
>> ),
>>
>> primaryBitstream as (
>>
>>   SELECT bundle.primary_bitstream_id as id FROM item2bundle, bundle
>>
>>   WHERE item2bundle.item_id in (SELECT id FROM itemHolder) AND
>> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='ORIGINAL' LIMIT 1
>>
>> ),
>>
>> nameHolder as (
>>
>>   SELECT name || '.jpg' as name
>>
>>   FROM bitstream
>>
>>   WHERE bitstream_id IN (SELECT id FROM PrimaryBitstream)
>>
>> ),
>>
>> namedBitstream as (
>>
>>   SELECT bitstream.bitstream_id as id FROM item2bundle, bundle,
>> bundle2bitstream, bitstream
>>
>>   WHERE item2bundle.item_id IN (SELECT id FROM itemHolder) AND
>> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='THUMBNAIL'
>>
>>   AND bundle.bundle_id=bundle2bitstream.bundle_id AND
>> bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name
>> IN (SELECT name from nameHolder)
>>
>> ) SELECT id FROM namedBitstream;
>>
>>
>>
>> Jacob
>>
>>
>>
>> *From:* Mark Ehle [mailto:marke...@gmail.com]
>> *Sent:* Wednesday, December 10, 2014 11:12 AM
>> *To:* DSpace-tech@lists.sourceforge.net
>> *Subject:* [Dspace-tech] Query to get ID of thumbnail of primary
>> bitstream
>>
>>
>>
>> Folks -
>>
>> I am in need of a way to query postgres in Dspace to give me the ID of
>> the primary bitstream's thumbnail ID. I am able to get the primary
>> bitstream ID from the handle (thanks to helix84
>> <http://dspace.2283337.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&user=211466>,
>>
>> http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
>> but I don't know where to match up the thumbnail to it.
>>
>> Thanks!
>>
>> Mark Ehle
>>
>> Computer Support Librarian
>>
>> Willard Library
>>
>> Battle Creek, MI
>>
>
>
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Mark Ehle]

Thanks, guys! That gives me something to chew on. What I need the query for
is to generate a media rss feed from Dspace.

On Wed, Dec 10, 2014 at 5:16 PM, Brown, Jacob  wrote:

> Hi Mark,
>
>
>
> Not sure if what you are using the query for, but if you are using it
> inside a Java application, DSpace provides a [service](
> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
> to get the primary bitstream’s thumbnail for an item. It’s used like, e.g.:
>
>
>
> org.dspace.content.service.ItemService.getThumbnail(context, item.id,
> false)
>
>
>
> If you need it outside Java, try the following (sorry for the CTEs, I’m
> using SQL snippets from helix84 and the ItemService code and didn’t want to
> rewrite everything). It could use some re-writing, but should get you
> started.
>
>
>
> with itemHolder as (
>
>   SELECT item_id as id FROM item, handle
>
>   WHERE handle.resource_id = item.item_id
>
>   AND handle.handle = 'dspace/handle'
>
> ),
>
> primaryBitstream as (
>
>   SELECT bundle.primary_bitstream_id as id FROM item2bundle, bundle
>
>   WHERE item2bundle.item_id in (SELECT id FROM itemHolder) AND
> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='ORIGINAL' LIMIT 1
>
> ),
>
> nameHolder as (
>
>   SELECT name || '.jpg' as name
>
>   FROM bitstream
>
>   WHERE bitstream_id IN (SELECT id FROM PrimaryBitstream)
>
> ),
>
> namedBitstream as (
>
>   SELECT bitstream.bitstream_id as id FROM item2bundle, bundle,
> bundle2bitstream, bitstream
>
>   WHERE item2bundle.item_id IN (SELECT id FROM itemHolder) AND
> item2bundle.bundle_id=bundle.bundle_id AND bundle.name='THUMBNAIL'
>
>   AND bundle.bundle_id=bundle2bitstream.bundle_id AND
> bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name
> IN (SELECT name from nameHolder)
>
> ) SELECT id FROM namedBitstream;
>
>
>
> Jacob
>
>
>
> *From:* Mark Ehle [mailto:marke...@gmail.com]
> *Sent:* Wednesday, December 10, 2014 11:12 AM
> *To:* DSpace-tech@lists.sourceforge.net
> *Subject:* [Dspace-tech] Query to get ID of thumbnail of primary bitstream
>
>
>
> Folks -
>
> I am in need of a way to query postgres in Dspace to give me the ID of the
> primary bitstream's thumbnail ID. I am able to get the primary bitstream ID
> from the handle (thanks to helix84
> <http://dspace.2283337.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&user=211466>,
>
> http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
> but I don't know where to match up the thumbnail to it.
>
> Thanks!
>
> Mark Ehle
>
> Computer Support Librarian
>
> Willard Library
>
> Battle Creek, MI
>
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Brown, Jacob]

Hi Mark,

Not sure if what you are using the query for, but if you are using it inside a 
Java application, DSpace provides a 
[service](https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
 to get the primary bitstream’s thumbnail for an item. It’s used like, e.g.:

org.dspace.content.service.ItemService.getThumbnail(context, item.id, false)

If you need it outside Java, try the following (sorry for the CTEs, I’m using 
SQL snippets from helix84 and the ItemService code and didn’t want to rewrite 
everything). It could use some re-writing, but should get you started.

with itemHolder as (
  SELECT item_id as id FROM item, handle
  WHERE handle.resource_id = item.item_id
  AND handle.handle = 'dspace/handle'
),
primaryBitstream as (
  SELECT bundle.primary_bitstream_id as id FROM item2bundle, bundle
  WHERE item2bundle.item_id in (SELECT id FROM itemHolder) AND 
item2bundle.bundle_id=bundle.bundle_id AND bundle.name='ORIGINAL' LIMIT 1
),
nameHolder as (
  SELECT name || '.jpg' as name
  FROM bitstream
  WHERE bitstream_id IN (SELECT id FROM PrimaryBitstream)
),
namedBitstream as (
  SELECT bitstream.bitstream_id as id FROM item2bundle, bundle, 
bundle2bitstream, bitstream
  WHERE item2bundle.item_id IN (SELECT id FROM itemHolder) AND 
item2bundle.bundle_id=bundle.bundle_id AND bundle.name='THUMBNAIL'
  AND bundle.bundle_id=bundle2bitstream.bundle_id AND 
bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name IN 
(SELECT name from nameHolder)
) SELECT id FROM namedBitstream;

Jacob

From: Mark Ehle [mailto:marke...@gmail.com]
Sent: Wednesday, December 10, 2014 11:12 AM
To: DSpace-tech@lists.sourceforge.net
Subject: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

Folks -

I am in need of a way to query postgres in Dspace to give me the ID of the 
primary bitstream's thumbnail ID. I am able to get the primary bitstream ID 
from the handle (thanks to 
helix84<http://dspace.2283337.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&user=211466>,
 
http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
 but I don't know where to match up the thumbnail to it.
Thanks!
Mark Ehle
Computer Support Librarian
Willard Library
Battle Creek, MI
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Terry Brady]

The following query might help.  I use this to generate thumbnail links in
a PHP report tool.

This assumes you have already queried an item from table item i.  You would
need additional logic to extract the primary bitstream.

select array_to_string(array_agg(text('{$handleContext}/bitstream/id/' ||
bit.bitstream_id || '/' || bit.name)), '')
from bitstream bit
inner join bundle2bitstream b2b
  on b2b.bitstream_id = bit.bitstream_id
inner join bundle b
  on b2b.bundle_id = b.bundle_id
  and b.name = 'THUMBNAIL'
inner join item2bundle i2b
  on i2b.bundle_id = b.bundle_id
  and i2b.item_id=i.item_id

https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/query/auxFields.php#L38-L49

Terry

On Wed, Dec 10, 2014 at 9:11 AM, Mark Ehle  wrote:

> Folks -
>
> I am in need of a way to query postgres in Dspace to give me the ID of the
> primary bitstream's thumbnail ID. I am able to get the primary bitstream ID
> from the handle (thanks to helix84
> ,
>
> http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
> but I don't know where to match up the thumbnail to it.
>
> Thanks!
>
> Mark Ehle
> Computer Support Librarian
> Willard Library
> Battle Creek, MI
>
>
> --
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>



-- 
Terry Brady
Applications Programmer Analyst
Georgetown University Library Information Technology
https://www.library.georgetown.edu/lit/code
425-298-5498
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[Dspace-tech] Query to get ID of thumbnail of primary bitstream

[Mark Ehle]

Folks -

I am in need of a way to query postgres in Dspace to give me the ID of the
primary bitstream's thumbnail ID. I am able to get the primary bitstream ID
from the handle (thanks to helix84
,
http://dspace.2283337.n4.nabble.com/Get-item-id-from-bitstream-handle-td4662208.html)
but I don't know where to match up the thumbnail to it.

Thanks!

Mark Ehle
Computer Support Librarian
Willard Library
Battle Creek, MI
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query Solr with special characters

[Ruben]

Hi all,

I found the fix for this issue and if anyone needs the fix, I'll 
explain. How I explained before, my idea was escape special characters 
before they will be sent to solr. This process is being done in the 
following classes:


/dspace-1.7.2-src-release/dspace-discovery/dspace-discovery-xmlui-api/src/main/java/org/dspace/app/xmlui/aspect/discovery/AbstractSearch.java

/dspace-1.7.2-src-release/dspace-discovery/dspace-discovery-xmlui-api/src/main/java/org/dspace/app/xmlui/aspect/discovery/AbstractSearch.java

In this classes I added escapeQueryChars function from solrj, who adds 
escape char before special characters on a string, and returns it well 
formatted. Next step is use this function in generateURL function:


protected String generateURL(Map parameters)
throws UIException {
String query = getQuery();
if (!"".equals(query))
{

query = escapeQueryChars(query);
parameters.put("query", encodeForURL(query));
}

Of course, if anyone knows a better solution will be welcome.

Regards


On 13/11/14 08:07, Ruben wrote:

Hi Adan,

It seems well, but it changes the type of the search that is executed. 
I think surrounding the query with quotes makes solr search the 
literal string, and only returns the searches which contains the 
exactly string entered. If you escape "?" character, the results list 
is different because executes a normal search, I don't know if I 
explained well


Also thanks because it's interesting to learn tricks to search.

On 12/11/14 17:20, Adan Roman wrote:

Hi Rubén

Try surronding the query between quotes. This can work in most cases, 
unless the special character is a quote, of course


regards



Hi,

I noticed that if I use special characters in advanced search, solr
doesn't return any results. I read in Lucene documentation that is
possible to escape these special characters adding "\" in front of them,
and I will ask you if it's possible to modify the string query adding
the escape character before send it to search engine, and if it's
possible, how can I do it.

Thanks in advance





   

El software de antivirus Avast ha analizado este correo electrónico 
en busca de virus.

www.avast.com 




--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk


___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette:https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette



--


Rubén Boada
Tècnic de Càlcul i Aplicacions
Consorci de Serveis Universitaris de Catalunya (CSUC)

Gran Capità, 2 (Edifici Nexus).08034 Barcelona
T.93 551 62 13.ruben.bo...@csuc.cat
www.csuc.cat  .Twitter @CSUC_info.Facebook.Linkedin
Subscriu-te al butlletí; (www.csuc.cat/butlleti)



--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk


___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette



--


Rubén Boada
Tècnic de Càlcul i Aplicacions
Consorci de Serveis Universitaris de Catalunya (CSUC)

Gran Capità, 2 (Edifici Nexus).08034 Barcelona
T.93 551 62 13.ruben.bo...@csuc.cat
www.csuc.cat .Twitter @CSUC_info.Facebook.Linkedin
Subscriu-te al butlletí; (www.csuc.cat/butlleti)


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.dur

Re: [Dspace-tech] Query Solr with special characters

[Ruben]

Hi Adan,

It seems well, but it changes the type of the search that is executed. I 
think surrounding the query with quotes makes solr search the literal 
string, and only returns the searches which contains the exactly string 
entered. If you escape "?" character, the results list is different 
because executes a normal search, I don't know if I explained well


Also thanks because it's interesting to learn tricks to search.

On 12/11/14 17:20, Adan Roman wrote:

Hi Rubén

Try surronding the query between quotes. This can work in most cases, 
unless the special character is a quote, of course


regards



Hi,

I noticed that if I use special characters in advanced search, solr
doesn't return any results. I read in Lucene documentation that is
possible to escape these special characters adding "\" in front of them,
and I will ask you if it's possible to modify the string query adding
the escape character before send it to search engine, and if it's
possible, how can I do it.

Thanks in advance





   

El software de antivirus Avast ha analizado este correo electrónico en 
busca de virus.

www.avast.com 




--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk


___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette



--


Rubén Boada
Tècnic de Càlcul i Aplicacions
Consorci de Serveis Universitaris de Catalunya (CSUC)

Gran Capità, 2 (Edifici Nexus).08034 Barcelona
T.93 551 62 13.ruben.bo...@csuc.cat
www.csuc.cat .Twitter @CSUC_info.Facebook.Linkedin
Subscriu-te al butlletí; (www.csuc.cat/butlleti)


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query Solr with special characters

[Adan Roman]

Hi Rubén

Try surronding the query between quotes. This can work in most cases, 
unless the special character is a quote, of course


regards



Hi,

I noticed that if I use special characters in advanced search, solr
doesn't return any results. I read in Lucene documentation that is
possible to escape these special characters adding "\" in front of them,
and I will ask you if it's possible to modify the string query adding
the escape character before send it to search engine, and if it's
possible, how can I do it.

Thanks in advance




---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[Dspace-tech] Query Solr with special characters

[Ruben]

Hi,

I noticed that if I use special characters in advanced search, solr 
doesn't return any results. I read in Lucene documentation that is 
possible to escape these special characters adding "\" in front of them, 
and I will ask you if it's possible to modify the string query adding 
the escape character before send it to search engine, and if it's 
possible, how can I do it.

Thanks in advance

-- 


Rubén Boada
Tècnic de Càlcul i Aplicacions
Consorci de Serveis Universitaris de Catalunya (CSUC)

Gran Capità, 2 (Edifici Nexus)•08034 Barcelona
T.93 551 62 13•ruben.bo...@csuc.cat
www.csuc.cat •Twitter @CSUC_info•Facebook•Linkedin
Subscriu-te al butlletí; (www.csuc.cat/butlleti)



--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[Dspace-tech] Query

[Parul dubey]

Hi 

 

As you have mentioned :

 

To make items of Collection2 unreadable for a particular user, you'd

have to remove the read rights for the Anonymous user (i.e. everyone)

and then enumerate everyone except for your particular user. I don't

think you want to do that.

 

Just wanted to know how to remove the read right for anonymous user.

 

What I actually want is that I  have a community named ex: 'Books' and I
want only a particular user to read and download its submitted Item.

So how would I be able to do this.

 

Regards

Parul Dubey

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query for finding handle given the collection title

[helix84]

Hi Mark, it's in the handle table, it's trivial:

Select handle from handle where resourceid = communityid
On Dec 31, 2012 10:12 PM, "Mark Ehle"  wrote:

> Hello -
>
> I am looking for the query that would return from dspace's posegresql the
> handle of a community given the name of the community. I can get the
> community_id, but I don't know where the handle is.
>
> Thanks -
>
> Library Mark
>
>
> --
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122412
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[Dspace-tech] Query for finding handle given the collection title

[Mark Ehle]

Hello -

I am looking for the query that would return from dspace's posegresql the
handle of a community given the name of the community. I can get the
community_id, but I don't know where the handle is.

Thanks -

Library Mark
--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Query - DSpace on Windows 7.

[brian88mail-l...@yahoo.com]

Appreciate the quick responses and valuable info from Hilton (HG) & hellix84. A 
lot of reading to do here now!

Thank you very much.

Cheers
-brian





 From: helix84 
To: "brian88mail-l...@yahoo.com"  
Cc: "dspace-tech@lists.sourceforge.net"  
Sent: Tuesday, 13 November 2012, 17:19
Subject: Re: [Dspace-tech] Query - DSpace on Windows 7.
 
On Tue, Nov 13, 2012 at 4:36 AM, brian88mail-l...@yahoo.com
 wrote:
> 1. The manual refers to an "import" script under the [DSPACE_DIR]/bin
> directory but my [DSPACE_DIR]/bin directory only has these files:
>     - buildpath.bat
>     - dspace.bat
>     - dspace-info.pl
>     - make-handle-config
>     - dspace
>     - dspace_migrate
>     - log-reporter
>     - start-handle-server

Hi Brian,

are you sure you're using the documentation for your version of
DSpace? Here's the correct one for 1.8:

https://wiki.duraspace.org/display/DSDOC18/DSpace+1.8+Documentation

In some older versions there were separate scripts, but now there is a
single launcher script and the individual classes are called using
parameters:

[dspace]/bin/dspace import

Also look at
[dspace]/bin/dspace -h
[dspace]/bin/dspace import -h

> 2. I have created a small hierarchy data structures, e.g.
> Communities->Sub-Communities->Collections, etc.:
>
>     e.g.
>     - CUHK Repository
>         - Faculties
>           - Faculty of Arts
>           - Faculty of Business Administration
>           - Faculty of Education
>
>     I have tried manually submit items into the individual Faculty and it
> seemed to accept them olay. However, when I exported the dublin_core.xml
> from one of the item and made another sample metadata file based on it, and
> then tried to import via the menu "Import Metadata" under the Administer
> menu. It gave this message:
>
>     "Unknown metadata schema in heading: "
>
> What I was trying to do was to find the correct qualified DC format to
> prepare some metadata files for batch import.

Most likely you added some custom field that is not defined in DSpace
out-of-the-box. You must first add the field to the metadata fields
ergistry, only then you can add values to the field. In XMLUI, log in
as admin, then in the "Administrative" menu under "Registries" select
"Metadata".

> 3. How to set up Handle Server on Windows? Where can I change the default
> "123456789" ID?

You can change the handle prefix in dspace.cfg - the handle.prefix
property. Then restart Tomcat.
You don't need to run update-handle-prefix unless you already have
created some items in your repository, which would have the 123456789
prefix.

DSpace comes with the handle server included, so you have 2 options:
1) you can use the included handle server (see start-handle-server below)
2) you can download the server from CNRI, set it up separately and start it

In both cases, you first need to register with CNRI (and pay the fee)
and configure the handle server (including sending your metadata to
CNRI).

https://wiki.duraspace.org/display/DSDOC18/Installation#Installation-TheHandleServer

Refer to the CNRI site for details:
http://www.handle.net/documentation.html


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette--
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query - DSpace on Windows 7.

[helix84]

On Tue, Nov 13, 2012 at 4:36 AM, brian88mail-l...@yahoo.com
 wrote:
> 1. The manual refers to an "import" script under the [DSPACE_DIR]/bin
> directory but my [DSPACE_DIR]/bin directory only has these files:
> - buildpath.bat
> - dspace.bat
> - dspace-info.pl
> - make-handle-config
> - dspace
> - dspace_migrate
> - log-reporter
> - start-handle-server

Hi Brian,

are you sure you're using the documentation for your version of
DSpace? Here's the correct one for 1.8:

https://wiki.duraspace.org/display/DSDOC18/DSpace+1.8+Documentation

In some older versions there were separate scripts, but now there is a
single launcher script and the individual classes are called using
parameters:

[dspace]/bin/dspace import

Also look at
[dspace]/bin/dspace -h
[dspace]/bin/dspace import -h

> 2. I have created a small hierarchy data structures, e.g.
> Communities->Sub-Communities->Collections, etc.:
>
> e.g.
> - CUHK Repository
> - Faculties
>   - Faculty of Arts
>   - Faculty of Business Administration
>   - Faculty of Education
>
> I have tried manually submit items into the individual Faculty and it
> seemed to accept them olay. However, when I exported the dublin_core.xml
> from one of the item and made another sample metadata file based on it, and
> then tried to import via the menu "Import Metadata" under the Administer
> menu. It gave this message:
>
> "Unknown metadata schema in heading: "
>
> What I was trying to do was to find the correct qualified DC format to
> prepare some metadata files for batch import.

Most likely you added some custom field that is not defined in DSpace
out-of-the-box. You must first add the field to the metadata fields
ergistry, only then you can add values to the field. In XMLUI, log in
as admin, then in the "Administrative" menu under "Registries" select
"Metadata".

> 3. How to set up Handle Server on Windows? Where can I change the default
> "123456789" ID?

You can change the handle prefix in dspace.cfg - the handle.prefix
property. Then restart Tomcat.
You don't need to run update-handle-prefix unless you already have
created some items in your repository, which would have the 123456789
prefix.

DSpace comes with the handle server included, so you have 2 options:
1) you can use the included handle server (see start-handle-server below)
2) you can download the server from CNRI, set it up separately and start it

In both cases, you first need to register with CNRI (and pay the fee)
and configure the handle server (including sending your metadata to
CNRI).

https://wiki.duraspace.org/display/DSDOC18/Installation#Installation-TheHandleServer

Refer to the CNRI site for details:
http://www.handle.net/documentation.html


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

--
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query - DSpace on Windows 7.

[brian88mail-l...@yahoo.com]

Greetings,

I'm a newbie on DSpace and recently successfully installed the system (ver 
1.8.2) on a 32-bit Win7 box for a pre-project testing. I just wondered if 
someone wouldn't mind to shed some lights on my following queries please?

1. The manual refers to an "import" script under the [DSPACE_DIR]/bin directory 
but my [DSPACE_DIR]/bin directory only has these files:
    - buildpath.bat  

    - dspace.bat  

    - dspace-info.pl  

    - make-handle-config
    - dspace 

    - dspace_migrate  

    - log-reporter    

    - start-handle-server


2. I have created a small hierarchy data structures, e.g. 
Communities->Sub-Communities->Collections, etc.:
    

    e.g. 

    - CUHK Repository
        - Faculties
  - Faculty of Arts
  -Faculty of Business Administration
      - Faculty of Education
    

    I have tried manually submit items into the individual Faculty and it 
seemed to acceptthem olay. However, when I exported the dublin_core.xml from 
one of the item and made another sample metadata file based on it, and then 
tried to import via the menu "Import Metadata" under the Administer menu. It 
gave this message:

    "Unknown metadata schema in heading: "

What I was trying to do was to find the correct qualified DC format to prepare 
some metadata files for batch import.

3. How to set up Handle Server on Windows? Where can I change the default 
"123456789" ID?

Thank you.
-brian.t
University Library System

CUHK
--
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query about Dspace

[Mark Diggory]

Rahul,

1.) The big question is if you want to have them individually searchable as
separate records, then you want one Item per PDF. In this case your going
to need to massage the content some and create some import packages for
DSpace, either via the commandline using the ItemImport and the Simple
Archive Format or via SWORD or LNI as SIP Packages.

2.) No, DSpace does not support this functionality at this time.

Best,
Mark

On Fri, Mar 16, 2012 at 1:11 PM, Rahul Soni  wrote:

> I have two queries about the feature of DSpace:
>
> 1. I have a large set of pdf files that are accommodated in tree like
> folder arrangement (one folder inside one and so on). Number of files are
> very large and each pdf file is titled by some numeric codes only. Is it
> possible to upload of them through single folder only, as individually
> uploading them will be very tedious? If yes then how someone will be able
> to search them. Searching by their numeric title is important.
>
> 2. I have some communities and collections that are for institute
> administrative and internal communication purpose only. Is it possible to
> set them like they won't be visual for outsider (outside the institute
> campus) on public Dspace url?
>
>
> Thanking you
>
> Sincerely yours
>
> Rahul Kumar Soni 
> Senior UG Student
> Indian School of Mines
>
>
>
> --
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>


-- 
[image: @mire Inc.]
*Mark Diggory *(Schedule a
Meeting
)
*2888 Loker Avenue East, Suite 305, Carlsbad, CA. 92010*
*Esperantolaan 4, Heverlee 3001, Belgium*
http://www.atmire.com
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Query about Dspace

[Rahul Soni]

I have two queries about the feature of DSpace:

1. I have a large set of pdf files that are accommodated in tree like
folder arrangement (one folder inside one and so on). Number of files are
very large and each pdf file is titled by some numeric codes only. Is it
possible to upload of them through single folder only, as individually
uploading them will be very tedious? If yes then how someone will be able
to search them. Searching by their numeric title is important.

2. I have some communities and collections that are for institute
administrative and internal communication purpose only. Is it possible to
set them like they won't be visual for outsider (outside the institute
campus) on public Dspace url?


Thanking you

Sincerely yours

Rahul Kumar Soni 
Senior UG Student
Indian School of Mines
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] query group2groupcache table takes too much time

[Evelio Martínez]

Hello 

 

I was wondering if  it is normal on your installations to have users that
belong to several groups.

If positive, how much and what time does it take to show the first step on
the backend?

 

In our installations of DSpace there are about 10 people that belong to more
than 20 groups.

 

First step to show list of groups takes around 20-25 seconds.  That’s a lot.


 

Is there any fix to this inefficient query?

 

Test it on 

-  Red Hat EL 5.5 (Tikanga)

-  DSpace 1.5.1

-  Postgresql 8.4.2

-  Tomcat 6.0.33

-  java version "1.6.0_30"

 

 

select eperson.eperson_id, count(*) as num from eperson,epersongroup2eperson
where eperson.eperson_id=epersongroup2eperson.eperson_id group by
eperson.eperson_id order by count(*) desc limit 10;

eperson_id | num

+-

 24 | 171

278 |  94

 30 |  87

  7 |  66

386 |  60

482 |  55

454 |  16

304 |  12

640 |  11

347 |  10

(10 filas)

 

dspace=# explain analyze SELECT * FROM group2groupcache WHERE child_id in
(select eperson_group_id from epersongroup2eperson where  eperson_id=24);

 QUERY
PLAN




Hash Join  (cost=16.23..112.81 rows=4158 width=12) (actual
time=5.575..18.461 rows=877 loops=1)

   Hash Cond: (group2groupcache.child_id =
epersongroup2eperson.eperson_group_id)

   ->  Seq Scan on group2groupcache  (cost=0.00..64.58 rows=4158 width=12)
(actual time=5.245..17.415 rows=4158 loops=1)

   ->  Hash  (cost=15.07..15.07 rows=93 width=4) (actual time=0.296..0.296
rows=171 loops=1)

 ->  HashAggregate  (cost=14.14..15.07 rows=93 width=4) (actual
time=0.233..0.260 rows=171 loops=1)

   ->  Bitmap Heap Scan on epersongroup2eperson
(cost=5.58..13.71 rows=171 width=4) (actual time=0.085..0.162 rows=171
loops=1)

 Recheck Cond: (eperson_id = 24)

 ->  Bitmap Index Scan on epg2ep_eperson_fk_idx
(cost=0.00..5.53 rows=171 width=0) (actual time=0.060..0.060 rows=171
loops=1)

   Index Cond: (eperson_id = 24)

Total runtime: 18.577 ms

(10 filas)

 


cid:f0154016-8e66-4c6b-9255-4e7524133341


Evelio Martínez


Director proyectos software.



CISA, CCNA



Dept. de Tecnologías y Sistemas de Información


C/ Garcilaso, 15-bajo
46003 Valencia
Telf: 96 369 41 23 / 677 405 909
Fax: 96 369 34 39 


  www.masmedios.com


cid:f0154016-8e66-4c6b-9255-4e7524133341

 


cid:65691c43-2689-4f20-9b5d-5425927026a4



Este correo electrónico y, en su caso, cualquier fichero anexo al mismo,
puede contener información de carácter confidencial exclusivamente dirigida
a su(s) destinatario(s). De acuerdo con la LOPD, MASmedios informa de que
los datos personales contenidos quedarán sometidos a un tratamiento del que
aquélla es responsable. Los interesados consienten el tratamiento de sus
datos para estos fines, pudiendo ejercitar sus derechos de acceso,
rectificación, cancelación y oposición dirigiéndose por escrito a MASmedios
para la gestión de la información, calle Garcilaso 15-B 46003 Valencia o en
 proteccionda...@masmedios.com

 

<><>

smime.p7s
Description: S/MIME cryptographic signature
--
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query regarding default dspace homepage

[Lewatle Phaladi]

Ok 

 

This is the steps :

 

  Alter Dspace Web Address 

* Change the address from http://DomainName.ac.za/jspui to
http://DomainName.ac.za  In a file dspace.cfg

* The I changed into directory like,

*  $ cd  /TOMCATDIR/conf

* # mkdir Catalina/localhost

*  # cd Catalina/localhost

* # touch ROOT.xml

* # vi ROOT.xml

* And type the following inside the xml file :

*  

* 

This Will work

 

Regards,

Lewatle

 

 

From: za...@iub.edu.bd [mailto:za...@iub.edu.bd] 
Sent: 25 March 2010 08:33 AM
To: Lewatle Phaladi
Subject: RE: query regarding default dspace homepage

 

Hi Lewatle:

It is nice that you have solved the problem, but I need your kind
assitance for me regarding the same problem. Please help me.

Zahid



Hi Zahid

Thanks for your eagerness to assist and I ultimately solved the problem.

Regards,

Lewatle 

From: za...@iub.edu.bd [mailto:za...@iub.edu.bd] 
Sent: 25 March 2010 08:20 AM
To: Lewatle Phaladi
Subject: query regarding default dspace homepage

 

Dear Lewatle:

I will be grateful if you kindly give me the solution of the dspace
default home page instead of tomcat homepage. Look forward to your kind
reply.

Kind regards,

Zahid, IUB
Bangladesh

 


This communication is intended for the addressee only. It

is confidential. If you have received this communication in error,
please notify us immediately and

destroy the original message. You may not copy or disseminate this
communication without the permission of

the University. Only authorized signatories are competent to enter into
agreements on behalf of the

University and recipients are thus advised that the content of this
message may not be legally binding on

the University and may contain the personal views and opinions of the
author, which are not necessarily

the views and opinions of The University of the Witwatersrand,
Johannesburg. All agreements between the

University and outsiders are subject to South African Law unless the
University agrees in writing to the

contrary.

 


 


This communication 
is intended for the addressee only. It is confidential. If you have received 
this communication in error, please notify us immediately and destroy the 
original message. You may not copy or disseminate this communication without 
the permission of the University. Only authorized signatories are competent to 
enter into agreements on behalf of the University and recipients are thus 
advised that the content of this message may not be legally binding on the 
University and may contain the personal views and opinions of the author, which 
are not necessarily the views and opinions of The University of the 
Witwatersrand, Johannesburg. All agreements between the University and 
outsiders are subject to South African Law unless the University agrees in 
writing to the contrary.
--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query for determining number of files and size - sanity check

[Susan Teague Rector]

Hi Claudia,

I think we're missing a join the query below. the Itemtobundle table is 
never joined to bundle, which gives us a Cartesian join...
I rearranged the query a bit:

Thanks!

select b.size_bytes
from item i, metadatavalue m, item2bundle i2b, bundle b, 
bundle2bitstream b2b, bitstream bi
where i.in_archive=true
and m.metadata_field_id=11
and b.name='ORIGINAL'
and b.deleted=false
and i.item_id=m.item_id
and i.item_id=i2b.item_id
and i2b.bundle_id = b.bundle_id
and b.bundle_id=b2b.bundle_id
and b2b.bitstream_id=b.bitstream_id;

Claudia Jürgen wrote:
> Hi Susan,
>
> defining the total size of bitstreams ingested is impossible if you 
> have deleted items and/or bitstreams within the same year. You can get 
> the number and size of bitstreams which are at the moment in your 
> system, e.g. belonging to items still in archive and beeing 
> accessioned in a given year.
>
> with
>
> select b.size_bytes from bitstream b, bundle2bitstream b2b, 
> item2bundle i2b, bundle, item i, metadatavalue m
> where i.in_archive=true
> and i.item_id=m.item_id
> and m.metadata_field_id=11
> and m.text_value like '2008%'
> and i.item_id=i2b.item_id
> and bundle.name='ORIGINAL'
> and bundle.bundle_id=b2b.bundle_id
> and b2b.bitstream_id=b.bitstream_id
> and b.deleted=false;
>
> (The use of and instead of joins was just for the sake of readability.)
>
> Notes:
> - in the bundle ORIGINAL (no extracted text, license etc)
> - for items in archive (not withdrawn)
> - bitstreams not deleted
> - accessioned in e.g.2008
> - dc.date.accessioned metadata_field_id=11
>
>
> You can use select count (b.*) ... for the number of bitstreams
> You can use select sum (b.size_bytes)  for the sum of size_bytes.
>
>
> Hope that helps
>
> Claudia
>
>
> Susan Teague Rector schrieb:
>> Hi all,
>>
>> I just wanted to run this past the Dspace experts - I'm determining 
>> how many files and the total size of files ingested into our Dspace 
>> installation last year.
>> Here's the query I'm running.
>>
>> Since I don't look at the Dspace database on a daily basis, I needed 
>> a sanity check from you folks - Is this is the best way to get at 
>> this data?
>>
>> Thanks in advance,
>>
>> Susan Teague Rector
>> Web Applications Manager
>> VCU Libraries
>>
>>
>> select id.item_id, id.date_issued, ib.bundle_id,
>> b.bitstream_id, b.name, b.size_bytes, b.source
>> from itemsbydate id inner join
>> item2bundle ib on id.item_id = ib.item_id
>> inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id
>> inner join bitstream b on bb.bitstream_id = b.bitstream_id
>> where name <> 'license.txt'
>> and (source not like '%Written by Media%') or source is null
>> order by id.date_issued, ib.bundle_id;
>>
>> --
>>  
>>
>> ___
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech 

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query for determining number of files and size - sanity check

[Susan Teague Rector]

Thanks all,
This is what I need - good to know abou the bundle name -
Best,
susan


Claudia Jürgen wrote:
> Hi Susan,
>
> defining the total size of bitstreams ingested is impossible if you 
> have deleted items and/or bitstreams within the same year. You can get 
> the number and size of bitstreams which are at the moment in your 
> system, e.g. belonging to items still in archive and beeing 
> accessioned in a given year.
>
> with
>
> select b.size_bytes from bitstream b, bundle2bitstream b2b, 
> item2bundle i2b, bundle, item i, metadatavalue m
> where i.in_archive=true
> and i.item_id=m.item_id
> and m.metadata_field_id=11
> and m.text_value like '2008%'
> and i.item_id=i2b.item_id
> and bundle.name='ORIGINAL'
> and bundle.bundle_id=b2b.bundle_id
> and b2b.bitstream_id=b.bitstream_id
> and b.deleted=false;
>
> (The use of and instead of joins was just for the sake of readability.)
>
> Notes:
> - in the bundle ORIGINAL (no extracted text, license etc)
> - for items in archive (not withdrawn)
> - bitstreams not deleted
> - accessioned in e.g.2008
> - dc.date.accessioned metadata_field_id=11
>
>
> You can use select count (b.*) ... for the number of bitstreams
> You can use select sum (b.size_bytes)  for the sum of size_bytes.
>
>
> Hope that helps
>
> Claudia
>
>
> Susan Teague Rector schrieb:
>> Hi all,
>>
>> I just wanted to run this past the Dspace experts - I'm determining 
>> how many files and the total size of files ingested into our Dspace 
>> installation last year.
>> Here's the query I'm running.
>>
>> Since I don't look at the Dspace database on a daily basis, I needed 
>> a sanity check from you folks - Is this is the best way to get at 
>> this data?
>>
>> Thanks in advance,
>>
>> Susan Teague Rector
>> Web Applications Manager
>> VCU Libraries
>>
>>
>> select id.item_id, id.date_issued, ib.bundle_id,
>> b.bitstream_id, b.name, b.size_bytes, b.source
>> from itemsbydate id inner join
>> item2bundle ib on id.item_id = ib.item_id
>> inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id
>> inner join bitstream b on bb.bitstream_id = b.bitstream_id
>> where name <> 'license.txt'
>> and (source not like '%Written by Media%') or source is null
>> order by id.date_issued, ib.bundle_id;
>>
>> --
>>  
>>
>> ___
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech 

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query for determining number of files and size - sanity check

[Allen Lam]

Hi Susan,

To get an estimation of total file size and count, you can do a simple 
directory listing of dspace/assetstore.
In a few minutes you get the answers, with no pain at all.
It is assumed you only want to count content files stored locally in dspace.
The count may contain some withdrawn/pending items. For our case, the 
result is accurate enough for most statistical uses.

Allen.
HKU Hub Administrator, http://hub.hku.hk


Susan Teague Rector wrote:
> Hi all,
>
> I just wanted to run this past the Dspace experts - I'm determining how 
> many files and the total size of files ingested into our Dspace 
> installation last year.
> Here's the query I'm running.
>
> Since I don't look at the Dspace database on a daily basis, I needed a 
> sanity check from you folks - Is this is the best way to get at this data?
>
> Thanks in advance,
>
> Susan Teague Rector
> Web Applications Manager
> VCU Libraries
>
>
> select id.item_id, id.date_issued, ib.bundle_id,
> b.bitstream_id, b.name, b.size_bytes, b.source
> from itemsbydate id inner join
> item2bundle ib on id.item_id = ib.item_id
> inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id
> inner join bitstream b on bb.bitstream_id = b.bitstream_id
> where name <> 'license.txt'
> and (source not like '%Written by Media%') or source is null
> order by id.date_issued, ib.bundle_id;
>
> --
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>   

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query for determining number of files and size - sanity check

[Claudia Jürgen]

Hi Susan,

defining the total size of bitstreams ingested is impossible if you have 
deleted items and/or bitstreams within the same year. You can get the 
number and size of bitstreams which are at the moment in your system, 
e.g. belonging to items still in archive and beeing accessioned in a 
given year.

with

select b.size_bytes from bitstream b, bundle2bitstream b2b, item2bundle 
i2b, bundle, item i, metadatavalue m
where i.in_archive=true
and i.item_id=m.item_id
and m.metadata_field_id=11
and m.text_value like '2008%'
and i.item_id=i2b.item_id
and bundle.name='ORIGINAL'
and bundle.bundle_id=b2b.bundle_id
and b2b.bitstream_id=b.bitstream_id
and b.deleted=false;

(The use of and instead of joins was just for the sake of readability.)

Notes:
- in the bundle ORIGINAL (no extracted text, license etc)
- for items in archive (not withdrawn)
- bitstreams not deleted
- accessioned in e.g.2008
- dc.date.accessioned metadata_field_id=11


You can use select count (b.*) ... for the number of bitstreams
You can use select sum (b.size_bytes)  for the sum of size_bytes.


Hope that helps

Claudia


Susan Teague Rector schrieb:
> Hi all,
> 
> I just wanted to run this past the Dspace experts - I'm determining how 
> many files and the total size of files ingested into our Dspace 
> installation last year.
> Here's the query I'm running.
> 
> Since I don't look at the Dspace database on a daily basis, I needed a 
> sanity check from you folks - Is this is the best way to get at this data?
> 
> Thanks in advance,
> 
> Susan Teague Rector
> Web Applications Manager
> VCU Libraries
> 
> 
> select id.item_id, id.date_issued, ib.bundle_id,
> b.bitstream_id, b.name, b.size_bytes, b.source
> from itemsbydate id inner join
> item2bundle ib on id.item_id = ib.item_id
> inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id
> inner join bitstream b on bb.bitstream_id = b.bitstream_id
> where name <> 'license.txt'
> and (source not like '%Written by Media%') or source is null
> order by id.date_issued, ib.bundle_id;
> 
> --
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] query for determining number of files and size - sanity check

[Susan Teague Rector]

Hi all,

I just wanted to run this past the Dspace experts - I'm determining how 
many files and the total size of files ingested into our Dspace 
installation last year.
Here's the query I'm running.

Since I don't look at the Dspace database on a daily basis, I needed a 
sanity check from you folks - Is this is the best way to get at this data?

Thanks in advance,

Susan Teague Rector
Web Applications Manager
VCU Libraries


select id.item_id, id.date_issued, ib.bundle_id,
b.bitstream_id, b.name, b.size_bytes, b.source
from itemsbydate id inner join
item2bundle ib on id.item_id = ib.item_id
inner join bundle2bitstream bb on ib.bundle_id = bb.bundle_id
inner join bitstream b on bb.bitstream_id = b.bitstream_id
where name <> 'license.txt'
and (source not like '%Written by Media%') or source is null
order by id.date_issued, ib.bundle_id;

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query on workflows

[Claudia Jürgen]

Hi Irene,

you must set

webui.submit.upload.required = false

in your dspace.cfg. Per default it is set to true.

Claudia


Kennedy, Irene schrieb:
> Hi guys,
> 
> I am currently running Dspace version 1.5 and thought there was an option to 
> skip the upload document if only
> metadata and references were going to be deposited within the repository.
> 
> Can anyone enlighten me if this is the case as we have material that will not 
> be in our repository however we do
> want people to know about them.
> 
> yours hopeful
> 
> __
> Irene Kennedy 
> Senior Information Specialist 
> Central Server Support Group 
> University of Abertay Dundee 
> [EMAIL PROTECTED] 
> (01382) 308814 
> The University of Abertay Dundee is a charity registered in Scotland, No: 
> SC016040.
> 
> 
> 
> 
> 
> 
> 
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 
> 
> 
> 
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] query on workflows

[Kennedy, Irene]

Hi guys,

I am currently running Dspace version 1.5 and thought there was an option to 
skip the upload document if only
metadata and references were going to be deposited within the repository.

Can anyone enlighten me if this is the case as we have material that will not 
be in our repository however we do
want people to know about them.

yours hopeful

__
Irene Kennedy 
Senior Information Specialist 
Central Server Support Group 
University of Abertay Dundee 
[EMAIL PROTECTED] 
(01382) 308814 
The University of Abertay Dundee is a charity registered in Scotland, No: 
SC016040.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query to determine number of full-text items?

[Claudia Jürgen]

Hi Susan,

then you got to use something like:

select count(b.bundle_id) from bundle b, item2bundle i2b, item i where 
b.name='TEXT' and b.bundle_id=i2b.bundle_id and i2b.item_id=i.item_id 
and i.in_archive=true;

The bundle are:

ORIGINAL - original, deposited bitstreams
THUMBNAILS - thumbnails of any image bitstreams
TEXT - extracted full-text from bitstreams in ORIGINAL, for indexing
LICENSE - the deposit license
CC_LICENSE - the distribution license, if  Creative Commons is used

Claudia


Susan Parham schrieb:
> Basically, the number of items which are full-text searchable - it
> doesn't matter if the original content is pdf, doc, etc.  This is why
> I was going for the items with that .txt file which is created by
> media filter.  We may have some older pdfs which are not OCR'd, and
> would then not have the .txt file.  We don't have any items which
> consist solely of metadata.
> 
> Susan
> 
> On Tue, Aug 12, 2008 at 3:12 PM, Claudia Juergen
> <[EMAIL PROTECTED]> wrote:
>> Hi Susan,
>>
>> what do you mean with "full-text" items, items which got content at all
>> and are not mere "metadata" items or item which got content of a special
>> mime type (pdf, doc, etc.)?
>>
>> Claudia
>>
>>
>>
>>> Any thoughts on how we would query the database to determine the
>>> number of full-text items in our repository?  These would be items
>>> with the additional .txt file created after running media filter.
>>>
>>> Thanks,
>>> Susan
>>> --
>>> Susan Wells Parham
>>> Head, Digital Library Development
>>> Georgia Institute of Technology
>>> Library & Information Center
>>> 404-894-4522
>>> [EMAIL PROTECTED]
>>>
>>> -
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>> challenge
>>> Build the coolest Linux based applications with Moblin SDK & win great
>>> prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in the
>>> world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> ___
>>> DSpace-tech mailing list
>>> DSpace-tech@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>>
>>
>>

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query to determine number of full-text items?

[Susan Parham]

Basically, the number of items which are full-text searchable - it
doesn't matter if the original content is pdf, doc, etc.  This is why
I was going for the items with that .txt file which is created by
media filter.  We may have some older pdfs which are not OCR'd, and
would then not have the .txt file.  We don't have any items which
consist solely of metadata.

Susan

On Tue, Aug 12, 2008 at 3:12 PM, Claudia Juergen
<[EMAIL PROTECTED]> wrote:
> Hi Susan,
>
> what do you mean with "full-text" items, items which got content at all
> and are not mere "metadata" items or item which got content of a special
> mime type (pdf, doc, etc.)?
>
> Claudia
>
>
>
>> Any thoughts on how we would query the database to determine the
>> number of full-text items in our repository?  These would be items
>> with the additional .txt file created after running media filter.
>>
>> Thanks,
>> Susan
>> --
>> Susan Wells Parham
>> Head, Digital Library Development
>> Georgia Institute of Technology
>> Library & Information Center
>> 404-894-4522
>> [EMAIL PROTECTED]
>>
>> -
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the
>> world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> ___
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>
>
>
>

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query to determine number of full-text items?

[Claudia Juergen]

Hi Susan,

what do you mean with "full-text" items, items which got content at all
and are not mere "metadata" items or item which got content of a special
mime type (pdf, doc, etc.)?

Claudia



> Any thoughts on how we would query the database to determine the
> number of full-text items in our repository?  These would be items
> with the additional .txt file created after running media filter.
>
> Thanks,
> Susan
> --
> Susan Wells Parham
> Head, Digital Library Development
> Georgia Institute of Technology
> Library & Information Center
> 404-894-4522
> [EMAIL PROTECTED]
>
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query to determine number of full-text items?

[Susan Parham]

Ah, thanks Dorothea ... we were thinking format of .txt, but that
wouldn't work because our manually submitted items have a license.txt
bitstream.

Susan

On Tue, Aug 12, 2008 at 2:26 PM, Dorothea Salo <[EMAIL PROTECTED]> wrote:
> On Tue, Aug 12, 2008 at 1:20 PM, Susan Parham <[EMAIL PROTECTED]> wrote:
>> Any thoughts on how we would query the database to determine the
>> number of full-text items in our repository?  These would be items
>> with the additional .txt file created after running media filter.
>
> Maybe
>
> select count(*) from bundle where name='TEXT';
>
> Be aware that if you're running 1.4.x you may have been bitten by the
> PDF filtering bug where filter-media chokes and dies on some PDFs.
> There may be other reasons this query won't get you an exact count,
> but it should be a place to start.
>
> Dorothea
>
> --
> Dorothea Salo [EMAIL PROTECTED]
> Digital Repository Librarian AIM: mindsatuw
> University of Wisconsin
> Rm 218, Memorial Library
> (608) 262-5493
>
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>



-- 
Susan Wells Parham
Head, Digital Library Development
Georgia Institute of Technology
Library & Information Center
404-894-4522
[EMAIL PROTECTED]

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Query to determine number of full-text items?

[Dorothea Salo]

On Tue, Aug 12, 2008 at 1:20 PM, Susan Parham <[EMAIL PROTECTED]> wrote:
> Any thoughts on how we would query the database to determine the
> number of full-text items in our repository?  These would be items
> with the additional .txt file created after running media filter.

Maybe

select count(*) from bundle where name='TEXT';

Be aware that if you're running 1.4.x you may have been bitten by the
PDF filtering bug where filter-media chokes and dies on some PDFs.
There may be other reasons this query won't get you an exact count,
but it should be a place to start.

Dorothea

-- 
Dorothea Salo [EMAIL PROTECTED]
Digital Repository Librarian AIM: mindsatuw
University of Wisconsin
Rm 218, Memorial Library
(608) 262-5493

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Query to determine number of full-text items?

[Susan Parham]

Any thoughts on how we would query the database to determine the
number of full-text items in our repository?  These would be items
with the additional .txt file created after running media filter.

Thanks,
Susan
-- 
Susan Wells Parham
Head, Digital Library Development
Georgia Institute of Technology
Library & Information Center
404-894-4522
[EMAIL PROTECTED]

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query on dspace

[Blanco, Jose]

I don't know of any other way of doing this through the interface.  If
you have a lot of these sorts of imports to do, you might consider using
ItemImport.  You can read about it here:
 
http://www.dspace.org/index.php?option=com_content&task=view&id=144#item
importer
 
-Jose



From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of biju 
Sent: Saturday, December 08, 2007 1:38 AM
To: [EMAIL PROTECTED]
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] query on dspace



sir 


  i am a user of dspace, my requirement of using the dspace software
is to upload the digitised data for user access at various places, i am
in the process of uploading various mauals and technical journals.  i
need to upload the chapters of manuals as seperate items,  normally each
item consisits of 200 pages, now to upload this chapter of the manual i
need to select the document by brousing and then click next button ,
click add another file button all the time.this is time consuming and
boring either

  can u suggest any method or way to select all the file as seen in
the 'file upload window' 


regards
biju 


On Sat, 08 Dec 2007 [EMAIL PROTECTED] wrote :
>Welcome to the DSpace-tech@lists.sourceforge.net mailing list!
>Welcome!  To make helping you as easy as possible, please follow these
>guidelines when reporting problems or asking for help, please:
>
>  * Don't be offended if you message is not immediately answered.
>Support is a voluntary effort.  Feel free to re-post after about a
>week if you don't get any replies, but try to include more information
>in your post.
>
>  * Reply-all to the list.  That way the conversation is archived, and
>can be useful for other people.  It's also not fair on the person who
>was kind enough to reply; replying to a message is not an offer to
>become a single point of support.
>
>  * Use a descriptive subject line.  Just "help" or no subject at all
>means that the busy people on the list are like to skip over your
>message, rather than think "ah, that's something I can help with".
>
>  * Specify your DSpace version number.
>
>  * Check the contents of your dspace.log file for errors if you're
>reporting an internal server error or 'blank page syndrome'.  Just
>posting a message that says "I do X and get an internal server error"
>will not allow anyone to help you.  Check the log files, documented
>here:
>  http://dspace.org/technology/system-docs/directories.html#logfiles
>
>and include any exception stack traces and a few surrounding lines in
>your post, preferable as an attachment.
>
>
>To post to this list, send your email to:
>
>  dspace-tech@lists.sourceforge.net
>
>General information about the mailing list is at:
>
>  https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>If you ever want to unsubscribe or change your options (eg, switch to
>or from digest mode, change your password, etc.), visit your
>subscription page at:
>
>
https://lists.sourceforge.net/lists/options/dspace-tech/star_4446%40redi
ffmail.com
>
>
>You can also make such adjustments via email by sending a message to:
>
>  [EMAIL PROTECTED]
>
>with the word `help' in the subject or body (don't include the
>quotes), and you will get back a message with instructions.
>
>You must know your password to change your options (including changing
>the password, itself) or to unsubscribe.  It is:
>
>  stride
>
>Normally, Mailman will remind you of your lists.sourceforge.net
>mailing list passwords once every month, although you can disable this
>if you prefer.  This reminder will also include instructions on how to
>unsubscribe or change your account options.  There is also a button on
>your options page that will email your current password to you.




-
SF.Net email is sponsored by: 
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] query on dspace

[biju]

sir 


   i am a user of dspace, my requirement of using the dspace software is to 
upload the digitised data for user access at various places, i am in the 
process of uploading various mauals and technical journals.  i need to upload 
the chapters of manuals as seperate items,  normally each item consisits of 200 
pages, now to upload this chapter of the manual i need to select the document 
by brousing and then click next button , click add another file button all the 
time.this is time consuming and boring either

   can u suggest any method or way to select all the file as seen in the 
'file upload window' 


regards
biju 


On Sat, 08 Dec 2007 [EMAIL PROTECTED] wrote :
>Welcome to the DSpace-tech@lists.sourceforge.net mailing list!
>Welcome!  To make helping you as easy as possible, please follow these
>guidelines when reporting problems or asking for help, please:
>
>  * Don't be offended if you message is not immediately answered.
>Support is a voluntary effort.  Feel free to re-post after about a
>week if you don't get any replies, but try to include more information
>in your post.
>
>  * Reply-all to the list.  That way the conversation is archived, and
>can be useful for other people.  It's also not fair on the person who
>was kind enough to reply; replying to a message is not an offer to
>become a single point of support.
>
>  * Use a descriptive subject line.  Just "help" or no subject at all
>means that the busy people on the list are like to skip over your
>message, rather than think "ah, that's something I can help with".
>
>  * Specify your DSpace version number.
>
>  * Check the contents of your dspace.log file for errors if you're
>reporting an internal server error or 'blank page syndrome'.  Just
>posting a message that says "I do X and get an internal server error"
>will not allow anyone to help you.  Check the log files, documented
>here:
>  http://dspace.org/technology/system-docs/directories.html#logfiles
>
>and include any exception stack traces and a few surrounding lines in
>your post, preferable as an attachment.
>
>
>To post to this list, send your email to:
>
>   dspace-tech@lists.sourceforge.net
>
>General information about the mailing list is at:
>
>   https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>If you ever want to unsubscribe or change your options (eg, switch to
>or from digest mode, change your password, etc.), visit your
>subscription page at:
>
>   
> https://lists.sourceforge.net/lists/options/dspace-tech/star_4446%40rediffmail.com
>
>
>You can also make such adjustments via email by sending a message to:
>
>   [EMAIL PROTECTED]
>
>with the word `help' in the subject or body (don't include the
>quotes), and you will get back a message with instructions.
>
>You must know your password to change your options (including changing
>the password, itself) or to unsubscribe.  It is:
>
>   stride
>
>Normally, Mailman will remind you of your lists.sourceforge.net
>mailing list passwords once every month, although you can disable this
>if you prefer.  This reminder will also include instructions on how to
>unsubscribe or change your account options.  There is also a button on
>your options page that will email your current password to you.
-
SF.Net email is sponsored by: 
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Query regarding installation of Dspace

[Jaipal Singh Sisodia]

Dear Moderator,


Plzz. submit my query for installation of Dspace.

Hi, everyone I am a working professional and need some information or you
can say a step step process of installation with all requirement like H/W &
S/W

thanks and regards

--
Jaipal Singh Sisodia
Assistant Librarian
Institute of Technology and Science
G.T. Raod Mohan Nagar Ghaziabab-201007
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech