<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">I believe this has been fixed — I can’t find the issue but this is the top entry in<div class=""><span style="background-color: rgb(203, 255, 254);" class="">git log</span><span style="background-color: rgb(203, 255, 254);" class=""> </span><span style="background-color: rgb(203, 255, 254);" class="">frontend/app/controllers/subjects_controller.rb </span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; color: rgb(152, 154, 23); background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">commit f9035b7ef72c65ab854070022d55cbfa023e6429</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Author: Lora Woodford <<a href="mailto:lorawoodford@gmail.com" class="">lorawoodford@gmail.com</a>></span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Date: Thu Jun 11 17:33:21 2020 -0400</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> Make subjects subject and fix csv and sort</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div><br class=""></div><div><br class=""></div><div>So if that’s the required fix, it should be in the last 2.8.0 release. </div><div>( CSV export seems to work properly for me running current master devserver )</div><div><br class=""></div><div>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.</div><div><br class=""></div><div>Using ASnake (<a href="https://github.com/archivesspace-labs/ArchivesSnake" class="">https://github.com/archivesspace-labs/ArchivesSnake</a>), something like:</div><div><br class=""></div><div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">client = ASnakeClient( baseurl="<a href="http://localhost:8089" class="">http://localhost:8089</a>", username=‘admin’, password=… )</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">client.authorize()</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">for</span> s in test.get_paged( 'subjects' ):</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>print( s[’title’] ) # and any other fields you want to output…. </div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">Or you can access the backend API at /subjects, but you will have to iterate the paged results manually </div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">curl <a href="http://archives-test.$lib:8089/subjects?page=1" class="">http://archives-test.$LIB:8089/subjects?page=1</a> | jq . </div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">{<br class=""> "first_page": 1,<br class=""> "last_page": 45,<br class=""> "this_page": 1,<br class=""> "total": 898,<br class=""> "results": [<br class=""> {<br class=""> "lock_version": 22,<br class=""> "title": "Drawings (visual works)",<br class=""> "authority_id": "300033973",<br class=""> "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.",<br class=""> "created_by": "img7u",<br class=""> "last_modified_by": "ew8ff",<br class=""> "create_time": "2015-10-19T18:22:55Z",<br class=""> "system_mtime": "2019-11-18T20:57:54Z",<br class=""> "user_mtime": "2017-07-13T15:01:53Z",<br class=""> "is_slug_auto": false,<br class=""> "source": "aat",<br class=""> "jsonmodel_type": "subject",<br class=""> "external_ids": [],<br class=""> "publish": true,<br class=""> "used_within_repositories": [],<br class=""> "used_within_published_repositories": [],<br class=""> "terms": [<br class=""> {<br class=""> "lock_version": 0,<br class=""> "term": "drawings (visual works)",<br class=""> "created_by": "img7u",<br class=""> "last_modified_by": "img7u",<br class=""> "create_time": "2015-10-19T18:22:55Z",<br class=""> "system_mtime": "2015-10-19T18:22:55Z",<br class=""> "user_mtime": "2015-10-19T18:22:55Z",<br class=""> "term_type": "genre_form",<br class=""> "jsonmodel_type": "term",<br class=""> "uri": "/terms/6",<br class=""> "vocabulary": "/vocabularies/1"<br class=""> }<br class=""> ],<br class=""> "external_documents": [],<br class=""> "uri": "/subjects/6",<br class=""> "vocabulary": "/vocabularies/1",<br class=""> "is_linked_to_published_record": true<br class=""> },<br class=""><br class=""></div></div><div>[ . . . ]</div><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 25, 2020, at 5:11 PM, Steven Giessler <<a href="mailto:Steve.Giessler@mail.wvu.edu" class="">Steve.Giessler@mail.wvu.edu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Dear ArchivesSpace user list,<br class=""><br class="">Here at West Virginia University, we are running version 2.7.0 of<br class="">ArchivesSpace.<br class=""><br class="">On the admin side if we go to Subjects:<br class=""><br class=""><a href="https://archivesspace.lib.wvu.edu/subjects" class="">https://archivesspace.lib.wvu.edu/subjects</a><br class=""><br class="">and try to click the Download CSV button, it gives us a file (excerpt below)<br class="">that is not comma separated (has \n between each field) and only lists<br class="">the first page worth of Subjects (25 in our case):<br class=""><br class="">tail 1597180067.csv<br class="">"title\n4-H clubs -- West Virginia\nAbb's Valley (Va. and W.<br class="">Va.)\nAbolition of slavery\nAbortions\nAbsentee Balloting -- Marion<br class="">County.\nAcademic costume\nAcademic librarians -- Faculty<br class="">status\nAcademies\nAcademies and Institutes.\nAcademies (Private<br class="">schools)\n\"Accomack County, V.A.\"\nAccount books\nAccounting\nAccounts<br class="">-- Church financial reocrds\nAcord family.\nAdams County<br class="">(Ohio)\nAdmiralty Islands (Papua New Guinea)\nAdvertising\nAdvertising<br class="">photography\nAerial photographs.\nAeronautics\n\"Afghanistan -- History<br class="">-- Saur Revolution, 1978\"\nAfrica\nAfrican American churches -- West<br class="">Virginia\nAfrican American soldiers\n"<br class=""><br class="">On the other hand, when we hit the Download CSV button while listing agents:<br class=""><br class="">https://archivesspace.lib.wvu.edu/agents<br class=""><br class="">we get what we would expect for all 10,000+ records (excerpt):<br class=""><br class="">tail 1597187282.csv<br class="">agent_corporate_entity,Institute for the History of Technology and<br class="">Industrial Archaeology,,ingest,<br class="">agent_corporate_entity,West Virginia University. Institute for the<br class="">History of Technology and Industrial<br class="">Archaeology,http://id.loc.gov/authorities/names/nr91038362,Library of<br class="">Congress Name Authority File,<br class="">agent_corporate_entity,Society for Industrial<br class="">Archeology,http://id.loc.gov/authorities/names/n78014220,Library of<br class="">Congress Name Authority File,<br class="">agent_person,"Barnette, Curtis H. and Others",,ingest,<br class="">agent_person,"Barnette, Curtis H.",,ingest,<br class="">agent_person,"Green, James Edwin",,ingest,<br class="">agent_family,Green<br class="">family,http://id.loc.gov/authorities/subjects/sh85057211,Library of<br class="">Congress Name Authority File,<br class="">agent_corporate_entity,Grand Army of the<br class="">Republic,http://id.loc.gov/authorities/names/n84076025,Library of<br class="">Congress Name Authority File,<br class="">agent_family,Deeds family,,ingest,<br class="">agent_person,"Pryzbylinski, Leon A.",,ingest,<br class=""><br class="">Any idea why we can't get a proper CSV file for Subjects?<br class=""><br class="">Logs show no errors.<br class=""><br class="">Thank you for any help you may be able to provide, or suggestions on how<br class="">to fix this,<br class=""><br class="">Steve Giessler<br class="">Professional Technologist<br class="">West Virginia University<br class=""><br class=""><br class=""><br class="">_______________________________________________<br class="">Archivesspace_Users_Group mailing list<br class="">Archivesspace_Users_Group@lyralists.lyrasis.org<br class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class=""></div></div></blockquote></div><br class=""></div></body></html>