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 :(

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<mailto: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.

Reply via email to