Accessory / License checkout during import?

[smksar]

First timer with GitHub, so not sure where to post questions? Not an issue really but just want to know if it is possible to checkout the accessory or license to a user by using the universal import?

Tried several times with different fields but to no avail.

Fresh install 4.2.0

Thanks~!

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

[smksar]

Oops... posting comment to open back issue

[smksar]

Hi @snipe, how do I revive this request?

[stale]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[snipe]

@dmeltzer can you advise?

[mnemonicly]

It's not currently possible. I think the only way to do it would be a separate checkoutsimporter...

[smksar]

@dmeltzer it took me a while after using Snipe-IT to know you are the father of the import feature. I am thankful for your contribution that it has easily saved me god knows how many hours or days if I were to put in current data manually.

At the moment we are slacking on the accesories tracking but we don't really pushing for it as the finance would ask us more of the assets assigned.

But of course we as IT team would like to track a little more detail together with accessories checkouts.

So thank you for the importing part sir! I truly appreciate it and hope in the future checkout to accessories will be possible through csv import. Love the speed too!!

Thank you both~!!

[LC-cchristiansen]

So glad I found this. I've been banging my head for days trying to figure out what I was doing wrong when attempting to import accessories.
I will say the import field "Checked out to" being an option for Accessories Import Type certainly added a little confusion.

Hopefully this means it's a coming feature.

Currently running Version v4.6.4

[stale]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[LC-cchristiansen]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

This is still something I'd love to see implemented. Please keep this open.

[stale]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[SirConfigMgr]

+1

[sambayford]

This feature would be invaluable to us as a college. As we have just started with Snipe-IT we have thousands of accessories to check out to students and staff. In addition to this initial import, every year we will need to check out hundreds of new accessories to new students and this would be a nightmare even with the bulk checkout proposed in #5665.

[iwendol]

+1

[stale]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[LC-cchristiansen]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

Still relevant, thanks stale bot, bleep bloop bleep bleep. :)

[stale]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[syswpit]

Why is this not an option? I'm forced to import my monitors under assets rather than accessoires, because I can't assign it to anyone during import, I can't mark it as active or in stock, I can't add notes.
For Assets I use "full name" and "username" to automatically check out an asset during import (found this on GitHub), but the "username" field is not available for accessoires. The actual "check out to" field is broken.

[stale]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.

[mzack5020]

This is still a desired feature. Please re-open and consider adding to a future feature request or enhancement. We love the import tool and adding the granularity to check out accessories to specific users as a part of the import would be a great addition.

[mzack5020]

@syswpit @LC-cchristiansen @sambayford

I threw together a quick python script to generate a .sql file which can be used to update your SnipeIt database with user assignments for accessories. It worked in my case and I haven't seen any problems with it.

Please read the README.md in the repository before you decide to use it. I'm not a fan of updating the database directly but I didn't see any other way through the application.

Long story short, this python script looks for a CSV file with accessory names -> user names. This serves as your accessory-to-user assignment file. Then it looks up the accessory IDs and user IDs via those names and generates a .sql output file with an insert statement. These insert statements update the accessories_users table which is where the accessory assignments are stored (from my investigation).

Repository: SnipeIt-Update-Accessory-Assignments

Feedback is wanted and welcome! I know it's a quickly thrown together project but if there's a better way to do it, I'm anxious to see what others think. Thanks and I hope this helps.