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,
--
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.
You can find entity relationship diagrams of AtoM's database on our wiki, here: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: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!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...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,
On Fri, May 12, 2017 at 9:05 AM, <cescoba...@gmail.com> wrote:
--
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.