You can no longer set an expiry date into the past. Test file: userid,cardnumber,branchcode,categorycode,surname "12345","65432","LONDON","STANDARD","Smith" 1. User should exist and have expiry date in future (say 2099-12-31) 2. Save above as file 3. Tools > Import users 4. Choose file saved in 2 5. Field to use for record matching: cardnumber 6. In default values set expiration date to a date in past (say 2025-10-19) using date picker 7. Select overwrite the existing one with this 8. Leave renew existing patrons as "use the expiration date in the file if present" 9. Run 10. Observe user expiry date is still 2099-12-31 NB/ Tested in 23.11.10 where the date was correctly set to the default value chosen
I think the problem occurs in Koha/Patrons/Import.pm at line 295-6 $borrower{$col} = $member->{$col} if $col eq 'dateexpiry' && ( !$csvkeycol{$col} || !$columns[ $csvkeycol{$col} ] ); The above evaluates to TRUE and resets the expiry date to its database value rather than the default that was set previously and has persisted until here. Hence it is not modified as requested. Note other default values (eg City) work fine.