Generating a list of slugs and reference codes

Skip to first unread message

Anna Mcnally

Sep 15, 2021, 9:16:24 AM9/15/21
to AtoM Users
Hi all,

we've recently upgraded to AtoM 2.6 and are having a few issues with reference codes and slugs not matching up, even though the slugs should be generated from the reference codes. In the records where we're having issues, it is usually the slug that is actually correct and the reference code that is incorrect. Therefore we'd ideally we'd like to generate a spreadsheet with a list of all the slugs and reference codes side by side, so that we could identify where the issues are. is there any way of doing this either a)within the the user interface or b)via the command line?
Many thanks,

Anna McNally
University of Westminster Archive

Dan Gillean

Sep 15, 2021, 2:55:16 PM9/15/21
to ICA-AtoM Users
Hi Anna, 

If you're willing to make a temporary local code change, then CSV export might be the easiest option to get what you need. 

The CSV export already includes a column with the full reference code. This is ignored during import since reference codes are built via inheritance, but is intended for exactly this kind of purpose on export. 

As for the slugs - we are adding a slug column on export in 2.7 for very similar reasons. You can see the issue ticket here: 
If you follow the link in the comments to the related pull request, you can see that adding this support is actually dead simple:
I think the easiest method then would to try making this change in your local instance, and then exporting what you need. Seems simpler to me than trying complicated SQL queries! 

Of course, if you'll be doing this on a production installation, we always strongly recommend making backups before making any kind of code changes! 


Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
he / him

This message and its attachments are private and confidential. If you have received this message in error, please notify the sender and remove it and its attachments from your system.

The University of Westminster is a charity and a company limited by guarantee. Registration number: 977818 England. Registered Office: 309 Regent Street, London W1B 2UW.

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
To view this discussion on the web visit
Reply all
Reply to author
0 new messages