Jacqueline,

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.
Thanks,

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



From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
[mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org] On Behalf Of 
Rider, Jacqueline
Sent: Thursday, October 13, 2016 1:30 PM
To: archivesspace_users_group@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
allow?

Thanks,
Jackie Rider

Jacqueline Rider
Digital Archivist
Princeton Theological Seminary
Library
PO Box 821
Princeton NJ 08542
609-497-7862
jacqueline.ri...@ptsem.edu<mailto:jacqueline.ri...@ptsem.edu>


_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Reply via email to