# Bulk Import User Restrictions via CSV

**URL:** <https://pug.phocassoftware.com/t/bulk-import-user-restrictions-via-csv/1357>\
**Category:** Product Ideas\
**Created:** [November 19, 2019, 6:46pm UTC](https://pug.phocassoftware.com/t/bulk-import-user-restrictions-via-csv/1357 "2019-11-19T18:46:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan.Kistler](https://avatars.discourse-cdn.com/v4/letter/r/c6cbf5/32.png) [@Ryan.Kistler](https://pug.phocassoftware.com/u/Ryan.Kistler)\
**Post date:** [November 19, 2019, 6:46pm UTC](https://pug.phocassoftware.com/t/bulk-import-user-restrictions-via-csv/1357/1 "2019-11-19T18:46:17Z")

</div>

Currently having to input each salesrep id with their restrictions manually per user. This is time consuming for our roster of about 40 reps, but I’d imagine a larger company with hundreds would be a nightmare. Is there no way now to bulk restrict rep user accounts to their own id without having to manually enter one by one?

---

<div class="post-metadata">

**Author:** ![Ryan.Kistler](https://avatars.discourse-cdn.com/v4/letter/r/c6cbf5/32.png) [@Ryan.Kistler](https://pug.phocassoftware.com/u/Ryan.Kistler)\
**Post date:** [November 19, 2019, 8:36pm UTC](https://pug.phocassoftware.com/t/bulk-import-user-restrictions-via-csv/1357/2 "2019-11-19T20:36:46Z")

</div>

Looks like this is doable technically via default database restrictions. There are only 2 custom user fields though, group and territory. So in my case I will be putting the SalesRep ID in the territory field and setting a default restriction to salesrep\_id equal to {{user:territory}} . This feels like a work around but I did just test it, and since you can include territory on a CSV User Import, it will work.

---

<div class="post-metadata">

**Author:** ![aaron.roma](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/aaron.roma/32/285_2.png) [@aaron.roma](https://pug.phocassoftware.com/u/aaron.roma)\
**Post date:** [November 20, 2019, 1:19pm UTC](https://pug.phocassoftware.com/t/bulk-import-user-restrictions-via-csv/1357/3 "2019-11-20T13:19:37Z")

</div>

Looks like you already figured it out, but yes, this is how we did it too. And FYI, you can include multiple entries in that territory field too, separated by semicolons, if needed. Example: ID1;ID2;ID3
