cca / equella_scripts

Collection of miscellaneous scripts for working with openEQUELLA
https://vault.cca.edu/
Other
0 stars 0 forks source link

export collection to CSV #15

Closed phette23 closed 2 years ago

phette23 commented 2 years ago

Write a script to export a collection's metadata to a CSV. Our initial use case is the Hamaguchi Collection but we will probably end up doing this again. The script can use the Search API route limited to live items in a given collection. We will need to identify particular metadata nodes (e.g. date, author, title, dimensions) to export and use XML parsing to extract them.

Finally, as an added bonus, it might be nice to have an option to also download the files associated with each item and write their location into the CSV output. I'm thinking you could write files to subfolders like "attachments/$UUID/$VERSION/filename" e.g. "attachments/5b388638-3a2a-ddd5-9161-7c1d78126840/2/p_atlan18.jpg".