[Archivesspace_Users_Group] CSV question

[Rider, Jacqueline]

Thanks, Brian!

Jackie

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Brian Thomas <bthomas at tsl.texas.gov>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Thursday, October 13, 2016 at 3:21 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] CSV question

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: bthomas at tsl.texas.gov
tsl.texas.gov<http://tsl.texas.gov/>
[id: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
allow?

Thanks,
Jackie Rider

Jacqueline Rider
Digital Archivist
Princeton Theological Seminary
Library
PO Box 821
Princeton NJ 08542
609-497-7862
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/20161014/7799788e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5315 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20161014/7799788e/attachment.png>