[Archivesspace_Users_Group] CSV question

Brian Thomas bthomas at tsl.texas.gov
Thu Oct 13 15:21:22 EDT 2016


While I don’t know the answer to this directly from the program standpoint, Ido know that if you create the file in excel and save as a csv it should do the proper method automatically. I believe my tests of the csv upload was with the “” option in the file. However excel does it automatically works just fine.

Brian Thomas
Electronic Records Specialist
Texas State Library and Archives Commission
1201 Brazos Street
Austin, TX 78701
PH: (512) 475-3374
e-mail: bthomas at tsl.texas.gov
[cid:image001.jpg at 01D029A2.37194C70]

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Rider, Jacqueline
Sent: Thursday, October 13, 2016 1:30 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] CSV question

When importing a CSV file of accession records, if a given value itself
contains a comma (as is especially common for descriptive text fields),
how should the internal comma be escaped? One common way to do this is to
use a backslash immediately before the comma, for example:

accession_acquisition_type,accession_title,accession_use_restrictions, ...
Gift,Horace T. Allen\, Jr. Collection,FALSE, ...

Another common method is to wrap the value in quotation marks, for example:

accession_acquisition_type,accession_title,accession_use_restrictions, ...
Gift,"Horace T. Allen, Jr. Collection",FALSE, ...

Which of these (or some other technique) does the accession CSV importer

Jackie Rider

Jacqueline Rider
Digital Archivist
Princeton Theological Seminary
PO Box 821
Princeton NJ 08542
jacqueline.rider at ptsem.edu<mailto:jacqueline.rider at ptsem.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20161013/c993e87e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5314 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20161013/c993e87e/attachment.png>

More information about the Archivesspace_Users_Group mailing list