Hi

On Collectionspace 5.0, using fcart only, how does one go about exporting all the data as a csv or excel?  This doesn't appear to be an option until later versions.

Is there a script or even a postgresql query I can do?

Thank you,
David

[cid:12e355b1-9159-4203-9cb9-a2e7f75a19a4]
David Hietpas
Library Software Engineer
UW Oshkosh Libraries
University of Wisconsin Oshkosh, Oshkosh Campus
Polk 109
920-424-7367
hietpasd@uwosh.edu
he, him, his

Hi David,
I recommend using the REST API to get your data as XML or JSON, then processing it to get what you need. The REST API is documented here: https://collectionspace.atlassian.net/wiki/spaces/CSPACE50/pages/665882907/Common+Services+REST+API+documentation

As an example, to retrieve a page of Object records:

curl -i -u {username}:{password} https://{hostname}/cspace-services/collectionobjects

To retrieve a full Object record using a csid from the above listing:

curl -i -u {username}:{password} https://{hostname}/cspace-services/collectionobjects/{csid}

Let us know if you have any questions.

Thanks,
Ray

From: David Hietpas hietpasd@uwosh.edu
Sent: Friday, October 20, 2023 9:00 AM
To: talk@lists.collectionspace.org
Subject: [Talk] Exporting data

Hi

On Collectionspace 5.0, using fcart only, how does one go about exporting all the data as a csv or excel?  This doesn't appear to be an option until later versions.

Is there a script or even a postgresql query I can do?

Thank you,
David

[cid:12e355b1-9159-4203-9cb9-a2e7f75a19a4]
David Hietpas
Library Software Engineer
UW Oshkosh Libraries
University of Wisconsin Oshkosh, Oshkosh Campus
Polk 109
920-424-7367
hietpasd@uwosh.edu
he, him, his