snipe
CSV Bulk Upload Record Count Inconsistency in Multi-Tenancy
When using Snipe-IT in a multi-tenancy setup, uploading consumable (or other records) via CSV under Company A causes inconsistencies in record counts: The number of records uploaded in the CSV The number of records visible under Super Admin The actual records in Company A Do not match. This results in incomplete data visibility and inaccurate reporting for both the company and super admin users.
Steps to Reproduce Login as an admin under Company A. Navigate to Import. Upload a CSV file containing, for example, 29 consumeable records. After successful import: Check the consumable count under Company A. Check the consumable count under Super Admin. Observe that the counts are inconsistent and some records are missing or duplicated.
Expected Behavior All records from the CSV should be successfully uploaded to Company A. Super Admin should see the same number of records (as a superset of all companies). Record counts should be consistent and match the CSV.
Actual Behavior Record counts differ between Company A and Super Admin.
Environment Details Snipe-IT version: (e.g., 8.2.2) OS: (Linux) Database: MariaDB 10.6 PHP version: 8.2
CSV Sample Bulk Consumables Upload - Template.csv
Screenshot
Company A
via Super Admin
As we're looking at this, it's possible that the duplicate name with different categories is actually the thing that's happening here.
@mselavarasan - do you have full multiple company support turned on? Those totals look okay to me. Is it possible that the components having the same name and different categories is causing this glitch?
