Duplicity in authority records after csv import

112 views
Skip to first unread message

cescoba...@gmail.com

unread,
May 12, 2017, 9:05:19 AM5/12/17
to AtoM Users
Hi everyone!

In a local installation with a few descriptions I did an  authority records import using a csv file. The problem is..... there are a lot of authorities duplicated (see image attached). Are there any way to delete them?

Thanks!



Dan Gillean

unread,
May 15, 2017, 4:35:07 PM5/15/17
to ICA-AtoM Users
Hi Claudio,

When you were importing, were you importing the Authority records CSV template, or an Archival description template that had some creators in it? I'm curious about how you ended up with so much duplication - I have a theory if you were importing descriptions...



There is unfortunately no easy way to bulk delete all of your duplicates via the user interface - you would have to manually delete them one by one. However, if you are confident with the back-end, you could use SQL to remove authority records. PLEASE back up all your data before you attempt this!

I don't have an exact query for you - you will have to explore. It becomes more complicated if these records are linked to descriptions, but if they are just duplicates, hopefully most of the information you need to delete is in one table. Some resources to help:

You can find entity relationship diagrams of AtoM's database on our wiki, here:

It looks like there are at least 2 tables you would want to work with - the actor table, and the actor.i18n table

Basic information on accessing the MySQL database from the command-line can be found in our docs here:

We have some slides I am attaching from our recent Camps that will give you a basic introduction to using SQL queries in AtoM, including one slide on Actors (e.g. authority records). They also explain how you can install and use something with a graphical user interface to interact with the database if you prefer, such as MySQL Workbench or PHPMyAdmin.

Regards,




Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory

--
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-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/6e1b72a3-3b4f-44fd-a0e8-5f13075c240b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

MySQL queries in AtoM - S Breker.pdf
MySQL-AtoM-TimHutchinson.pdf

cescoba...@gmail.com

unread,
May 26, 2017, 3:18:33 PM5/26/17
to AtoM Users
Thanks Dan!

I could finally fix it using SQL

:D


El lunes, 15 de mayo de 2017, 16:35:07 (UTC-4), Dan Gillean escribió:
Hi Claudio,

When you were importing, were you importing the Authority records CSV template, or an Archival description template that had some creators in it? I'm curious about how you ended up with so much duplication - I have a theory if you were importing descriptions...



There is unfortunately no easy way to bulk delete all of your duplicates via the user interface - you would have to manually delete them one by one. However, if you are confident with the back-end, you could use SQL to remove authority records. PLEASE back up all your data before you attempt this!

I don't have an exact query for you - you will have to explore. It becomes more complicated if these records are linked to descriptions, but if they are just duplicates, hopefully most of the information you need to delete is in one table. Some resources to help:

You can find entity relationship diagrams of AtoM's database on our wiki, here:

It looks like there are at least 2 tables you would want to work with - the actor table, and the actor.i18n table

Basic information on accessing the MySQL database from the command-line can be found in our docs here:

We have some slides I am attaching from our recent Camps that will give you a basic introduction to using SQL queries in AtoM, including one slide on Actors (e.g. authority records). They also explain how you can install and use something with a graphical user interface to interact with the database if you prefer, such as MySQL Workbench or PHPMyAdmin.

Regards,




Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory

On Fri, May 12, 2017 at 9:05 AM, <cescoba...@gmail.com> wrote:
Hi everyone!

In a local installation with a few descriptions I did an  authority records import using a csv file. The problem is..... there are a lot of authorities duplicated (see image attached). Are there any way to delete them?

Thanks!



--
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 post to this group, send email to ica-ato...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages