[Bug]: For an item checked out to a location, checking it out to a new location via CSV upload checks it in instead from a user with the same ID

[druexmachina]

Snipe-IT Version

Version v8.3.7 - build 20803 (master)

PHP Version

8.2.29

Composer Version

2.7.7

MySQL/MariaDB version

MySql

How did you install Snipe-IT?

Git install

Is this a fresh install or an upgrade?

NA

What happened?

Hello! Sorry for the issue title gore. I observed some behavior today that seems unintended. CSV uploading is disabled in the demo so I couldn't verify it there. To reproduce:

1. Create locations A and B (note the location IDs - make sure there are users with the same IDs)
2. Check out an asset to location A
3. Upload a csv to update existing assets with these mapped fields:

Asset Tag,Checkout To Location,Checkout Type
{Asset Tag},B,location

Expected result:

• Asset should have location B as the new location and checkout target
• An activity record should be generated for the checkin event from location A
• An activity record should be generated for the checkout event to location B

Observed result:
Aligned, except...the activity record for the checkin event is for the user with the same db ID as location A (e.g., if location A has db ID 2, the asset is checked in from the user with db ID 2).

If I upload a similar csv to checkout the asset to location A again, a checkin activity record is generated for the user with the same db ID as location B.

What browsers are you seeing the problem on?

Other

Can you reproduce this on the public demo?

N/A

Do you have full multiple company support enabled?

Yes

If you have full multiple company support enabled, do you have location scoping to company enabled?

Yes

Application log output

Browser console output

Common Issues

• I have searched this repo for existing issues related to my issue (including closed issues)
• My APP_URL is set correctly in my .env file (including http or https and no trailing slash)
• I have searched the official Snipe-IT documentation and have checked the Common Issues documentation (where applicable)
• I have run database migrations (where applicable).
• I have attached screenshots and/or videos of the issue (where applicable)

Code of Conduct

• I agree to follow this project's Code of Conduct

[marcusmoore]

I can confirm this. Thank you for reporting.