exporting the Atom database

[camezq...@gmail.com]

Good morning, the system department of our institution has doubts about exporting the Atom database to a csv file. the questions are as follows:

What are the queries to be able to Query and export the database.

If we can extract the specific data from each área of archval description?, if posible what is the necessary Query.

It is posible to extract the information of each área of archival description? to be acceded by code QR.


regards,

[Dan Gillean]

Hi Cristian, 

I don't know all of the related SQL queries to access this data directly from the database but if you are interested in constructing SQL queries for data extraction, you might find the following resources useful. 

First, please see this slide deck: 

• https://www.slideshare.net/accesstomemory/constructing-sql-queries-for-atom
  

These slides include further information and sample queries that should help you learn how archival descriptions are represented in the database. Essentially, from what I understand, data is spread across multiple tables. 

Note as well that one of the first slides recommends that you try setting up a front-end tool to help you explore the database in a visual way - I recommend looking into either MySQL Workbench or PHPMyAdmin. 

We also have Entity Relation Diagrams from the AtoM database on the wiki, to help you learn how the database is constructed. See: 

• https://wiki.accesstomemory.org/Development/ERDs#January_2017
  

In terms of extracting the entire database, you can easily create a SQLdump of the database contents. We use this as part of the upgrade process, for example. See: 

• https://www.accesstomemory.org/docs/2.4/admin-manual/maintenance/cli-tools/#backing-up-the-database
  
• https://www.accesstomemory.org/docs/2.4/admin-manual/maintenance/data-backup/
  

If you can use the data in other forms (such as a CSV file), you might consider simply performing a CSV export of your data. See: 

• https://www.accesstomemory.org/docs/2.4/admin-manual/maintenance/cli-import-export/#exporting-csv-files-from-the-command-line
  

Take a look around the documentation, there are other ways to get the data out as well, such as CSV export from the user interface, EAD XML exports (both command-line and user interface), and AtoM even has an API that can serve json. 

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/547c2ccf-d014-48fd-ba6f-973ee54d31cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dan Gillean]

Oops, I just realized you were asking about CSV specifically. Well, one option: you can explore the database with the tools I've given you above and create your own custom CSV export scripts from SQL queries. Otherwise, AtoM does have CSV export options for some data types, but not all. See: 

• https://www.accesstomemory.org/docs/2.4/user-manual/import-export/csv-export/#export-clipboard-results-in-csv-format
  

Cheers, 

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

@accesstomemory

To post to this group, send email to ica-ato...@googlegroups.com.