topic Re: Create user script in Alfresco Archive

Create user script

darkmstr — Mon, 13 Aug 2012 15:26:31 GMT

Hello everybody, I'm new using alfresco and I'm having problems with a task in my job.All I need is to modify or find the way Alfresco inserts, modify or delete users, is there any script that Alfresco uses or something that I can handle ?I have my own database, with all my users from a mail service

Re: Create user script

afaust — Mon, 13 Aug 2012 16:40:33 GMT

Hello,

what type of script do you need? Do you mean a JavaScript action / script, or a web script as a remote API you could call from your service?

Regards
Axel

Re: Create user script

darkmstr — Mon, 13 Aug 2012 22:19:56 GMT

First of all does Alfresco have a script for the user creation, I'm using MySQL so how it makes the insertion ? cause if it is by a script I can call it when I do the insertion in the mail service, but if it isn't by a script how does it work ?
I need to know it's how its the insertion made, not by the UI.
Thanks for your answer.

Re: Create user script

afaust — Tue, 14 Aug 2012 08:37:25 GMT

Hello,

Alfresco inserts users into the datatabase with dynamically generated SQL (based on MyBatis). The database tables affected are alf_node, alf_node_child_assocs, alf_node_properties, alf_node_aspects, alf_authority and potentially one or two more, all with references / foreign keys to a couple of other, secondary tables. The data structure is very abstract and there is not simple table to just import users - users share the same structure as all the content.
You should never attempt to insert new data into the Alfresco schema via direct access to the database layer. From an external service, the best way would to create users would be to call the CSV upload web script at /alfresco/s/api/people/upload (using POST) - or create your own web script.

Regards
Axel

Re: Create user script

darkmstr — Tue, 14 Aug 2012 13:31:23 GMT

Sorry if I'm beign stupid or something, but the script that you mentioned is in the all in one installer?
'cause I went to /alfresco/scripts, /alfresco/tomcat/webapps/alfresco/scripts, /alfresco/tomcat/webapps/alfresco/services, and there isn't anything like that.

Re: Create user script

afaust — Tue, 14 Aug 2012 14:53:33 GMT

Hello,

the web script I mentioned can be called via HTTP on the URI I posted. The actual files reside in different places - the code that handles the actual logic for CSV input and insertion is located in the Java class UserCSVUploadPost (part of the alfresco-remote-api.jar).

Regards
Axel

Re: Create user script

darkmstr — Tue, 14 Aug 2012 16:00:55 GMT

Thank you I misunderstood.
Now I have a script to import my database to a CSV format, also I can modifiy it that everytime I create an user create a CSV file for that user; however is there any way to import it in Alfresco not using the UI, sorry I'm new at this, and this are my practices for my University.
I have read about Web Services in Alfresco but I don't know how to get to them, also I don't know if they will work for this case, I've already know the problem with accesing directly to the DB layer in alfresco, it is pretty complicated.

Re: Create user script

afaust — Tue, 14 Aug 2012 16:23:29 GMT

Hello,

this might be usefull: http://radomirml.com/2009/02/13/file-upload-with-httpcomponents-successor-of-commons-httpclient
Of course if you are using a language other than Java, you have to check how you may execute HTTP calls from your environment.

Regards
Axel

Re: Create user script

darkmstr — Wed, 15 Aug 2012 13:17:09 GMT

Hello,

Thanks for your help I really appreciate it, yesterday my boss found out about this : localhost:8080/alfresco/api/AdministrationService?wsdl
and we saw that this wsdl had a "CreateUsers", "UpdateUsers", "changePassword" and "deleteUsers" function, the problem is that the "createUsers" function is weird ops: it does have a "username", "password" field, but the other fields are "name", "isMultiValue", "value" and "values" and it is twice, so have you used this wsdl ?' is there a place where I can find some info about it ? I've read this in the wiki :

http://wiki.alfresco.com/wiki/Administration_Web_Service
http://dev.alfresco.com/resource/docs/java/remote-api/org/alfresco/repo/webservice/administration/AdministrationWebService.html

We're trying to see if we can use it by a soapclient, but as I told you using this website:

http://soapclient.com/

I don't know how are the users detail, I just know that it is an array but not how it the data in there, or how to really used it.

Re: Create user script

darkmstr — Wed, 15 Aug 2012 21:13:16 GMT

Nevermind I found use useful use the ifresco library.