<div dir="ltr">Hi Lisa,<div><br></div><div>I'm not sure if you have a connection to query your MySQL database (presuming that's what you're using behind ASpace), but this is the kind of thing I tend to pull out of ASpace using SQL queries. If you are able to run queries like that, let me know and I'd be happy to share a version of a query that would get you the desired output.</div><div><br></div><div>Michelle</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Apr 29, 2019 at 10:11 PM Lisa Crane <<a href="mailto:Lisa.Crane@claremont.edu" target="_blank">Lisa.Crane@claremont.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_-1605573938888094304gmail-m_6128785274264165329WordSection1">
<p class="MsoNormal"><span style="color:black">Hello all!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:black">Has anyone been successful in exporting a container list in CSV or Excel from a Resource in ASpace? I am looking for a list of box numbers (one column); file folder numbers (another column); file folder titles
(another column); and date expressions (another column).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:black">Does anyone know how to do this? Can it even be done?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:black">All the best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:black">Lisa<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="color:black">Lisa L. Crane | Western Americana Manuscripts Librarian | The Claremont Colleges Library<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="color:black">800 North Dartmouth Ave. | Claremont, CA 91711-5053
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black">Phone (909) 607-0862 | </span><u><span style="color:blue"><a href="mailto:lisa.crane@claremont.edu" target="_blank"><span style="color:blue">lisa.crane@claremont.edu</span></a></span></u><span style="color:black">
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:black">Pronouns: she/her/hers<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail-m_-1605573938888094304gmail_signature"><div dir="ltr"><div><div dir="ltr"><font face="tahoma, sans-serif">Michelle Paquette</font><div><font face="tahoma, sans-serif">Metadata & Technical Services Archivist</font></div><div><font face="tahoma, sans-serif">Special Collections</font></div><div><font face="tahoma, sans-serif">Smith College</font></div><div><font face="tahoma, sans-serif">413-585-7029</font></div><div><font face="tahoma, sans-serif"><a href="mailto:mpaquette@smith.edu" target="_blank">mpaquette@smith.edu</a></font></div></div></div></div></div>