Dear All,
We are planning to Install Current release of DSpace windows version soon.
We want to know, is there any options to create Blog/Comment pages in
DSpace?... Please guide us.
regards
Thimmappa
Librarian, PRDC Bangalore
On Wed, Jun 6, 2012 at 1:19 AM,
<[email protected]>wrote:
> Send DSpace-tech mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> or, via email, send a message with subject or body 'help' to
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of DSpace-tech digest..."
>
>
> Today's Topics:
>
> 1. Customizing creation of communities and collections in DS 1.8
> (C?sar Sabater)
> 2. Map File SQL statement (Mark Ehle)
> 3. Re: Map File SQL statement (helix84)
> 4. Re: Map File SQL statement (Mark Ehle)
> 5. Re: Map File SQL statement (helix84)
> 6. Re: Map File SQL statement (Mark Ehle)
> 7. Re: Map File SQL statement (helix84)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 5 Jun 2012 12:23:18 -0300
> From: C?sar Sabater <[email protected]>
> Subject: [Dspace-tech] Customizing creation of communities and
> collections in DS 1.8
> To: [email protected],
> [email protected]
> Message-ID:
> <CAPMu+v=13EXxk6yvoOVnB+p38HtaeiiWaHKmddupegwmb=z...@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello,
>
> I'm trying to customize the creation of Communities and Collections in
> DSpace 1.8 in a way that I'm not sure will preserve compatibility for
> future versions of DSpace.
>
> 1- The main customization in the Community Creation is to add default
> Collections to a community. That is, if a community is created, it will
> come with certain pre-defined collections.
>
> 2- Also, I would like to customize the creation of a collection by
> dynamically assigning a specific customized submission in the moment of its
> creation.
>
> For #2, I've read about the Service Manager and how can modify the sources
> of config values, and seems that would be a nice way to modify the process
> of assigning a specific submission to a collection. But the Service Manager
> seems to be a very recent update and I'm not sure if it is applicable in
> DSpace 1.8 or not. Maybe there is a simple way to do that without using it.
>
> #1 seems more difficult to me because involves the creation of collections
> in the same moment of the community creation (and #2 could be applied in #1
> as well for the default collections).
>
> I will try to emphasize the major compatibility with the future versions of
> dspace in this customizations, but they seem to me they are somehow
> "radical". Is it possible to customize dspace that way without loosing
> compatibility?
>
> Thougts?
>
> Cheers,
> C?sar
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Tue, 5 Jun 2012 12:13:26 -0400
> From: Mark Ehle <[email protected]>
> Subject: [Dspace-tech] Map File SQL statement
> To: [email protected]
> Message-ID:
> <cap3oluc8c2yawmdy47iovyzog7vjsq0jxgwhv6ahbtnvcap...@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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 that it would make way more
> sense to query dspace instead. I am not at all familiar with postgres but
> am 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?
>
> Thanks -
>
> Mark
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Tue, 5 Jun 2012 18:33:15 +0200
> From: helix84 <[email protected]>
> Subject: Re: [Dspace-tech] Map File SQL statement
> To: Mark Ehle <[email protected]>
> Cc: [email protected]
> Message-ID:
> <CAGdvKqgkLp4Awq+_D-dSmgp4pr9Fx7X_3=H6F=dqwdft-gk...@mail.gmail.com
> >
> Content-Type: text/plain; charset=UTF-8
>
> On Tue, Jun 5, 2012 at 6:13 PM, Mark Ehle <[email protected]> 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/display/DSPACE/DSpace+2.0+Requirements+and+Issues#DSpace2.0RequirementsandIssues-DatabaseOverviewGraphic
>
> item name is stored in the "metadatavalue" table (by default " WHERE
> metadata_field_id=64", you can look up the value in
> "metadatafieldregistry"), handle in "handle" (resource_id is item ID)
> and bistream in "bitstream" connected to items via bundle2bitstream
> and item2bundle. The queries can get a bit hairy, since metadatavalue
> is an EAV table, but it is doable. Let me know if you have any
> problems.
>
> Regards,
> ~~helix84
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 5 Jun 2012 13:50:21 -0400
> From: Mark Ehle <[email protected]>
> Subject: Re: [Dspace-tech] Map File SQL statement
> To: [email protected]
> Cc: [email protected]
> Message-ID:
> <CAP3oLuBSVwCjAZqaBaH+1xpH=mkjpqc3mvwpizrj-wfx_hz...@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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, 2012 at 12:33 PM, helix84 <[email protected]> wrote:
>
> > On Tue, Jun 5, 2012 at 6:13 PM, Mark Ehle <[email protected]> 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/display/DSPACE/DSpace+2.0+Requirements+and+Issues#DSpace2.0RequirementsandIssues-DatabaseOverviewGraphic
> >
> > item name is stored in the "metadatavalue" table (by default " WHERE
> > metadata_field_id=64", you can look up the value in
> > "metadatafieldregistry"), handle in "handle" (resource_id is item ID)
> > and bistream in "bitstream" connected to items via bundle2bitstream
> > and item2bundle. The queries can get a bit hairy, since metadatavalue
> > is an EAV table, but it is doable. Let me know if you have any
> > problems.
> >
> > Regards,
> > ~~helix84
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 5
> Date: Tue, 5 Jun 2012 20:28:56 +0200
> From: helix84 <[email protected]>
> Subject: Re: [Dspace-tech] Map File SQL statement
> To: Mark Ehle <[email protected]>
> Cc: [email protected]
> Message-ID:
> <cagdvkqgv_7sewbabyrvx3ip1st-xxm3wtmqr1-rsqyzpmx-...@mail.gmail.com
> >
> Content-Type: text/plain; charset=UTF-8
>
> On Tue, Jun 5, 2012 at 7:50 PM, Mark Ehle <[email protected]> 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 do I find the handle?
>
> Easy - for item_id=123:
>
> SELECT handle FROM handle WHERE resource_id = 123;
>
> Regards,
> ~~helix84
>
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 5 Jun 2012 14:46:22 -0400
> From: Mark Ehle <[email protected]>
> Subject: Re: [Dspace-tech] Map File SQL statement
> To: [email protected]
> Cc: [email protected]
> Message-ID:
> <CAP3oLuDoSW5DO6btChqXeG60Rghb5T=cf4ebwij5xdu5sz8...@mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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 <[email protected]> wrote:
>
> > On Tue, Jun 5, 2012 at 7:50 PM, Mark Ehle <[email protected]> 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 do I find the handle?
> >
> > Easy - for item_id=123:
> >
> > SELECT handle FROM handle WHERE resource_id = 123;
> >
> > Regards,
> > ~~helix84
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 7
> Date: Tue, 5 Jun 2012 21:49:23 +0200
> From: helix84 <[email protected]>
> Subject: Re: [Dspace-tech] Map File SQL statement
> To: Mark Ehle <[email protected]>
> Cc: [email protected]
> Message-ID:
> <cagdvkqhm2biqdhmjkrs632ysv+cr2jfjpmkuh4hcg0sttp1...@mail.gmail.com
> >
> Content-Type: text/plain; charset=UTF-8
>
> 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 your familiarity with Java and/or XSL, it
> might be easier to achieve via an aspect and a theme.
>
> Regards,
> ~~helix84
>
>
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>
> ------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
> End of DSpace-tech Digest, Vol 74, Issue 11
> *******************************************
>
--
ಪ್ರೀತಿ ಒಂದು ಉಡುಗೊರೆ. ಅದು ಎಲ್ಲಿ೦ದಲೂ, ಯಾರಿ೦ದಲೂ ಬೆಲೆ ಕೊಟ್ಟು ಖರೀದಿಸಲಾಗದು.
Thimmappa N
[email protected]/[email protected]
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
