[BE-26] Implement bulk asset import — CSV/XLSX with dry-run validation and template

[yusuftomilola]

Overview

Nobody registers hundreds of existing assets one modal at a time. Every competitor (Snipe-IT, Asset Panda, EZOfficeInventory) ships CSV import. exceljs and CSV tooling are already installed. The wizard UI is planned as [FE-15].

What to Build

Extend AssetsModule (or an ImportModule):

Method	Path	Description
POST	/api/assets/import?dryRun=true|false	Multipart CSV/XLSX upload
GET	/api/assets/import/template	Download a CSV template with headers + one example row

• Parse CSV and XLSX; map columns to asset fields (name, category, department, serialNumber, status, condition, purchaseDate, purchasePrice, location…)
• Category/department matched by name — auto-create or reject? Reject with a row error listing valid values (safer for v1)
• Dry-run mode returns per-row validation results (row, status: ok|error, errors[]) without writing
• Real run: insert valid rows, return a summary { created, failed, errors[] }; large files processed via the Bull queue ([BE-22]) if row count exceeds a threshold
• Record CREATED history events ([BE-08]) with an import marker

References

• Blocked by [BE-06], [BE-09]; queue via [BE-22]
• Consumed by [FE-15] (wizard UI)

Acceptance Criteria

• Template download matches accepted columns
• Dry-run validates every row and writes nothing
• Real import creates valid rows and reports precise per-row errors for the rest
• Duplicate serial numbers within the file or against the DB are flagged
• 1,000-row file imports without timing out the request

[Leemxiey]

@Leemxiey has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi, maintainer can i work on this issue?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Leemxiey to this issue.

[GdAyo19]

@GdAyo19 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I WOULD LOVE TO WORK ON THIS ISSUE PLEASE

ℹ️ Repo Maintainers: To accept this application, review their application or assign @GdAyo19 to this issue.

[ositaemmanuel653-netizen]

@ositaemmanuel653-netizen has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I’m a full-stack and smart contract developer with experience building responsive frontend interfaces, scalable backend systems, and secure blockchain applications,permit me to resolve this.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ositaemmanuel653-netizen to this issue.

[hmhidey111-collab]

@hmhidey111-collab has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Interested in working on this issue. I understand the requirements and can deliver a solution that meets the expected outcome

ℹ️ Repo Maintainers: To accept this application, review their application or assign @hmhidey111-collab to this issue.

[olufunsoolutayo]

@olufunsoolutayo has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello Maintainer. I would love to resolve this issue. Please assign to me. Thanks

ℹ️ Repo Maintainers: To accept this application, review their application or assign @olufunsoolutayo to this issue.

[Stanley-Owoh]

@Stanley-Owoh has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Good day maintainer please i would like to work on this,
I have gone through the description and am certain that i can start work on this immediately with positive results if it is been assigned to me.
I would appreciate if this issue will be assigned to me. Thank you

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Stanley-Owoh to this issue.

[RUKAYAT-CODER]

@RUKAYAT-CODER has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi maintainer can i work on this task?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @RUKAYAT-CODER to this issue.

[zakariyaufarida5-wq]

@zakariyaufarida5-wq has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi can i work on this task?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @zakariyaufarida5-wq to this issue.

[drips-wave]

Congratulations, @zakariyaufarida5-wq! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @zakariyaufarida5-wq: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox!

@zakariyaufarida5-wq's PR #1356 was approved and merged by @yusuftomilola.

🏆 @zakariyaufarida5-wq: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (296 total points). Track your full progress on GrantFox.

👏 Great work, @zakariyaufarida5-wq! Keep contributing to DistinctCodes.