[Archivesspace_Users_Group] Publish status set incorrectly in Accession csv import

[Wetherill, Julie M.]

Hi Leah,

User 0 reports that the user preference setting for ‘Publish’ is unchecked. Under ‘Repository Preferences’, it’s also unchecked.  --julie

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Leah Tams
Sent: Wednesday, December 7, 2022 12:49 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Publish status set incorrectly in Accession csv import

Hi Julie,

Are User 0’s settings correct? There is a setting for users that will automatically publish any record they create or upload. If that’s turned on, I’d suggest turning it off and then seeing if the problem persists.

Best,
Leah


On Dec 7, 2022, at 12:22 PM, Wetherill, Julie M. <julie_wetherill at harvard.edu<mailto:julie_wetherill at harvard.edu>> wrote:

Hi all,

We have a problem importing accession records by csv that seems to be limited to a single user's computer.

Accession imports by this staff user are loaded successfully, but the records always land in the system as published despite the accession_publish column being set to '0' (unpublished) across the board. Our public interface doesn't display accessions but PUI solr happily indexes them, so PUI users find these accession records but can't open them. So we don't want published accessions.

We are running v3.0.2 and the user (who I'm calling User 0) is working off a fresh accession csv template pulled from github.

Using the same csv, I am able to import accession records that load as unpublished. And other users in the same repository as User 0 can load that csv and get unpublished records. But not User 0.

All csv editing is done in a text editor and not Excel. I don't think this is an issue with user preferences or permissions (which are the same for everyone who has tested).

Using a hex viewer, I don't see anything funky going on with the value for accession_publish in the csv (it is the number zero).

Any ideas what is causing this weirdness? Many moons ago we had a similar issue importing EADs from spreadsheet and discovered that the internal Excel datatype assigned to the publish column was not what the loader expected, causing it to assign a default publish value regardless of the supplied value. But in the accessions case, Excel is not involved.

Thanks in advance for any advice you can offer. Regards. -julie

Julie Wetherill
HUIT Library Technology Services
Harvard University
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
https://urldefense.com/v3/__http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!OToaGQ!si2xKFmOjAf4dqXN8lfhdNlh6jdmPttwzDk_WpUuUeLeU98PMOBBf25tbv2FeWfv9ZEGKBd9gpeYrH-QXDGyaeHA9uQYmUQ$<https://urldefense.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!OToaGQ!si2xKFmOjAf4dqXN8lfhdNlh6jdmPttwzDk_WpUuUeLeU98PMOBBf25tbv2FeWfv9ZEGKBd9gpeYrH-QXDGyaeHA9uQYmUQ$>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20221207/c9d9acdc/attachment.html>