[Building Sakai] RES: Removing users from sites directly via SQL

[Steve Swinsburg]

I recommend you code this up in Java and use quartz. You have access to all
of the sakai apis and the updates will be handled properly. There are
events that fire based on certain actions, you will be bypassing all of
that by going to the db directly.

Cheers
Steve

sent from my mobile device
On 26/03/2014 3:15 AM, "Gabriel Slomka" <gabriel.slomka at puc-campinas.edu.br>
wrote:

> Yes, im tryng to integrate sakai with our academic system. We are removing
> studants that change classes from theyr own classes, by scheduling SQL
> Jobs. We compare databases so we know wich students are in the wrong
> classes (sites). I know the 'ideal' would be to run this by sakai's
> WebService, but since we run this mostly in a SQLServer its not possible,
> or we would need to create a specific service application that would do
> this.
>
>
>
>   THanks alot for the attention !
>
>
>
> *De:* Miguel Carro Pellicer [mailto:miguel at educlever.es]
> *Enviada em:* segunda-feira, 24 de março de 2014 10:01
> *Para:* Gabriel Slomka; sakai-dev at collab.sakaiproject.org; 'Cleusa Sellin'
> *Assunto:* Re: [Building Sakai] Removing users from sites directly via SQL
>
>
>
> Hi Gabriel, i do not recommend to remove users directly from the
> database.....
>
> Why are you deleting them directly? Any specific objective or are you
> trying to make some integration from external systems?
>
> Miguel.
>
> El 24/03/2014 12:45, Gabriel Slomka escribió:
>
> Hello there Sakaiers.
>
>
>
>    Im having a little issue on removing users from sites directly using
> mysql code. I think this is kind of a simple question, yet im not being
> able to solve it.
>
>
>
>    Im tryng to remove users from sites deleting lines directly at
> SAKAI_SITE_USERS table , however some users are still participants on theyr
> websites, even if theyr deleted from this table. Is there any other place i
> must delete the users so theyr totally removed from those sites ?
>
>
>
>   Would apreciate any help. Thanks alot for the attention !
>
>
>
>   Best Regards, Gabriel Slomka.
>
>
>
>
> _______________________________________________
>
> sakai-dev mailing list
>
> sakai-dev at collab.sakaiproject.org
>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
>
> --
>
> [image: Logo]
>
> Miguel Carro Pellicer<http://es.linkedin.com/pub/miguel-carro-pellicer/38/502/b92>
> *IT Consultant - Elearning solutions*
>
> Phone: +34 - 686266485
> Email: miguel at educlever.es
>
> No me imprimas si no es necesario. Protejamos el medio ambiente
>
>
> AVISO LEGAL: El contenido de este mensaje de correo electrónico, incluidos
> los ficheros adjuntos, es confidencial y está protegido por el artículo
> 18.3 de la Constitución Española, que garantiza el secreto de las
> comunicaciones.
> Si usted recibe este mensaje por error, por favor póngase en contacto con
> el remitente para informarle de este hecho, y no difunda su contenido ni
> haga copias.
> *** Este mensaje ha sido verificado con herramientas de eliminación de
> virus y contenido malicioso ***
> Este aviso legal ha sido incorporado automáticamente al mensaje.
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140326/4758b327/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1103 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140326/4758b327/attachment.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8960 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140326/4758b327/attachment.png