| Time |
Nick |
Message |
| 06:22 |
|
Guest46 joined #evergreen |
| 06:25 |
|
JBoyer joined #evergreen |
| 08:42 |
|
mmorgan joined #evergreen |
| 09:02 |
|
Dyrcona joined #evergreen |
| 10:17 |
Dyrcona |
Related to Lp 2123871: I've found that actor.usr_delete and actor.usr_purge_data leave behind some auditor table rows with PII in all cases. The number of tables and rows affected can vary, auditor.actor_usr_history is always there. |
| 10:17 |
pinesol |
Launchpad bug 2123871 in Evergreen 3.15 "Holds with deleted requestor not displayed " [Medium,Confirmed] https://launchpad.net/bugs/2123871 |
| 10:18 |
* Dyrcona |
is working on a Lp write up. |
| 11:02 |
|
sandbergja joined #evergreen |
| 11:23 |
Bmagic |
Dyrcona++ |
| 11:23 |
Bmagic |
sandbergja++ # weekend warrior |
| 11:24 |
Bmagic |
sandbergja++ # weekend warrior for realz |
| 11:32 |
|
Christineb joined #evergreen |
| 11:59 |
|
jihpringle joined #evergreen |
| 12:52 |
Dyrcona |
Interesting stuff: Looks like we've got some race conditions with patron updates and deletes, but those are rare. I've 1 setting and 2 "penalties" added to deleted patrons with timestamps right around the delete time. |
| 13:11 |
Dyrcona |
I might split this up into multiple bugs.... |
| 13:23 |
|
mantis joined #evergreen |
| 13:26 |
mantis |
had a question about the patron_loader.pl. I'm testing it out with a csv that has cardnumber, usrname, profile, home_library, family_name, first_given_name filled out. These are completely new patrons. When running the script, I get these kinds of errors: line 6 could not find valid profile, id: none, column: 2 for 55555264687 |
| 13:27 |
mantis |
the way I'm reading it is there's no id which I'm assuming is for the actor.usr table |
| 13:27 |
mantis |
btw the barcodes are just made up numbers |
| 13:28 |
mantis |
I also get this error that shows with the --debug: parameters: 1758561898,line 2 could not find valid home library, id: none, column: WDBURY for 55555264683,0,117 |
| 13:31 |
|
jvwoolf joined #evergreen |
| 13:35 |
jeffdavis |
looks to me like the missing id's in question are the profile (permission.grp_tree.id) and home_library (actor.org_unit.id) |
| 13:36 |
jeffdavis |
i.e. that either your data contains profile and home lib values that aren't valid for the EG system you're running this on, or they weren't mapped successfuly to valid values |
| 13:37 |
mantis |
I assumed that the profile was the int value which is in there |
| 13:38 |
mantis |
and I thought home_library was an int as well but I was getting the same error back before switching it to the shortcode |
| 13:39 |
mantis |
do you need to map every column even if they are the required columns for the script? |
| 13:54 |
sandbergja |
I believe the profile should be the actual name of the profile (e.g. Patrons) |
| 13:54 |
sandbergja |
based on this sample in the code base: https://github.com/evergreen-library-system/Evergreen/blob/main/Open-ILS/src/perlmods/live_t/data/patrons-to-import.csv |
| 13:54 |
sandbergja |
(^ mantis) |
| 13:55 |
mantis |
ok so I was right about the shortcode |
| 13:55 |
mantis |
thank you! |
| 13:55 |
mantis |
I might update the current docs to reflect this if the test passes |
| 13:55 |
sandbergja |
that would be great! |
| 13:59 |
sandbergja |
full credit goes to Rogan for that sample CSV |
| 13:59 |
mantis |
the script did process, but I don't see the patrons in the actor.usr table |
| 14:01 |
Dyrcona |
mantis: They're probably in a table in the staging schema. (I haven't looked at this in a while.) |
| 14:02 |
mantis |
ah gotcha |
| 14:02 |
mantis |
thank you! |
| 14:02 |
Dyrcona |
Pending users interface in the client, IIRC. |
| 14:03 |
* Dyrcona |
dives back into writing bug reports. Got 1 down. One to go. |
| 14:06 |
mantis |
does anyone know the table? I'm still not seeing any evidence of these getting loaded somewhere including Pending Users |
| 14:10 |
mantis |
script's debug is saying it's inserting into specific parts of the actor schema |
| 14:13 |
Dyrcona |
mantis: I'd have to look at the script source. |
| 14:17 |
Dyrcona |
Meh... Where is my brain.... I edited my latest bug report to fix some nonsense. I wrote the original report in my text editor hoping to avoid issues that come up when I try to type into a web form..... |
| 14:17 |
Dyrcona |
Lp 2125430 |
| 14:17 |
pinesol |
Launchpad bug 2125430 in Evergreen "Personally Identifiable Information and Other Unpurged Data Left After a User is Deleted" [Undecided,New] https://launchpad.net/bugs/2125430 |
| 14:33 |
Dyrcona |
I wonder if I have a 3rd bug? |
| 14:38 |
pinesol |
News from commits: LP2121886: Refactor do_hold_cancel to safely resolve current_copy and fetch barcode <http://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=37c75a525194544a13a6e20f5044f8d9177f7d81> |
| 14:49 |
Dyrcona |
I should have mentioned that the patron's email address is still in the database. |
| 14:56 |
|
mantis left #evergreen |
| 15:12 |
sandbergja |
mantis: is there anything in the actor.patron_loader_log ? |
| 15:22 |
Dyrcona |
sandbergja: "mantis left the room" |
| 15:22 |
sandbergja |
ah gotcha |
| 15:22 |
sandbergja |
someday I'll learn how to use irc haha |
| 15:22 |
Dyrcona |
:) |
| 15:23 |
Dyrcona |
Elvis has left the building. |
| 15:23 |
sandbergja |
lol |
| 17:08 |
|
mmorgan left #evergreen |
| 17:33 |
|
jihpringle joined #evergreen |
