More in this section
Forums / Developing with Sitefinity / Batch User Processing

Batch User Processing

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
1 posts, 0 answered
  1. Brian
    Brian avatar
    26 posts
    12 Jun 2015
    09 Mar 2017
    Link to this post

    We get a lot of requests from our customer to do things for users in bulk.  This sometimes involves 100k+ users.  It might be adding users, adding users to roles, removing them, etc...  We have been trying to write things so that the requests can be accomplished without dev involvement after the initial request.  So, for instance, we might write a page that allows a user with the correct access to upload a CSV that will then be parsed and use that to add the users to a specified role.  This works to a point.  However, it takes a bit of time for each user.  If the list gets too big, the HTTP request times out.   What we would like to do in this case is import the CSV to a table and execute a stored procedure that would add those users to the specified role.  The user would receive a notification that the process completed with info on the success and number of users processed.   We might also want to take a list and ensure that a Sitefinity account is created for each user in the list (creating one for each user that is not).

    I can find a lot of info on using the API for this, but nothing at all on how to do anything from the database side.  Is there any documentation available on how to do this kind of thing?

    We could profile the database while doing this in code, but that does not always work out so well in my experience.

1 posts, 0 answered