Difference between revisions of "Resources/CSV templates"

From AtoM wiki
(AtoM 2.2 CSV templates)
(Reorganize page, add more content)
Line 3: Line 3:
  
 
On this page you'll find copies of the CSV templates we provide for use when importing data into AtoM. As the CSV files change over versions, we will add sections, so that you can be sure you are using the right template for your AtoM installation.  
 
On this page you'll find copies of the CSV templates we provide for use when importing data into AtoM. As the CSV files change over versions, we will add sections, so that you can be sure you are using the right template for your AtoM installation.  
 
At this time, we provide templates for the ISAD(G) and RAD descriptive templates in AtoM. If you are wanting to import data but are using a different content standard (e.g. DACS, DC, or MODS), we recommend using the ISAD(G) template, and simply ignoring any fields that do not crosswalk. We will be adding crosswalking mappings from each content standard to the relevant ISAD template CSV column in the Data entry section of our AtoM [https://accesstomemory.org/docs User manual.]
 
  
 
<admonition type="tip">
 
<admonition type="tip">
Line 10: Line 8:
 
</admonition>
 
</admonition>
  
 +
'''Page organization'''
 +
 +
This page has been divided first by type - archival description, or other CSV import type (as the archival description CSV templates are the most commonly used, and also the ones most subject to further development and versioning), and then in each section, by release. If the template has not changed for a version, it will '''not''' be added to the newest release section - you can simply download the link in the previous version.
 +
 +
 +
 +
 +
==Archival descriptions==
 +
 +
Below you'll find copies of the CSV template examples for archival descriptions, organized by each major release. A change log will be included for versions after 2.0.0, so you can quickly determine what has changed.
 +
 +
At this time, we provide templates for the ISAD(G) and RAD descriptive templates in AtoM. If you are wanting to import data but are using a different content standard (e.g. DACS, DC, or MODS), we recommend using the ISAD(G) template, and simply ignoring any fields that do not crosswalk. We will be adding crosswalking mappings from each content standard to the relevant ISAD template CSV column in the Data entry section of our AtoM [https://accesstomemory.org/docs User manual.]
 +
 +
If there are no changes to the archival description CSV templates for a major release, a section will not be included - you can then use the templates from the previous release. Be sure to review the CSV import documentation in the AtoM user manual for your release - a link directly to the CSV import section for each major AtoM version is included in the sections below.
  
 
===AtoM 2.0 and earlier CSV templates===
 
===AtoM 2.0 and earlier CSV templates===
  
These CSV template should work for AtoM 2.0.0, 2.0.1, 2.0.2, and any earlier version of ICA-AtoM that supports CSV import.
+
These archival description CSV templates should work for AtoM 2.0.0, 2.0.1, 2.0.2, and any earlier version of ICA-AtoM that supports CSV import.
 +
 
 +
* ISAD CSV template
 +
* RAD CSV template
 +
 
  
 
<admonition type="seealso">
 
<admonition type="seealso">
Line 19: Line 35:
 
</admonition>
 
</admonition>
  
* ISAD
 
* RAD
 
  
 +
===AtoM 2.1 CSV templates===
  
===AtoM 2.1 CSV templates===
+
'''Change log'''
 +
 
 +
* <code>digitalObjectURI</code> and <code>digitalObjectPath</code> columns added for importing digital objects with archival descriptions - see issue [https://projects.artefactual.com/issues/6525 #6525]
 +
* Cast, Credits, and Signatures columns added to RAD CSV template - see issue [https://projects.artefactual.com/issues/7130 #7130]
  
Describe changes here
 
  
 
<admonition type="seealso">
 
<admonition type="seealso">
Line 31: Line 48:
 
</admonition>
 
</admonition>
  
* ISAD
+
* ISAD 2.1 CSV template
* RAD
+
* RAD 2.1 CSV template
 +
 
  
 
===AtoM 2.2 CSV templates===
 
===AtoM 2.2 CSV templates===
  
Describe changes here
+
'''Change log'''
 +
 
 +
* Change <code>creatorDates</code> column header and related columns labels to <code>creationDates</code> - see issue [https://projects.artefactual.com/issues/6526 #6526]
 +
* Add new columns to allow import of <code>alternativeIdentifiers</code> and <code>alternativeIdentifierLabels</code> - see issue [https://projects.artefactual.com/issues/7388 #7388]
 +
 
 +
 
 +
<admonition type="seealso">
 +
See the 2.2 CSV import documentation [https://www.accesstomemory.org/docs/2.2/user-manual/import-export/csv-import/ here.]
 +
</admonition>
 +
 
 +
* ISAD 2.2 CSV template
 +
* RAD 2.2 CSV template
 +
 
 +
 
 +
==Other CSV templates==
 +
 
 +
Here you'll find the CSV templates for entities other than archival descriptions, including authority records and accessions. Please see the AtoM  [https://accesstomemory.org/docs User manual] for further information on using each type.
 +
 
 +
If there are no changes to the CSV templates for a major release, a link or section will not be included - you can then use the templates from the previous release. Be sure to review the CSV import documentation in the AtoM user manual for your release - a link directly to the CSV import section for each major AtoM version is included in the sections below.
 +
 
 +
<admonition type="tip">
 +
There is another kind of CSV import, for linking digital objects to existing descriptions, for which we do not provide example templates, because the format is very simple. For further information, see for example the 2.0 CSV import docs about this:
 +
 
 +
* https://accesstomemory.org/docs/2.0/user-manual/import-export/csv-import/#load-digital-objects-via-the-command-line
 +
</admonition>
 +
 
 +
 
 +
===AtoM 2.0.0 and earlier CSV templates===
 +
 
 +
The following  CSV templates should work for AtoM 2.0.0, 2.0.1, and 2.0.2, as well as any previous ICA-AtoM release that supports CSV import.
 +
 
 +
* Accession CSV template
 +
* Authority record CSV template
 +
* Authority record aliases CSV template
 +
* Authority record relationships CSV template
 +
* Events CSV template
 +
 
 +
<admonition type="seealso">
 +
See the 2.0 CSV import documentation [https://www.accesstomemory.org/docs/2.0/user-manual/import-export/csv-import/ here.]
 +
</admonition>
 +
 
 +
 
 +
===AtoM 2.1 CSV templates
 +
 
 +
'''Change log'''
 +
* Add <code>qubitParentSlug</code> to accessions CSV import to allow accessions import to link to existing descriptions - see issue [https://projects.artefactual.com/issues/6752 #6752]
 +
* Add <code>identifier</code> as an option for the second column in the digital object CSV import task - see the related documentation [https://accesstomemory.org/docs/2.1/user-manual/import-export/csv-import/#load-digital-objects-via-the-command-line here.]
 +
 
 +
 
 +
<admonition type="seealso">
 +
See the 2.1 CSV import documentation [https://www.accesstomemory.org/docs/2.1/user-manual/import-export/csv-import/ here.]
 +
</admonition>
 +
 
 +
* Accessions  2.1 CSV template
 +
 
 +
 
 +
==AtoM 2.2 CSV templates===
 +
 
 +
'''Change log'''
 +
* Add 4 new columns to Accessions CSV import template to allow for creation date imports - see issue [https://projects.artefactual.com/issues/8463 #8463]
 +
 
  
 
<admonition type="seealso">
 
<admonition type="seealso">
Line 42: Line 120:
 
</admonition>
 
</admonition>
  
* ISAD
+
* Accessions 2.2 CSV template
* RAD
+
 
  
  

Revision as of 16:11, 19 May 2015

Main Page > Resources > Resources/CSV templates

On this page you'll find copies of the CSV templates we provide for use when importing data into AtoM. As the CSV files change over versions, we will add sections, so that you can be sure you are using the right template for your AtoM installation.

Tip

For more information on CSV import, see the CSV section of our User manual. Links directly to each major release's CSV import documentation are included in the relevant sections below.

Page organization

This page has been divided first by type - archival description, or other CSV import type (as the archival description CSV templates are the most commonly used, and also the ones most subject to further development and versioning), and then in each section, by release. If the template has not changed for a version, it will not be added to the newest release section - you can simply download the link in the previous version.

Archival descriptions

Below you'll find copies of the CSV template examples for archival descriptions, organized by each major release. A change log will be included for versions after 2.0.0, so you can quickly determine what has changed.

At this time, we provide templates for the ISAD(G) and RAD descriptive templates in AtoM. If you are wanting to import data but are using a different content standard (e.g. DACS, DC, or MODS), we recommend using the ISAD(G) template, and simply ignoring any fields that do not crosswalk. We will be adding crosswalking mappings from each content standard to the relevant ISAD template CSV column in the Data entry section of our AtoM User manual.

If there are no changes to the archival description CSV templates for a major release, a section will not be included - you can then use the templates from the previous release. Be sure to review the CSV import documentation in the AtoM user manual for your release - a link directly to the CSV import section for each major AtoM version is included in the sections below.

AtoM 2.0 and earlier CSV templates

These archival description CSV templates should work for AtoM 2.0.0, 2.0.1, 2.0.2, and any earlier version of ICA-AtoM that supports CSV import.

  • ISAD CSV template
  • RAD CSV template

Seealso

See the 2.0 CSV import documentation here.

AtoM 2.1 CSV templates

Change log

  • digitalObjectURI and digitalObjectPath columns added for importing digital objects with archival descriptions - see issue #6525
  • Cast, Credits, and Signatures columns added to RAD CSV template - see issue #7130

Seealso

See the 2.1 CSV import documentation here.

  • ISAD 2.1 CSV template
  • RAD 2.1 CSV template

AtoM 2.2 CSV templates

Change log

  • Change creatorDates column header and related columns labels to creationDates - see issue #6526
  • Add new columns to allow import of alternativeIdentifiers and alternativeIdentifierLabels - see issue #7388

Seealso

See the 2.2 CSV import documentation here.

  • ISAD 2.2 CSV template
  • RAD 2.2 CSV template

Other CSV templates

Here you'll find the CSV templates for entities other than archival descriptions, including authority records and accessions. Please see the AtoM User manual for further information on using each type.

If there are no changes to the CSV templates for a major release, a link or section will not be included - you can then use the templates from the previous release. Be sure to review the CSV import documentation in the AtoM user manual for your release - a link directly to the CSV import section for each major AtoM version is included in the sections below.

Tip

There is another kind of CSV import, for linking digital objects to existing descriptions, for which we do not provide example templates, because the format is very simple. For further information, see for example the 2.0 CSV import docs about this:

AtoM 2.0.0 and earlier CSV templates

The following CSV templates should work for AtoM 2.0.0, 2.0.1, and 2.0.2, as well as any previous ICA-AtoM release that supports CSV import.

  • Accession CSV template
  • Authority record CSV template
  • Authority record aliases CSV template
  • Authority record relationships CSV template
  • Events CSV template

Seealso

See the 2.0 CSV import documentation here.

===AtoM 2.1 CSV templates

Change log

  • Add qubitParentSlug to accessions CSV import to allow accessions import to link to existing descriptions - see issue #6752
  • Add identifier as an option for the second column in the digital object CSV import task - see the related documentation here.

Seealso

See the 2.1 CSV import documentation here.

  • Accessions 2.1 CSV template

AtoM 2.2 CSV templates=

Change log

  • Add 4 new columns to Accessions CSV import template to allow for creation date imports - see issue #8463

Seealso

See the 2.2 CSV import documentation here.

  • Accessions 2.2 CSV template