> The point is you can find all the metadata in the metadatavalue table Ah, OK - that all makes sense now! I shall go away and have a read . . .
I thought I was going mad, so many thanks for restoring my sanity! ;-) Cheers, Mike Michael White Senior Developer Business Applications and Integrations T: (01786) 466877 E: michael.wh...@stir.ac.uk A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA -----Original Message----- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: 12 February 2018 12:06 To: Michael White <michael.wh...@stir.ac.uk> Cc: dspace-tech@googlegroups.com Subject: Re: [dspace-tech] Collection details in DSpace v6/Postgres DB? You can read the background about the change and a practical example here: https://wiki.duraspace.org/display/DSPACE/Metadata+for+all+DSpace+objects The point is you can find all the metadata in the metadatavalue table, an EAV table, which is why you couldn't find the metadata field names as column names anywhere. You may also find the ds6_metadata_id2field() and ds6_collectionhandle2collection() functions (or just their code) helpful: https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace+6 Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Feb 12, 2018 at 12:55 PM, Michael White <michael.wh...@stir.ac.uk> wrote: > Hi, > > > > I want to extract details of the Collections in my DSpace 6 DEV system > so was just looking in the database (postgres) but can’t seem to find > what I’m looking for, so I’m hoping someone might be able to shed some light > . . . ? > > > > In DSpace v4 I was able to pull the information I wanted from the > table “collections” (i.e. id, “name”, “short description”, > “introductory text”, > etc) . . . > > > > However, in DSpace v6, the “collection” table has fewer columns, and > is missing all the “textual detail” relating to each Collection (so no > “name”, “short_description” etc) . . . > > > > I’ve perused the Database schema diagram > (https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer) but I can’t > see anywhere where this information appears to be held!? > > > > I’ve also tried searching the database “information_schema” for > appropriately named columns – e.g.: > > > > select table_name from information_schema.columns where column_name > like > > '%introductory_text%'; > > > > - but still no joy L > > > > Can someone put me out of my misery and point me to where I can find > the details relating to each Collection in the DB? > > > > My ultimate goal here is to extract a mapping from Collection names to > uuids for use by an integration with our CRIS system (just in case it > helps to know where I’m heading with this!) . . . > > > > Cheers, > > > > Mike > > > > Michael White > > Senior Developer > > Business Applications and Integrations > > > > T: (01786) 466877 > > E: michael.wh...@stir.ac.uk > > A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA > > > > ________________________________ > The University achieved an overall 5 stars in the QS World University > Rankings 2016/17 The University of Stirling is a charity registered in > Scotland, number SC 011159. > > -- > You received this message because you are subscribed to the Google > Groups "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- The University achieved an overall 5 stars in the QS World University Rankings 2016/17 The University of Stirling is a charity registered in Scotland, number SC 011159. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
