Thanks, Brian! Jackie
From: <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Brian Thomas <btho...@tsl.texas.gov> Reply-To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Date: Thursday, October 13, 2016 at 3:21 PM To: Archivesspace Users Group <archivesspace_users_group@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: btho...@tsl.texas.gov tsl.texas.gov<http://tsl.texas.gov/> [id: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
