unable to upload part bulkload file

[AdrienneRaniszewski]

Issue Documentation is http://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html

Describe the bug can't upload file for part bulkload

To Reproduce attach csv click "upload this file" get error

Expected behavior for it to load

Additional context below is the error I get. is my username (AdrienneR) causing issues again? Is it possible for you to just change it to all lower case?

lucee.commons.cli.CommandException: psql:/usr/local/webroot/temp/excopy_adrienner_2024042512044590_210.sql:9: ERROR: insert or update on table "cf_temp_parts" violates foreign key constraint "cf_temp_parts_username_fkey" DETAIL: Key (username)=(adrienner) is not present in table "cf_users".

[dustymc]

data please

[AdrienneRaniszewski]

2023.027-extra-parts.csv

[AdrienneRaniszewski]

any luck?

[dustymc]

Sorry, 8 million fires to put out, I'll try to get this today or I can probably force it through as me if you're in a huge hurry.

[AdrienneRaniszewski]

alrighty. not a huge rush, but do have more like it to upload soon. thanks!

[Jegelewicz]

FWIW @KatherineLAnderson was having the same issue on Friday.

[dustymc]

@AdrienneRaniszewski @KatherineLAnderson this should be patched, please test and confirm as I'm still working behind some limitations. (One of those fires turned into an outright conflagration....)

[KatherineLAnderson]

It's fixed on my end! Thanks Dusty!

[AdrienneRaniszewski]

I was able to upload the file, but I can't actually load the parts. I think it's a different problem, but I don't understand the error message. It's in the parts bulkloader, if you want to take a look. user AdrienneR. Thanks!

[KatherineLAnderson]

edit: part of what I said before was human error (thanks Teresa!)

BUT, it's still not recognizing part names. And I tried to manually enter part names in the data entry page and they aren't recognized there either.

[dustymc]

Thanks, bugfixed (I hope, and you can't check because TACC-things, but I'll try to get a patch out tonight....)

recognizing part names.

collection settings at the top of https://arctos.database.museum/info/ctDocumentation.cfm?table=ctspecimen_part_name, or there's a link in manage collection.

I don't think that's documented - @Jegelewicz ??

[Jegelewicz]

@KatherineLAnderson you need to select the parts you want to use - see https://drive.google.com/file/d/1nmCFYhNaX5z3VM8_8UZXZ_MszdsQskJy/view?usp=drive_link

[dustymc]

Assuming everything's all happy....

[AdrienneRaniszewski]

Yes! All happy now. Thank you!