Re: [Dspace-tech] Map File SQL statement

2012-06-05 Thread helix84
I don't know what exactly you're doing but this sounds similiar (see Calendar View): http://staff.lib.muohio.edu/~tzocea/files/dspace/ Can you send a mockup of what you want to do and describe how? I'm just curious how you want to call that SQL because there may be an easier way. Depending on you

Re: [Dspace-tech] Map File SQL statement

2012-06-05 Thread Mark Ehle
And - this query duplicates what's in the map files: SELECT text_value, handle FROM metadatavalue INNER JOIN handle ON (metadatavalue.item_id = handle.resource_id) where metadata_field_id = '24' Thanks! Mark On Tue, Jun 5, 2012 at 2:28 PM, helix84 wrote: > On Tue, Jun 5, 2012 at 7:50 PM, Mar

Re: [Dspace-tech] Map File SQL statement

2012-06-05 Thread helix84
On Tue, Jun 5, 2012 at 7:50 PM, Mark Ehle wrote: > Thanks, helix84 - this will give me something to chew on. When I run, > > select * from metadatavalue where metadata_field_id = '24' and text_value > LIKE '1967%' > > I can see all the pdf files from 1967. Given the item_id from that query, > how

Re: [Dspace-tech] Map File SQL statement

2012-06-05 Thread Mark Ehle
Thanks, helix84 - this will give me something to chew on. When I run, select * from metadatavalue where metadata_field_id = '24' and text_value LIKE '1967%' I can see all the pdf files from 1967. Given the item_id from that query, how do I find the handle? Thanks again - Mark On Tue, Jun 5, 20

Re: [Dspace-tech] Map File SQL statement

2012-06-05 Thread helix84
On Tue, Jun 5, 2012 at 6:13 PM, Mark Ehle wrote: > capable with mysql. Can someone tell me what the query would be to extract > from dspace all the item names, their handles. and the bitstream associated > with each one? Hi Mark, here's the DSpace database schema: https://wiki.duraspace.org/disp

[Dspace-tech] Map File SQL statement

2012-06-05 Thread Mark Ehle
Folks - We are using dspace to index our digitized newspaper collection. I would like to create a tree interface for the newspapers, sorted by newspaper, year, month, day, etc. I was planning on using the map files that were generated when I loaded all the papers into dspace, but then I thought t

Re: [Dspace-tech] Map file

2010-09-15 Thread Webshet, Sisay (ILRI)
a Import program generates only 3 files (dublin_core.xml, contents, and ...pdf) -- Message: 1 Date: Tue, 14 Sep 2010 13:59:59 +0200 From: Claudia J?rgen Subject: Re: [Dspace-tech] Map file To: dspace-tech Message-ID: <4c8

Re: [Dspace-tech] Map file

2010-09-15 Thread Claudia Jürgen
Hello Sisay, all the metadata fields used during import must be registered within the DSpace instance metadata registry, check whether you got dc.description.degree registered, the error below indicates that this is missing Am 15.09.2010 10:57, schrieb Webshet, Sisay (ILRI): ... at >

[Dspace-tech] Map file

2010-09-15 Thread Webshet, Sisay (ILRI)
files (dublin_core.xml, contents, and ...pdf) -- Message: 1 Date: Tue, 14 Sep 2010 13:59:59 +0200 From: Claudia J?rgen Subject: Re: [Dspace-tech] Map file To: dspace-tech Message-ID: <4c8f63bf.9080...@ub.tu-dortmund.de>

Re: [Dspace-tech] Map file

2010-09-14 Thread Claudia Jürgen
Hello Sisay, you got a type, it should be org.dspace.app.itemimport.ItemImport Hope that helps Claudia Jürgen Am 14.09.2010 13:48, schrieb Webshet, Sisay (ILRI): > Hi Claudia J?rgen, > > > > Thanks but still some the following error. > > Should map file have an extension? > > C:\dspace\bin>ds

[Dspace-tech] map file contention?

2009-08-17 Thread Van Ly
Hi, I have two components sharing a filesystem where package directories are put for batch import. The first component from whence packages originate has only the following relevant directories import/ failed/ success/ success/Log/ and the files handle.map ; import.map When the s

Re: [Dspace-tech] map file import process

2008-11-07 Thread Claudia Juergen
Hola Miguel, in the map file the handles of newly created items are stored. It might hence be used to undo an import. You might run the itemimporter with -h to get a list of the options. The optios are -a, add items to DSpace -r, replace items in mapfile -d, delete items in mapfile -s, source of

[Dspace-tech] map file import process

2008-11-07 Thread Miguel Pizarro
Hi: someone knows referred to the map file in the process of import? I know the parameters, but I don’t now´the function of every parameter. Best regards, Miguel Pizarro Soporte Tecnológico Alerta al Conocimiento Fono: 56 (2) 233 79 08 --