Developer forum

Hi Jacob,

Do you have SQL skills to work with the database directly? Because the easiest way to get rid of the users is to delete them from the AccessUser table. E.g.:
where @3@ could be different in your case, depending on the actual group you're trying to clear.

Cheers,

Imar

Hi Imar, I just forgot to mention a vital part in my question... This should be a part of the import procedure, which my client should be able to trigger when he uploads a new csv-file... or in best case a scheduled pipeline, which it self executed the SQL command and then did the import... :-)

In that case, I am not sure what to do. I don't think there's an automated way to delete specific records from the AccessUser table, but I could be wrong.

Maybe someone else knows the answer?
 

Imar

Hi Jacob and Imar,
We (Co3) have made a "SQL Source" activity for the import/export module which originally is designed to select rows from a table as xml like "SELECT * FROM AccessUser FOR XML AUTO, ELEMENTS" which then can be processed via XSLT.

The activity is today used in various ways because you can feed it with any SQL command :)
And since it has XML output contraint is matches perfect as the start of any pipeline.

Jacob, tell me if you could be interested in this activity, I'm sure we'll make a decent price for you.

 I don't really see any other way than to make your own activity that will do the job. So either you'll have to code this activity yourself (pretty simple), but if you have no coding skills at all, I'd advice you to do the bargain of the century with Kevin.  :-)

Regards /Snedker

Have just sent the DLL to Jacob with the SQL Source activity.