Where can I find my repository name?
27 views
Skip to first unread message
Gurvinik
May 29, 2020, 1:05:43 AM5/29/20
to AtoM Users
Greetings,
My archivist asked me to to download a CSV file of the descriptions currently in our AtoM instance. I followed the instructions here: https://www.accesstomemory.org/fr/docs/2.4/admin-manual/maintenance/cli-import-export/#csv-export-cli, but I am not sure what our repository is. We run AtoM in-house and it only contains our institution's archive, but I am not sure where to look exactly for the repository name. I have access to AtoM admin and to MySQL database, I just need a nudge in the right direction, so I can substitute "this-is-my-repository-slug" in SELECT object_id FROM slug WHERE slug="this-is-my-repository-slug";
Dan Gillean
May 29, 2020, 10:32:25 AM5/29/20
to ICA-AtoM Users
Hi there,
First of all, if you are looking for an export of all records (or if you only have one archival institution in your AtoM site), then you can probably run the command-line export without needing to limit to a repository - just export everything, no SQL parameters needed. However, I'll include some tips below for you to take a look at the AtoM instance and find the repository slug if desired.
There are a number of ways you can get the slug value you need via AtoM.
Another name for repository records in AtoM is Archival institutions - so you can see all repository records that have been created in AtoM by navigating in the user interface to Browse > Archival institutions. If your users have modified the menus (so this link isn't available for example), you can also manually navigate to [your-site]/repository/browse. You can see an example of the repository browse page in our demo site, here:
If you click on a repository record, it will show a count of linked top-level descriptions in the holdings sidebar. This example in our demo site has 18 holdings:
Another way of checking this information: open the CSV export you created. There should be a repository column in the CSV. If this is populated with a name, then you will know the descriptions are linked to a repository record. You should then be able to search on the name in AtoM, find the repository record, and get the slug.
Yet another way: find one of the descriptions in AtoM's user interface that you know is part of the target export. On its view page, you will see a box in the upper left corner that will either have the name of the linked repository record, or else a repository logo if one has been uploaded. You can click on this to navigate to the associated repository record. Here's an example description linked to the Women's College Hospital Archives in our demo data:
Clicking on the repository / archival institution name in the box at the top left takes us to the repository record:
Cheers,
he / him
On Fri, May 29, 2020 at 1:05 AM Gurvinik <stani...@gmail.com> wrote:
Greetings,My archivist asked me to to download a CSV file of the descriptions currently in our AtoM instance. I followed the instructions here: https://www.accesstomemory.org/fr/docs/2.4/admin-manual/maintenance/cli-import-export/#csv-export-cli, but I am not sure what our repository is. We run AtoM in-house and it only contains our institution's archive, but I am not sure where to look exactly for the repository name. I have access to AtoM admin and to MySQL database, I just need a nudge in the right direction, so I can substitute "this-is-my-repository-slug" in SELECT object_id FROM slug WHERE slug="this-is-my-repository-slug";
--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/771281dd-0511-42c6-95b8-c19a6ce5ff5d%40googlegroups.com.
Gurvinik
May 31, 2020, 4:52:36 PM5/31/20
to AtoM Users
Million thanks, Dan!
My elasticsearch is not working properly right now, so I cannot yet apply some of the suggestions you made, but I used your first advice - "you can probably run the command-line export without needing to limit to a repository - just export everything, no SQL parameters needed" and it worked like a charm. Ran "sudo php symfony csv:export /tmp/atom/csv_export.csv". Sure, It gave me initially a PHP error about allowed memory size of xxx bytes exhausted, but after increasing the memory_limit parameter in php.ini, it exported everything in a 1.5 MB csv file with 57 columns and 3500 rows of sheer goodness! Wonderful!
I will now work on elasticsearch and try your other suggestions then.
Reply all
Reply to author
Forward
0 new messages