Re: [Archivesspace_Users_Group] Adding barcoded items within barcoded containers to the import spreadsheet

2022-09-29 Thread Karen Miller
I’ve written an API script to do this. If you’re familiar with using the API and would like it please contact me directly. I’ll be happy to send it out. Karen Miller Northwestern University k-mill...@northwestern.edu Sent from my iPhone On Sep 29, 2022, at 6:59 PM, Lori Dedeyan wrote:  Hi

Re: [Archivesspace_Users_Group] Log of ASpace User actions

2022-07-12 Thread Karen Miller
Hi Anna, If you can query the backend database, this information is stored in the MySQL table archivesspace.deleted_records. If you sort the data by the URI element, all of the Agent records will appear at the top. Our table shows records back to August 30, 2021. I'm not sure if the amount of

Re: [Archivesspace_Users_Group] ODBC advice

2022-02-17 Thread Karen Miller
Hi Celia, I had to redo my ODBC setting recently, so it’s relatively fresh in my mind. Here’s what I think is the relevant issue from our documentation at NUL: Set up an ODBC connection with the following: * Data Source Name: ArchivesSpace Production * Description: can be left blank

Re: [Archivesspace_Users_Group] Adding an element with the API

2020-12-18 Thread Karen Miller
do this. If not, you could try things out on one of the other TEST instances out there  Mark From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> mailto:archivesspace_u

Re: [Archivesspace_Users_Group] Adding an element with the API

2020-12-18 Thread Karen Miller
hopefully this helps. Good luck! Michelle On Fri, Dec 18, 2020 at 1:20 PM Karen Miller mailto:k-mill...@northwestern.edu>> wrote: Thank you, Michelle! Yes, if you don’t mind sending the script, I’d really appreciate it. This looks like what I need, but I think having the script might be

Re: [Archivesspace_Users_Group] Adding an element with the API

2020-12-18 Thread Karen Miller
mbnail_uri is coming from a spreadsheet. If seeing the full script is helpful for you please let me know and I'd be happy to share it with you. Best, Michelle On Fri, Dec 18, 2020 at 12:48 PM Karen Miller mailto:k-mill...@northwestern.edu>> wrote: I hope there are still some folks around to th

[Archivesspace_Users_Group] Adding an element with the API

2020-12-18 Thread Karen Miller
I hope there are still some folks around to think about an API problem I'm having! We're updating URLs in our digital objects. I can easily update the URL that exists in digital objects, using Python syntax like this: digital_object_json['file_versions'][0]['file_uri'] = permalink post_record

Re: [Archivesspace_Users_Group] Developing custom reports

2020-11-09 Thread Karen Miller
Hello Adrien, I've got several reports that bring together multiple tables and aggregate repeatable fields (such as Extent) using SQL. My SQL is not very pretty, but it might be helpful for you. Below is the SQL I use to generate a list of Accession records with aggregated Extents and Agents

Re: [Archivesspace_Users_Group] Custom reports with string params?

2020-10-02 Thread Karen Miller
Hi Nick, I have an SQL query that I've embedded into an Excel spreadsheet (as a .odc file) which prompts the user for a value. The value I'm prompting for is numeric, but the code could be adjusted to take a string. I don't think this is what you want, but if it is, please let me know and I'll

Re: [Archivesspace_Users_Group] Agent/Subject record merging in multi-repository setting

2020-09-28 Thread Karen Miller
...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> [mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org] On Behalf Of Karen Miller Sent: Monday, 28 September, 2020 10:52 AM To: Archivesspace Users Group mailto:archivesspace_users

Re: [Archivesspace_Users_Group] Agent/Subject record merging in multi-repository setting

2020-09-28 Thread Karen Miller
Hello Betts et al, At Northwestern University we have also merged quite a few duplicate Subjects and Agents that were used by multiple repositories. The merged records do indeed retain all of the links to Resource and Accession records that were previously linked to the separate Subject and

[Archivesspace_Users_Group] ASpace v2.7.1 languages issue / Help with API deleting notes

2020-09-09 Thread Karen Miller
Hi all, I've been trying to rectify the problems we had with Language of Materials notes when we upgraded to v2.7 without much success. The issue is as Benn described it below - archival objects that had Language of Materials notes ended up with a Languages sub-record that has a Language

Re: [Archivesspace_Users_Group] help with API route for archival object notes

2020-07-02 Thread Karen Miller
anyway ;) From your example, you should be able to reference the content with the bad tag like this: [’notes’][0][‘content’][0] Cheers, James On Jul 2, 2020, at 1:23 AM, Karen Miller mailto:k-mill...@northwestern.edu>> wrote: Hello, James. Sorry, I just realized I addressed you as

Re: [Archivesspace_Users_Group] help with API route for archival object notes

2020-07-02 Thread Karen Miller
YZFwVvM8fWXHDtN3ecL--n7iU_fCRmT1ijs0J-y9UnFC3$> Pronouns: he / him / his From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Karen Miller S

Re: [Archivesspace_Users_Group] help with API route for archival object notes

2020-07-01 Thread Karen Miller
Hello, James. Sorry, I just realized I addressed you as Chris instead of as James! My apologies! I was so thrilled to get some assistance that I skimmed through the signatures too quickly. Best, Karen From: Karen Miller Sent: Wednesday, July 01, 2020 9:50 AM To: 'Archivesspace Users Group

Re: [Archivesspace_Users_Group] help with API route for archival object notes

2020-07-01 Thread Karen Miller
a life of their own, they are really just repeating parts of the top level record that they are contained within. Hope that helps.. Cheers, James On Jul 1, 2020, at 8:22 AM, Karen Miller mailto:k-mill...@northwestern.edu>> wrote: Good morning, ArchivesSpace users. I am a cataloger (*not* a deve

Re: [Archivesspace_Users_Group] help with API route for archival object notes

2020-07-01 Thread Karen Miller
just repeating parts of the top level record that they are contained within. Hope that helps.. Cheers, James On Jul 1, 2020, at 8:22 AM, Karen Miller mailto:k-mill...@northwestern.edu>> wrote: Good morning, ArchivesSpace users. I am a cataloger (*not* a developer) using the API

[Archivesspace_Users_Group] help with API route for archival object notes

2020-06-30 Thread Karen Miller
Good morning, ArchivesSpace users. I am a cataloger (*not* a developer) using the API to update ArchivesSpace. So far I've figured out how to add LCCNs to the authority_Id of Agent records and do a couple more updates that, in retrospect, were pretty simple. The next task I'd like to tackle,

Re: [Archivesspace_Users_Group] Mrs. Husband's Name / updates in our ArchivesSpace database

2020-05-19 Thread Karen Miller
Good morning. At Northwestern University, our ArchivesSpace is hosted by Atlas, who has given us ODBC read-only access to the MySQL database. Just yesterday I ran a report that harvests BiogHist notes from Agents for a cleanup project. My SQL is pretty hacky too (although Mark’s is a good bit

Re: [Archivesspace_Users_Group] Family names as Creators/Subjects

2020-04-06 Thread Karen Miller
: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Karen Miller Sent: Friday, April 3, 2020 4:20 PM To: Archivesspace

Re: [Archivesspace_Users_Group] Family names as Creators/Subjects

2020-04-03 Thread Karen Miller
p-boun...@lyralists.lyrasis.org>> On Behalf Of Karen Miller Sent: Friday, April 3, 2020 3:38 PM To: Archivesspace Users Group mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: [Archivesspace_Users_Group] Family names as Creators/Subjects Happy Friday, everyone! I’ve been using

[Archivesspace_Users_Group] Family names as Creators/Subjects

2020-04-03 Thread Karen Miller
Happy Friday, everyone! I’ve been using my WFH time to do some ArchivesSpace cleanup and have a question about how people are using family names. We are a NACO library and have been creating personal and corporate body name headings for people and organizations represented in our collections.

Re: [Archivesspace_Users_Group] Publish All workflows

2018-09-13 Thread Karen Miller
We've addressed this by querying the backend for a Resource before clicking the "Publish All" button. The following SQL code has been embedded into an Excel worksheet with prompt for the Resource Identifier ( WHERE T8.root_record_id=?) and then displays a list of archival object unittitles with

Re: [Archivesspace_Users_Group] Subject Heading Plugin not working properly 1.4.2

2017-06-19 Thread Karen Miller
appings to create a term ? Does it need to check if there is a previous 15x tag first to determine whether to skip 45x ? — Steve. On Jun 16, 2017, at 2:57 PM, Karen Miller <k-mill...@northwestern.edu<mailto:k-mill...@northwestern.edu>> wrote: Hi, Candace. I can’t help on the plugin

Re: [Archivesspace_Users_Group] LCNAF plugin

2017-04-12 Thread Karen Miller
...@lyralists.lyrasis.org] On Behalf Of Lapka, Francis Sent: Wednesday, April 12, 2017 12:52 PM To: archivesspace_users_group@lyralists.lyrasis.org Subject: [Archivesspace_Users_Group] LCNAF plugin Thanks Karen. My comments are below. Francis -- Karen Miller k-miller3 at northwestern.edu

Re: [Archivesspace_Users_Group] LCNAF plugin

2017-04-11 Thread Karen Miller
Francis, this is great news and I'm very excited by the prospect of getting an updated plug-in! We're doing a lot of editing when using it now, and the changes you have planned will eliminate a lot of that work for us at Northwestern. I only have two comments on the mappings. 1. I'd

Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Issues

2017-03-08 Thread Karen Miller
Hi, Suzanne. We migrated from Archon to ArchivesSpace 1.4.2 in December at Northwestern University. We did not experience issues with top containers, but we did have about 2 dozen (out of 1200+) finding aids come over with scrambled components. As you described, the scrambling appeared to be

[Archivesspace_Users_Group] Archon migration of Private Titles & other audience='internal' elements

2016-11-02 Thread Karen Miller
Good morning. We've just done an initial migration from Archon to ArchivesSpace and found that the Private Title element in Archon migrates to an ArchivesSpace Note with type="Materials Specific Details" and label "Private Title". This is somewhat understandable, as there doesn't seem to be an

Re: [Archivesspace_Users_Group] exporting an identifier for use in a URL to the public user interface

2016-10-31 Thread Karen Miller
not pointing at localhost. ] — Steve Majewski On Oct 31, 2016, at 10:51 AM, Karen Miller <k-mill...@northwestern.edu<mailto:k-mill...@northwestern.edu>> wrote: Good morning. We are getting ready (at long last!) to migrate from Archon to ArchivesSpace at Northwestern University