[Archivesspace_Users_Group] Accessions Import Error id_0

[Zachary Adams]

Hi All,

Fairly new to using ASpace, so you have my sincere apologies if this question 
has been answered previously for the group, or if I missed the best resource to 
find an answer.

I'm importing a .csv of accession records and keep getting the error message:

--
id_0: That ID is already in use.

Problem creating 'Records of the Finance Department': id_0 That ID is already 
in use
--

My understanding from the user manual and screencasts that I've watched so far 
is that only the accession ID needs to be unique, not the accession title (this 
upload has a number of records with identical titles, but all have different 
accession IDs). We are using a pretty standard multi-part accession number 
format of -0001-0001, tracking sequentially each accession throughout a 
given year. So on the import template, we have the accession numbers broken up 
in 'accession_number_1', 'accession_number_2', and 'accession_number_3', with 
'accession_number_4' left blank. Though this adds up to an overall unique 
identifier for any given record, it clearly results in the 'accession_number_1' 
field being identical for all the accessions in the same year, including a few 
records with identical titles as well. Is that what's triggering the error?

I double checked that my 'accession_number' fields are all unique when all four 
fields are combined, and they are. I also tried removing the specific records 
cited in the error above from the .csv and attempted importing again, but the 
import produces the same error only now citing a different duplicate title.

Any thoughts on how to proceed?

Many thanks for reading.

-

Zach Adams
Project Archivist
Brooklyn Museum
200 Eastern Parkway, Brooklyn, NY 11238-6052

brooklynmuseum.org


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

Re: [Archivesspace_Users_Group] Importing Accessions CSVs - linking agents and resources

[Lora Woodford]

Hi Carly,

The current accessions CSV import is limited to the columns that exist in the 
csv template, and, as such, does not support the type of workflow you describe. 
 Rightly or wrongly, it definitely assumes that you are using the CSV importer 
to import wholly new records and new linked/associated records (in the case of 
subjects and agents, at least).  It does not support importing classifications 
and links to related resources.

I’ve done very little with the csv imports so I’m not sure how difficult it 
would be to extend the functionality to accomplish what you want, but would 
encourage anyone to chime in here with advice if you have done so (or attempted 
to do so and scrapped the idea!).  Given the fact that I haven’t seen any 
examples of folks doing this work (correct me if I’m wrong!), I suspect it is 
rather tricky.

There are many more examples out there of folks associating existing linked 
records to one another using the ArchivesSpace API.  A great resource to start 
learning how this project might be accomplished using the API is the 
ArchivesSnake repository in GitHub (a readme begins after you scroll past that 
list of files):  https://github.com/archivesspace-labs/ArchivesSnake

 Hopefully others will chime in with additional advice.

Best,

Lora

From:  on behalf of 
"Bogen, Carly (Records)" 
Reply-To: Archivesspace Users Group 

Date: Saturday, November 17, 2018 at 12:13 PM
To: "archivesspace_users_group@lyralists.lyrasis.org" 

Subject: [Archivesspace_Users_Group] Importing Accessions CSVs - linking agents 
and resources

Hi all,

Is there a way to use the accessions CSV import to link the new accession being 
created to agents, resources and classifications that already exist in the 
repository?

We'd like to be able to add an existing agent uid to a field in the 
spreadsheet, include a role, and have that automatically link. Same for 
resources and classifications, only without the role.

I can't seem to figure out how to make this work.

Thanks for your help! And sorry for the cross-post – this list seems a bit more 
active than the Google group.

-Carly

Carly Bogen | Manager, Digital Programs
Department of Records and Information Services (DORIS)
31 Chambers Street, New York, NY 10007
P: 212-341-6029  | E-mail: cbo...@records.nyc.gov
[mailBanner]
Follow us on:
[acebook]  [witter] 
   [umblr] 
[outube] 


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