[Archivesspace_Users_Group] CSV file for subjects not generating

Tue Aug 25 21:53:53 EDT 2020

I believe this has been fixed — I can’t find the issue but this is the top entry in
git log  frontend/app/controllers/subjects_controller.rb 

commit f9035b7ef72c65ab854070022d55cbfa023e6429
Author: Lora Woodford <lorawoodford at gmail.com>
Date:   Thu Jun 11 17:33:21 2020 -0400

    Make subjects subject and fix csv and sort

So if that’s the required fix, it should be in the last 2.8.0 release. 
( CSV export seems to work properly for me running current master devserver )

If upgrading right away to get the results is not convenient, you can try pulling the info from the backend on your current installed version.

Using ASnake (https://github.com/archivesspace-labs/ArchivesSnake <https://github.com/archivesspace-labs/ArchivesSnake>), something like:

client = ASnakeClient( baseurl="http://localhost:8089", username=‘admin’, password=… )
client.authorize()
for  s in test.get_paged( 'subjects' ):
	print( s[’title’] ) # and any other fields you want to output…. 

Or you can access the backend API at /subjects, but you will have to iterate the paged results manually 

curl http://archives-test.$LIB:8089/subjects?page=1 | jq .  

{
  "first_page": 1,
  "last_page": 45,
  "this_page": 1,
  "total": 898,
  "results": [
    {
      "lock_version": 22,
      "title": "Drawings (visual works)",
      "authority_id": "300033973",
      "scope_note": "Visual works produced by drawing, which is the application of lines on a surface, often paper, by using a pencil, pen, chalk, or some other tracing instrument to focus on the delineation of form rather than the application of color. This term is often defined broadly to refer to computer-generated images as well.",
      "created_by": "img7u",
      "last_modified_by": "ew8ff",
      "create_time": "2015-10-19T18:22:55Z",
      "system_mtime": "2019-11-18T20:57:54Z",
      "user_mtime": "2017-07-13T15:01:53Z",
      "is_slug_auto": false,
      "source": "aat",
      "jsonmodel_type": "subject",
      "external_ids": [],
      "publish": true,
      "used_within_repositories": [],
      "used_within_published_repositories": [],
      "terms": [
        {
          "lock_version": 0,
          "term": "drawings (visual works)",
          "created_by": "img7u",
          "last_modified_by": "img7u",
          "create_time": "2015-10-19T18:22:55Z",
          "system_mtime": "2015-10-19T18:22:55Z",
          "user_mtime": "2015-10-19T18:22:55Z",
          "term_type": "genre_form",
          "jsonmodel_type": "term",
          "uri": "/terms/6",
          "vocabulary": "/vocabularies/1"
        }
      ],
      "external_documents": [],
      "uri": "/subjects/6",
      "vocabulary": "/vocabularies/1",
      "is_linked_to_published_record": true
    },

[ . . . ]

> On Aug 25, 2020, at 5:11 PM, Steven Giessler <Steve.Giessler at mail.wvu.edu> wrote:
> 
> Dear ArchivesSpace user list,
> 
> Here at West Virginia University, we are running version 2.7.0 of
> ArchivesSpace.
> 
> On the admin side if we go to Subjects:
> 
> https://archivesspace.lib.wvu.edu/subjects
> 
> and try to click the Download CSV button, it gives us a file (excerpt below)
> that is not comma separated (has \n between each field) and only lists
> the first page worth of Subjects (25 in our case):
> 
> tail 1597180067.csv
> "title\n4-H clubs -- West Virginia\nAbb's Valley (Va. and W.
> Va.)\nAbolition of slavery\nAbortions\nAbsentee Balloting -- Marion
> County.\nAcademic costume\nAcademic librarians -- Faculty
> status\nAcademies\nAcademies and Institutes.\nAcademies (Private
> schools)\n\"Accomack County, V.A.\"\nAccount books\nAccounting\nAccounts
> -- Church financial reocrds\nAcord family.\nAdams County
> (Ohio)\nAdmiralty Islands (Papua New Guinea)\nAdvertising\nAdvertising
> photography\nAerial photographs.\nAeronautics\n\"Afghanistan -- History
> -- Saur Revolution, 1978\"\nAfrica\nAfrican American churches -- West
> Virginia\nAfrican American soldiers\n"
> 
> On the other hand, when we hit the Download CSV button while listing agents:
> 
> https://archivesspace.lib.wvu.edu/agents
> 
> we get what we would expect for all 10,000+ records (excerpt):
> 
> tail 1597187282.csv
> agent_corporate_entity,Institute for the History of Technology and
> Industrial Archaeology,,ingest,
> agent_corporate_entity,West Virginia University. Institute for the
> History of Technology and Industrial
> Archaeology,http://id.loc.gov/authorities/names/nr91038362,Library of
> Congress Name Authority File,
> agent_corporate_entity,Society for Industrial
> Archeology,http://id.loc.gov/authorities/names/n78014220,Library of
> Congress Name Authority File,
> agent_person,"Barnette, Curtis H. and Others",,ingest,
> agent_person,"Barnette, Curtis H.",,ingest,
> agent_person,"Green, James Edwin",,ingest,
> agent_family,Green
> family,http://id.loc.gov/authorities/subjects/sh85057211,Library of
> Congress Name Authority File,
> agent_corporate_entity,Grand Army of the
> Republic,http://id.loc.gov/authorities/names/n84076025,Library of
> Congress Name Authority File,
> agent_family,Deeds family,,ingest,
> agent_person,"Pryzbylinski, Leon A.",,ingest,
> 
> Any idea why we can't get a proper CSV file for Subjects?
> 
> Logs show no errors.
> 
> Thank you for any help you may be able to provide, or suggestions on how
> to fix this,
> 
> Steve Giessler
> Professional Technologist
> West Virginia University
> 
> 
> 
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200826/6c4498fa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3342 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200826/6c4498fa/attachment.bin>