Thanks, Brian!


From: <> on behalf of 
Brian Thomas <>
Reply-To: Archivesspace Users Group 
Date: Thursday, October 13, 2016 at 3:21 PM
To: Archivesspace Users Group <>
Subject: Re: [Archivesspace_Users_Group] CSV question


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

[] On Behalf Of 
Rider, Jacqueline
Sent: Thursday, October 13, 2016 1:30 PM
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

Archivesspace_Users_Group mailing list

Reply via email to